4.24

LibreOffice - A free, open source, cross-platform Office Suite

A powerful office suite, and a successor to OpenOffice. Its clean interface and feature-rich tools help you unleash your creativity and enhance your productivity. Compatible with other major office suites such as OpenOffice, Gnome Office (Abiword / GNumeric), Calligra / KOffice, Microsoft Office, Apple iWork. The software looks and feels familiar and is instantly usable by anyone who has used a competitive product.

Category: software, open source, free, office, richtext, spreadsheet, presentation

Stable Version: LibreOffice 7.4.7 LTS

Release Date:

Runs on: windows, mac, linux, openbsd, netbsd, freebsd

windows mac linux openbsd netbsd freebsd

 Download LibreOffice / Install Binaries: Links on the Official Website
Disclaimer: We do not store any binary or executable file formats on this website to provide direct file downloads. All download links of binaries or executables presented on this website, for any software application without exception, are provided only from the application's publisher Official Website and no other locations. This website is not responsible for the accuracy or safety of the software applications presented here. In particular this website section is just a catalog with popular opensource software applications mainly addressed to software developers to easy the access to the open source code.

  Get the Source Code of LibreOffice / Software Source Code Download

Specifications:

  • Project Developer: The Document Foundation
  • License: Mozilla Public License (MPL) 2.0
  • OpenSource, Free: Yes
  • Written in: C++, XML, Java
Building from Source: dependencies
  • Zip, Unzip, GNU Tar, Perl, Perl Archive Zip, GPerf
  • Boost, CPP Unit, GetText Tools, ICU4C, GNU Patch
  • GNU Core Utils, GNU Sed, Bison, Bash, Find Utils
  • LCMS2, Graphite2, CUPS Libs, Poppler
  • Glew, Glm, GStreamer 1 - Base Plugins
  • LibXSLT, CLucene, Raptor, Redland, Hunspell, Harfbuzz
  • Pango, Cairo, GTK+3, CURL, Nss
  • DB v4, MariaDB, PostgreSQL, Open LDAP
  • OpenJDK / Java (optional)
  • LLVM or GCC compiler

Review

0 5 4.6
LibreOffice is a free and open source office productivity software suite, a project of The Document Foundation. It was forked in 2010 from OpenOffice.org, an open-sourced version of the earlier StarOffice. This office suite uses the OpenDocument standard as its native file format, but supports formats of most other major office suites, including Microsoft Office, through a variety of import and export filters.
It is the most actively developed free and open-source office suite, with approximately 50 times the development activity of Apache OpenOffice, the other major descendant of OpenOffice.org, in 2015.
LibreOffice Online is an online office suite which includes the applications Writer, Calc and Impress and provides an upstream for other projects.
The development is open to new talent and new ideas. This software is tested and used daily by a large and devoted user community.
Writer has all the features you need from a modern, full-featured word processing and desktop publishing tool. It's simple enough for a quick memo, but powerful enough to create complete books with contents, diagrams, indexes, and more. You're free to concentrate on your message, while Writer makes it look great.
Calc is the free spreadsheet program you've always needed. Newcomers find it intuitive and easy to learn, while professional data miners and number crunchers appreciate the comprehensive range of advanced functions. Built-in wizards guide you through choosing and using a comprehensive range of advanced features. Or you can download templates from the online template repository, for ready-made spreadsheet solutions.
In Impress, creating and editing slides is very versatile thanks to different editing and view modes: Normal (for general editing), Outline (for organizing and outlining your text content), Notes (for viewing and editing the notes attached to a slide), Handout (for producing paper-based material), and Slide Sorter (for a thumbnail sheet view that lets you quickly locate and order your slides).
Draw lets you produce anything from a quick sketch to a complex plan, and gives you the means to communicate with graphics and diagrams. With a maximum page size of 300cm by 300cm, Draw is a an excellent package for producing technical drawings, brochures, posters and many other documents. Draw lets you manipulate graphical objects, group them, crop them, use objects in 3D and much more.
Base is a full-featured desktop database front end, designed to meet the needs of a broad array of users. Base caters to power users and enterprise requirements, providing native-support drivers for some of the most widely employed multi-user database engines: MySQL/MariaDB, Adabas D, MS Access and PostgreSQL. In addition, the built-in support for JDBC- and ODBC-standard drivers allows you to connect to virtually any other existing database engine as well.
Math is a formula editor, and can be invoked in your text documents, spreadsheets, presentations and drawings, enabling you to insert perfectly formatted mathematical and scientific formulas. Your formulas can include a wide range of elements, from fractions, terms with exponents and indices, integrals, and mathematical functions, to inequalities, systems of equations, and matrices. You can start Math either as a stand-alone application directly from the Start Center or directly from within other applications such as Writer, Calc, Impress and Draw.

