This is a migrated thread and some comments may be shown as answers.

Set cell value - slow - Manual calculation

1 Answer 289 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Henrik
Top achievements
Rank 1
Henrik asked on 09 May 2017, 08:01 AM

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

Sort by
0
Nencho
Telerik team
answered on 11 May 2017, 06:21 AM
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
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.
Tags
Spreadsheet
Asked by
Henrik
Top achievements
Rank 1
Answers by
Nencho
Telerik team
Share this question
or