Apple's office suite is my favorite I've ever used, and it's not close.
After that, old copies of MSOffice.
Next-best would be a hodgepodge of the lighter options on Linux and such. Gnumeric, Abiword, that sort of thing. Not great, but at least they're light on resources and easy to use.
Distantly after that, LibreOffice.
Then, modern MSOffice in last place.
The only reason I'd count any of them as "worse" than modern MSOffice is that ~perfect office compatibility and a bulletproof excuse when things go wrong ("I'm also using MSOffice, don't know why your document isn't working") is non-negotiable in any business context.
[EDIT] Oh I forgot about Google. That's actually the true last-place. Modern MSOffice isn't worse than that. Christ the performance is awful.
I value performance and stability highly, and Apple's productivity programs are so light I can leave them open in the background and forget they're running for months at a time even on fairly old, weak machines. And I'm not sure I've ever seen any of them crash (I can't say the same about, say, LibreOffice or pretty much any other Linux-associated productivity software). That they're a ton more polished and stable than things like Abiword or Gnumeric, and have most modern features I'd expect (even live collaborative editing) puts them solidly above those other light options.
I hate modern MSOffice's UI, plus it's full of slow, heavy webtech which deducts a lot of points from basically anything for me. Google's leaks memory (like most of their software... so do Gmail tabs) and is so slow that it introduces a ton of input latency, which drives me nuts, I hate to type in it, aside from my experience with most of its formatting and editing features being that they're very janky even by the standards of GUI word processors. Both are very heavy on resources, which means they have a huge hurdle to overcome on the feature side before I'd consider them anything but extremely-unpleasant.
Old (like... '00s) MSOffice is pretty good because it's not such a resource hog, and the UI used to be really good.
I have a google sheet with less than 200 rows in it. Not exactly Big Data. When I load it, the first 100 rows appear pretty much instantly, but the following <100 rows take 9 seconds to load! WTF? I don't know any other spreadsheet that takes that long to load more than 100 rows.
Google does essentially everything I need. If I were more of a spreadsheet power user these days, Excel. And maybe other Office apps as needed for compatibility.
> Apple's office suite is my favorite I've ever used, and it's not close.
I’ve written many comments criticizing this. Do you use a lot of keyboard shortcuts when you use Numbers or Pages or Keynote or do you use the trackpad/mouse a lot? I generally find these apps and others lacking on the keyboard front, by which I mean that it’s almost impossible to use them without a trackpad or a mouse. I can completely live with just a keyboard on Excel or LibreOffice Calc.
BTW, I hate all the MS Office applications (and find them quite buggy and annoying) except for Excel. Maybe I’m just a lot more used to using Excel.
You may want to look into Karabiner Elements. Understandable if one doesn't want to have to allow a privileged daemon access to key inputs, but it allows for complex, application-focus-aware shortcuts. In the past I used a "Windows on MacOS" config preset because it allowed for my 60~70 key keyboard to operate similarly across win/linux/macos. Finally killed my last windows boot drive and main linux... but I do have a ritualistic annual step into a windows vm to file taxes on crack err with a crakced turbotax hehehe. In-tooits lobbying malpractice is deserving of petty flippancy
Numbers has a lot of keyboard shortcuts [1]. Are there particular ones you're missing? Or is your issue that Numbers has different keyboard shortcuts from the ones you're used to in Excel?
A lot of menu options don’t seem to have keyboard shortcuts. I know I can assign them, but defaults should be better.
But the second one hits harder for me: “Or is your issue that Numbers has different keyboard shortcuts from the ones you're used to in Excel?” Considering that Numbers came much later than Excel, some of the common ones could’ve been directly adapted with Mac specific substitutions (like using Cmd instead of Ctrl).
It's not pretty, but both Pages and Numbers are pretty powerful in their modern incarnations. If you actually need Microsoft Office, then you need it, but a lot of people who don't think they could get away with just Apple's freebies probably could.
(Disclosure: I write 99% of my stuff in Emacs now, so I'm not going to go that far out on a limb for iWork. It's just that it's the best "Works"-style suite that I've used.)
I also like Apple's office suite, the problem is network effects. I'd even argue most people don't actually need MS Office. The amount of people using PowerQuery, VBA, etc. is probably less than 2% of users.
The problem is, because everyone else (in business) already has and uses office, if you want to collaborate, that's what you have to use. Open file formats didn't win out in the end.
This is absolutely the problem - with the added issue of platform support.
I’m the only Mac user in our company of 15, which means I’m also the only person that can open a .pages file. Anyone can read a .docx, and if authored in word it will actually look the same on both computers.
Is it 2% who author content using those tools, or are you also including anyone who might need to open and use a spreadsheet using one of those technologies?
It's not "the end" yet. Many governments and sufficiently motivated orgs are switching to ODF - it's only over for proprietary file formats that pretend they can stand toe-to-toe with docx. By eschewing open formats you're making all the mistakes of .docx with none of the upsides of the network effect.
Personally, I like Apple's iWork. Keynote is slightly less fiddly than Powerpoint. I like that in Numbers you can have multiple movable tables on one screen without constraining column widths etc to each other. I also like that Pages is simpler than word with much more manageable styles, especially when copy and pasting from multiple other documents. But lots of people don't have Macs or like iWork, and in most businesses you eventually need MS Office to work with outside parties so for work the choice is really iWork plus MS Office vs MS Office.
MS Office collaboration features work well these days but when you are using Office 365 for work, it's almost inevitable that different files get saved locally, on MS teams, Sharepoint, and OneDrive. It's a version control nightmare.
I really like google's suite for work because it nudges everyone towards using only one location for all files, without a other places to save a copy. And it's good enough with Office files that you might only need a few roles to also need MS Office.
You can drag a pdf into Keynote, and get a vector quality image. This feature is great for science when a plot is made elsewhere (R or matplotlib). Or you can even drag in an SVG, even from something you find in a browser. Drag, drop.
Why in heaven's name is it nearly impossible to do the same with Powerpoint is a mystery. You still have to paste a bit image.
I used word for windows 2.0 well into the early 2000s. My needs aren't crazy and I don't think word has added a single feature I've cared about since. Pages is my current go-to.
This line right he is where I will always stop reading any reply, and block any YouTube channel that uses it in a title. Mind numbingly overused. It's literally verbal clickbait.
After that, old copies of MSOffice.
Next-best would be a hodgepodge of the lighter options on Linux and such. Gnumeric, Abiword, that sort of thing. Not great, but at least they're light on resources and easy to use.
Distantly after that, LibreOffice.
Then, modern MSOffice in last place.
The only reason I'd count any of them as "worse" than modern MSOffice is that ~perfect office compatibility and a bulletproof excuse when things go wrong ("I'm also using MSOffice, don't know why your document isn't working") is non-negotiable in any business context.
[EDIT] Oh I forgot about Google. That's actually the true last-place. Modern MSOffice isn't worse than that. Christ the performance is awful.