Copy/Paste from outside spreadjs

Copy/Paste from outside spreadjs

Posted by: mikebamm on 18 December 2017, 7:41 pm EST

• 

  mikebamm

  • Post Options:
  • Link
    Copy

  Posted 18 December 2017, 7:41 pm EST

  I’m trying to get the copy / paste functionality in code.
  
  1.User copy from spread js and pastes to excel using below code:
  
  //initialization
  
  let spread = new GC.Spread.Sheets.Workbook(element[0], {allowCopyPasteExcelStyle: true});

  //copy
  
  spread.getWorkbook().commandManager().execute({cmd: “copy”});
  
  This code does not work when I paste to excel, it works using keyboard keys.

  2. User copy from outside and paste in spread:
     
     //paste
     
     spread.getWorkbook().commandManager().execute({cmd: “clipboardPaste”, pasteOption: GC.Spread.Sheets.ClipboardPasteOptions.all});
     
     The above code does not work, but works when I use keyboard keys and not code.

  Can you please advise what needs to changed. Is there a code sample I can use as a reference? Thank you

• 

  mikebamm

  • Post Options:
  • Link
    Copy

  Posted 18 December 2017, 8:01 pm EST

  I also tried spread.getWorkbook().commandManager().execute({cmd: “clipboardCopy”});
  
  I would like to use copy/cut/paste functionality using code and my own buttons and without using context menu. All functionality is working using keyboard keys. Thank you

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 20 December 2017, 1:24 am EST

  Hello,

  Here is the code to copy and paste using button click:

  
  window.onload = function(){
                        var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"),{sheetCount:3});
                        var sheet = spread.getActiveSheet();
  sheet.setValue(0, 0, 1, GC.Spread.Sheets.SheetArea.viewport);
  sheet.setValue(1, 0, 2, GC.Spread.Sheets.SheetArea.viewport);
  sheet.setFormula(2, 0, "=A1+A2", GC.Spread.Sheets.SheetArea.viewport);
  sheet.setValue(0, 1, 3, GC.Spread.Sheets.SheetArea.viewport);
  sheet.setValue(1, 1, 4, GC.Spread.Sheets.SheetArea.viewport);
  sheet.setFormula(2, 1, "=B1+B2", GC.Spread.Sheets.SheetArea.viewport);
  var fromRange = [new GC.Spread.Sheets.Range(0, 0, 3, 2)];
  var toRanges = [new GC.Spread.Sheets.Range(5, 0, 3, 2)];
  
  $("#button1").click(function () {
      //Cut Paste Action
      spread.commandManager().execute({cmd: "clipboardPaste", sheetName: "Sheet1", fromSheet: sheet, fromRanges: fromRange, pastedRanges: toRanges, isCutting: true, clipboardText: "", pasteOption: GC.Spread.Sheets.ClipboardPasteOptions.all});
  });
  $("#button2").click(function () {
      spread.commandManager().execute({cmd: "clipboardPaste", sheetName: "Sheet1", fromSheet: sheet, fromRanges: fromRange, pastedRanges: toRanges, isCutting: false, clipboardText: "", pasteOption: GC.Spread.Sheets.ClipboardPasteOptions.all});
  });
  
  

  http://help.grapecity.com/spread/SpreadSheets11/webframe.html#sccopy.html

  Thanks,
  
  Deepak Sharma