All docs
V20.2
20.2
20.1
19.2
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

IWorkbook.Calculate(CellRange) Method

Forces recalculation of the specified cell range in a worksheet.

Namespace: DevExpress.Spreadsheet

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

Declaration

void Calculate(
    CellRange range
)
Sub Calculate(
    range As CellRange
)

Parameters

Name Type Description
range CellRange

A CellRange object containing formulas to be recalculated.

Remarks

The Calculate method calculates all cells contained in the specified range. If the CalculationOptions.Iterative option is enabled and the DocumentOptions.CalculationEngineType property is set to CalculationEngineType.ChainBased, the dependency tree is not constructed and the cells are calculated from left to right, top to bottom.

See Also