News for hackers. Stuff that matters.

A comment on Array Languages vs. the Curse of the Spreadsheet. Parent comment

Re:Array Languages vs. the Curse of the Spreadsheet by jamses on Tuesday March 05, 2024 @05:27PM (#39609959)
Ctrl+` will show the underlying formula, or you could use conditional formatting to apply whatever style you want to static values =NOT(ISNUMBER(FIND("=",FORMULATEXT(A1)))), or you could write a VBA macro to do that and more (e.g. find all the formula that have been zeroised, etc).
[ Parent | on HN ]
Re:Array Languages vs. the Curse of the Spreadsheet by analog31 on Tuesday March 05, 2024 @06:02PM (#39610228)
I did exactly that with a VBA macro, that indicated whether something was a formula, a constant, or empty. I would just put it next to my column of calculations. It was not what I would call "clean code" but sure made it easier to follow my thought process and find bugs.

The macro was the first thing that came to mind. Your formula is cleaner.

[ Parent | on HN ]
Re:Array Languages vs. the Curse of the Spreadsheet by n_plus_1_acc on Tuesday March 05, 2024 @05:47PM (#39610112)
Why not ISFORMULA
[ Parent | on HN ]
Re:Array Languages vs. the Curse of the Spreadsheet by Tomte on Wednesday March 06, 2024 @12:45AM (#39612708)
And that shortcut is very annoying to type on a German keyboard layout.
[ Parent | on HN ]
Re:Array Languages vs. the Curse of the Spreadsheet by qsi on Wednesday March 06, 2024 @03:18AM (#39613575)
You could make it a matter of style discipline. In my non-trivial spreadsheets I typically have cell formatting conventions, e.g. light yellow background is input, light green is formula, etc. You do have do it manually but it's worth the effort in my case.
[ Parent | on HN ]