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

  • 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.
  • Replied 25 July 2022, 9:59 am EST

    annual-enterprise-survey-2020-financial-year-provisional-csv.csv.zip
  • 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
  • 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
Need extra support?

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

Learn More

Forum Channels