While I think LibreOffice is great and definitely fills the needs for most people, I wish it was more polished. IMO MS Office just feels so smooth and clean, whereas LibreOffice feels clunky and dated. And I miss Excel when using Calc, although it gets the job done.
I guess I am from the old days. For me MSO has had nothing in terms of needed improvements since about 1998. And thankfully I moved to Libreoffice before the ribbon bar and all the VBA issues with 2013. Libreoffice became usable about 2005. Yes it was Excel for me that was the last to go. Solver in particular. As far as VBA, I switched from that to python about 1998.
As far as dated. I think it depends on who you think defines the standard . For me that is not MS.
As a user of advanced excel features like Power Query and even its plethora of built in functions, LibreOffice Calc just doesn’t hold up at all. It lacks all beyond the most basic table features
As an example, I made a spreadsheet that queried WoW’s auction house API and showed me items, their crafting components, prices and profits from crafting, that was then easily interactable and extendable in the GUI. Doing the same thing in python would have been great up until the point where I want to display the information… getting python to output a proper front end GUI is definitely a more time consuming exercise than using Excel’s built in functionality
Keep in mind Python can interact with spreadsheet formats. So it is very possible to input your data in a spreadsheet , load that data into Python, then dump it into a spreadsheet. Easiest is CSV but I have done direct too.
What approach depends. If you know a spreadsheet really well, then taking it quite a ways makes a lot of sense. On the other hand when one gets to the point of writing more then 100 lines of VBA and especially into the 500 range, it may be time to use another approach. Same when execution times are very long or data very large. Working with large VBA code bases is kind of nutty but people often get too deep into the I have a hammer so every problem looks like a nail thinking. I have had to work with code like that myself.
If you work with other people’s really complex word documents where formatting is important, you kind of do have to use MS word because Libre Office still does not have 100% compatibility (probably Microsoft’s fault).
I’m still a 360 holdout though. I hate the subscription model at the best of times and with Microsoft it just seems egregious.
Yes. I use to have to do patent work in MSO. The other issue is presentations. If you just cannot go with a PDF or use your own laptop you kind of have to use MSO since it is often the only program available.
FOSS people would probably use Libreoffice. On the other hand if you must work in the MSO world yes Onlyoffice seems like worth a look. Otherwise chasing MS is kind of a loosing strategy.
Just install Libreoffice. No reason for MSO unless you work in an org that supplies it.
While I think LibreOffice is great and definitely fills the needs for most people, I wish it was more polished. IMO MS Office just feels so smooth and clean, whereas LibreOffice feels clunky and dated. And I miss Excel when using Calc, although it gets the job done.
I guess I am from the old days. For me MSO has had nothing in terms of needed improvements since about 1998. And thankfully I moved to Libreoffice before the ribbon bar and all the VBA issues with 2013. Libreoffice became usable about 2005. Yes it was Excel for me that was the last to go. Solver in particular. As far as VBA, I switched from that to python about 1998.
As far as dated. I think it depends on who you think defines the standard . For me that is not MS.
As a user of advanced excel features like Power Query and even its plethora of built in functions, LibreOffice Calc just doesn’t hold up at all. It lacks all beyond the most basic table features
That is the thing. I would not do anything advanced in a spread sheet. Just not productive. I would use Python.
As an example, I made a spreadsheet that queried WoW’s auction house API and showed me items, their crafting components, prices and profits from crafting, that was then easily interactable and extendable in the GUI. Doing the same thing in python would have been great up until the point where I want to display the information… getting python to output a proper front end GUI is definitely a more time consuming exercise than using Excel’s built in functionality
Keep in mind Python can interact with spreadsheet formats. So it is very possible to input your data in a spreadsheet , load that data into Python, then dump it into a spreadsheet. Easiest is CSV but I have done direct too.
What approach depends. If you know a spreadsheet really well, then taking it quite a ways makes a lot of sense. On the other hand when one gets to the point of writing more then 100 lines of VBA and especially into the 500 range, it may be time to use another approach. Same when execution times are very long or data very large. Working with large VBA code bases is kind of nutty but people often get too deep into the I have a hammer so every problem looks like a nail thinking. I have had to work with code like that myself.
Have you tried enabling the ribbon interface?
Sure. No thanks.
Libre Office is cool.
If you work with other people’s really complex word documents where formatting is important, you kind of do have to use MS word because Libre Office still does not have 100% compatibility (probably Microsoft’s fault).
I’m still a 360 holdout though. I hate the subscription model at the best of times and with Microsoft it just seems egregious.
Yes. I use to have to do patent work in MSO. The other issue is presentations. If you just cannot go with a PDF or use your own laptop you kind of have to use MSO since it is often the only program available.
True. Powerpoint is de rigeur in some contexts.
Doesn’t have dark theme tbf
LibreOffice does have a dark theme now.
No one uses OnlyOffice? So far it’s been suitable and feels familiar to MSO.
FOSS people would probably use Libreoffice. On the other hand if you must work in the MSO world yes Onlyoffice seems like worth a look. Otherwise chasing MS is kind of a loosing strategy.
deleted by creator
Libre has the option to use a ribbon
deleted by creator