Get excel cell value without UI update in Excel Addin Nodejs Api

Gianluca Bisceglie 1 Reputation point
2021-04-07T10:21:47.62+00:00

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.

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,715 questions
{count} votes