excelFormulaUtilitiesJS icon indicating copy to clipboard operation
excelFormulaUtilitiesJS copied to clipboard

Published 20 hours ago • verified publisher icon joshbtn

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

Open AhmedAbdelkhalek opened this issue 5 years ago • 3 comments
trafficstars

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

Is there a way to fix that issue?

AhmedAbdelkhalek avatar Jul 18 '20 06:07 AhmedAbdelkhalek

+1

matepek avatar Dec 16 '20 17:12 matepek

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

brainysmurf avatar Jan 02 '21 08:01 brainysmurf

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

image

jlaramie avatar Jan 01 '22 23:01 jlaramie