Set cell value - slow - Manual calculation

2 posts, 0 answers
  1. Henrik
    Henrik avatar
    6 posts
    Member since:
    Jan 2015

    Posted 09 May 2017 Link to this post

    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);

    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.



  2. Nencho
    Nencho avatar
    1888 posts

    Posted 11 May 2017 Link to this post

    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:

    Hope this would help.

    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 visualization (charts) and form elements.
Back to Top