• Wheaties [she/her]@hexbear.net
    link
    fedilink
    English
    arrow-up
    21
    ·
    1 day ago

    The spreadsheets seem to run better, at least on initial glance.

    I kinda think that’s the most important thing. Excel is the only service Microsoft provides that’s decent. A proper replacement for that is how you get more people and organizations on open source systems.

    • quarrk [he/him]@hexbear.net
      link
      fedilink
      English
      arrow-up
      2
      ·
      11 hours ago

      Microsoft also makes SQL Server, Azure, and .NET which are all pretty big too. I’m not knowledgeable enough to evaluate them but I think they are at least decent

    • SocialistVibes01@lemmy.ml
      link
      fedilink
      English
      arrow-up
      5
      ·
      1 day ago

      Excel + PowerBI (query?) is too powerful.

      Maybe some LibreOffice + KNime integration + Easier Python macroing would be THE killer feature coming from a FOSS office suite.

      • zedcell@lemmygrad.ml
        link
        fedilink
        English
        arrow-up
        1
        ·
        10 hours ago

        Power Query just trivialises so many once annoying tasks I can’t imagine going back to “just a spreadsheet”

        • SocialistVibes01@lemmy.ml
          link
          fedilink
          English
          arrow-up
          1
          ·
          10 hours ago

          I agree. Do you know KNIME? It does a lot of the same transformations. But something like DAX has to be provided by Python.

          • zedcell@lemmygrad.ml
            link
            fedilink
            English
            arrow-up
            1
            ·
            10 hours ago

            No idea about KNIME personally. I find there’s real value in having the Swiss army knife of Excel that every office worker has access to be able to do really in-depth and multi-step transformations without needing access to a scripting language and package manager. Normally corporate IT are a little cagey handing out access to Python to a random admin staff member, but we all have and can share Excel stuff no problem.

      • SocialistVibes01@lemmy.ml
        link
        fedilink
        English
        arrow-up
        2
        ·
        18 hours ago

        Actually, expanding on that, LibreOffice needs both a book like OpenOffice.org Macros explained, but for Python and a grumpy guru like Villeroy, but on the pythonic side of the fence.