Back to Devexpress

Workbook.Calculate(CellRange) Method

officefileapi-devexpress-dot-spreadsheet-dot-workbook-dot-calculate-x28-devexpress-dot-spreadsheet-dot-cellrange-x29.md

latest2.2 KB
Original Source

Workbook.Calculate(CellRange) Method

Forces recalculation of the specified cell range in a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Docs.v25.2.dll

NuGet Package : DevExpress.Document.Processor

Declaration

csharp
public void Calculate(
    CellRange range
)
vb
Public Sub Calculate(
    range As CellRange
)

Parameters

NameTypeDescription
rangeCellRange

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.

Implements

Calculate(CellRange)

See Also

Calculation Process

Workbook Class

Workbook Members

DevExpress.Spreadsheet Namespace