As usual, most people attempting to replace Office don't get the features that are actually available.
Amongst my personal peeves are: inability to do non-integral scrolling; no multi-statement functions or inline-variables; still no sane and consistent CSV support; and still no TryParseDateExact and TryParseCurrency functions - using Excel when you want to use ISO 8601 consistently is painful.
There are the programming languages everyone complains about, and the ones that nobody uses.
FWIW, I can do everything I need with LibreOffice. It even runs stable on my Mac. However, on Citrix, my employer does not have LibreOffice, so I gotta resort to MS Office. I gotta work with the tool which is tge default, my choice of preference be damned. Which is rather standard. And students learn to use MS Office because if massive discounts. Bail 'em in when young, and you get lifetime customer. How I ended up staying with my bank post student years.
Which are they? Libreoffice calc has a lot of jagged edges, google sheets is very slow on even modest sheets.
I think PowerPoint has simultaneously been the best - and the worst - thing to happen to academia in the past 100+ years, and PP has only been out with good MM projectors for only the past 20 years - it has tremendous value. It’s only a bad thing when people aren’t using it correctly - though I appreciate that good software should be difficult to use incorrectly.
(okay, next worst thing after Blackboard).
https://www.edwardtufte.com/bboard/q-and-a-fetch-msg?msg_id=...
It is possible to lie using ordinary sentences and paragraphs, but slides pile on even more ways to deceive. They encourage you to break up the flow of information into optimistic headlines and soundbites followed by fine print that is easily ignored.
Slide decks are humanity’s most dangerous invention. We should teach our enemies about slide decks. When we meet aggressive aliens, we can sell them Powerpoint to slow them down. Too bad our own military already uses it; I’ve read that all of our high–level military planning is done by Powerpoint presentations.