EdxSpreadSheetCircularReferencesError Class
The exception class for handling circular references detected when parsing formula expressions.
Declaration
EdxSpreadSheetCircularReferencesError = class(
EdxSpreadSheetError
)Remarks
This exception is raised to warn an end-user that a formula expression containing one or more circular references can be calculated incorrectly if the iterative formula calculation functionality is disabled. A circular reference within an expression refers to a cell or cell range containing the expression’s calculation result:
Note
The EdxSpreadSheetCircularReferencesError exception is never raised if the iterative formula calculation functionality is enabled (for instance, if the Spreadsheet/Report Designer control’s OptionsBehavior.IterativeCalculation property is set to True, and the OptionsBehavior.IterativeCalculationMaxCount property value is positive).