News for hackers. Stuff that matters.
Re:Like MS Excel, Pivot tables never die by happytoexplain on Thursday October 16, 2025 @10:33AM (#45605846)
Excel is fantastic. I love it.

But using a spreadsheet to store data is completely reasonable. We delude ourselves as technically experienced people when we imply otherwise. When Excel fucks up data (perhaps the most unforgivable sin in all of software) with unexplainably bad defaults and UX for auto-formatting (i.e. "trying to be clever"), it's absolutely out of touch to point the finger at the end user.

Re:Like MS Excel, Pivot tables never die by xnx on Thursday October 16, 2025 @10:44AM (#45605993)
> unexplainably bad defaults and UX for auto-formatting

Agree. Soooo many leading zeroes have been striped from ZIP codes.

Equally as bad is no visual indicator to distinguish formula cell from static cells. Easy to silently overwrite formulas with a careless paste.