> 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.
Re:Excel Labs, a Microsoft Garage Project
by rickdeckard on Tuesday May 30, 2023 @03:53AM
(#36122217)
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.
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.
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.