officefileapi-devexpress-dot-spreadsheet-dot-worksheet-1ad73384.md
Forces recalculation of the current worksheet and does not look for circular references.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
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.
|
See Also