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.v23.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
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 |
|
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.