|Original author(s)||Star Division|
|Developer(s)||The Document Foundation|
|Initial release||25 January 2011|
|Written in||C++, XML, and Java|
|Operating system||Linux, Windows 7+, macOS 10.10+;|
Unofficial: Android and iOS, Chrome OS, FreeBSD, OpenBSD, NetBSD, Haiku, Solaris (v. 5.2.5)
|Platform||x86-64 (all operating systems), IA-32, ARMel, ARMhf, ARM64, MIPS, MIPSel, PowerPC, ppc64el, S390x|
|Available in||119 languages|
|Type||Office productivity suite|
LibreOffice (//)[a] is a free and open-source office productivity software suite, a project of The Document Foundation (TDF). It was forked in 2010 from OpenOffice.org, an open-sourced version of the earlier StarOffice. The LibreOffice suite consists of programs for word processing, creating and editing of spreadsheets, slideshows, diagrams and drawings, working with databases, and composing mathematical formulae. It is available in 115 languages. TDF doesn't provide support for LibreOffice, but enterprised-focused editions are available from companies in the ecosystem.
LibreOffice 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.
LibreOffice is available for a variety of computing platforms, with official support for Microsoft Windows, macOS and Linux and community builds for many other platforms. LibreOffice is the default office suite of most popular Linux distributions.
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 projects such as commercial Collabora Online.
The project was announced and a beta released on 28 September 2010. In the nine months between January 2011 (the first stable release) and October 2011, LibreOffice was downloaded about 7.5 million times. In 2015, the project claimed 120 million unique downloading addresses from May 2011 to May 2015, excluding Linux distributions, with 55 million of those being from May 2014 to May 2015. The Document Foundation estimates that there are 200 million active LibreOffice users worldwide; approximately 25% are students and 10% are Linux users, who usually find LibreOffice part of their preferred distribution.
|Writer||A word processor with similar functionality and file support to Microsoft Word or WordPerfect. It has extensive WYSIWYG word processing capabilities, but can also be used as a basic text editor. It can also create fillable forms via PDF or the Forms tab.|
|Calc||A spreadsheet program, similar to Microsoft Excel or Lotus 1-2-3. It has several unique features, including a system which automatically defines series of graphs, based on information available to the user.[clarification needed]|
|Impress||A presentation program resembling Microsoft PowerPoint. Impress has support for multiple file formats including PPTX, ODP, and SXI.|
|Draw||A vector graphics editor, raster graphics editor, and diagramming tool similar to Microsoft Visio, CorelDRAW, and Adobe Photoshop. It provides connectors between shapes, which are available in a range of line styles and facilitate building drawings such as flowcharts. It also includes features similar to desktop publishing software such as Scribus and Microsoft Publisher, but the features are not on par with desktop publishing software. It can also act as a PDF file editor.|
|Math||An application designed for creating and editing mathematical formulae. The application uses a variant of XML for creating formulas, as defined in the OpenDocument specification. These formulas can be incorporated into other documents in the LibreOffice suite, such as those created by Writer or Calc, by embedding the formulas into the document.|
|Base||A database management program, similar to Microsoft Access. LibreOffice Base allows databases to be created and managed, and the generation of forms and reports of database content. Like Access, it can be used to create small embedded databases that are stored with the document files (using Java-based HSQLDB and C++ based Firebird as its storage engine), and for more demanding tasks it can also be used as a front-end for various database management systems, including Access Database Engine (ACE/JET), ODBC/JDBC data sources, and MySQL, MariaDB, PostgreSQL and Microsoft Access.|
LibreOffice is cross platform software. The Document Foundation developers target Microsoft Windows (IA-32 and x86-64), Linux (IA-32, x86-64 and ARM) and macOS (x86-64). There are community ports for FreeBSD, NetBSD, OpenBSD and Mac OS X 10.5 PowerPC receive support from contributors to those projects, respectively. LibreOffice is also installable on OpenIndiana via SFE.
Historically predecessors of LibreOffice, back to StarOffice 3, have run on Solaris with SPARC CPUs that Sun Microsystems (and later Oracle) made. Unofficial ports of LibreOffice, versions now obsolete, have supported SPARC. Current unofficial ports of LibreOffice 5.2.5 run only on Intel-compatible hardware, up to for Solaris 11.
In 2011, developers announced plans to port LibreOffice both to Android and to iOS. A beta version of a document viewer for Android 4.0 or newer was released in January 2015; In May 2015, LibreOffice Viewer for Android was released with basic editing capabilities. In February 2020, Collabora released its first officially supported version of LibreOffice (branded as Collabora Office) for Android and iOS. In July 2020 Collabora shipped an app, branded as Collabora Office, for Chrome OS, as used on the popular Chromebook line of notebook computers as well as other form factors of computers.
The LibreOffice Impress Remote application for various mobile operating systems allows for remote control of LibreOffice Impress presentations.
|Operating system||Processor architecture||Current||From|
|Android||Yes||LibreOffice, Collabora Office|
|BSD (FreeBSD, NetBSD, OpenBSD)||IA-32, x86-64, ARM, many others||Yes||Community ports|
|Chrome OS (Chromebooks)||Yes||Collabora Office|
|Linux||IA-32, x86-64, ARM64||Yes||LibreOffice, Collabora Office, Collabora Online|
|macOS||X86-64, 10.5 PowerPC, ARM based M1 is in development||Yes||LibreOffice, Collabora Office, NeoOffice, community ports|
|Windows||IA-32, x86-64, ARM is in development||Yes||LibreOffice, Collabora Office, CIB|
|All operating systems running a modern web browser||All processors running a modern web browser||Yes||Collabora Online, LibreOffice Online (frozen)|
LibreOffice Online is the online office suite edition of LibreOffice. It allows for the use of LibreOffice through a web browser by using the canvas element of HTML5. Development was announced at the first LibreOffice Conference in October 2011, and is ongoing. The Document Foundation, IceWarp, and Collabora announced a collaboration to work on its implementation. A version of the software was shown in a September 2015 conference, and the UK Crown Commercial Service announced an interest in using the software. On 15 December 2015, Collabora, in partnership with ownCloud, released a technical preview of LibreOffice Online branded as Collabora Online Development Edition (CODE). In July 2016 the enterprise version Collabora Online 1.0 was released. The same month, Nextcloud and Collabora partnered to bring CODE to Nextcloud users. By October 2016, Collabora had released nine updates to CODE. The first source code release of LibreOffice Online was done with LibreOffice version 5.3 in February 2017. In June 2019, CIB software GmbH officially announced its contributions to LibreOffice Online and "LibreOffice Online powered by CIB".
In October 2020 Collabora announced the move of its work on Collabora Online from The Document Foundation infrastructure to GitHub.
A detailed 60-page report in June 2015 compared the progress of the LibreOffice project with the related project Apache OpenOffice. It showed that "OpenOffice received about 10% of the improvements LibreOffice did in the period of time studied."
As its native file format to save documents for all of its applications, LibreOffice uses the Open Document Format for Office Applications (ODF), or OpenDocument, an international standard developed jointly by the International Organization for Standardization (ISO) and the International Electrotechnical Commission (IEC). LibreOffice also supports the file formats of most other major office suites, including Microsoft Office, through a variety of import and export filters.
|AbiWord||ABW, ZABW||Document||From 4.2|
|Adobe Flash||SWF||Graphics, multimedia||Yes||Up to 6.4 (Impress / Draw only)||Support for writing the format was discontinued as Adobe Flash Player will no longer be maintained.|
|Adobe PageMaker||PMD, PM3, PM4, PM5, PM6, P65||Document, DTP||From 4.4|
|AppleWorks word processing||CWK||Document||From 4.1||Formerly called ClarisWorks|
|Adobe Swatch Exchange||ASE||Color plate||From 5.0|
|Adobe FreeHand||AGD, FHD||Graphics / Vector||Yes|
|Apple Keynote||KTH, KEY||Presentation||From 5.0|
|Apple Numbers||Numbers||Spreadsheet||From 5.0|
|Apple Pages||Pages||Document||From 5.0|
|AportisDoc (Palm)||PDB||Document||Yes||Yes||Requires Java|
|AutoCAD DXF||DXF||Graphics / CAD||Yes|
|BMP file format||BMP||Graphics / Raster||Yes||Yes|
|Comma-separated values||CSV, TXT||Text||Yes||Yes|
|ClarisDraw||Graphics / Vector||Yes|
|CorelDRAW 6-X7||CDR, CMX||Graphics / Vector||From 3.6|
|Computer Graphics Metafile||CGM||Graphics||Yes||Binary-encoded only; not those using clear-text or character-based encoding|
|Data Interchange Format||DIF||Spreadsheet||Yes||Yes|
|DBase, Clipper, VP-Info, FoxPro||DBF||Database||Yes||Yes|
|Enhanced Metafile||EMF||Graphics / Vector / Text||Yes||Yes|
|GIMP Palette||GPL||Color plate||From 4.4|
|Gnumeric||GNM, GNUMERIC||Spreadsheet||From 5.1||No|
|Graphics Interchange Format||GIF||Graphics / Raster||Yes||Yes|
|Hangul WP 97||HWP||Document||Yes||Newer "5.x" documents are not supported|
|HPGL plotting file||PLT||Graphics||Yes|
|HTML||HTML, HTM||Document, text||Yes||Yes|
|Ichitaro 8/9/10/11||JTD, JTT||Document||Yes|
|Lotus 1-2-3||WK1, WKS, 123, wk3, wk4||Spreadsheet||Yes|
|Lotus Word Pro||Document||Yes|
|MacDraft||Graphics / CAD||From 5.0|
|MacDraw||Graphics / Vector||From 4.4|
|MacDraw II||Graphics / Vector||From 4.4|
|Macintosh Picture File||PCT||Graphics||Yes||Yes|
|MacWrite Pro 1.5||Document||From 4.1|
|Microsoft Excel 2003 XML||XML||Spreadsheet||Yes||Yes|
|Microsoft Excel 4/5/95||XLS, XLW, XLT||Spreadsheet||Yes||Up to 3.6|
|Microsoft Excel 97–2003||XLS, XLW, XLT||Spreadsheet||Yes||Yes|
|Microsoft Excel 2007-2016||XLSX||Spreadsheet||Yes||Yes|
|Microsoft Excel Web Query File||IQY||Data sources, text||From 5.4|
|Microsoft Office 2007-2016 Office Open XML||DOCX, XLSX, PPTX||Multiple formats||Yes||Yes|
|Microsoft Pocket Excel||PXL||Spreadsheet||Yes||Yes||Requires Java|
|Microsoft Pocket Word||PSW||Document||Yes||Yes||Requires Java|
|Microsoft PowerPoint 97–2003||PPT, PPS, POT||Presentation||Yes||Yes|
|Microsoft PowerPoint 2007-2016||PPTX||Presentation||Yes||Yes|
|Microsoft Publisher||PUB||Document, DTP||From 4.0|
|Microsoft Word 2003 XML (WordprocessingML)||XML||Document||Yes||Yes|
|Microsoft Word 4/5/6.0/95||DOC, DOT||Document||Yes||Up to 3.6|
|Microsoft Word 97–2003||DOC, DOT||Document||Yes||Yes|
|Microsoft Word 2007-2016||DOCX||Document||Yes||Yes|
|Microsoft Word for Mac||Document||From 4.1||Word 1–5.1|
|Microsoft Word for Windows 2.0||DOC, DOT||Document||Yes||Yes|
|Microsoft Works||WPS, WKS, WDB||Multiple||Yes||Microsoft Works for Mac formats since 4.1|
|Microsoft Write||WRI||Document||From 5.1||No|
|Microsoft Visio||VSD||Graphics / Vector||From 3.5|
|Netpbm format||PGM, PBM, PPM||Graphics / Raster||Yes||Yes|
|OpenDocument||ODT, FODT, ODS, FODS, ODP, FODP, ODG, FODG, ODF||Multiple formats||Yes||Yes|
|Open Office Base||ODB||Database forms, data||Yes||Yes|
|OpenOffice.org XML||SXW, STW, SXC, STC, SXI, STI, SXD, STD, SXM||Multiple formats||Yes||Yes|
|Plain text||TXT||Text||Yes||Yes||Various encodings supported|
|Portable Document Format||Document||Yes||Yes||Including hybrid PDF|
|Portable Network Graphics||PNG||Graphics / Raster||Yes||Yes|
|QuarkXPress 3–4||QXP||Document, DTP||From 6.0|
|Quattro Pro 6.0||WB2, wq1, wq2||Spreadsheet||Yes|
|RagTime for Mac||From 4.4|
|Scalable vector graphics||SVG||Graphics / Vector||Yes||Yes|
|Software602 (T602)||602, TXT||Document||Yes|
|StarOffice StarCalc 3/4/5||SDC, VOR||Spreadsheet||Dropped in 4.0,
added back in 5.3
|Up to 3.6|
|StarOffice StarDraw/StarImpress||SDA, SDD, SDP, VOR||Presentation||Dropped in 4.0,
added back in 5.3
|Up to 3.6|
|StarOffice StarMath||SXM||Math||Up to 3.6||Up to 3.6|
|StarOffice StarWriter 3/4/5||SDW, SGL, VOR||Document||Dropped in 4.0,
added back in 5.3
|Up to 3.6|
|Star Writer graphics||SGF||Graphics||Yes|
|Sony Broad Band eBook||RLF||eBook||From 4.4|
|SunOS Raster||RAS||Graphics / Raster||Yes||Yes|
|SVM||SVM||Graphics / Vector||Yes||Yes|
|SYLK||SLK||Spreadsheet, file exchange||Yes||Yes|
|Tagged Image File Format||TIF, TIFF||Graphics / Raster||Yes||Yes|
|Truevision TGA (Targa)||TGA||Graphics / Raster||Yes|
|Unified Office Format||UOF, UOT, UOS, UOP||Multiple||Yes||Yes|
|Windows Metafile||WMF||Graphics, vector, bitmap||Yes||Yes|
|WordPerfect Suite 2000/Office 1.0||WPS||Document||Yes|
|WriteNow 4.0||Document||From 4.1|
|X BitMap||XBM||Graphics / Raster||Yes|
|X PixMap||XPM||Graphics / Raster||Yes||Yes|
|Zoner Draw||ZMF||Graphics||From 5.3|
LibreOffice can use the GStreamer multimedia framework in Linux to render multimedia content such as videos in Impress and other programs.
Visually, LibreOffice used the large "Tango style" icons that are used for the application shortcuts, quick launch icons, icons for associated files and for the icons found on the toolbar of the LibreOffice programs in the past, and used on the toolbars and menus by default. They were later replaced by multiple icon themes to adapt the look and feel of specific desktop environment, such as Colibre for Windows, and Elementary for GNOME.
LibreOffice also ships with a modified theme which looks native on GTK-based Linux distributions. It also renders fonts via Cairo on Linux distributions; this means that text in LibreOffice is rendered the same as the rest of the Linux desktop.
With version 6.2, LibreOffice includes a toolbar-style GUI, called Notebookbar, including three different views. This feature has formerly been included as an experimental feature in LibreOffice 6 (experimental features must be enabled from LibreOffice settings to make the option available in the View menu).
LibreOffice has a feature similar to WordArt called Fontwork.
LibreOffice uses HarfBuzz for complex text layout, it was first introduced in 4.1 for Linux and 5.3 for Windows and macOS. Fonts with OpenType, Apple Advanced Typography or SIL Graphite features can be switched by either a syntax in the Font Name input box or the Font Features dialog from the Character dialog.
LibreOffice supports a "hybrid PDF" format, a file in Portable Document Format (PDF) which can be read by any program supporting PDF, but also contains the source document in ODF format, editable in LibreOffice by dragging and dropping.
The LibreOffice project uses a dual LGPLv3 (or later) / MPL 2.0 license for new contributions to allow the license to be upgraded. Since the core of the OpenOffice.org codebase was donated to the Apache Software Foundation, there is an ongoing effort to get all the code rebased to ease future license updates. At the same time, there were complaints that IBM had not in fact released the Lotus Symphony code as open source, despite having claimed to. It was reported that some LibreOffice developers wanted to incorporate some code parts and bug fixes which IBM already fixed in their OpenOffice fork.
LibreOffice supports third-party extensions. As of July 2017[update], the LibreOffice Extension Repository lists more than 320 extensions. Another list is maintained by the Apache Software Foundation and another one by the Free Software Foundation. Extensions and scripts for LibreOffice can be written in C++, Java, CLI, Python, and LibreOffice Basic. Interpreters for the latter two are bundled with most LibreOffice installers, so no additional installation is needed. The application programming interface for LibreOffice is called "UNO" and is extensively documented.
LibreOffice Basic is a programming language similar to Microsoft Visual Basic for Applications (VBA) but based on StarOffice Basic. It is available in Writer, Calc and Base. It is used to write small programs known as "macros", with each macro performing a different task, such as counting the words in a paragraph.
Members of the OpenOffice.org community who were not Sun Microsystems employees had wanted a more egalitarian form for the OpenOffice.org project for many years; Sun had stated in the original OpenOffice.org announcement in 2000 that the project would eventually be run by a neutral foundation and put forward a more detailed proposal in 2001.
Ximian and then Novell had maintained the ooo-build patch set, a project led by Michael Meeks, to make the build easier on Linux and due to the difficulty of getting contributions accepted upstream by Sun, even from corporate partners. It tracked the main line of development and was not intended to constitute a fork. It was also the standard build mechanism for OpenOffice.org in most Linux distributions and was contributed to by said distributions.
In 2007, ooo-build was made available by Novell as a software package called Go-oo (ooo-build had used the go-oo.org domain name as early as 2005), which included many features not included in upstream OpenOffice.org. Go-oo also encouraged outside contributions, with rules similar to those later adopted for LibreOffice.
Sun's contributions to OpenOffice.org had been declining for some time. They remained reluctant to accept contributions and contributors were upset at Sun releasing OpenOffice.org code to IBM for IBM Lotus Symphony under a proprietary contract, rather than under an open source licence.
Sun was purchased by Oracle Corporation in early 2010. OpenOffice.org community members were concerned by Oracle's behaviour towards open source software, specifically the Java lawsuit against Google and Oracle's withdrawal of developers, and lack of activity on or visible commitment to OpenOffice.org, as had been noted by industry observers – as Meeks put it in early September 2010, "The news from the Oracle OpenOffice conference was that there was no news." Discussion of a fork started soon after.
On 28 September 2010, The Document Foundation was announced as the host of LibreOffice, a new derivative of OpenOffice.org. The Document Foundation's initial announcement stated their concerns that Oracle would either discontinue OpenOffice.org, or place restrictions on it as an open source project, as it had on Sun's OpenSolaris.
LibreOffice 3.3 beta used the ooo-build build infrastructure and the OpenOffice.org 3.3 beta code from Oracle, then adding selected patches from Go-oo. Go-oo was discontinued in favour of LibreOffice. Since the office suite that was branded "OpenOffice.org" in most Linux distributions was in fact Go-oo, most moved immediately to LibreOffice.
Oracle was invited to become a member of The Document Foundation. However, Oracle demanded that all members of the OpenOffice.org Community Council involved with The Document Foundation step down from the OOo Community Council, claiming a conflict of interest.
The name "LibreOffice" was picked after researching trademark databases and social media, as well as after checks were made to see if it could be used for URLs in various countries. Oracle rejected requests to donate the OpenOffice.org brand to the project.
LibreOffice was initially named BrOffice in Brazil. OpenOffice.org had been distributed as BrOffice.org by the BrOffice Centre of Excellence for Free Software because of a trademark issue.
Oracle announced in April 2011 that it was ending its development of OpenOffice.org and would lay off the majority of its paid developers. In June 2011, Oracle announced that it would donate the OpenOffice.org code and trademark to the Apache Software Foundation, where the project was accepted for a project incubation process within the foundation, thus becoming Apache OpenOffice. In an interview with LWN in May 2011, Ubuntu founder Mark Shuttleworth blamed The Document Foundation for destroying OpenOffice.org because it did not license its code under Oracle's Contributor License Agreement. In opposition to Shuttleworth's view, the former Sun executive Simon Phipps argued in the interview for the same online magazine, that the lay-off was an inevitable business decision by Oracle, not impacted by existence of LibreOffice.
In March 2015, an LWN.net comparison of LibreOffice with its cousin project Apache OpenOffice concluded that "LibreOffice has won the battle for developer participation".
In late 2017 The Document Foundation held a competition for the new mascot of LibreOffice. The mascot was to be used primarily by the community, and was not intended to supersede existing logos for the project. Over 300 concepts were submitted before the first evaluation phase.
The mascot contest was cancelled soon after new submissions stopped being accepted. The Document Foundation cited their lack of clear rules and arguments among community members as their reasoning for cancelling the contest.
Since March 2014 and version 4.2.2, two different major "released" versions of LibreOffice are available at any time in addition to development versions (numbered release candidates and dated nightly builds). The versions are designated to signal their appropriateness for differing user requirements. Releases are designated by three numbers separated by dots. The first two numbers represent the major version (branch) number, and the final number indicates the bugfix releases made in that series. LibreOffice designates the two release versions as:
LibreOffice uses a time-based release schedule for predictability, rather than a "when it's ready" schedule. New major versions are released around every six months, in January or February and July or August of each year. The initial intention was to release in March and September, to align with the schedule of other free software projects. Minor bugfix versions of the "fresh" and "still" release branches are released frequently.
Commercially-supported distributions for LibreOffice with service-level agreements are available via partners such as Collabora (marketed as Collabora Office and Collabora Online), CIB (marketed as LibreOffice powered by CIB on the Microsoft Store for Windows 10), and Red Hat. The three vendors are major corporate contributors to the LibreOffice project.
As of version 7.1, the open source release of LibreOffice is officially branded as "LibreOffice Community", in order to emphasize that the releases are intended primarily for personal individual use, and are "not targeted at enterprises, and not optimized for their support needs". The Document Foundation states that usage of the community versions in such settings "has had a two-fold negative consequence for the project: a poor use of volunteers' time, as they have to spend their time to solve problems for business that provide nothing in return to the community, and a net loss for ecosystem companies."
The figure shows the worldwide number of LibreOffice users from 2011 to 2018 in millions. References are in the text.
2011: The Document Foundation estimated in September 2011, that there were 10 million users worldwide who had obtained LibreOffice via downloads or CD-ROMs. Over 90% of those were on Windows, with another 5% on OS X. LibreOffice is the default office suite for most Linux distributions, and is installed when the operating system is installed or updated. Based on International Data Corporation reckonings for new or updated Linux installations in 2011, The Document Foundation estimated a subtotal of 15 million Linux users. This gave a total estimated user base of 25 million users in 2011. In 2011, the Document Foundation set a target of 200 million users worldwide before the end of 2020.
2013: In September 2013, after two years, the estimated number of LibreOffice users was 75 million. A million new unique IP addresses check for downloads each week.
2015: In 2015, LibreOffice was used by 100 million users and 18 governments.
2016: In August 2016, the number of LibreOffice users was estimated at 120 million.
2018: The Document Foundation estimated in 2018 that there are 200 million active LibreOffice users worldwide. About 25% of them are students and 10% Linux users (who often automatically receive LibreOffice through their distribution). In comparison, Microsoft Office was used in 2018 by 1.2 billion users.
LibreOffice has seen various major deployments since its inception:
Starting in 2011, The Document Foundation has organized the annual LibreOffice Conference, as follows:
Tracking direct download Update Ping origins. Excludes all Linux Distributions downloads ~120m so far ( + Linux ) This time last year @ openSUSE con. was ~65m
LibreOffice On-Line in slideware
OpenOffice received about 10% of the improvements LibreOffice did in the period of time studied.
Dropped support for export to legacy Word and Excel (version 6.0/95) files.
Nach der Übernahme von Sun hatte Oracle offenbar etliche Entwickler vom OpenOffice-Projekt abgezogen, was zu empfindlichen Verzögerungen bei der Weiterentwicklung geführt hat. [After the acquisition of Sun, Oracle apparently took several developers off the OpenOffice project, which led to severe delays in development.]
((cite news)): CS1 maint: unfit URL (link)
TDF is urging enterprises to adopt LibreOffice Enterprise from partners that offer long-term support options, professional assistance, custom features and Service Level Agreements.