Pros +
  • compatible with Microsoft Office (Word, Excel, Powerpoint) ; compatible with Apple iWork (Pages, Numbers, Keynote)
  • better collaboration: sharing documents and edits with other users - starting with version 7.3 the change tracking features have been enhanced, to make modifications more clear ; you can now easily identify when whole paragraphs have been moved
  • Writer lets you design and produce text documents that can include graphics, tables, or charts ; you can then save the documents in a variety of formats, including the standardised OpenDocument format (ODF), Microsoft Word (DOC) format, or HTML ; you can also export your document to the Portable Document Format (PDF) ; tracked footnote insertions and deletions are now visible in the footnote area ; in addition, Writer now can take advantage of the remote LanguageTool APIs for grammar checking
  • work faster in Calc: when you're working with spreadsheets, the new Bash-like autocompletion feature helps you to input data in a snap ; you can save the documents in native ODS format or Excel (XLS / XSLX) ; you can also export your document to the Portable Document Format (PDF) ; Calc supports now 16,384 columns
  • Impress lets you create professional slide shows that can include charts, drawing objects, text, multimedia and a variety of other items ; if you want, you can even import and modify Microsoft PowerPoint presentations ; you can then save them to native ODP format or Microsoft PowerPoint (PPT / PPTX / PPS) formats ; you can also export your document to the Portable Document Format (PDF) ; Impress now has initial document theme support: it is possible to define a document theme on master pages, and you can refer to the theme colours from shape text (including effects)
  • Draw lets you create simple and complex drawings and export them in a number of common image formats (JPG, PNG, GIF, BMP), but also PDF ; you can also insert tables, charts, formulas and other items created in any of this suite applications into your drawings ; Draw creates vector graphics using lines and curves defined by mathematical vectors ; you can also create simple 3D objects such as cubes, spheres, and cylinders
  • barcodes and borders: you can now insert barcodes into your documents with just a few clicks (QR codes are also supported), while border line widths have been unified throughout the suite
  • you can sign an existing PDF document from any application that belong to this office suite: just go to the File menu, Digital Signatures submenu, click Sign Existing PDF and open the PDF document that you want to sign
Cons -
  • a regression bug has appeared (before was fixed): opening Word DOCX documents does not always work well and sometimes LibreOffice deforms the files ; it looks like some versions may have some minor issues to import Office 2003 file formats and looks like it is depending on the version of the import libraries LibreOffice is using on a system
  • some features are illogical and really hard to find ; this is expected to be solved in the upcoming LibreOffice version 8 which will address a lot of productivity issues found in the current version

About

LibreOffice is a powerful and free office suite, a successor to OpenOffice(.org), used by millions of people around the world. Its clean interface and feature-rich tools help you unleash your creativity and enhance your productivity. It includes several applications that make it the most versatile Free and Open Source office suite on the market: Writer (word processing), Calc (spreadsheets), Impress (presentations), Draw (vector graphics and flowcharts), Base (databases), and Math (formula editing). This software is a free alternative to MS Office and Apple iWork.

Features


The list of Applications inside the LibreOffice package:
LibreOffice Writer Icon LibreOffice Calc Icon LibreOffice Impress Icon LibreOffice Draw Icon LibreOffice Math Icon LibreOffice DataBase Icon
  • Writer: document editor, compatible with Microsoft Word and Apple Pages
  • Calc: spreadsheet editor, compatible with Microsoft Excel and Apple Numbers
  • Impress: presentation software, compatible with Microsoft Powerpoint and Apple Keynote
  • Draw: drawing software
  • Math: equation and math formula editor
  • Database: database manager, partial support for Microsoft Access Databases

