LibreOffice hits back at critics, says its UI is better than Microsoft Office's
neowin.net
neowin.net
Libreoffices UI is DIFFERENT to Microsoft Office.
Thats the real impediment. I have applied "make it more like that" changes including font uploads. It's good. But it doesn't get over the user "principle of least astonishment" which is what drives the resistance.
There is a similar problem with the UI differences on OSX. otherwise rational people find the experience of moving to Office on OSX too hard.
(happy MS Office user on OSX, tolerably happy Libreoffice user on OSX and other platforms)
How good is the Excel formula language equivalent these days? Does it have LET and LAMBDA?
The difference is that in Libreoffice, you don't have to search for a "ribbon item" every fscking time. Ribbon sucks. Yes, I know Libreoffice also has a ribbon, but it gives you a choice.
I don't know what it's like using modern Microsoft Office with no experience using toolbars and menus and then switching to LibreOffice, which still uses traditional toolbars and menus.
I prefer traditional toolbars and menus, but I remember Microsoft doing user studies when developing the original Office 2007 ribbon. It showed that the ribbon was more productive for beginners and casual users. Given that many office suite users are casual users who use word processors, spreadsheets, and presentation tools, Microsoft Office may be more productive for them than LibreOffice. It would be good if LibreOffice did user studies.
For example, LibreOffice doesn’t have the “Format as Table” feature from Excel, which in a single action combines adding sorting arrows along with a color scheme on a selected range of grouped cells. The range of grouped cells and the background colors in the Excel version auto-expand as new columns or rows are added. Sure, I could press 3-4 different hotkeys and manually update all of this in a sequence for LibreOffice Calc each time I modify the group of cells, but ideally the software would have some single unified action to not make me need to do that without resorting to creating custom possibly flaky macros.