Get excel cell value without UI update in Excel Addin Nodejs Api
Gianluca Bisceglie
1
Reputation point
We cannot find a way to run a recalculation without refreshing the grid (Excel UI).
Even if we turn off UI update, when we need to get the value in a cell the UI is forced to update.
We call API function doNotUpdateScreenUntillNextSync()
but in order to get updated values we have to call context.sync()
that will update the screen.
Any idea how to get cell value without UI update in excel: basically having access to Excel engine skipping the UI layer until we want to look at it.