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

Number parenthesis levels #84

Open Ronsss opened 4 years ago

Ronsss commented 4 years ago

Could you add an option to add numbers to identify the parenthesis levels ie =IF(#1 SUM(#2 IF(#3 FOO = BAR, 10, 0

3),

    10
#2) = 20,
"FOO",
"BAR"

1)

Naturally they should have a different color.

Ronsss commented 4 years ago

Note: ignore the green/yellow/blue highlights in the image. I applied them to help me identify categories of elements in the formula. You would have no way of doing this.

Ronsss commented 4 years ago

Sorry, I didn't mean to close the whole suggestion.

Ronsss commented 4 years ago

Wow, am I an id-10-t on this site