We have an Excel add-in and an algorithm where we need to get calculated values of a cell while changing more than 10,000 cells one by one.
We buffer the ranges and call context.sync() only once and also we call app.suspendScreenUpdatingUntilNextSync() in the beginning, so it doesn't update UI on every change.
But the buffer contains more than 10,000 ranges/cells and when we call context.sync() I see white screen only (Excel cells are not visible).
Here is the gist url that simulate the situation I have. Please use excel file added in comment section.
So can you please provide a better way to get calculated values without updating UI.
From Stackoverflow we got a suggestion for feature request for "Excel session level UI suspend" API.