Skip to main content
Row

IWorkbook.CalculateFull() Method

Forces a full calculation of the data in a workbook.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

void CalculateFull()

Remarks

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