News for hackers. Stuff that matters.
Re:Excel Labs, a Microsoft Garage Project by rickdeckard on Friday May 26, 2023 @07:18AM (#36082659)
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.

Re:Excel Labs, a Microsoft Garage Project by loudmax on Friday May 26, 2023 @08:46AM (#36083335)
> 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.

Re:Excel Labs, a Microsoft Garage Project by aaravchen on Friday May 26, 2023 @09:04AM (#36083530)
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.