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


    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:-


    Hope it helps.

  • 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,
  • 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


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


    Hope it clarifies.

Need extra support?

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

Learn More

Forum Channels