The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

IWorkbook.CalculateFull() Method

Forces a full calculation of the data in a workbook.

Namespace: DevExpress.Spreadsheet

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

Declaration

void CalculateFull()
Sub CalculateFull
void CalculateFull()
Sub CalculateFull
void CalculateFull()
Sub 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