4 ms·
Oh, I need to check that out. The universal language and portability of a spreadsheet is really hard to beat. Seeing how people often read xls-sheets by backtr
by rickdeckard 3y ago
Oh, I need to check that out. The universal language and portability of a spreadsheet is really hard to beat.
Seeing how people often read xls-sheets by backtracking formulas, it would be great if MS could add support for comments within formulas (multiline formulas being a thing for many years now)
That wouldn't blow up the whole complexity of formulas, but still allow at least to explain some of these huge formulas people have to deal with on a daily basis.
- loudmax 3y ago> The universal language and portability of a spreadsheet Depends strongly on your definitions of "universal" and "portable". Try reading these files with non-proprietary software.
- rickdeckard 3y agoYes, very valid comment. Portable in the sense of sharing something across different departments of a company, universal in the sense of a tool that can be understood and used across many disciplines of work.
- aaravchen 3y agoAs a hack workaround, I drop everything into a `let` block and define "variables" named "comment1", "comment2", etc that are just comment strings and otherwise unused. It affects performance if you're hitting that formula a lot with disparate data, but most of the time anything needing performance from a cell should be using the new arrays processing anyway.