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
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.
Makes me wonder, what exactly are you missing on LibreOffice Sheet?
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
OpenOffice?? That thing is dead. I thought we’re talking about LibreOffice.
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.