Posted 3 November 2021, 10:38 am EST - Updated 3 October 2022, 9:33 am EST
Pasting more records than existing rows
Posted by: baloghbencefacebook on 3 November 2021, 10:38 am EST
-
-
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.htmlRegards

