I have a large data set, SpreadJS will crash when trying to copy whole content

I have a large data set, SpreadJS will crash when trying to copy whole content

Posted by: zhoubing.yang on 25 July 2022, 9:59 am EST

• 

  zhoubing.yang

  • Post Options:
  • Link
    Copy

  Posted 25 July 2022, 9:59 am EST

  I have a large data set, SpreadJS will crash when trying to copy whole content.
  Step to produce:
  1. import the example csv file.
  2. Select All text (click top left corner)
  3. Ctrl + C copy, wait for copy indicator to show up.
  4. Ctrl + C again, the app will crash
  
  Please let me know any chances we could've implement optimization on coping and paste action, so that it will not crash.
• 

  zhoubing.yang

  • Post Options:
  • Link
    Copy

  Replied 25 July 2022, 9:59 am EST

  annual-enterprise-survey-2020-financial-year-provisional-csv.csv.zip
• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Replied 25 July 2022, 5:28 pm EST

  Hi Zhoubing,
  
  I think this is a limitation because of the number of cells being copied are large. I have also forwarded this to the dev team for further investigation and if any optimization is possible. The internal tracking id is: SJS-14006. I will let you know when I have an update for you.
  
  Meanwhile, could you please share your use case as to why you want to copy such large range so that we can have a better understanding of your use case and could assist you accordingly?
  
  Regards
  
  Ankit
• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Replied 28 July 2022, 3:02 pm EST

  Hi Zhoubing,
  
  The devs have informed that if you don't care about the style, using allowCopyPasteExcelStyle = false may enhance the performance.
  
  In the designer, you can use
  
  
  
  Also, if you are copying an entire sheet, it is better to just export to Excel or CSV instead.
  
  API Docs:
  
  Workbook options: https://www.grapecity.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.Workbook~options.html
  
  SpreadJS Designer: https://www.grapecity.com/spreadjs/designer/index.html
  
  Regards
  
  Ankit