Add folding option

[minio]

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]

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

[jkeruzec]

Interested into this also !

[jgrisham]

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.