Ctrl + V not pasting grouped cells as grouped

Ctrl + V not pasting grouped cells as grouped

Posted by: mwyatt on 8 October 2021, 12:47 pm EST

• 

  mwyatt

  • Post Options:
  • Link
    Copy

  Posted 8 October 2021, 12:47 pm EST

  Issue 1:
  
  If I have some rows or columns grouped and I use Ctrl + A to select everything, Crtl + C to copy and then open a new sheet and paste using Ctrl + V, all groupings are lost

  Issue 2:
  
  if you have something grouped and the grouping is closed (hidden), when you paste the cells it doesn’t keep the grouping. Instead it just turns them into hidden cells (may be the same cause/related to issue 1 but mentioning here just in case they are not)

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 11 October 2021, 5:38 am EST

  Hi,

  Thanks for the information. We are able to observe the issue at our end hence we have escalated this issue to the concerned team for further investigation. We will update you regarding this as we get any information from the team. The internal ID for this issue will be SJS-10359.

  Regards
  
  Avinash

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 18 October 2021, 5:11 am EST

  Hi,

  The dev confirmed that SJS does not support the following two cases while copy-pasting.

  1. copy/paste outline in the same sheet.
  2. copy/paste outline from one sheet to another sheet when not copy whole sheet.

  Further, You may look to the following workaround and let me know if you still face any issue.

  
  var oldClipboardPasteCommand = GC.Spread.Sheets.Commands.clipboardPaste.execute;
  GC.Spread.Sheets.Commands.clipboardPaste.execute = function (context, options, isUndo) {
      var self = this, fromRanges = options.fromRanges, wholeSheet = fromRanges && fromRanges.length === 1 && fromRanges[0].row === -1 && fromRanges[0].col === -1;
      if (wholeSheet) {
          let commandManager = context.commandManager(), oldSheetName = options.fromSheet.name(), newSheetName = options.sheetName, targetIndex = context.getSheetIndex(newSheetName);
          context.removeSheet(targetIndex);
          return commandManager.execute({cmd: "copySheet", sheetName: oldSheetName, targetIndex: targetIndex, newName: newSheetName, includeBindingSource: true});
      }
      return oldClipboardPasteCommand(context, options, isUndo);
  }
  
  

  Regards
  
  Avinash