joshbtn / excelFormulaUtilitiesJS

This library contains methods to beautify an excel formula. This library also contains functions to convert an excel formula to JavaScript (ECMAScript) or C# and python.
http://excelformulabeautifier.com/
Other
394 stars 101 forks source link

Incorrect ecxecution in NODE #103

Open Arhimagistr opened 1 year ago

Arhimagistr commented 1 year ago

Your website works correct https://www.excelformulabeautifier.com/?numberOfSpaces=2 with this formula for example: =ARRAYFORMULA(IFERROR(VLOOKUP(A11:A;'Уникальные подписчики'!C2:G;4;0);""))

I installed your package npm install excel-formula But when i execute the code from block (Basic Usage for Node) in NODE it works just with simple formulas like as in example ('IF(1+1=2,"true","false")') but not with this one: =ARRAYFORMULA(IFERROR(VLOOKUP(A11:A;'List'!C2:G;4;0);""))

Can you help or may be it needs to update excel-formula in npm ??