formatFormula* with array literals has buggy output

joshbtn / excelFormulaUtilitiesJS

Based on ewbi's go calc excel formula parser http://ewbi.blogs.com/develops/popular/excelformulaparsing.html. 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

formatFormula* with array literals has buggy output #89

Closed brainysmurf closed 3 years ago

brainysmurf commented 3 years ago

For example, the simple legal formula:

={F2:G}

results in:

={ F2:G
  ARRAYROWSTOP)
ARRAYSTOP)

I'm happy to help figure out but could use some pointers on how to adjust the algorithm.

joshbtn commented 3 years ago

Fixed in https://github.com/joshbtn/excelFormulaUtilitiesJS/pull/92