-
Notifications
You must be signed in to change notification settings - Fork 108
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
[Bug]: Functions do not take null named expressions into account #1389
Comments
Hi @jboysen! Thank you for reaching out to us. This behavior doesn't seem correct. We will fix it in one of the upcoming releases. It seems that there is an issue with the implementation of the function Other functions from NumericAggregationPlugin may also be affected by this issue. |
Hi @sequba, Thanks a lot, sounds nice. Looking forward to the fix. |
Description
We have found a deviation from Excel where named expressions not set are taken into account in functions. E.g. for the following code:
In Excel the corresponding example correctly yields 1: Hyperformula function issue.xlsx
This causes some issues, as it either requires that users of Hyperformula always define all required named expressions or they take this into account in formulas, which will give very long formulas.
Video or screenshots
No response
Demo
https://jsfiddle.net/9muhqwct/3/
HyperFormula version
2.6.2
Your framework
No response
Your environment
Chrome 122 on Windows 11
The text was updated successfully, but these errors were encountered: