Register custom Command without overwriting the default built-in one

Register custom Command without overwriting the default built-in one

Posted by: rlescano on 18 October 2017, 6:55 am EST

• 

  rlescano

  • Post Options:
  • Link
    Copy

  Posted 18 October 2017, 6:55 am EST

  Hello,
  
  is there a way I can create my own Command for ‘clipboardPaste’ then register it but without overwriting the default implementation you guys provide?

  I want to be able to register my Command and when it’s being executed, just receive the parameters via ‘options’ argument, do some custom stuff and then be able to call the default built-in command for ‘clipboardPaste’.

  Regards
  
  Román

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 27 October 2017, 11:11 pm EST

  Hi Roman,

  You can surely use your code to perform copy and paste, here is how you can do that:
  
  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});
  
  });

  Thanks,
  
  Deepak Sharma