Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

CalculationOptions.Iterative Property

Gets or sets whether the application should perform iterative calculations for formulas that contain circular references.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

bool Iterative { get; set; }

#Property Value

Type Description
Boolean

true, to perform iterative calculations; otherwise, false. Default is false.

#Property Paths

You can access this nested property as listed below:

Object Type Path to Iterative
DocumentSettings
.Calculation .Iterative

#Remarks

A circular reference in a formula is a reference to the cell that contains the formula. For such formulas, you should determine how many times the formula should be recalculated. If the Iterative is set to false (default), only the first iteration is performed to calculate the formula. Otherwise, the number of calculations will be determined by the CalculationOptions.MaxIterationCount and the CalculationOptions.MaxChange settings.

See Also