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

Formula doesn't recalculate When IF mentions diving by zero #5272

Closed
AMBudnik opened this issue Jul 19, 2018 · 1 comment
Closed

Formula doesn't recalculate When IF mentions diving by zero #5272

AMBudnik opened this issue Jul 19, 2018 · 1 comment

Comments

@AMBudnik
Copy link
Contributor

AMBudnik commented Jul 19, 2018

Description

The formula results in a bug as the if false value returns a bug (we can't divide by zero). If you type there anything else the formula works.

As mentioned on our forum

an IF() must never evaluate both the true & false results, because for example that could lead to a division by zero error from the route which the IF() will not follow. It must evaluate the condition first, and only then decide which single one of the two result to evaluate.

Steps to reproduce

  1. Uncomment the first line of data to see proper behavior

Demo

http://jsfiddle.net/y7wp6qvm/

Your environment

  • Handsontable version: 5.0.0
    not version related
  • Browser Name and version: Chrome 67
  • Operating System: Windows 10

Inform forum

@AMBudnik
Copy link
Contributor Author

We should stick to the origin repo https://github.com/handsontable/formula-parser/issues/57

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant