The only two innovations in spreadsheets in 20 years that I’ve liked are connecting them to databases directly (which still sucks) and being able to collaboratively edit them.
what the hell is going on with “Tables” vs filter views vs slices vs named ranges.
That should all be one properly thought out feature. And tables are so fragile. Nobody knows how to use filters because they default to global. The row groupings feature is entirely broken and forgotten about… they recently updated the filter views UI to be fragile all e s as f throw error messages about whether you’ve saved the change or not (nobody ever cared about this, we’re just trying to filter without breaking the sheet)
The little pills you get for validated entries are nice though, but even that has like 3 different versions and ways to do it.
Then there’s things like checkboxes, I know there’s an option for it somewhere, but I have never once found the menu it lives in.
Oh and the paste style menu item that tells you the shortcut but doesn’t copy stole for you. That is the most written by an engineer feature I’ve ever seen. “You’re doing it wrong, do it my way now or don’t do it all”.
It’s been a while since I’ve used it, how good is it compared to office and Google sheets now?
Similar but with an interface that refuses to do anything new for 20 years.
I don’t know if that’s good or bad
The only two innovations in spreadsheets in 20 years that I’ve liked are connecting them to databases directly (which still sucks) and being able to collaboratively edit them.
Some of it is just familiarity but I found Google sheets to be a breath of fresh air and still find Excel just painful.
Although Google has really gotten pretty cluttered lately as they add features and slap them in whatever menu they pick at random.
100%.
what the hell is going on with “Tables” vs filter views vs slices vs named ranges.
That should all be one properly thought out feature. And tables are so fragile. Nobody knows how to use filters because they default to global. The row groupings feature is entirely broken and forgotten about… they recently updated the filter views UI to be fragile all e s as f throw error messages about whether you’ve saved the change or not (nobody ever cared about this, we’re just trying to filter without breaking the sheet)
The little pills you get for validated entries are nice though, but even that has like 3 different versions and ways to do it.
Then there’s things like checkboxes, I know there’s an option for it somewhere, but I have never once found the menu it lives in.
Oh and the paste style menu item that tells you the shortcut but doesn’t copy stole for you. That is the most written by an engineer feature I’ve ever seen. “You’re doing it wrong, do it my way now or don’t do it all”.