Comment on LibreOffice downloads on the rise as users look to avoid subscription costs | The free open-source Microsoft Office alternative is being downloaded by nearly 1 million users a week

• PacMan@sh.itjust.works ⁨3⁩ ⁨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

  source

  • pastermil@sh.itjust.works ⁨3⁩ ⁨weeks⁩ ago

    OpenOffice?? That thing is dead. I thought we’re talking about LibreOffice.

    source
• Seaflea@lemmynsfw.com ⁨3⁩ ⁨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.

  source