OpenDocument File Format
Libre Office uses the OpenDocument Format (ODF), a fully open and ISO standardised file format that guarantees access to your data forever. (You can, of course, encrypt your documents with a password.) Because ODF is standardised, other office software can implement support for it as well - and many programs have done so. By using ODF, you ensure that your data can be transferred between different computers and operating systems, without having to worry about vendor lock-in or license fees.
Typical extensions for ODF files include the following: .odt - a text document ; .ods - a spreadsheet file ; .odp - a presentation file ; .odg - an illustration or graphic

Great-looking, well-structured documents
Your documents will look professional and clean, regardless of their purpose: a letter, a master thesis, a brochure, financial reports, marketing presentations, technical drawings and diagrams. This office suite makes your work look great while you focus on the content, thanks to its powerful styles system and structuring tools.

Use documents of all kinds
This office suite is compatible with a wide range of document formats such as Microsoft Word (.doc, .docx), Excel (.xls, .xlsx), PowerPoint (.ppt, .pptx) and Publisher. But it goes much further with its native support for a modern and open standard, the Open Document Format (ODF). With this software you have maximum control over your data and content - and you can export your work in many different formats including PDF.

Get more features with extensions
Beyond the many features shipped by default, it is easily extensible through its powerful extensions mechanisms. Get even more features and document templates on our dedicated websites.

A powerful charts creation module available
It includes the ability to create and embed charts. Their style, color and size can be customized in a broad variety of ways - pie charts, square and round columns, trend graphs, dots, 2D and 3D charts, and so much more...

Screenshot: Main Screen
LibreOffice - Main Screen



Changelog Highlights

2022-08-18 - 2023-05-11 : version 7.4.0 - 7.4.7

notable changes

  • Writer: Menu item Tools -> Update -> Update all now updates the preview of OLE objects
  • Writer now supports clearing breaks from Word for improvement layout fidelity ; Fixed Index or Table of Contents generation
  • For documents that are loaded read-only, Writer will now allow to view tracked changes via both: dialog and sidebar
  • Add in Writer a new typographic settings: Add new optional hyphenation settings to adjust paragraph-level text flow
  • Writer improvements - New numbering in Show Changes mode ; New remote grammar checker: LanguageTool
  • Calc: Support for sparklines was added
  • Calc now supports and uses 16384 columns ; The height of the formula bar is now stored into the document
  • Added COUNTA, PRODUCT, STDEV, STDEVP, VAR, VARP functions to drop-down autosum widget on Formula bar for Calc
  • A new context menu Duplicate Sheet is added, which can be accessed when you right-click on the sheet tabs area in Calc
  • Calc: Automatic cell matrix expansion for formula expressions that return an array/matrix
  • Improved performance when many columns contain data and for functions such as COUNTIF, SUMIFS and VLOOKUP, especially with unsorted data, in Calc
  • Start of document themes in Impress: shape text ; shape fill support for document themes
  • Impress: support using slide background as shape fill for PPTX interoperability
  • Added support for WebP images import/export
  • Added support for EMZ/WMZ files
  • Fix regression for the rendering of equations created with Microsoft Equation Editor
  • Enhancements for lighting extruded custom shapes to make rendering more compatible with MS Office
  • Improved text layout performance for cases like PDF export, document loading and others
  • Improved PDF export options in the command-line ; Field type of Numeric, Currency, Date and Time forms are exported to PDF
  • DOCX: import textboxes (with tables, images etc.) in group shapes
  • PPTX export: fixed export of embedded video files
  • RTF filter improvements
  • Export encoding (character set) configuration is dropped from Options|Load/Save|HTML Compatibility, HTML is now always exported using UTF-8 encoding
  • TIFF: import filter rewritten to import via libtiff in order to support many more variants
  • GUI: The Navigator can now scroll to the item on selection by a single click, without leaving the navigator
  • The Colibre icon theme which is the default theme in Windows, now has a dark variant
  • New languages/locales with locale data ; Improvements to proofing tools and language support
  • The (new) Menu service, to describe a new menu to be displayed in the menubar
  • VBA Support and Basic improvements
  • FTP support is deprecated and will be removed in a future version
2022-01-31 - 2022-09-08 : version 7.3.0 - 7.3.6

