Spreadsheet Sheet Batch Option

[Marc]

Hi, in the documents it says to use batch if doing a number of operations on the spreadsheet. Can you explain what the {layout: true} is?

http://docs.telerik.com/kendo-ui/api/javascript/spreadsheet/sheet#methods-batch

I'm guessing it represents the change event to fire after the batch operation finishes - if this is the case are there any other options? Ie - layout is for layout changes, what about adding validations or changing colours? I cannot seem to find this list. 

Thanks

Marc

[Dimitar]

Hi Marc,

The idea is that batch suspends certain operations that would normally occur when calling the methods outside batch. The example snippet hides the first 10 rows and columns. A refresh (relayout) of the view would occur twice on each iteration, if it was done outside a batch. So that second argument tells batch to redraw the view's layout,  after evaluating the body. The only other option I find in the source code is recalc: true. There are no other options available for this case.

Regards,
Dimitar
Telerik by Progress

[Marc]

Hi Dimitar,

Thanks for the explanation - very clear! I understand that layout would be used for things such as hiding columns, colouring cells etc. What would recalc be used for? 

Thanks

Marc

[Dimitar]

Hi Marc,

Batch suspends some updates that the Spreadsheet normally does during the execution of the body. For example, if you set many formulas on some cells in a batch, there won't be a recalculation after each one. Passing recalc: true tells batch that it should recalculate the formulas after the body ends.

Regards,
Dimitar
Progress Telerik