TdxSpreadSheetOptionsBehavior.IterativeCalculation Property

Specifies if the spreadsheet formula engine resolves formula expressions with circular references.

Declaration

property IterativeCalculation: Boolean read; write; default False;

Property Value

Type	Default
Boolean	False

Remarks

A circular reference in a formula expression refers to the cell where the formula expression is. If the IterativeCalculation property is set to False and a formula expression contains a circular reference, the spreadsheet formula engine raises an EdxSpreadSheetCircularReferencesError exception. Otherwise – the IterativeCalculationMaxCount property value determines the number of iterations.

Note

Not all built-in functions can accept circular references.

The InterativeCalculation property’s default value is False.