Posted 22 November 2019, 4:33 am EST
Hi.
■Content
When adding rows to the spreadsheet, the memory will increase by about 500MB.
As a result, adding more than a few lines can cause memory pressure.
UndoTransaction is used for row insertion processing.
I want to know how to limit the number of undoTransaction stacks.
■Supplement
There are about 50 columns in the spreadsheet.
It contains cell formats and values.
■code sample
Commands.startTransaction(context, options);
sheet.addRows(rowno, 1);
Commands.endTransaction(context, options);
■environment
spreadJS ver12.1.0.
The browser uses the latest version of Google Chrome.
