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.
As 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.
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.
Comments
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.
As 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.
Depends strongly on your definitions of "universal" and "portable". Try reading these files with non-proprietary software.
Yes, 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.