• rich@feddit.uk
      link
      fedilink
      arrow-up
      16
      arrow-down
      1
      ·
      1 year ago

      Ha yeah but to explain, without my excel vba scripts the place I work at would fall apart. Too many systems with varying formats from our clients and excel is the middleman, for better or worse. Nothing else does the job, only excel.

      • finestnothing@lemmy.world
        link
        fedilink
        arrow-up
        5
        ·
        1 year ago

        Libre calc is a great replacement imo. It has support for excel vba macros, but you can also make macros in Python, JavaScript, and their own macro language. For the most part it’s cross compatible with excel, but doesn’t support their xlsm file type as far as I know.

        • rich@feddit.uk
          link
          fedilink
          arrow-up
          10
          arrow-down
          1
          ·
          edit-2
          1 year ago

          I mean, I tried.

          Problem is, I have only limited power in an enterprise led decision. I argued to have Notepad++ enabled on my login for my purposes and they accepted it - but excel is so engrained in everyone’s offices I simply cannot change.

          Excel just works…there’s no fuss or stress or drama with admins. It just fucking works. I’m getting too old for hassle, so office it is.

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

          It’s fine if you never leave Calc. If you’re trying to use Calc at home and Excel at work, it’s absolutely awful. Key bindings aren’t the same. Basic things like auto completing formulas is different. It’s terrible to flip between the two.