This article explains how to retrieve the cell value without enabling sheet calculations using XlsIO.
There can be situations where the formula value or the last calculated value in a cell is required without actually recalculating sheet formulas through . This can be achieved using property in worksheet range.
The below table illustrates the behavior of DisplayText property with respect to enabling sheet calculations.
Code snippet to use DisplayText property
The following complete code snippet explains how to retrieve the formula value in cell without enabling sheet calculations using XlsIO.
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:|