• 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.

          • 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.

    • snowe@programming.dev
      link
      fedilink
      arrow-up
      4
      arrow-down
      2
      ·
      1 year ago

      That’s what I came here to post. People always think that other software are actual options. If you are using drools rules then other software can’t even follow the xlsx standard properly enough to even allow drools to compile correctly. It sucks because I’d rather not have to get licenses for my whole team to use excel when there’s plenty of free options and we don’t even use it that much, but it’s just so far into another league it isn’t even close.

        • snowe@programming.dev
          link
          fedilink
          arrow-up
          2
          arrow-down
          1
          ·
          1 year ago

          I mean, maybe, but that doesn’t really change anything. Excel is better for a lot of use cases and whether that’s due to terrible antitrust violations or not doesn’t really change the fact of the matter. I honestly would love to use Libre or Open office, and it’s literally the first thing I tried, it just doesn’t work for most of the things I would need it for.

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

        What are drools rules? All the pages I’m reading are very high level “bueiness rules” what does that even mean?

        • snowe@programming.dev
          link
          fedilink
          arrow-up
          2
          arrow-down
          1
          ·
          1 year ago

          oh sorry, forgot I wasn’t on a programming community. It’s a software for writing rules for business operation. Not relevant to the majority of people on the planet.