Worksheet.Calculate() Method

Forces recalculation of the current worksheet and does not look for circular references.

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

void Calculate()

Sub Calculate

Call this method to force calculation in a worksheet. The table below lists API to recalculate formulas.

To recalculate formulas in	Do this
A document	Use one of the following methods: IWorkbook.Calculate - Calculates all cells marked for calculation. Works only if the calculation mode is Manual. IWorkbook.CalculateFull - Calculates all cells regardless of whether they are marked for calculation. Works for any calculation mode. IWorkbook.CalculateFullRebuild - Rebuilds the dependency tree and calls the IWorkbook.CalculateFull method for the chain-based engine type. Calls the IWorkbook.CalculateFull method for the recursive engine type.
A worksheet	Use the IWorkbook.Calculate method overload with the Worksheet parameter, or call the `Worksheet.Calculate` method.
A cell range	Use the IWorkbook.Calculate method overload with the CellRange parameter, or call the CellRange.Calculate method.

To recalculate formulas in

Do this

A document

Use one of the following methods:

IWorkbook.Calculate - Calculates all cells marked for calculation. Works only if the calculation mode is Manual.
IWorkbook.CalculateFull - Calculates all cells regardless of whether they are marked for calculation. Works for any calculation mode.
IWorkbook.CalculateFullRebuild - Rebuilds the dependency tree and calls the IWorkbook.CalculateFull method for the chain-based engine type. Calls the IWorkbook.CalculateFull method for the recursive engine type.

A worksheet

Use the IWorkbook.Calculate method overload with the Worksheet parameter, or call the Worksheet.Calculate method.

A cell range

Use the IWorkbook.Calculate method overload with the CellRange parameter, or call the CellRange.Calculate method.