Asklemmy

43816 readers

1070 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!

Open-ended question
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.
Not regarding using or support for Lemmy: context, see the list of support communities and tools for finding communities below
Not ad nauseam inducing: please make sure it is a question that would be new to most members
An actual topic of discussion

Looking for support?

Looking for a community?

Lemmyverse: community search
sub.rehab: maps old subreddits to fediverse options, marks official as such
!lemmy411@lemmy.ca: a community for finding communities

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

founded 5 years ago

MODERATORS

432

Which proprietary software do you prefer over their open-source alternatives, and why? (lemmy.ml)

submitted 1 year ago by mayflower@lemmy.ml to c/asklemmy@lemmy.ml

657 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

[–] CafecitoHippo@lemm.ee 32 points 1 year ago (3 children)

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 8 points 1 year ago (2 children)

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

[–] CafecitoHippo@lemm.ee 3 points 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 1 points 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.

[–] LeFantome@programming.dev 4 points 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.

[–] The_Walkening@hexbear.net 4 points 1 year ago (1 children)

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.

[–] CafecitoHippo@lemm.ee 1 points 1 year ago (1 children)

I'm not usually doing any filtering of information. I'm doing calculation based analysis on tax returns for commercial loan underwriting.

[–] The_Walkening@hexbear.net 1 points 1 year ago

Ah gotcha - well it always comes down to use case, imo.