Setting a cell value seems to be very slow when the sheet contains several formulars.
I this the optimal code to set a cell value :
var rr = range._sheet.range(row, column);
rr.value(value);
Is there any setting that disable automatic calculation "manual calculation" ? Could offer a better performance by
1. disable automatic calculation
2. set all cell values
3. activate automatic calculation.
1 Answer, 1 is accepted
0
Hello Henrik,
Indeed the calculations base on the formulas of the cells is triggered on each change and this is by design. I can suggest, however, to use the batch method of the Sheet object, which can help you suppress the triggering of the change events for a sequence of actions. Please refer to the following documentation article:
http://docs.telerik.com/kendo-ui/api/javascript/spreadsheet/sheet#methods-batch
Hope this would help.
Regards,
Nencho
Telerik by Progress
Indeed the calculations base on the formulas of the cells is triggered on each change and this is by design. I can suggest, however, to use the batch method of the Sheet object, which can help you suppress the triggering of the change events for a sequence of actions. Please refer to the following documentation article:
http://docs.telerik.com/kendo-ui/api/javascript/spreadsheet/sheet#methods-batch
Hope this would help.
Regards,
Nencho
Telerik by Progress
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data (charts) and form elements.