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

variables are treated differently than cells - why? and any workarounds? #55

Open
makarandp0 opened this issue Sep 15, 2022 · 0 comments

Comments

@makarandp0
Copy link

Firstly Thank you for all your contributions - Its amazing utility !

I am trying to use this in our workflow but have found an issue:

Lets say Cell A1 has value "1"

SUM("1", "1") === 2
SUM(A1, A1) === 2
but
SUM(var1, var1) === 0 where var1 resolve to A1

This is because code treat literals different from variable references.
https://github.com/LesterLyu/fast-formula-parser/blob/master/formulas/functions/math.js#L599

Is there any way to be able to use variables but let them be treated similar to literals or cell references?

Thank you for all your contributions !
Makarand

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