That’s the problem: if you want greater adoption, you must cover the needs of accountants, because Excel knows perfectly well that they are the fixed source of income for companies.
PacMan@sh.itjust.works 4 weeks ago
I really like LibreOffice but I still need Excel. It’s a good 20 years ahead of the OSS software. It works find if your doing light work though
MCasq_qsaCJ_234@lemmy.zip 4 weeks ago
pastermil@sh.itjust.works 4 weeks ago
Makes me wonder, what exactly are you missing on LibreOffice Sheet?
PacMan@sh.itjust.works 4 weeks ago
Easiest thing I can think of off the top of my head is dealing with pivot tables. UI is terrible in OpenOffice also integrations with PowerBI does not exist along with XLookup not existing last I checked
pastermil@sh.itjust.works 4 weeks ago
OpenOffice?? That thing is dead. I thought we’re talking about LibreOffice.
Seaflea@lemmynsfw.com 4 weeks ago
For me biggest missing I’ve found is web/external queries. Excel has a system to log in to an API, retrieve that data and format it before it lands on your sheet.
Libre functionality here is lacking/non existent.
My workaround was to write a python query, add it as a cron job, write that data to a csv then call that csv from my sheet with a timed refresh. Not something the average user can or wants to do.
Everything else I’ve found achievable.