Does XlsIO support auto-correcting formulas?

24 Jun 20261 minute to read

No, Syncfusion XlsIO does not support auto-correcting or recalculating formulas automatically when loading Excel files. To resolve this, open and resave the Excel file using Microsoft Excel. This triggers formula evaluation and updates the cached results. Once resaved, XlsIO can process the file and return the correct values.

Alternatively, invoke the Calculate method of IWorksheet to evaluate and update all formulas in the worksheet.

Use the EnableSheetCalculations method of IWorksheet to initialize CalcEngine objects and retrieve calculated values of formulas in a worksheet. On completion of worksheet calculation, invoke the DisableSheetCalculations method of IWorksheet to dispose all CalcEngine objects.

For more details, please refer to Working with Formulas | Syncfusion.