(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”.
The Libre Office Suite is better, and Free Open Source Software (FOSS).
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”.
Libreoffice calc is pretty hurrendous tbh
It’s ok if you use it for simple things. Simple arithmetic
Yeah, I prefer Grist