ONLYOFFICE vs LibreOffice: what to choose when you decide to ditch Microsoft

23 August 2018 By Nadya 3 9,946 views

Yes, Microsoft Office is cool but one day it will become burdensome for your budget. Or you may want to give it up following your rebellious open source spirit. No matter what your reasoning is, you’ll need a good replacement. So… ONLYOFFICE or LibreOffice?

With this article, we’ll help you to make an informed choice. We suggest using your preferred office formats as the main criteria.

ONLYOFFICE vs LibreOffice

A Brief History of Time Formats

Here’s a quick primer on office software history. Once all of the office formats were binary. We are talking about doc, xls, and ppt. They were strictly closed so that Microsoft could maintain a monopoly. No one liked that.

Luckily, the Jedi knights from open source community created an alternative – new XML-based formats called ODF. The abbreviation stands for Open Document formats, and the word ‘open’ here reveals their open source nature and that they could be used without restrictions. And you what? They were good. Even Microsoft tech guys saw that and took the idea.

In 2007 Microsoft launched a new version of their Office that by default saved documents in the newly created OOXML (Office Open XML) formats – docx, xlsx, pptx. Note that the word ‘open’ here did not mean being open source because the formats were protected by Microsoft patents. But putting aside the moral aspects of their monopolistic approach, we have to say they were brilliant and also put much time and effort in their document editors.

ODF and OOXML are not compatible with each other

Although ODF and OOXML had much XML in common, they were (and are now) perfectly incompatible. This means that if you open a docx file in ODF-based OpenOffice/LibreOffice, you are likely to lose the initial formatting. It also works vice versa, when you try to work with odt in Microsoft Word.

But in fact, no one wanted the compatibility – open source developers never wanted to play by Microsoft rules and support proprietary software, while the corporation saw the community as rivals, or maybe sort of rebels. But were these rebels able to destroy the Death Star? No. Maybe they didn’t have their Luke Skywalker, or maybe they were less violent.

OOXML is more popular than ODF

Even with such alternatives as OpenOffice (back then) and LibreOffice (now), Microsoft Office stays the most popular office suite in the world and the majority of office docs ever created was saved in Microsoft formats. The old files still exist in binary formats, but OOXML is catching up quickly.

No scientific survey was conveyed to proved that OOXML is more widely used than ODF. Moreover, the majority of organizations has closed document circulation, so we’ll never know anything about their documentation. But we have the Internet!

Google Trends service, for instance, shows us that docx is being googled way more often than odt.

ONLYOFFICE vs LibreOffice: what to choose when you decide to ditch Microsoft

he filetype search experiment also proves the point.

1 filetype:docx = 14 400 000 documents found.

1 filetype:odt = 388 000 documents found.


text filetype:docx = 1 020 000 documents found.

text filetype:odt = 28 100 documents found.

Does it mean that OOXML is better than ODF? Not necessarily. It is just the distribution model.

Are we trying to talk you into using OOXML? No way! We are just saying that it is more widely spread which may have nothing to do with your personal preferences.

We suggest you just decide considering two things:

  1. Formats you personally like.
  2. Formats popular in your environment.

As we have already said the format families are incompatible. So, choose what you are going to use more (or what formats are customary for your organization and your partners) and then download the most suitable office apps.

ONLYOFFICE for OOXML, LibreOffice for ODF

ONLYOFFICE was made for working with docx, xlsx and pptx, and has maximum MS Office compatibility (of all existing office suites). It means that all the objects present in ONLYOFFICE are created strictly according to MS Office format specs. So, if you look at a doc as a set of objects, ONLYOFFICE’s object models corresponds to OOXML specifications, while Libre’s object model corresponds to ODF’s ones.

ONLYOFFICE also works with ODF. Since its native formats are incompatible with them, ONLYOFFICE  automatically converts ODF to OOXML when opening such files, later you can save them as ODF (but having in mind that it would mean double conversion). Unfortunately, some losses in initial formatting may occur during the process. But we are constantly improving the conversion quality.

LibreOffice is great at ODF, and also opens docx, xlsx and pptx. But with issues. Lots of. And that’s only natural regarding formats’ history.