notable changes

  • Insert - SVG clippath not fully supported
  • SVG fill property in uppercase doesn't work
  • Pixelated PDF export and print for a rotated image
  • Formula object is not displayed properly in formula editor when text editor zoom level < 1
  • MSWord 2019 doesn't open odt files with tables created by LibreOffice
  • Writer - Hyperlinks can now be attached to shapes ; Footnote and endnote anchors in the end of a paragraph are now treated exactly as they already were treated in the middle for the purposes of search/replace with regular expressions
  • Tracked table row deletion/insertion ; Basic support of table change tracking was extended
  • Tracked text moving - During track changes, show moved text in green color and with double strikethrough or underlines to speed up reviewing
  • Performance - Increased a PDF export speed of some complex documents ; Speed up loading large RTL documents ; Improved rendering speed with some complex documents
  • Calc - The "Link to External Data" dialog now lists HTML tables in the order they appear in the source
  • Whitespace line feed and character tabulation in cell formula expressions are now preserved and survive round-tripping between OOXML and ODF file formats
  • CSV import/export support a sep=; and "sep=;" field separator setting ; A new Evaluate formulas option in the CSV Import and Paste Special and Text to Column dialog
  • Cell cursor now uses the system's highlight color instead of the default font color to improve visibility ; Support Color Filter in "Standard Filter" dialog
  • Queries and filters using some text-based operations such as 'contains' now properly work even with numeric data
  • Option "Search criteria = and <> must apply to whole cells" has been fixed to apply properly in lookup functions when turned off
  • The IF() function now unconditionally propagates the condition's error value, if any
  • Improved speed of some XLSM and XLSX files opening
  • Impress & Draw - Added PowerPoint-compatible screen sizes ; Unshare shape properties for the same type before insertion ; The dialog "3D-Settings" opens if you toggle a shape to "Extrusion on"
  • Base - FireBird data base engine bugfixes
  • LibreOffice can now generate one-dimensional barcodes in addition to QR codes
  • new WebDAV/HTTP UCP based on libcurl
  • Border line widths have been unified throughout LibreOffice
  • Various rendering improvements in the Skia-based rendering backend
  • Improvements of DOC import/export filter - greatly improved list/numbering import
  • Improvements of DOCX import/export filter - greatly improved list/numbering import ; Hyperlinks attached to shapes are now imported/exported ; fix user index and index entry support defined by field code \f ; andle ZOrder of chart objects
  • Improvements of XLSX import/export filter - decreased a row height for XLSX files created by MS Office ; cell indent doesn't increase on each save now ; Calc buttons with macros - better XLSX support ; fix Chart labels from cell-range ; Chart date categories - improved support for formatting, scaling, range-selection(min/max), increments
  • Improvements of PPTX import/export filter - fixed interactions and hyperlinks on images ; Impress doesn't drop the read-only password in PPTX file now ; Fix the incorrect import of slide footers from PPTX ; Make slide footers get exported to PPTX ; Transparent shadow for tables
2021-08-22 - 2022-07-10 : version 7.2.0 - 7.2.7.2

