Skip to main content

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

TdxSpreadSheetOptionsBehavior.IterativeCalculationMaxCount Property

Specifies the maximum number of iterative calculations in formula expressions with circular references.

#Declaration

Delphi
property IterativeCalculationMaxCount: Integer read; write; default 1;

#Property Value

Type Default
Integer 1

#Remarks

A circular reference in a formula expression refers to the cell where the formula expression is. If the IterativeCalculationMaxCount property is set to 0, the spreadsheet formula engine calculates such an expression only once. Otherwise, the number of iterations equals a positive IterativeCalculationMaxCount property value. The property adjusts an assigned negative value to 0.

Note

The spreadsheet formula engine ignores the IterativeCalculationMaxCount property value if the IterativeCalculation property is set to False.

The IterativeCalculationMaxCount property’s default value is 0.

See Also