429
submitted 10 months ago by mayflower@lemmy.ml to c/asklemmy@lemmy.ml
you are viewing a single comment's thread
view the rest of the comments
[-] rich@feddit.uk 79 points 10 months ago
[-] Smallletter@lemmy.world 39 points 10 months ago

Hah, with no attempt to explain because it's very self explanatory.

[-] rich@feddit.uk 15 points 10 months 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 5 points 10 months 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 9 points 10 months ago* (last edited 10 months 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 5 points 10 months 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 2 points 10 months 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.

[-] 5ublimation@hexbear.net 5 points 10 months ago

Weren't the MSFT X standards intentionally poorly defined with the goal of smothering OpenDocument in the crib?

[-] snowe@programming.dev 1 points 10 months 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 1 points 10 months 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 1 points 10 months 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.

[-] Pantherina@feddit.de 1 points 10 months ago

Why excel? For most things I wouldnt say Libreoffice is worse. Impress though is something to learn.

But now I can use Impress and Writer, Calc too but the graphs are shit. Thats fair to say, graphs in Calc are horrible. The rest should be pretty much the same... I guess, havent used Excel in years

this post was submitted on 12 Aug 2023
429 points (95.9% liked)

Asklemmy

42432 readers
2516 users here now

A loosely moderated place to ask open-ended questions

Search asklemmy 🔍

If your post meets the following criteria, it's welcome here!

  1. Open-ended question
  2. Not offensive: at this point, we do not have the bandwidth to moderate overtly political discussions. Assume best intent and be excellent to each other.
  3. Not regarding using or support for Lemmy: context, see the list of support communities and tools for finding communities below
  4. Not ad nauseam inducing: please make sure it is a question that would be new to most members
  5. An actual topic of discussion

Looking for support?

Looking for a community?

~Icon~ ~by~ ~@Double_A@discuss.tchncs.de~

founded 5 years ago
MODERATORS