IWorkbook.Calculate(Range) Method

Forces recalculation of the specified cell range in a worksheet.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

void Calculate(
    Range range
)

VB.NET

Sub Calculate(
    range As Range
)

Parameters

Name	Type	Description
range	Range	A Range 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.