LibreOffice is a free, open-source office suite developed by TDF, based in Germany.

It works great. Not much difference.

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.

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.

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.

"You can't get fired for choosing Intel" Was corporate maxim not so long ago. See where it went.

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.

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.

I also think it's a bit odd. If you're using LibreOffice you're not buying it. I think choosing a FOSS alternative to a US-based commercial product is valid in itself regardless of where the organisation is located. If TDF was located in the US what would it change?

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.

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...

TBH, as a New Zealander, highlighting that it's not based or of the US is a huge win.

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.

No it's just saying libre office kills babies

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.

It's not like Solider Boy is great either lol.

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.

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.

Yes and yes

For some reason I don't fully understand, LibreOffice hides the option to switch the UI in View > User Interface. The option Tabbed 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?'

Isn't Krita considered the better open source image editor now? I keep meaning to learn it.

cryptpad.fr if you need a google docs alternative. DONATE BTW; they are not a megacorp.

To ensure better compatibility, do a fresh save-as to another format if possible on MS side (docx-doc, doc-docx, -docm, whatever). It forces Office to rebuild the file, i believe, and usually it fixes some display mistakes coming from excessive formatting, trashes the leftovers of previous edits, etc, and the file itself becomes lighter. Some other tricks:

1. Have strict formatting rules and only select amount of styles. If you see them mutating, choose to select everything with a style-bastard applied, and then reapply their parent to all affected paragraphs (after what it should disappear);
2. Don't use rare fonts as long as possible, and if you do, on different machines too, copy them from Windows fonts folder in advance;
3. Overwhelmingly long and complex tables in Word usually break. The most dire offender is how you unite cells and move separate cells' borders, because it breaks their structure. Google has workarounds iand limitations on that in their products. To ensure your table translates right, copy it into Excel and then back after setting all cells in Excel to text data, as it likes to reformat e.g. 18.03.2025 into date format and such.

Some of these problems occured to me between different installations of MS products themselves, and with LO I had it the other way: Excel had a bugged file that wasn't adjustable in how to print it. One column wasn't fitting on the page one, but once I move the guideline over that column, Excel cuts this table into 70+ pages, one cell on each. The only thing that helped is opening this exact file in LO Calc where this problem just can't be reproduced. Since that I use Calc first, and then Google Sheets as I haven't found a fitting online sharing solution for myself and get invited tonedit it by others, and Excel is not an option at all anymore.

Same. I've had some professional frustrations when spreadsheets don't carry over formatting correctly and dealing with macros is a pain, but it's great to start with or if you aren't collaborating.

LibreOffice is a fork of OpenOffice and most developers went to work on LibreOffice instead. You should consider switching to LibreOffice.

OpenOffice is not recommended, I hope you mean OnlyOffice, they get confused sometimes.