Ask Lemmy
A Fediverse community for open-ended, thought provoking questions
Please don't post about US Politics. If you need to do this, try !politicaldiscussion@lemmy.world
Rules: (interactive)
1) Be nice and; have fun
Doxxing, trolling, sealioning, racism, and toxicity are not welcomed in AskLemmy. Remember what your mother said: if you can't say something nice, don't say anything at all. In addition, the site-wide Lemmy.world terms of service also apply here. Please familiarize yourself with them
2) All posts must end with a '?'
This is sort of like Jeopardy. Please phrase all post titles in the form of a proper question ending with ?
3) No spam
Please do not flood the community with nonsense. Actual suspected spammers will be banned on site. No astroturfing.
4) NSFW is okay, within reason
Just remember to tag posts with either a content warning or a [NSFW] tag. Overtly sexual posts are not allowed, please direct them to either !asklemmyafterdark@lemmy.world or !asklemmynsfw@lemmynsfw.com.
NSFW comments should be restricted to posts tagged [NSFW].
5) This is not a support community.
It is not a place for 'how do I?', type questions.
If you have any questions regarding the site itself or would like to report a community, please direct them to Lemmy.world Support or email info@lemmy.world. For other questions check our partnered communities list, or use the search function.
Reminder: The terms of service apply here too.
Partnered Communities:
Logo design credit goes to: tubbadu
view the rest of the comments
LibreOffice Calc.
Pro is that my company is very pro-linux.
Con is that calc is so broken. At first, I thought it was just me. But even our accountants were quietly building spreadsheets in Google Sheets and then "pretending" like they use Calc.
There's a reason people pay for office. As shitty as Microsoft is, they know how to make a spreadsheet.
Excel Desktop > Google Sheets > LibreOffice Calc > Excel Online
Your missing apple numbers somewhere in there. I think between libre and excel online? Been years since I've used it for 5 minutes.
And Only office. Haven't used their spreadsheet but I really liked their word processor overall.
Honestly anything you can't do in Google sheets is something a spreadsheet shouldn't be doing in the first place.
Sure sure, but also https://youtu.be/l40YTagEOC4
That was like those people that build working computers in Minecraft. On one hand it's impressive as all hell. On the other...what the fuck?
Surprising to see that here. It's usually not the solution that corporations choose and for home use it's good enough. Yeah it doesn't work nearly as well as real Excel but it's manageable for simple things.
There is one thing I use Libre Calc over Excel for. It's when I need to use Autohotkey to copy data out of a spreadsheet to be sent to another program. Still, in 2024, with the current version of Office 365 Excel, I will get the error "We could not copy the content to the Clipboard, it is in use by another application", breaking the flow of my macro.
I never have that issue when copying data out of Libre Calc, so I work with my data and formulas in Excel, then open the spreadsheet with Calc when it's time for Autohotkey to do its thing. It's a narrow use case for me but I appreciate Calc for being the workaround I need for that.
Sheets is decent too though, I've made macros for others that use Sheets and did not have any issues working with it.