Copy and paste single row

Copy and paste single row

Posted by: dean.kinnear on 16 April 2024, 6:58 am EST

• 

  dean.kinnear

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 16 April 2024, 6:58 am EST

  Is there a way to copy a single row, and paste it to a range?

  For instance, I want to copy just formats from range of cells: B9:F9
  
  and paste that area to multiple rows - say a desintation of B10:F35

  I looked at sheet.copyTo, but it doesn’t look like it works for a destination consisting of multiple rows.

  Thanks!

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 16 April 2024, 6:27 pm EST

  Hi,

  You could use the “clipboardPaste” command to paste for the multiple rows. Kindly refer to the following code snippet and the attached sample:

          var fromRange = [new GC.Spread.Sheets.Range(8, 1, 1, 5)];
          var toRanges = [new GC.Spread.Sheets.Range(9, 1, 25, 5)];
          spread.commandManager().execute({
              cmd: "clipboardPaste", sheetName: "Sheet1",
              fromSheet: sheet, fromRanges: fromRange, pastedRanges: toRanges, isCutting: false,
              clipboardText: "", pasteOption: GC.Spread.Sheets.ClipboardPasteOptions.formatting
          });

  Sample: https://jscodemine.mescius.io/share/WfO4kzVjV0qlR-gz7psJHw/?IsEmbed=false&Theme=Unset&PreviewDirection=0&IsEditorShow=true&IsExplorerShow=true&IsPreviewShow=true&IsConsoleShow=true&IsRunBTNShow=false&IsResetBTNShow=false&IsOpenInCodemineBTNShow=false&PanelWidth=20&PanelWidth=50&PanelWidth=30&defaultOpen={"OpenedFileName"%3A["%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  References:

  clipboardPaste command: https://developer.mescius.com/spreadjs/api/modules/GC.Spread.Sheets.Commands#clipboardpaste

  ClipboardPasteOptions Enumeration: https://developer.mescius.com/spreadjs/api/enums/GC.Spread.Sheets.ClipboardPasteOptions

  Let me know if you face any issues.

  Regards,

  Ankit

• 

  dean.kinnear

  • Post Options:
  • Link
    Copy

  Posted 16 April 2024, 9:57 pm EST

  Perfect, thanks!