I ended up appending an open paren to the function names and using that as Folder Open Keywords. Not the worst thing in the world, but not would I would do intuitively. That still may be a better option, although it would require that I consistently line break before the open paren rather than after. However, it seems to require a space before the open parenthesis or to have it start a line to work. Then I thought that simply having an open parenthesis as the only Folder Open Keyword would be even better. That worked OK, but didn’t work well with FALSE as FALSE is both a potential argument and the name of a function.
I started by trying to make all of the function names Folder Open Keywords and a close parenthesis as the Folder Close Keyword. Folding is collapsing certain portions of the code so the rest is easier to read.
The only thing I don’t like about it is the folding option. I downloaded Notepad++ and Bob’s xml files and gave it a try. He uses a custom language in Notepad++ to allow for indenting formulas, editing formulas, and all the other stuff you can do in a text editor that you can’t do in Excel’s formula bar.
Bob wrote a blog post last week, Formulas Made Easy, that I read with great interest.
0 kommentar(er)
