TdxSpreadSheetOptionsBehavior.IterativeCalculationMaxCount Property
In This Article
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 Iterative
The IterativeCalculationMaxCount property’s default value is 0.
See Also