-
Notifications
You must be signed in to change notification settings - Fork 270
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Handling of circular references #4
Labels
Comments
Circular references are now ignored on functions such as ROW and COLUMN. For other circular references the calc engine will either throw a CircularReferenceException if ExcelCalculationOpton.AllowCircularReferences is set to false (default) or count the cell as empty if it is set to true. The default behaviour of this property can also be set via configuration files. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
The handling of circular references needs a redesign for the following reasons:
Currently a CircularReferenceException is always thrown when the formula engine detects a circular reference during construction of the dependency chain. We want to move the logic for throwing this exception downstream to the compiler so that it only is thrown when Calculate is called.
Some functions should be able to ignore if a circular reference occurs.
The text was updated successfully, but these errors were encountered: