TdxSpreadSheetOptionsBehavior.IterativeCalculationMaxCount Property

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

Declaration

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.