How to retrieve cell value without enabling sheet calculations in C#, VB.NET?

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 EnableSheetCalculations. This can be achieved using DisplayText 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

Download input sample with data

Download complete sample

To know more about enabling and disabling sheet calculations, please refer the documentation.

The following complete code snippet explains how to retrieve the formula value in cell without enabling sheet calculations using XlsIO.

C#

VB