>
I can't imagine trying to replace MS word with libreoffice for businesses. I respect the project and the complexity of the task, but it's just not there for even light professional use.
Exactly.
Just work in the finance or insurance industry for a year, and you will see how it is part of the daily workflow to use very obscure, advanced Excel feature combined with VBA. If a proposed Microsoft Office alternative cannot handle this, it's not suitable.
I personally observe that a lot of nerds who barely use Excel in their daily workflow patronising that ... (in particular LibreOffice) is an alternative to Microsoft Office. Better first learn how the actual powerusers' workflows (in particular for Excel in the finance and insurance industry) actually look like.
> I personally observe that a lot of nerds who barely use Excel
Most people using Excel/Sheets/Word/Docs are not power users. Pretty much all home use is covered by OpenOffice and that is the majority by user count.
Totally agree. I would never use windows at home but Excel at work is the main reason to ever use Windows.
I have Libre Calc installed because I am on mint at home and even if it could do everything excel could do, I don't know how to do things the same way. Neither do most people. The personal experience and network effect is insurmountable for other software.
There's an import function in the File dropdown, with a dialog giving you control over separators. If that fails, you can paste the data, followed by Data > Split text to Columns. I work with CSVs in Google Sheets often and it's pretty reliable.
You can either complain about how Microsoft is treating or you can keep making excuses and add on requirements until there is no alternative but if you keep doing both you deserve whatever you get.
Exactly.
Just work in the finance or insurance industry for a year, and you will see how it is part of the daily workflow to use very obscure, advanced Excel feature combined with VBA. If a proposed Microsoft Office alternative cannot handle this, it's not suitable.
I personally observe that a lot of nerds who barely use Excel in their daily workflow patronising that ... (in particular LibreOffice) is an alternative to Microsoft Office. Better first learn how the actual powerusers' workflows (in particular for Excel in the finance and insurance industry) actually look like.