Error beautify formula: =SORT($B$3:$F$20,{2,1},{-1,1})

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

Error beautify formula: =SORT($B$3:$F$20,{2,1},{-1,1}) #83

Open AhmedAbdelkhalek opened 4 years ago

AhmedAbdelkhalek commented 4 years ago

The result was =SORT( $B$3:$F$20, { 2, 1 ARRAYROWSTOP) ARRAYSTOP), {- 1, 1 ARRAYROWSTOP) ARRAYSTOP) )

Is there a way to fix that issue?

matepek commented 3 years ago

brainysmurf commented 3 years ago

I'm seeing the same issue. Any formula with array literal doesn't parse.

jlaramie commented 2 years ago

I'm working on converting this to use https://github.com/psalaets/excel-formula-tokenizer instead of the copied and modified source it currently uses.

This is the fork I'm working on currently which passes all tests but no longer maintains the source of the tokenizer. https://github.com/joshbtn/excelFormulaUtilitiesJS/pull/97