notable changes

  • Writer - Alphabetical indexes, tables of contents and user-defined indexes will now generate clickable hyperlinks to document index entry marks
  • All background fills can now be set to either cover the page inside the margins or the entire page
  • Page styles can now have a gutter margin
  • Bibliography improvements - tooltip for bibliography entry fields and clickable URLs in the bibliography table
  • The Word-compatible table border painting now has better support for merged cells
  • When Writer document is exported to PDF, links between anchors and footnotes or endnotes (even if not on the same page) are now available in both directions
  • Support for list format strings in ODT files - right now complex numbering rules from DOCX are supported also for ODT
  • Spell-checking for indices is disabled now (language set to None for paragraph style Index and children)
  • Image file type is now displayed in the Image Properties dialog, not just the Compress dialog
  • Fields are now listed in the the Navigator sidebar, and users can choose "Field" and "Field type" in the "Navigate by" tool
  • Adding and deleting images is now recorded by Track Changes
  • Mail Merge - User will see a warning about nonexistent data sources instead of producing empty fields ; there is a button to fix the problem
  • Performance - Improved font caching to speed up text rendering ; Reduced opening time for some DOCX file
  • It's possible to set a custom shading color for an annotated text range or a metadata field e.g. for visualization of metadata categories in the document editor
  • Calc - Fixed problems with pasting filtered cells and pasting with transpose ; HTML tables listed in the External Data dialog
  • The Paste Special dialog has been redesigned, and the new preset "Formats Only" was added
  • New options "Select Visible Rows Only" and "Select Visible Columns Only" to deselect hidden cells
  • Autofilter improvements - Calc shows blue row numbers for filtered rows by Autofilter ; Calc now highlights an active autofilter dropdown arrow
  • Calc now can filter by color in Autofilter (both cell background color and text color), importing from and exporting to OOXML format are also supported
  • CELL() now evaluates the top left cell of a given cell range argument as second parameter instead of the usual intersecting position for scalar parameters
  • RAWSUBTRACT() now processes arguments from left to right
  • ROUND() has its artificial limitation on the second parameter (rounding position) removed
  • IRR() can now take an array for the Values parameter
  • All background fills can now be set to either cover the page inside the margins or the entire page
  • Add support for multiple columns in LibreOffice text boxes
  • UI - Direct access to the document's scaling factor via statusbar in Draw
  • Improved export dialog for PNG and JPG clarifies the distinction between dimensions and resolution
  • Data Series Labels - Adding series name to data series label is now possible
  • For "Moving average" trend line, the type can now be selected
  • Math - It's now possible to scale the code input box
  • The C++ library used to generate QR codes was changed from qrcodegen to ZXing
  • Performance - Improved drawing speed with large images ; Improved text rendering speed when using font fallback ; Various drawing speed improvements when using the Skia-based drawing backend ; Improve document loading speed by using zlib optimized crc32
  • Improvements of DOC import/export filter - fixed chapter numbering ; fixed Z-order of objects ; fixed some DOC file in 64 bit systems ; fixed a loss of the outline level
  • Improvements of DOCX import/export filter - import discarded headers/footers - before the inactive DOCX headers/footers lost during import time ; fix lost tables in footnotes and endnotes by converting them to floating tables during the import, and removing floating at the DOCX export ; export save header image once ; fix missing page break ; fix missing border of frame ; fix frame positions of old docs by limiting AddFrameOffsets compatibility option for docs created by MSO 2010 or older ; support tracked table (row) deletion
  • Improvements of the RTF filter - fix too small graphic size when both picwgoal and picw are provided
  • Improvements of XLSX import/export filter - set filtered flag for rows hidden by AutoFilter to support copying the result of filtering ; fix lost rounded filters if the stored filter values are in the visible cell format ; fix missing datetime filters by convert string representation ; apply more than 8 filters in OOXML autofilter import by removing the artificial limit ; fix conditional formatting in same cell range ; export autofiltered date columns ; fix position of rotated images ; fix "Formula is" type conditional formatting rule when the formula contains a reference to another worksheet
  • Improvements of PPTX import/export filter - fix WordArt effect textDeflate and textInflateTop ; fix lost direct hyperlink colors ; fix vertical alignment ; wordart 3D, add sp3d ; Shadow for tables from PPTX in Impress ; Import support for graphics cropped into custom geometry ; Import support for crop position of the custom cropped graphics ; Import support for greyscale effect of the custom cropped graphics
  • Improvements of WMF/EMF filter - Add support for import WMF and EMF images ; EMF FILLRGN record is displayed correctly now ; EMF Implement PAINTRGN record support ; EMF - Add rotation support for INTERSECTCLIPRECT, ARC, ARCTO, CHORD, PIE and ROUNDRECT ; WMF - Add support for selecting colors from palette
  • Improvements of SVG filter - A slide with a custom background is exported correctly now ; It is possible to export a slide with a bitmap as background ; The background is exported in an optimized way
2021-02-07 - 2021-12-15 : version 7.1.0 - 7.1.8.1

