Unable to add new rows in the ClipboardPasting event

Posted by: Christian.Froehlich on 13 August 2018, 6:11 pm EST

  • Posted 13 August 2018, 6:11 pm EST

    Hi, I want to be able to dynamically add rows to my SpreadJS sheet when a user pastes tabular content that is too large. I should be able to do this in the ClipboardPasting event however i get an InvalidOperation that prevents this event from triggering.

    Can someone advise if there is a way to disable the paste size validation, or another event in which to integrate this functionality? Or if there is another means entirely to dynamically grow the number of rows?

    Thanks in advance.

  • Replied 13 August 2018, 7:47 pm EST

    Hello,

    For this you can set allowExtendPasteRange Spread option to true as given in documentation link below. When allowExtendPasteRange set to true, it will extend the paste range to accept more data:-

    http://help.grapecity.com/spread/SpreadSheets11/webframe.html#SpreadJS~GC.Spread.Sheets.Workbook~options.html

    Hope it helps.

    Thanks,
    Reeva
  • Replied 14 August 2018, 10:39 am EST

    That's great Reeva, however i don't seem to have that option in the version used by my company.

    Could you please tell me which version introduced this option and the "spread.options" property?

    Thanks in advance,
    Christian
  • Replied 15 August 2018, 3:29 pm EST

    I see this requires v10 or above, when we have the time to reinvestigate upgrading i will look into this further.

    Thanks for your help.
  • Marked as Answer

    Replied 15 August 2018, 5:08 pm EST

    Hello,

    The allowCopyPasteExcelStyle and allowExtendPasteRange properties have been added to the Workbook options in SpreadJS version 10.0.0 as given in release notes here:-

    http://help.grapecity.com/spread/SpreadSheets11ReadMe/webframe.html#rnotesv10.html

    Hope it clarifies.

    Thanks,
    Reeva
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels