How max rows are supported by your spreadsheet (FlexSheet)?

How max rows are supported by your spreadsheet (FlexSheet)?

Posted by: serge.dudnic on 11 April 2021, 8:10 pm EST

• 

  serge.dudnic

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 11 April 2021, 8:10 pm EST

  how many maximum rows are supported by your spreadsheet (FlexSheet)?

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 12 April 2021, 8:13 pm EST

  Hi Serge,
  
  We have tested with about 2M records and it works fine in Unbound Mode. Could you please share what type of binding you would like to do? Also, please elaborate your requirement so that we may assist you accordingly?

  Regards,
  
  Manish Gupta

• 

  serge.dudnic

  • Post Options:
  • Link
    Copy

  Posted 12 April 2021, 8:58 pm EST

  Hello Manish
  
  we are working with sheets we need to “paste” from Excel to the Database. Sometimes we could paste 15 000 rows. So, we are wondering if the paste will auto-add the rows to the existing sheet. Suppose by default we initialized the sheet to 100 rows and pasted in it some 10 200 rows fro the clipboard (taken from Excel)

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 13 April 2021, 11:11 pm EST

  Hello Serge,
  
  For this, we need to set the allowAddNew to true using the JS code for BoundSheet. It will allow you to paste more rows and add the additional rows if needed.

  Regards,
  
  Manish Gupta

  FlexSheet_AllowAddNew_paste.zip