this post was submitted on 12 Aug 2023
429 points (95.9% liked)
Asklemmy
44184 readers
1227 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
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
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.
Honestly anything I can't do easily in Google docs probably means I should just do it in Python anyway.
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.
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.
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.
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.
I'm not usually doing any filtering of information. I'm doing calculation based analysis on tax returns for commercial loan underwriting.
Ah gotcha - well it always comes down to use case, imo.