IWorkbook.CalculateFull() Method

Forces a full calculation of the data in a workbook.

Namespace : DevExpress.Spreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

• C#
• VB.NET

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

Calculation Process

IWorkbook Interface

IWorkbook Members

DevExpress.Spreadsheet Namespace