notable changes

  • Writer now has support for anchoring shapes relative to the bottom of the page content frame
  • Writer supports locale-independent templates
  • Added a new Writer outline folding mode (as experimental feature)
  • Table formulas - PRODUCT / ABS / SIGN / COUNT
  • Added Style Inspector for displaying all the attributes of Paragraph Styles, Character Styles and manually formatted (Direct Formatting) properties
  • Input Fields can be toggled and can be selected with the mouse
  • Simple cases of subtables in legacy ODF documents initially created by OpenOffice.org 2.2 and older can now be converted to modern rowspan tables on import
  • Calc - Now you can select items in Autofilter window clicking by all item's row, but not only by checkbox
  • Fixed an issue in formula input box when Calc fail to set the formula reference if you have freeze rows/columns enabled in a sheet
  • Fill with merged cells - Fix lost merging and bad linear sequence of numbers during fill with merged cells ; Copy merged cell structure like other spreadsheets do
  • Calc - Now INDIRECT function supports sheet-local scoped names
  • Draw - Adding visible digital signatures to existing PDF files with Draw
  • Now Impress allows changing animations for several objects at once ; Presentation console has "Exit" and "Pause/Resume" buttons now
  • Impress & Draw have realistic soft blurred shadows for objects
  • Math has now a full support of HTML colors. Some of them have been added to the UI on Attributes section in Element pane
  • Scripting - An extensible and robust collection of macro scripting resources for LibreOffice to be invoked from user Basic or Python scripts
  • Improve finding a matching printer paper size for the printed document
  • Improvements of DOCX import/export filter - Add support for change tracking in floating table ; Add formula import in text tables ; Export formula fields ; Added a workaround for ABOVE/BELOW/LEFT/RIGHT arguments in SUM, AVERAGE, etc. table functions importing. Now Writer converts that arguments into cell range like <A1:A10> and saves into DOCX as a cell range
  • Improvements of PPTX import/export filter - Several SmartArt improvements when importing from PPTX
  • UI - elementary icon theme got update to be more closely to upstream's color branding
  • Windows - It's now possible to build LibreOffice native for Windows Arm64
2020-08-12 - 2021-06-01 : version 7.0.0 - 7.0.6.2

notable changes

  • Implemented a padded numbering in Writer's lists
  • Bookmarks and Fields can now be protected to prevent accidental changes to them
  • Fix in Mail merge - progress is not updated during export of many files
  • Improved rotated text handling in Writer's table rows with automatic height
  • Implemented support for semi-transparent text in Writer
  • Navigator's categories are gray if they don't have any items
  • Table's context menu in Navigator now has Insert caption item
  • Added Navigator section tooltip word and character count
  • AutoCorrect - Improved usage of quotation marks and apostrophe in several languages
  • New (experimental) features have been added to make documents more accessible
  • Performance improvements - Find & Replace is ~50% faster
  • New spreadsheet functions - RAND.NV() and RANDBETWEEN.NV() non-volatile random number generating functions
  • Calc - Functions that allow using regular expressions now correctly honor case-insensitivity flags (?i) / (?-i) in expressions
  • TEXT() now allows the second argument to be an empty format string for interoperability with other implementations
  • OFFSET() optional 4th parameter (Width) and 5th parameter (Height) now must be greater than 0 if given, otherwise the result is Err:502 (invalid argument) error
  • TEXTJOIN() and CONCAT() now handle array/matrix arguments row-wise instead of column-wise, to behave the same as for cell range references and interoperability with other implementations
  • Improved opening speed of XLSX files with many pictures
  • Improved Calc autofill speed ; Decreased a time for a sheet deleting's undoing operation
  • Impress & Draw - Subscripts now return to the default of 8%
  • Implemented support for semi-transparent text in Draw/Impress
  • Base - Macro signatures are now evaluated on document load
  • Math - Added RGB personalized color. You should use syntax like color rgb 0 100 0 { your_symbols } in Formula editor
  • The underlying OpenGL backend on Windows was replaced with the Skia library and Vulkan
  • Gallery - Add new shape galleries which can be easily edited and stylized by the user
  • Templates - Add new shape galleries which can be easily edited and stylized by the user
  • ODF 1.3 - LibreOffice 7.0 adds support for exporting to new versions of ODF
  • Improvements of the EMF+ import filter
  • Improvements of DOCX import/export filter ; DOCX now saves in native 2013/2016/2019 mode instead of in 2007 compatibility mode
  • DOCX export of non-default cell margins has been implemented
  • Improvements of PPTX import/export filter ; mplemented better support for Impress math objects from PPTX, avoiding duplication
  • GUI - Standard Toolbars - All toolbars are locked by default now on fresh user profiles
  • Impress presenter screen/presenter console got new refreshed and more up to date user interface design