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.
PacMan@sh.itjust.works 2 months 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 2 months ago
OpenOffice?? That thing is dead. I thought we’re talking about LibreOffice.