search

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

Add folding option #15

Open minio opened 11 years ago

minio commented 11 years ago

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 argument (which may be nested formula) and numbers as later arguments. Then user could just hide nested part and see all arguments at glance.

joshbtn commented 11 years ago

Sounds like a good idea. Thanks for the suggestion, I'll include this in my next push.

jkeruzec commented 5 years ago

Interested into this also !

jgrisham commented 3 years ago

Fyi, many text editors that support code highlighting/folding (e.g. VSCode on Mac/Windows/Linux, Notepad++ on Windows) can actually highlight and fold/unfold Excel formulas as well. Do the initial beautifying here, and then edit / analyze there.

If there isn’t an explicit Excel language option, try selecting Swift instead - that has been working well for us.

Additionally: when the Let function is available in your version of Excel, arguments can be moved to the beginning of the formula for better readability.