
Table of contents
Office software is among the tools computer users need most often. Open-source office suites make it possible to create documents, spreadsheets and presentations without paying a license fee. In our tests, these suites kept pace with their paid rivals for standard correspondence and simple spreadsheets. With heavily formatted documents and spreadsheets containing macros, however, we occasionally ran into compatibility issues. For students, small businesses and remote workers, open-source options are more than enough.
Document compatibility test
We tried three open-source office suites with the kinds of documents people deal with every day. We created a ten-page report, an essay with footnotes, a résumé with tables and a brochure with photos, then saved them in their paid rivals' formats and reopened them. We saw no formatting loss in simple correspondence or single-column reports. We opened every document twice and compared them, noting any shifts.
With complex layouts, however, differences show up. A multi-column newsletter and floating text boxes caused shifts in one suite. If the fonts aren't installed on your computer, page breaks can change, so we recommend using a fixed format, namely PDF, when sharing documents. On the interface side, the old-style menus may feel unfamiliar to some users.

Being free doesn't mean it isn't a serious tool.
Sophie Laurent
Spreadsheets and macros
In the spreadsheet apps, basic formulas, charts and data filtering worked flawlessly. A spreadsheet of a few thousand rows was sorted quickly and turned into a pivot table. But when we opened a spreadsheet with macros from the paid suite, some automations didn't work; because the macros were written in a different scripting language, they had to be rewritten. Layouts like these are rare in everyday correspondence but common in corporate documents.
When it comes to new features, paid rivals still have the advantage of cloud-based collaboration. In open-source suites, co-editing may require setting up an online server. The presentation tool, on the other hand, supports transitions and animations well. Extension and template libraries are growing with the community, but the selection is limited compared with rivals. That's something to keep in mind for teamwork.
Who are they good enough for?
So who are open-source suites good enough for? For students, small businesses, remote workers and users who mostly create and print their own documents, they're more than enough. They cover basic needs without a license fee, updates are free and they're privacy-friendly. Because they're installed locally on your computer, your documents aren't kept on someone else's server. On top of that, maintenance and updates are handled regularly by the community.
| Topic | Software |
|---|---|
| Highlights | comparison, operating system, how-to |
| Reading time | 7 minutes |
| Written by | Sophie Laurent |
Key takeaways
- Formatting compatibility with paid rivals was good for simple documents.
- Complex layouts and macros occasionally cause compatibility issues.
- A solid solution for students, small businesses and remote workers.
Those who exchange lots of documents with large organizations, finance teams working with complex macros and anyone who needs perfect formatting compatibility should be careful, however. In those cases, run a small trial first. Being free doesn't mean it isn't a serious tool; many organizations have cut their annual license costs by switching to these suites. Give the installation a try; you have nothing to lose.
What do you think about this post?


































































Leave a comment