Unable to add new rows in the ClipboardPasting event

Unable to add new rows in the ClipboardPasting event

Posted by: Christian.Froehlich on 14 August 2018, 3:11 am EST

• 

  Christian.Froehlich

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 14 August 2018, 3:11 am 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.

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 14 August 2018, 4:47 am 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

• 

  Christian.Froehlich

  • Post Options:
  • Link
    Copy

  Posted 14 August 2018, 7:39 pm 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

• 

  Christian.Froehlich

  • Post Options:
  • Link
    Copy

  Posted 16 August 2018, 12:29 am 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.

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 16 August 2018, 2:08 am 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