Allow formulas to be formatted and editted like code in the formula dialog box
When writing complex formulas, it is very difficult to troubleshoot errors with in-line formats and although I can 'simulate' writing the formula like code in the formula dialog box, it is very cumbersome as it doesn't treat 'enter' as a next line and 'tab' as a tab. Also, when using this format in the current version, selecting a formula part and clicking on the fx doesn't show the values, only blanks. A sample is attached showing the format. Would it be possible to setup the formula dialog box to support a more coding IDE model?
Jeffery Teall commented
I guest formatting is an issue for this tool as well as it wiped out the spacing of the example.