LibreOffice 26.8 Fixes a Major Excel Compatibility Problem

For millions of people, LibreOffice is the go-to free alternative to Microsoft Office. Its biggest weakness has always been the same: compatibility with Microsoft’s file formats, especially Excel spreadsheets. A file that looks perfect in Excel can open in LibreOffice Calc with broken formulas, shifted layouts, or missing features, and the reverse happens too.

With LibreOffice 26.8, The Document Foundation addresses one of these long-standing pain points. Here’s what changed, who benefits, and how to get the update.

What Is LibreOffice 26.8?

LibreOffice is a free, open-source office suite developed by The Document Foundation (TDF), a nonprofit based in Germany, together with a global community of contributors and companies. The suite includes:

• Writer (word processing, a Microsoft Word alternative)
• Calc (spreadsheets, an Excel alternative)
• Impress (presentations, a PowerPoint alternative)
• Draw, Base, and Math

Since 2024, LibreOffice has used calendar-based version numbers. The first number is the year and the second is the month of release:

The project ships two major releases per year, in February and August, with smaller bug-fix updates in between.

The Excel Compatibility Problem, Explained

What Was Fixed

[À COMPLÉTER : décrire le problème précis, d’après les notes de version 26.8.] For example:

• Which feature was affected: formulas, pivot tables, conditional formatting, charts, external links, etc.
• What users experienced before: errors, data loss, wrong calculations, or files flagged as corrupted by Excel.
• What LibreOffice 26.8 does now: the improved behavior.
• Bug tracker reference: tdf#XXXXXX on bugs.documentfoundation.org.
• Who contributed the fix: TDF developers, Collabora, allotropia, or a community volunteer.

💡 Suggested quote: add a statement from The Document Foundation’s announcement blog post (blog.documentfoundation.org) if available.

Why Excel Compatibility Is So Hard

The problem is not simply that LibreOffice “doesn’t support Excel.” Several technical realities are involved:

• Different native formats. LibreOffice uses the OpenDocument Format (ODF), an ISO standard. Excel uses Office Open XML (OOXML), standardized as ECMA-376 and ISO/IEC 29500.
• Excel doesn’t always follow the standard exactly. Real-world .xlsx files often contain Microsoft-specific behaviors that other apps must reverse-engineer.
• Decades of legacy features. Excel supports old .xls files, macros, and calculation quirks that users expect to work identically.
• New Excel features keep arriving. Dynamic arrays and new functions require constant catch-up work.

Each compatibility fix therefore reflects careful engineering, often based on testing thousands of real-world files.

LibreOffice’s Recent Progress on Excel Compatibility

LibreOffice 26.8 builds on several years of steady improvements to Calc:

• LibreOffice 7.4 (2022) raised Calc’s maximum to 16,384 columns, matching Excel’s grid limit.
• LibreOffice 24.8 (2024) added popular modern Excel functions such as XLOOKUP and XMATCH.
• Ongoing releases have improved import and export of charts, conditional formatting, pivot tables, and OOXML files in general.

Much of this interoperability work comes from companies in the LibreOffice ecosystem, such as Collabora, which serve business and government customers who exchange files with Microsoft Office users daily.

Who Benefits Most

• Small businesses that use LibreOffice to avoid Microsoft 365 subscription costs but trade spreadsheets with clients.
• Students and teachers who receive .xlsx assignments.
• Government agencies and schools adopting open-source software for cost or data sovereignty reasons.
• Linux users, for whom LibreOffice is often the default office suite.
• Mac and Windows users looking for a free, offline alternative to Excel.

How to Update to LibreOffice 26.8

LibreOffice is free for Windows, macOS, and Linux.

On Windows and macOS

1. Go to the official site: libreoffice.org/download
2. Download the installer for your system.
3. Run it. It upgrades your existing installation automatically.

🔒 Security tip: only download LibreOffice from libreoffice.org or your operating system’s official app store. Fake download sites sometimes bundle malware.

On Linux

• Ubuntu, Debian, Fedora: wait for your distribution’s update, or use the official packages from libreoffice.org.
• Flatpak (Flathub) or Snap: usually updated soon after the official release.

Should You Upgrade Right Away?

Businesses that prefer maximum stability often wait for the first bug-fix update (26.8.1 or 26.8.2). Home users who need the Excel fix can generally upgrade right away.

Tips for Better Excel Compatibility in LibreOffice

Even with the latest version, these habits help files move smoothly between LibreOffice and Excel:

1. Save in .xlsx when sharing with Excel users. Go to File → Save As and choose “Excel 2007–365 (.xlsx).” Click Use Excel 2007–365! when prompted.
2. Install metric-compatible fonts. LibreOffice uses Carlito in place of Calibri and Caladea in place of Cambria, so layouts stay consistent.
3. Be careful with macros. LibreOffice supports many Excel VBA macros, but not all. Test complex macros before relying on them.
4. Avoid Excel-only features when collaborating, such as Power Query or some newer functions not yet supported.
5. Keep LibreOffice updated. Every release brings interoperability fixes.
6. Report problems. File compatibility bugs at bugs.documentfoundation.org. Sample files help developers greatly.

LibreOffice vs. Microsoft Excel: Quick Comparison

Frequently Asked Questions

Is LibreOffice 26.8 free? Yes. LibreOffice is completely free for personal, educational, and commercial use.

Can LibreOffice open and save Excel files? Yes. Calc opens and saves .xlsx and older .xls files. Version 26.8 further improves how faithfully these files are handled.

Will my Excel macros work in LibreOffice? Many will, but complex VBA macros may need adjustments. Test critical macros before switching fully.

Is LibreOffice safe to use? Yes, when downloaded from libreoffice.org. The project regularly publishes security updates, so keep your installation current.

What’s the difference between LibreOffice and OpenOffice? LibreOffice was forked from OpenOffice.org in 2010. It is much more actively developed, receives more frequent updates, and generally offers better Microsoft Office compatibility than Apache OpenOffice.

Bottom Line

Excel compatibility has long been the main reason people hesitate to switch to LibreOffice. With version 26.8, The Document Foundation removes another obstacle. It won’t make LibreOffice a perfect Excel clone, but it moves the free suite closer to “it just works” for everyday spreadsheets. If you exchange Excel files regularly, this is an update worth installing.

Sources

1. LibreOffice official download page: libreoffice.org/download
2. LibreOffice 26.8 Release Notes (TDF Wiki): wiki.documentfoundation.org/ReleaseNotes/26.8
3. The Document Foundation Blog (release announcements): blog.documentfoundation.org
4. LibreOffice Release Plan and versioning: wiki.documentfoundation.org/ReleasePlan
5. LibreOffice Bugzilla: bugs.documentfoundation.org
6. LibreOffice 24.8 Release Notes (XLOOKUP, XMATCH): wiki.documentfoundation.org/ReleaseNotes/24.8
7. LibreOffice 7.4 Release Notes (16,384 columns): wiki.documentfoundation.org/ReleaseNotes/7.4
8. ISO/IEC 29500 (Office Open XML) and OASIS OpenDocument Format: iso.org / oasis-open.org