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

C#

bool Iterative { get; set; }

VB.NET

Property Iterative As Boolean

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.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Iterative property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-implement-a-service-to-manage-the-process-of-worksheet-cell-calculation-t270403/CS/CustomCalculationServiceExample/Form1.cs#L24

spreadsheetControl1.BeginUpdate();
spreadsheetControl1.Document.DocumentSettings.Calculation.Iterative = true;
calculationService = new TestCustomCalculationService(loggingControl);

VB.NET

how-to-implement-a-service-to-manage-the-process-of-worksheet-cell-calculation-t270403/VB/CustomCalculationServiceExample/Form1.vb#L23

spreadsheetControl1.BeginUpdate()
spreadsheetControl1.Document.DocumentSettings.Calculation.Iterative = True
calculationService = New TestCustomCalculationService(loggingControl)