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 ⁨1⁩ ⁨week⁩ ago

• pastermil@sh.itjust.works ⁨1⁩ ⁨week⁩ ago

  Makes me wonder, what exactly are you missing on LibreOffice Sheet?

  source

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

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

      source
  • Seaflea@lemmynsfw.com ⁨1⁩ ⁨week⁩ 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
• MCasq_qsaCJ_234@lemmy.zip ⁨1⁩ ⁨week⁩ ago

  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.

  source