2X faster development
The ultimate WinForms UI toolkit to boost your development speed.
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 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
|
2X faster development
The ultimate WinForms UI toolkit to boost your development speed.
This page will automatically be redirected to the sign-in page in 10 seconds.