> "
because 1% of Excel users need pivot tables or something"
It's crazy to me how often Open Source pushers have the vibe "I don't use computers, I don't know what anyone does with computers, but I'm still dismissive and superior". I almost made this comment earlier today in reply to [1] which was another "You have problems with Linux? I daily-drive Linux for years and I've never had any problems" comment and the issues were common/well-known things - fractional scaling in Gnome, HDMI, screen sharing in Slack, crashes in Google Meet, crashes in Chrome, KDE unstable, missing desktop software they use, audio too buggy, constant crashes in another program after days of work.
Nothing anyone would be surprised at, except a Linux user who - apparently - never does anything with their computer and is baffled that other people do. I decided my comment was too trolling and didn't finish it, but here you are bringing that vibe again: you don't know what Excel does or why people use it, but you're confident that you know better; prompting me to actually call it out.
The first thing I looked for when I installed LibreOffice most recently, I found a thread[2] asking: "In excel you can create a table simply by using insert->table. Is there a way to create tables in calc, as well?" and the first visible reply is them explaining that they don't want to create a table in Write, they want Excel's "insert table" feature in Calc. Why would they have to explain that again already, their question was two short lines. Presumably the people replying don't know that feature exists. There are some people being helpful and suggesting ways to get similar effects, but of course there's "Why do you want to insert a table into a Calc spreadsheet? It doesn’t seem like a feature that I’d use much" ("I don't know what the feature does but I know I don't want it"), a couple people commenting explanations of what Excel's tables are and why they are useful including a link to a video demonstration ... followed by someone saying "It already works, they are called database ranges" - no, that's different. Someone who doesn't know what they are, didn't read the explanations or watch the video and still thinks they know better. Crazy.
One of the earlier repliers comes back with "LibreOffice has a database component which is by far more powerful than any fake tables on a calculator’s grid." doubling down on "I don't understand it, didn't read the explanations, don't respect you enough to consider that you know anything about what you want or do on a computer, I still know better" and with namecalling it 'fake'. Crazy.
Note, to avoid the obvious tangent, that I'm not demanding people implement features for me in free software. As the thread ends by kerosene5 "Instead of spending so much time poo pooing the feature request, you could explore it. It really is a good feature. I just downloaded and opened my bank transactions and the very FIRST thing I did was look how to convert it to a table. . . . back to Excel."
It's not "1% of Excel users need pivot tables or something" it was the very FIRST thing they wanted, and multiple people in that thread want, and the second thing I wanted. No this is not the only feature Excel has that LibreOffice hasn't; if you want to know why people aren't using Open Source software? Try actually looking and listening instead of whatever that is you are doing.
[Edit: THIS IS YOU: https://news.ycombinator.com/item?id=43855927 ! Of course it is. Of course it is].
[1] https://news.ycombinator.com/item?id=43855663
[2] https://ask.libreoffice.org/t/creating-tables-in-calc/1433