search

LesterLyu / fast-formula-parser

Parse and evaluate MS Excel formula in javascript.
https://www.npmjs.com/package/fast-formula-parser
MIT License
462 stars 64 forks source link

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

Open makarandp0 opened 2 years ago

makarandp0 commented 2 years ago

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