LibreOffice

On this page 7

LibreOffice is a free and open-source office suite that provides a word processor, spreadsheet, presentation program, vector drawing tool, database front end and formula editor, and runs on Windows, macOS and Linux. Among office applications in software, it is the most widely used open alternative to commercial suites and the reference implementation of the OpenDocument Format (ODF).

LibreOffice is developed by a global community under the umbrella of The Document Foundation, a non-profit organization, and is released under the Mozilla Public License 2.0. It can be installed and used without license fees in homes, schools, businesses and public administrations.

Components of the LibreOffice suite

LibreOffice consists of six applications that share one code base, one user interface framework and one document engine. Because they share components, a chart or a table behaves the same way whether it sits in a text document or a presentation.

ApplicationPurposeNative ODF formatMain counterpart format
WriterWord processingODTDOCX
CalcSpreadsheetsODSXLSX
ImpressPresentationsODPPPTX
DrawVector drawing and PDF editingODGVSDX import
BaseDatabase front endODBAccess import
MathFormula editingODF formulaMathML
LibreOffice applications and their native formats

Calc supports up to 16,384 columns and more than one million rows per sheet in current versions, which matches the grid size of modern commercial spreadsheets. Writer includes styles-based formatting, mail merge, master documents and a native PDF export with tagged and archival options.

Origins and release model

LibreOffice was created in 2010 as a fork of OpenOffice.org, which itself grew out of the StarOffice suite. Most active developers moved to the new project, and LibreOffice has since diverged substantially in features, file filters and code quality, while Apache OpenOffice continues separately with much lower development activity.

The project publishes two major releases per year, in February and August, and uses version numbers that combine the year and the release, such as 25.2 and 25.8. Two download lines are offered at the same time, as the table shows.

Release lineIntended usersCharacter
Community, newest major releaseEnthusiasts and early adoptersLatest features, some early bugs
Community, previous major releaseMost individuals and conservative usersSeveral bug-fix updates applied
Long-term supported buildsEnterprises and administrationsCommercial support from ecosystem companies
LibreOffice release lines

The Document Foundation recommends that organizations use builds with professional support from companies in the LibreOffice ecosystem, which provide long-term maintenance, service-level agreements and deployment help. The community builds have the same core features but a shorter maintenance window of roughly nine months per release.

LibreOffice and file formats

The native format of LibreOffice is ODF, an ISO and OASIS standard based on compressed XML. Using ODF gives the highest fidelity, because LibreOffice implements the full specification and its own extensions are documented.

LibreOffice also opens and saves DOCX, XLSX and PPTX, the Office Open XML formats used by Microsoft Office, as well as older binary formats such as DOC and XLS. Compatibility with simple and medium-complexity documents is generally good, while complex layouts, advanced charts, macros and some form controls may differ. The table summarizes the typical behavior.

Content typeTypical fidelityNote
Plain text with stylesHighStyles map well between formats
Tables and imagesHigh to mediumAnchoring and wrapping may shift
Spreadsheet formulasHigh for common functionsSome newer functions are unsupported
Charts and SmartArt-like graphicsMediumAppearance can change
VBA macrosLimitedPartial support, rewriting often needed
FontsDepends on installed fontsMetric-compatible fonts reduce reflow
Typical LibreOffice compatibility with Office Open XML

LibreOffice ships metric-compatible fonts such as Liberation and Carlito, which have the same character widths as common proprietary fonts, so line breaks and page counts stay stable when those fonts are missing.

Choosing and deploying LibreOffice

LibreOffice fits best where cost, openness and long-term access to documents matter more than perfect compatibility with one commercial suite. Its strength is full offline functionality; it is not primarily a real-time cloud collaboration tool, although server-based editing exists through separate products built on its engine.

SituationSuitabilityReason
Public administration with ODF policyStrong fitNative, standards-based format
Schools and home usersStrong fitNo license cost, full feature set
Heavy macro-based Excel workflowsWeak fit without migrationVBA support is partial
Constant co-authoring in the cloudLimited fitNeeds a separate online editing service
Linux desktopsDefault choicePreinstalled on many distributions
Decision guide for adopting LibreOffice

Large deployments use MSI packages on Windows, administrative templates for central configuration, and default-format settings that decide whether users save in ODF or Office Open XML by default.

Common pitfalls when switching to LibreOffice

  • Testing only simple files: migration pilots must include the most complex templates, forms and spreadsheets in real use.
  • Ignoring macros: VBA solutions need an inventory and often a rewrite in Basic, Python or another automation approach.
  • Mixed default formats: if half of a team saves in ODF and half in DOCX, documents bounce between formats and slowly lose fidelity.
  • Missing fonts: documents designed with fonts that are not installed reflow; install or substitute fonts before rollout.
  • Skipping training: the menus and style handling differ enough that short, targeted training avoids frustration.

The short version

LibreOffice is a free set of office programs for writing letters, building spreadsheets and making slide shows. Anyone can download it and use it at home or at work without paying for a license.

It saves files in an open format by default but can also open and save the formats most offices use. Think of it as a universal power adapter: it works with most plugs, though an unusual one may not fit perfectly. The key point is that simple documents move easily, while very complex ones deserve a test first.

Where it makes a difference

A regional school network with 1,200 classroom computers needs an office suite for students and teachers. The budget does not allow licenses for every machine, and the education authority requires documents in an open, standardized format for official records.

The IT team deploys LibreOffice through MSI packages with a central setting that saves in ODF, installs metric-compatible fonts, and prepares templates for reports and timetables. A pilot with two schools reveals that a grading spreadsheet uses VBA macros, so the team rebuilds it with standard formulas. After the rollout, all schools use one consistent suite at no license cost, and parents with other office programs can still open the exported PDF reports.