Skip to content
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

IF greater than error on 2.2.8 #70

Open
jeanie77 opened this issue Oct 4, 2023 · 0 comments
Open

IF greater than error on 2.2.8 #70

jeanie77 opened this issue Oct 4, 2023 · 0 comments

Comments

@jeanie77
Copy link

jeanie77 commented Oct 4, 2023

I would like to reopen issue #62 about an error that was introduced with the lastest release of calx 2.2.8:

IF(C6>0,B:B/C6,0)                 // #ERROR!
IF(C6> 0,B:B/C6,0)                // ..ok..

If the formula contains a "greater than" expression, a space must be added after the ">" symbol, otherwise the result will be "#ERROR!". The previous version of the library behaved well in both cases, with or without spaces.

Since this formula is being inserted by the user and then saved to database, I'd rather not force him to enter unwanted spaces. Also, there are many formulas on each table that must be calculated, so it would be dangerous (and probably expensive!) to parse all of them to fix spaces on the fly.

Have you found maybe, over the years, a fix that solves the problem? Or could you please suggest me a workaround to let the user enter the spaces he wants, without having errors during calculation?

@jeanie77 jeanie77 changed the title IF greater than after upgrading IF greater than error on 2.2.8 Oct 4, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant