The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

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.v19.1.Core.dll

Declaration

bool Iterative { get; set; }
Property Iterative As Boolean
bool Iterative { get; set; }
Property Iterative As Boolean

Property Value

Type Description
Boolean

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

Property Value

Type Description
Boolean

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

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