.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

IWorkbook.CalculateFull() Method

Forces a full calculation of the data in a workbook.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v20.2.Core.dll


void CalculateFull()
Sub CalculateFull


The CalculateFull method forces recalculation of all spreadsheet cells regardless of whether the cell is marked for calculation. The method works with any CalculationOptions.Mode setting.

Use the CalculateFull method if worksheet formulas use User-Defined Functions (UDF) and the function code has been modified. Since the worksheet is not aware of such changes, the cells containing that function are not marked for calculation and the IWorkbook.Calculate method will not process them. In this situation, the CalculateFull method will recalculate all cells.

See Also