Performance of formatting question.

[Christopher]

Generally speaking, is it just as performant to apply formatting and validation settings cell by cell, or is it better to apply it by range? Or are they functionally the same and there wouldn't necessarily be an operational performance difference?

[Christopher]

Well, found this out the hard way. Multiple sheet range calls are far slower than defining the styling upon sheet insert, that is, within the sheet config/json itself. Way faster loading it initially from config than applying styles to the sheet after the insert.

[Michelle]

Yes, I came to exactly the same conclusion as well after implementing it the slow way the first time around.

[Christopher]

Just an FYI, while the initial config is very fast, I did find a good workaround if you need to apply styling post-load.

The trick is to leverage the sheet's "suspendChanges" function. So your workflow would look something like:

sheet.suspendChanges(true);
//apply a bunch of changes to values and styles
//...
sheet.suspendChanges(false);

[Veselin Tsvetanov]

Hello Christopher,

Using the suspendChanges() method, when applying multiple changes in a Spreadsheet Sheet is a viable approach to improve performance when applying multiple changes to values and styling. However, as this method is internally used (and therefore, not documented), I would suggest you to use the Sheet.batch() method instead. Under the hood it will do exactly the same as what is done in the suggested snippet.

Regards,
Veselin Tsvetanov
Progress Telerik