Set cell value - slow - Manual calculation

[Henrik]

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.

 

 

[Nencho]

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