excelFormulaUtilitiesJS

excelFormulaUtilitiesJS copied to clipboard

Suggestion: extension for VSCode

2

It would be useful to have this functionality as a VS Code extension or language.

cmargoli

negative sign placed at beginning of line instead of in front of modified expression

1

I have the formula: ``` =IF(AB$5=$C$6,(1+$C$18)*(-$H$4-$H$5),IF(AND(AB$5>$C$6,AB$5

benmccann

Fixing up package.json

5

- Modified the way tests are called for cross platform testing - Added a 'build' package script for running gulp

jlaramie

Replace tokenizer

2

This is an effort to remove the formula tokenizer and replace it with the one in excel-formula-tokenizer - As a consequence this fixes #83 and a test as added This...

jlaramie

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

3

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


NTCarlos

Is there a way to make a contribution to Josh through Venmo or PayPal. I was needing to document a lot of Excel formulas and stumbled across his Online Excel...

arholland1970

Add folding option

3

Hi I think it would be great, if one could also fold indented parts of formula. This would be especially useful for text formulas, that mostly receive text as first...

minio

Throwing an error when an excel function is not supported

1

Hi, I want to use the "formula.toJavaScript(formula)" but there are some excel functions like : ISBLANK or NOT that are not supported for js ( and cSharp). So first of...

coral-re-ma

Edit formula

4

Would be nice if you could edit the formula while it is formatted

Mattwmaster58