LibreOffice is a suite of programs for word processing, spreadsheets, presentations, databases, and vector drawings. It is free to download, use, and distribute. It is available in many languages and runs on Linux, Mac, and Windows.
LibreOffice’s native file formats are OpenDocument (*.ODT, *.ODS, *.ODP, etc.), but it can open and save to many other formats, including Microsoft Office formats (*.DOC, *.XLS, *.PPT, etc.).
To download LibreOffice, go to the LibreOffice website.
LibreOffice is a project of the not-for-profit organization, The Document Foundation.
It’s been a long time coming, but an updated version of the LibreOffice Calc Guide has finally been completed by the Documentation Team.
Free PDFs are here: https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide and will be linked from the main LibreOffice website in the new year.
A printed copy can be purchased here: http://www.lulu.com/content/paperback-book/libreoffice-62-calc-guide/26019667
My new book, Self-publishing using LibreOffice Writer 6, is now available in paperback or PDF.
Printed copies are available from Lulu.com for US$15.00. Pay at Lulu.com.
Download PDF here. Cost is US$5.00, on the honor system. Please pay using the button below (Paypal or credit card). If you buy a printed copy, you are welcome to a free copy of the PDF.
On August 14, 2019 The Document Foundation announced LibreOffice 6.2.6, the sixth minor release of the LibreOffice 6.2 family, targeted at users in production environments. All users of LibreOffice 6.1.x and LibreOffice 6.2.x versions should upgrade immediately for enhanced security, as the software includes both security fixes and some months of back-ported fixes. See their blog post.
(LibreOffice 6.2 and 6.3 are concurrent releases. LibreOffice 6.3 represents the bleeding edge in term of features for open source office suites, and is targeted at technology enthusiasts, early adopters and power users. V6.2 is for users in production environments.)
On 8 August 2019, The Document Foundation announced the release of LibreOffice 6.3, a feature-rich major release with better performance, a large number of new and improved features, and enhanced interoperability with proprietary document format:
- Writer and Calc performance has been improved by an order of magnitude based on documents provided by end users: text files with different bookmarks, tables and embedded fonts, large ODS/XLSX spreadsheets, and Calc files with VLOOKUP load and render more quickly. Saving Calc spreadsheets as XLS files is also faster.
- The Tabbed Compact version of the NotebookBar user interface, introduced in LibreOffice 6.2, is now available for Writer, Calc, Impress and Draw. It leaves more space for user documents, spreadsheets and presentations on laptops with wide screens. In addition, the new Contextual Single UI is ready for Writer and Draw.
- In Calc, a new drop-down widget in the formula bar replaces the old Sum tool, giving the user quick access to the most frequently used functions. Also, a new FOURIER function has been added, to compute the discrete Fourier transform of an input array.
- Export as PDF has been improved with the support for the standard PDF/A-2 document format, which is required by several organizations for long term file storage. In addition, the design of editable PDF forms has been simplified with the addition of the Form menu to Writer, to further improve one of LibreOffice strongest features.
- Documents can now be redacted to remove or hide sensitive information such as personal data before exporting or sharing the file, to help companies or organisations to comply with regulations.
- On Windows, a proper console mode was added, with better output and error codes. This makes it easier to use LibreOffice to perform batch operations such as printing or converting many documents.
- Interoperability with Microsoft Office proprietary file formats has been improved in several areas with export support for DOTX document templates and XLTX spreadsheet templates, import of charts from DOCX drawingML group shapes, import/export of SmartArt from PPTX files, to preserve editing capabilities in PowerPoint, and better XLSX Pivot table interoperability.
More information, including screenshots, is available on the TDF blog.
In September 2018 Friends of OpenDocument published the printed edition of the LibreOffice 6.0 Getting Started Guide, written by the LibreOffice Documentation Team. Free PDFs and ODTs are available from the LibreOffice website. Purchase printed copies from our store at Lulu.com.