fast-formula-parser
fast-formula-parser copied to clipboard
LesterLyu
Parse and evaluate MS Excel formula in javascript.
This PR adds support for ranges like `$A1:$A3` or `$1:$3` I found in an Excel file lately. I added according unit tests. Thanks for considering.
Currently `=SUM(A2:A)` computes the entire column as if the formula was `=SUM(A:A)`. While this would throw an error in Excel, google sheets parses this as the entire column, starting at...
Hi Lester, I have an issue with parseAsync : If both arguments use not implemented function then we have an UnhandledPromiseRejectionWarning. You can reproduce with this formula "SUM(NOTIMP1(2,1), NOTIMP2(3,4))" I...
Is there any plan/time table for Type definitions?
`50*.85` throws an error while `50*0.85` works. Is this an issue with the parser?
## Why? People need to know the format of the formula result to visulize the result. ### Example 1: `DATE(2000, 1, 1)` results in - `36526` in **General** format -...
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...
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...
Hi, we have the formula defined in a excel sheet that formula is reference to multiple cell values from another sheet in same excel file. we have to evalute that...
