Mergen Demo Gadget Lab 38/60
Skip to content
Open-source office software: How good are the free alternatives?
GuideSoftware

Open-source office software: How good are the free alternatives?

You don't have to pay for licenses to create documents, spreadsheets and presentations. We tried open-source office suites in real work scenarios.

SLSophie LaurentArts & Entertainment Editor
7 min7.9B0
Table of contents
  1. Document compatibility test
  2. Spreadsheets and macros
  3. Who are they good enough for?
  4. Key takeaways

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.

Document compatibility test — Open-source office software: How good are the free alternatives?

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.

Share this post

What do you think about this post?

SL
Arts & Entertainment Editor

Sophie Laurent

A former film, music and performing arts reporter, Sophie Laurent covers festivals and exhibitions alongside the colorful world of entertainment news. In her interviews, she likes to put the story the artist is telling front and center, rather than the artist.

Leave a comment

Share your thoughts

Your email address will not be published. Respectful, on-topic comments are approved.

Gadget House

Welcome back

Log in to your account; your saved posts and comments are waiting for you.