• CafecitoHippo@lemm.ee
    link
    fedilink
    English
    arrow-up
    35
    arrow-down
    3
    ·
    1 year ago

    Excel. There’s just basic stuff with LibreOffice and OnlyOffice that work like crap. Like why in LibreOffice when I type =sum then hit tab does it think I’m done with the formula instead of adding the ( and letting me put in the first input. It’s awful.

    • socsa@lemmy.ml
      link
      fedilink
      arrow-up
      8
      ·
      1 year ago

      Honestly anything I can’t do easily in Google docs probably means I should just do it in Python anyway.

      • CafecitoHippo@lemm.ee
        link
        fedilink
        English
        arrow-up
        3
        ·
        1 year ago

        I need spreadsheets for work in commercial loan underwriting. We don’t have a commercial underwriting system yet so all our templates are excel based. I waited to move to Linux solely because of Excel when working from home. During COVID though my work finally gave everyone laptops so I didn’t need to do work on my personal rig anymore.

      • AnarchoYeasty@beehaw.org
        link
        fedilink
        arrow-up
        1
        ·
        1 year ago

        Have you tried quadratic? It’s web based but it’s an infinite spreadsheet that lets you use JS, Python, and SQL on your spreadsheets and is open source.

        https://github.com/quadratichq/quadratic

        Never used it but they’ve sponsored No Boiler Plate who is one of my favorite programming YouTubers a few times and he seems to sing their praises.

    • The_Walkening [none/use name]@hexbear.net
      link
      fedilink
      English
      arrow-up
      4
      ·
      1 year ago

      Libre office’s filtering is far better though- being able to apply actual regex instead of Excel’s weird proprietary pattern matching is just so much better that I opt for it most of the time.

    • LeFantome@programming.dev
      link
      fedilink
      arrow-up
      4
      ·
      1 year ago

      I am a big fan of LibreOffice in general and there is not much I need that I cannot do. That said, I agree that Calc has lots of little usability paper cuts like the one you describe that make using Excel a lot more pleasant.