- cross-posted to:
- [email protected]
- cross-posted to:
- [email protected]
cross-posted from: https://europe.pub/post/12592
Originally posted on Reddit
Any accountants use LibreOffice Calc? Is it a good excel replacement? I just downloaded it this week but haven’t tested it yet.
The only thing I really miss from office is Power Query.
For somebody like me with no formal programming knowledge but self taught, it’s graphical interface and feature are really hard to replace.
There’s also OnlyOffice from Latvia.
Yeah nah. I maybe for light weight every day use yeah. But MS Office is a beast for pros.
And they have excel. Nothing beats excel.
I’m not a pro but all the people I know that use it say excel is the best by far
Yep LibreOffice has felt like a beta for the last 10 years. Whoever makes this suggestion might as well use Notepad, because that’s all the functions they seem to need and it’s probably more stable than Writer anyways.
MS Office is scriptable with basic. LibreOffice, on the other hand, supports basic, python, js, beanshell.
Both software have there advantages. Scientific research is often done on Linux, and they use LibreOffice. In University, we also used it, because they said it has better functions for our use-case.
“You can’t get fired for choosing Intel” Was corporate maxim not so long ago. See where it went.
LibreOffice is a really chunky and ugly piece of software.
During the pandemic, my job handed out Linux laptops with open source software like libreOffice, and after a month, people were secretly using Google Sheets.
Yeah, “upgrade” is a strong word for something that’s ugly as sin and just about as unintuitive to use
It’s only unintuitive to you because you memorized how things work in MS Office.
I don’t use office lol
Personally I’ve had an issue with LibreOffice mainly in that it tends to be more unstable and clunky. It oftentimes goes unresponsive on me and has crashed a time or two when loading larger files, but that may be because I’m running it in Windows so I dunno
I imported a 10,000 line csv and every time I scrolled, half the data wouldn’t update. From scrolling.
It’s pretty unusable for me.
I haven’t used LibreOffice in quite some time in favor of OnlyOffice because of how it handles MS Office formatting. Is the formatting situation better for LibreOffice now?
Lol no. It still lacks many of the formatting tools that MS Office has, and documents originally created in MS will frequently get messed up. I use LibreOffice because it’s FOSS, but I’m not going to pretend it’s functionally better than MS Office, because it’s not by almost every metric.
The reason why OpenDocument format is enforced in MS Office, is because it enforces compatibility. Tell everyone who uses docx to stop promoting a proprietary software, they have the option to save to a neutral file format.
I only use this. It got to a point where it is superior to MS Word.
Does it do macros, and does it save in .dotx and DOCX formats?
Yes and yes
I find Softmaker FreeOffice easier to use, especially if you want a similar UI to MS office, german company but not opensource. Now, I only use it occasionally, I don’t know which one is better for heavy users, they have a paid version too.
For some reason I don’t fully understand, LibreOffice hides the option to switch the UI in
View > User Interface
. The optionTabbed
seems to resemble MS ribbon-like style.They should possibly consider to make that a default question on first start-up, like: ‘What interface layout feels familiar?’
I use libreoffice but man libreoffice writer is so finnicky. Formatting is all wonky. Definitely not a 1:1 replacement. It will format things differently than if you opened it in word
I was using Microsoft Word on and off since 6.0 (shipped with Office 4.0), and no version of Microsoft Word was formatting your documents in the same way that the other versions did, and the same version liked to break things on different version of Windows, and sometimes ever on the same version of Windows on the other computer, because locale settings were different.
That being said, Word is a toy that can be replaced with just basically any word processing software (unless you need multiplayer editing from the Sharepoint), it’s the Excel which is the true strength of MS Office, and unfortunately it’s irreplaceable by anything that isn’t purpose-built database processing software.
Excel doesn’t do anything very well, but it can do everything that the twisted minds of the upper management can imagine, and in the hands of person experienced enough and mad enough (and you will become mad enough after couple years of VBA) the possibilities are endless.
LibreOffice Calc on the other hand is limited to 1024 columns, which is a hard limit I hit more than once, and external database integrations are real PITA.
LibreOffice Calc on the other hand is limited to 1024 columns, which is a hard limit I hit more than once, and external database integrations are real PITA.
Might be time to learn an actually programming language and take a database course brother
Nah, I’m good :) I don’t need to touch anything like that those days, days of anything resembling big data are gone for me. But I know of people who need – and who work in dark basements of „Big 4” with terabytes worth of Excel sheets passed down through the generations of data scientists. No one will ever touch those workbooks, as they make the world go round, and last person that understood how it works retired 15 years ago. These setups will survive humanity, and will be estimating resource and energy prices on the international markets long after we’re gone and only entities dealing in resources will be rats and roaches.
Now if they could do the same for Gimp. What a UX mess.
Isn’t Krita considered the better open source image editor now? I keep meaning to learn it.
As of now, there is only Gimp. And it’s very bad.
Its more for drawing than editing images, so not a complete gimp replacement
No issues with Libre Office, but isn’t the point of this scene that homelander really is a downgrade?
He isn’t a downgrade, he is stronger using the other guys DNA. He is mentally effed though, as a result of being brought up in a lab and tested on to see his limits.
Thanks, I wasn’t sure cause in that season they seemed to be somewhat evenly matched in their confrontations.
They needed Soldierboy, Butcher and Hughie to stop him for a moment.
I just wish it wasnt so ugly.
I think the look depends a lot on the icon set in use, which can be changed in the settings. Personally I use the Elementary SVG version on my Plasma Desktops, I find those icons to be clearer and neater than the ones in the Breeze pack. Also the default Font Liberation Sans, while a fine font, has a certain look that looks slightly dated somehow. If you change the default style for all documents to some other font, it looks a lot fresher :-)
I prefer LibreOffice’s ugliness to Microsoft’s strange menus. Anyway they’re also available in LibreOffice, in the view menu.
For the rest of the interface you could look into GTK themes, I think LO’s looks depend a lot of the theme you use. The interface is pretty customizable, I think.
I’m not a fan of people applying nationalism to open source software. I get this is a reaction to another country’s nationalism but it really undermines what open source software is all about.
Yea, The Document Foundation is based in Germany. But Libre Office is an international collaborative open source project, with contributors in many countries.
Open source projects dont have a nationality. Even the ones with organisations based in the USA. And if people really are concerned about US based legal orgs then we should be looking at forking the software.
Its already under open source licences and belongs to everyone regardless of nationality.
TBH, as a New Zealander, highlighting that it’s not based or of the US is a huge win.
Uuuh this is about closed source Microsoft Office Vs open source Libre Office which just happen to be from Germany and thus is the reason why this is posted in this community.
They’re replying because of OP’s comment “based in Germany”
I’ll say, I feel this. I love FOSS, and I love the BuyEuropean movement as well, but I’m also always scared this will turn nationalistic, which I’m not a big fan of…
Precisely my feelings. I hope it doesn’t turn out to in the negative way, but I’m afraid of some of the vitriol I’m seeing already
How would that work though? Nationalistic people tend to be anti-EU, no?
You’re taking it too literally. I don’t know if nationalists tend to be anti-EU, though you’re right that a lot of them are, but I was using nationalistic there very loosely to refer to the negative aspects of nationalistic ideology as applied to Europe — and the EU, in particular.
That being said, it’s very easy to get hooked into a Buy European craze and then shift into Buy YourNation, which can quickly turn into “We’re better than everyone else and if you don’t think that you’re a traitor” and so on and so on…
Eh I just don’t see it… There are just too many ideological conflicts between being nationalist/myNation and being motivated in participating in the avoid USA movement in the first place. The way I see it, they are direct opposite crowds.
For example, do you think Canadians are in danger of going full nationalist because they are avoiding usa products now because Trump wants to make them 51st state?
If anything, it’s mostly a liberal movement.
The way I see it, they are direct opposite crowds.
I think that’s very naïve, to be honest. Ideological conflicts? I think conservatism is hypocrisy, and nationalism is inherently contradicting and artificial. “No hate like Christian love” is a saying for a reason. Those “crowds,” as you put it — and by the way, it’s very easy for anyone to be roped in to any ideology, so I don’t think it’s really a kind of person that believes any given thing, more so a person that happened to have been exposed to this and that at some point or another — are hypocritical, contradicting, and malleable. Well, that’s my take, anyway.
For example, do you think Canadians are in danger of going full nationalist because they are avoiding usa products now because Trump wants to make them 51st state?
Yes!
If anything, it’s mostly a liberal movement.
Do you mean liberal as in American liberal, progressives? That does seem to be the case, for now. I’m not saying the movement is nationalist yet, I’m saying I think the rhetoric is a little iffy, and I’d rather avoid going down those routes!
I think conservatism is hypocrisy, and nationalism is inherently contradicting and artificial.
I mean sure, but I’m saying these tend to not be the kind of people who want to avoid USA products. Like, afd members are probably not boycotting Teslas or twitter etc right now, if you know what I mean.
No I don’t mean american liberals, i mean its more liberals in general (canada, EU…) supporting this kind of movement, american liberal leaning people seem to be supportive of it too as far as I can tell.
I can’t speak for others, but at least I am trying to avoid USA products, not because suddenly I feel like local products are superior (in many cases they are not, often there is no alternative at all), I just don’t want to support this corporate capture bullshit in USA. That’s it. There’s nothing conservative about it. I really don’t know why they called it buyfromEU or buyeuropean or whatever, but what i’m noticing is that if you want to avoid USA products, almost every alternative is from EU (as long as you want to avoid China too). And it’s not really about EU anyway, people promote Canada or UK stuff all the time.
Please be careful with quoting! You need to add a a double-paragraph after the >, otherwise it all gets joined in a single quote block.
I mean sure, but I’m saying these tend to not be the kind of people who want to avoid USA products. Like, afd members are probably not boycotting Teslas or twitter etc right now, if you know what I mean.
I suppose that’s true, but there’s levels to this. AfD is fascistic, no? You’re going into ultra-nationalism there. It’s not that you’re either not a nationalist or AfD. I know that’s not what you said, but what you did say just doesn’t really mean much, IMO. Nationalists can easily support the idea of rejecting foreign products! That’s something very nationalistic. I don’t think we should mistake nationalism, in general, with the worship of capital; they are often connected because conservatives are hypocrites, but they are not the same. AfD, from my understanding as an outsider, is just another fascist party rising in the EU with the strict goal of furthering capital and their own interests, using populism as a tool to get people on their side. I hope I’m making sense here…
No I don’t mean american liberals, i mean its more liberals in general (canada, EU…) supporting this kind of movement
Uh, no, I disagree. I don’t see a lot of liberals supporting this at all. Then again, I’m on Lemmy where seemingly every other person is a leftist. I mean, a big part of the movement, from what I’ve seen, is a critique and rejection of American free-market capitalism, which is not a particularly liberal position at all. You see people clamouring for state adoption of decentralized social media, and the idea has been pushed (on Reddit, and I believe here as well) of an EU-funded public social platform for EU citizens. I don’t think that sort of position aligns with liberal policy; rather, it aligns with a leftist, socialist perspective. I’d say.
I really don’t know why they called it buyfromEU or buyeuropean or whatever, but what i’m noticing is that if you want to avoid USA products, almost every alternative is from EU (as long as you want to avoid China too). And it’s not really about EU anyway, people promote Canada or UK stuff all the time.
It does have the EU flag, but it’s about Europe as a whole. Even when they say EU, it’s shifted to include the UK and other non-EU countries. It’s just that the EU has better regulations, so it’s usually a better choice, as a consumer.
Also, I’m pretty sure it got called Buy From EU because they wanted to create some sort of tribal attachment and appeal to a broader cultural connection, therefore highlighting the cultural divide between Americans and “Europeans.” Culture, culture, culture… Huh, I wonder what ideology has such a focus on culture… Bingo!
And please, the goal is not to “avoid USA products.” That’s not what this is about, and if you make it about that then it’s not a question of if nationalism will creep in; it’s a certainty. Make it about supporting EU-businesses, about strengthening the regional economy, and about showing that great products and services can be produced outside of monopolies!
So… we supposed to be rooting for Homelander now?
For real. I really hate how all the internet has just decided to meme with homelander like he is a good guy. Any meme I see with him I just assume some sort of malevolence behind it because he is so fucking evil.
No it’s just saying libre office kills babies
Is that how it loads so fast?
No, the babies are necessary to parse the .doc format.
Thankfully nobody uses that anymore, praise be
I have a coworker that regularly sends *.xls files. They always function fine, so I really have no reason to complain.
Weird
xls files are blocked in our company because they can contain potentially harmful macros
No, it’s bloated as shit so it uses techniques from 2000s java to keep a good portion of it in memory at all times from boot to shutdown.
Try loading a portable version of libre office (ie if you have admin rights issues). It’s a solid ten second cold load on a 2 year old system.
*eats
It’s not like Solider Boy is great either lol.
No, certainly not. I’m just pointing out that with context this meme template means something very different to what it says on the surface.
Unless OP’s point is that LibreOffice is more functional but much, much worse for society while there are better options just off-screen, in which case fair enough and well played.
I wouldn’t over think it. It’s just about the line used. The same way people use the Spider-Man template where he sees clearly with his glasses even though in the scene he sees better without them.
I feel like a meme academic lmao. “Well, yes, but the colloquial usage of templates often aren’t a one-to-one with what’s being shown, in Sam Raimi’s Spider-Man,”
I’d hoped my last line would convey I was being more light-hearted than pedantic.
I’d hoped my last paragraph would convey the same back.