This content is part of the Essential Guide: Guide to open source operating systems, programs and more
Problem solve Get help with specific problems with your technologies, process and projects.

LibreOffice, OpenOffice are tempting but differ from Microsoft Office

Open source and free suites such as LibreOffice and OpenOffice could save organizations money, but not effort in comparison with Microsoft Office.

We are considering getting rid of Microsoft Office in our organization and moving to OpenOffice or LibreOffice. How difficult is it to do this? Are there things we should be aware of?

OpenOffice and LibreOffice are free/open source productivity suites for many platforms -- including Windows, Linux and Mac OS X -- that provide much of the same functionality as Microsoft Office. Word processing, spreadsheets, presentations, drawing/diagramming tools and database utilities are included in the suite, and there's no price tag at all for using or redistributing the software.

Given that Microsoft Office can get pricey, and that OpenOffice or LibreOffice can read and write Microsoft Office files, many smaller organizations are considering these suites. Many folks have gone down that path successfully, but a few things are worth keeping in mind.

First, the feature sets for OpenOffice and LibreOffice differ slightly from that of Microsoft Office -- and from each other, despite being based on common code. Some functions of Microsoft Office are duplicated in these products, but not in exactly the same way. The interface may be different, or the way the function behaves may not be quite the same.

Second, while OpenOffice and LibreOffice are able to open and save Microsoft Office documents, they're not always able to do so with perfect transparency. Sometimes the formatting of Microsoft Office documents passed to those programs gets altered when edited and saved by them.

Granted, these Microsoft Office alternatives are gradually improving their ability to read and write Microsoft Office files, but it helps to keep interoperation to a minimum. If you use OpenOffice or LibreOffice, convert documents to the native OpenDocument Format used by those suites (there are tools for mass document conversion) and don't pass them back to Microsoft Office if you can.

Third, one of the big reasons Microsoft Office remains entrenched in many organizations is because of document macros or other customizations. Not all of these work in OpenOffice or LibreOffice, so documents with such customizations need to be tested to make sure they work as intended.

Dig Deeper on Enterprise software

Join the conversation

1 comment

Send me notifications when other members comment.

Please create a username to comment.

Serdar, are you sure that OpenOffice or LibreOffice are not being tripped?

Here are some mind-blowing facts:

1993 Microsoft uses Monopoly power to kill Word Perfect
The next challenge to the Microsoft Monopoly was a word processor called Word Perfect – which until 1993 had a higher market share than Microsoft Word. One of the purposes for the constant model changes in Windows was to create incompatibility with Word Perfect. Novell, which owned Word Perfect, recently brought a lawsuit against Microsoft for this predatory practice. As evidence that Microsoft used model changes to give Word and Office an advantage, Novell produced a 1994 email from Bill Gates that states:
"I have decided that we should not publish these extensions. We should wait until we have a way to do a high level of integration that will be harder for likes of Notes, WordPerfect to achieve, and which will give Office a real advantage . . . We can't compete with Lotus and WordPerfect/Novell without this.".... Bill Gates 1994
The failure to publish the extensions meant that Word Perfect was not compatible with Windows 95 when it was released in 1995 – and that led to the death of Word Perfect as shown on the following chart:

Market Share of Word Perfect versus Word 1986 to 1997
Graph from Stan Liebowitz, University of Texas at Dallas