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

[makarandp0]

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

[michaeltford]

Thanks for raising this issue!

fast-formula-parser has now been integrated into the SheetXL project.
For ongoing improvements and support (including TypeScript, ESM, and many new formulas), please see the actively maintained package:

@sheetxl/formulas

The source can be found here:
https://github.com/sheetxl/sheetxl/tree/main/packages/formulas/src

We recommend migrating to @sheetxl/formulas for the latest updates.