Pasting more records than existing rows

Pasting more records than existing rows

Posted by: baloghbencefacebook on 3 November 2021, 10:38 am EST

• 

  baloghbencefacebook

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 3 November 2021, 10:38 am EST - Updated 3 October 2022, 9:33 am EST

  Hi!

  Is there a way to catch the paste event before this error occurs?

  

  697×551 182 KB

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 8 November 2021, 3:06 am EST

  Hi,

  If you need to allow pasting rows when no of rows is less than the copied rows then you may set the allowExtendPasteRange option to true.

  let spread = designer.getWorkbook();
  spread.options.allowExtendPasteRange = true;
  
  

  Sample demonstrating the same: https://jscodemine.grapecity.com/share/Midl_3WgmkCfqBENLjQRxg/
  
  Further if you just need to catch the event then you may handle the InvalidOperation and check if the invalid event type is CopyPaste.
  
  API docs:
  
  • https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Events~InvalidOperation_EV.html
  
  • https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.InvalidOperationType.html

  Regards