-
Notifications
You must be signed in to change notification settings - Fork 107
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
#CYCLE! shouldn't occur when the IF condition is not met #336
Comments
By design. ATM no plans to change the behavior, because it would affect the performance. |
We should also remember, that this would require revision of the main assumptions of the design of HyperFormula. It seems possible, but we should expect a big change in the engine. |
Even simpler example presenting this issue:
as currently HF will return |
I get the following results:
so it works as in excel? |
Yes, this works. But the problem is when the |
Related: #1214 |
Description
If we have an IF function where the conditions that lead to #CYCLE! error isn't met we will get an error anyway. All other spreadsheets I've checked, GS, XL, LC, handles this situation differently. When the condition for circular reference is met the GS will show
#REF
with a description about circular reference, XL will display a pop-up, LC will showErr:522
which is described as "522 Circular reference"[1].HF will always return
#CYCLE!
error. Doesn't matter if the condision is met or not.Steps to reproduce
This test should pass
Links
[1] https://help.libreoffice.org/6.2/en-US/text/scalc/05/02140000.html
The text was updated successfully, but these errors were encountered: