LesterLyu/fast-formula-parser

Parsing some inputs that are invalid in Excel

danielgesua opened this issue · 2 comments

danielgesua commented

Hi Lester,

I tried parsing "SUM((SUM(A2)-48):(SUM(A2)-48))" in your demo and got a valid answer (the sum of the 2nd row). However, while this works on your parser this would give a formula error in Excel.

Is this desirable behavior for your parser?

Best,

Daniel Gesua

LesterLyu commented

The grammar in the project is different from MS Excel, the current grammar does allow SUM((SUM(A2)-48):(SUM(A2)-48)).
In the future release I may introduce a new way of checking the validity of some grammar.

  • 👍1
danielgesua commented

Nice. Thank you for this project by the way. It really helped us along with ours.