So, ONLYOFFICE or LibreOffice? It’s up to you.

P.S. Another important question that may affect your choice is collaborative work in the document editors.

ONLYOFFICE started as a web solution, so it is collaborative by its very nature. LibreOffice Online is more like desktop editors working on a server and then being translated to your browser. Read the ONLYOFFICE vs Collabora (as LibreOffice successor) comparison to go deeper into the collaborative work question.

The answer to the dicey question why not all of the docx files are opened correctly by ONLYOFFICE can be found in this post.

Comments (3)
  1. laslowlife - Reply
    August 26, 2018 at 2:14 pm

    Nadya, thanks a lot for the article post.Much thanks again. Fantastic.

  2. User - Reply
    October 2, 2018 at 3:06 pm

    Thanks for the artistic article on onlyoffice vs libreoffice.

    your writing skills are very nice, I felt like I am reading some kind of comedy / novel.

    I would like to go with OnlyOffice!

  3. 11 - Reply
    April 15, 2019 at 10:15 am

    LibreOffice exports all settings
    All the settings of LibreOffice, all in the LibreOffice folder.

    C:\Users\a←When installing the operating system, the name entered.\AppData←File Manager ~ “Hidden project” to open, the AppData folder will be displayed.\Roaming\LibreOffice

    Back up the LibreOffice folder, when reinstalling, put the LibreOffice folder in its original place.

    1. If the installation is preview edition, because the name of preview edition is LibreOfficeDev, so the LibreOfficeDev folder will be displayed.
    2. Formal edition can be installed together with preview edition, if both formal edition and preview edition are installed, LibreOffice folder and LibreOfficeDev folder will be displayed.
    3. To clear all settings, just delete the LibreOffice folder, then open the program, a new LibreOffice folder will be created.

    LibreOffice exports a single toolbar I made
    Common path
    C:\Users\a←When installing the operating system, the name entered.\AppData←File Manager ~ “Hidden project” to open, the AppData folder will be displayed.\Roaming\LibreOffice\4\user\config\soffice.cfg\modules\Please connect the branch path of the individual software below.

    Branch path
    \modules\StartModule\toolbar\The “Start” toolbar I made is placed here.

    \modules\swriter\toolbar\The “writer” toolbar I made is placed here.

    \modules\scalc\toolbar\The “calc” toolbar I made is placed here.

    \modules\simpress\toolbar\The “impress” toolbar I made is placed here.

    \modules\sdraw\toolbar\The “draw” toolbar I made is placed here.

    \modules\smath\toolbar\The “math” toolbar I made is placed here.

    \modules\dbapp\toolbar\The “base” toolbar I made is placed here.

    Backup file, when reinstalling, put the file in the original place.

    1. Because of the toolbar that I made myself, default file name, will automatically use Numbering, so to open the file, can know the name of the toolbar.
    2. The front file name “custom_toolbar_” cannot be changed, change will cause error, behind’s file name can be changed.
    For example: custom_toolbar_c01611ed.xml→custom_toolbar_AAA.xml.
    3. Do well of toolbar, can be copied to other places to use.
    For example: In the “writer” Do well of toolbar, can be copied to “calc” places to use.

    LibreOffice self-made symbol toolbar
    Step 1 Start “Recording Macros function”
    Tools\Options\Advanced\Enable macro recording(Tick), in the “Tools\Macros”, the “Record Macro” option will appear.

    Step 2 Recording Macros
    Tools\Macros\Record Macro→Recording action (click “Ω” to enter symbol→select symbol→Insert)→Stop Recording→The name Macros stored in “Module1” is Main→Modify Main name→Save.

    Step 3 Add item new toolbar
    Tools\Customize\Toolbar→Add→Enter a name (example: symbol)→OK, the new toolbar will appear in the top left.

    Step 4 Will Macros Add item new toolbar
    Tools\Customize\Toolbar\Category\Macros\My Macros\Standard\Module1\Main→Click “Main”→Add item→Modify→Rename (can be named with symbol)→OK→OK.

Add a comment