(Hint,the devs have flat out stated they will never add tables to Calc, as it’s wrong to do).
99% of Excel usage includes a table in the first, or second, sheet. Without tables a spreadsheet app is useless, in my opinion, regardless of how “wrong” it is (and I agree that it’s wrong).
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”.
I love filter views, no real complaints there except that other people can’t manage to figure out the difference between filtering the whole sheet and setting up a filter view.
Tables seem kind of pointless but better than a separate database app I guess?
Not sure about “little pills”, do you mean the drop downs? That’s in validation, and it’s a little odd but better both in interface and function than Excel. There’s really only one version and two ways to do it: “data validation” and “insert drop-down” (the latter is just a shortcut to the former, but with relevant options selected). Checkboxes are the same (both live in the insert menu).
I’ve never known the “paste style” menu, I mostly use keyboard shortcuts when pasting. I might be misunderstanding what you’re describing there.
The Libre Office Suite is better, and Free Open Source Software (FOSS).
Libreoffice calc is pretty hurrendous tbh
It’s ok if you use it for simple things. Simple arithmetic
Yeah, I prefer Grist
Create a table in Libre Office, I’ll wait…
(Hint,the devs have flat out stated they will never add tables to Calc, as it’s wrong to do).
99% of Excel usage includes a table in the first, or second, sheet. Without tables a spreadsheet app is useless, in my opinion, regardless of how “wrong” it is (and I agree that it’s wrong).
Wait excel sheets are pretty much already tables right…
Everything is a table if you’re brave enough.
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”.
I love filter views, no real complaints there except that other people can’t manage to figure out the difference between filtering the whole sheet and setting up a filter view.
Tables seem kind of pointless but better than a separate database app I guess?
Not sure about “little pills”, do you mean the drop downs? That’s in validation, and it’s a little odd but better both in interface and function than Excel. There’s really only one version and two ways to do it: “data validation” and “insert drop-down” (the latter is just a shortcut to the former, but with relevant options selected). Checkboxes are the same (both live in the insert menu).
I’ve never known the “paste style” menu, I mostly use keyboard shortcuts when pasting. I might be misunderstanding what you’re describing there.
No PowerQuery? No thank you.