Forums Home / Spread / SpreadJS
Posted by: zhoubing.yang on 25 July 2022, 9:59 am EST
zhoubing.yang
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:
Please let me know any chances we could’ve implement optimization on coping and paste action, so that it will not crash.
zhoubing.yang
Posted 25 July 2022, 9:59 am EST
ankit.kumar
Posted 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
Posted 28 July 2022, 3:02 pm EST - Updated 3 October 2022, 12:10 am 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
