LibreOffice 5.4 released with new features for Writer, Calc and Impress

Berlin, July 28, 2017 – The Document Foundation announces LibreOffice 5.4, the last major release of the LibreOffice 5.x family, immediately available for Windows, macOS and Linux, and for the cloud. LibreOffice 5.4 adds significant new features in every module, including the usual large number of incremental improvements to Microsoft Office file compatibility.

Shorter, sweeter documents make interoperability easier

Inspired by Leonardo da Vinci’s “simplicity is the ultimate sophistication”, LibreOffice developers have focused on file simplicity as the ultimate document interoperability sophistication. This makes ODF and OOXML files written by the free office suite more robust and easier to exchange with other users than the same documents generated by other office suites.

Thanks to the efforts of developers, the XML description of a new document written by LibreOffice is 50% smaller in the case of ODF (ODT), and around 90% smaller in the case of OOXML (DOCX), in comparison with the same document generated by the leading proprietary office suite. Additional details in the file simplicity backgrounder: https://nextcloud.documentfoundation.org/s/5Oe8guDN0XSS7h8.

LibreOffice 5.4 highlights

  • A new standard colour palette has been included, based on the RYB colour model.
  • File format compatibility has been improved, with better support for EMF vector images. This helps when you’re importing detailed diagrams from other office software.
  • Imported PDF files are rendered with much better quality, also when inserted into a document, while exported PDF files – from Writer and Impress – support embedded videos (and linked videos if opened with Acrobat Reader).
  • LibreOffice 5.4 supports OpenPGP keys for signing ODF documents on Linux. If you already use GPG/PGP for signing emails, it ensures the authenticity of your ODF documents regardless of the mode of transport or storage.

WRITER

  • In Writer, you can now import AutoText from Microsoft Word DOTM templates.
  • When you’re exporting or pasting numbered and bulleted lists as plain text, their full structure is preserved.
  • In the Format menu, you can now create custom watermarks for your documents.
  • New context menu items have been added for working with sections, footnotes, endnotes and styles.

CALC

  • Calc now includes support for pivot charts, which use data from pivot tables. When the table is updated, the chart is automatically updated as well.
  • Comments are now easier to manage, with menu commands to show, hide and delete all comments.
  • When applying conditional formatting to cells, you can now easily change the priority of rules with up and down buttons.
  • Extra sheet protection options have been added, to optionally allow insertion or deletion of rows and columns.
  • Lastly, when you’re exporting in CSV format, your settings are remembered for the next export operation.

IMPRESS

  • In Impress, when you’re duplicating an object, you can now specify fractional angles. In addition, your settings are saved for the next duplication operation.

ONLINE

  • Finally, LibreOffice Online has been improved as well. Performance is better, while the layout adapts responsively to mobile devices. In addition, a read-only mode has been added.

A list of the most significant new features is presented in a short video (https://www.youtube.com/watch?v=lBNWOWJul4w). A page with a description of new features – and links to relevant resources – is available on the wiki at https://wiki.documentfoundation.org/ReleaseNotes/5.4.

LibreOffice 5.4 has also been improved “under the hood,” thanks to the work of hundreds of volunteers. This translates into an open source office suite which is easier to develop, maintain and debug. Although this is not visible to users, it is extremely important for enterprise deployments.

LibreOffice Online

LibreOffice Online is fundamentally a server service and should be installed and configured by adding a cloud storage and an SSL certificate. It might be considered an enabling technology for the cloud of ISPs or the private cloud of enterprises and large organizations. Builds of the latest LibreOffice Online source code are available as Docker images: https://hub.docker.com/r/libreoffice/online/. Background document providing the positioning of LibreOffice Online: https://nextcloud.documentfoundation.org/s/uSdCYL2TgPa3yUI.

Enterprise deployments

LibreOffice 5.4 represents the bleeding edge in term of features for open source office suites, and as such is targeted at technology enthusiasts, early adopters and power users. For enterprise class deployments, TDF maintains the more mature 5.3 family – to be updated very soon with the announcement of the 5.3.5 release – which should always be supported by certified professionals (http://www.libreoffice.org/get-help/professional-support/).

Several companies sitting in TDF Advisory Board (http://www.documentfoundation.org/governance/advisory-board/) are providing either value added Long Term Supported versions of LibreOffice or consultancy services for migrations and training, based on best practices distilled by The Document Foundation. LibreOffice is deployed by large organizations in every continent. A list of the most significant migrations announced in the media is available on TDF wiki: https://wiki.documentfoundation.org/LibreOffice_Migrations.

Availability of LibreOffice 5.4

LibreOffice 5.4 is immediately available from the following link: http://www.libreoffice.org/download/. LibreOffice users, free software advocates and community members can support The Document Foundation with a donation at http://www.libreoffice.org/donate.

LibreOffice 5.4 is built with document conversion libraries from the Document Liberation Project: http://www.documentliberation.org.

Press Kit

The press kit, with background documents and high-resolution images, is here: https://nextcloud.documentfoundation.org/s/pfz28pVIhoZJ7uO.

Report from the Indonesian Community

I am Taufik Hidayat, Founder and Coordinator of BLOI (Belajar LibreOffice Indonesia) Community in Telegram. The BLOI group was created on March 16th, 2016, as GBLOI (Grup Belajar LibreOffice Indonesia). The acronym was then simplified in BLOI (Belajar LibreOffice Indonesia). The objective of the group is to help Indonesians to learn and use LibreOffice.

We announced the first book about LibreOffice in the same month, on April 21st, 2016. The original title was “Mari Mengenal Aplikasi LibreOffice”, then changed into “Mari Mengenal LibreOffice”. The book has 42 pages and has been written by 6 people (http://libreoffice.puskomedia.web.id/kontributor/). Two months after the release of the first book, we started our second project: “Lebih Dekat Dengan LibreOffice Writer”, to focus on Writer. This book has 225 pages and has been written by 15 people (http://libreoffice.puskomedia.web.id/kontributor/). The second book was completed in 3 months and was released on October 30, 2016, and has been reprinted three times since then. Both books can be downloaded from http://libreoffice.puskomedia.web.id/buku/.

We decided to print our second book to allow everyone to get a “phisical” copy, in addition to the digital one (e-book). But even after the publication of the second book, I still had the feeling that those two books were not enough. So, we decided to publish an improved version, which is called “Lebih Dekat dengan LibreOffice Writer Edisi Revisi 2” and contains many changes over the previous one (changes are listed here: http://libreoffice.puskomedia.web.id/2017/07/12/pesan-buku-lebih-dekat-dengan-libreoffice-writer-edisi-revisi-2/#more-46). We published only the printed version of this book, which we sell through the website to raise the money to pay contributors and cover the costs. All of our books are published under the CC BY-SA 3.0 license.

On July 12th, 2017, we have released the official website of the BLOI Community. Before, we were using my own blog at http://ubupediaindonesia.wordpress.com. The BLOI Community website has many contributors, which are listed on the same page: http://libreoffice.puskomedia.web.id/kontributor/. They contribute to the book, to the domain (website, subdomain and server), to the mirror, and to the different administrative tasks, including the delivery of orders.

Today, the BLOI Community has specific growth plans: collecting donations and member fees, organising online courses, creating jobs and providing directions for the community. We have announced jobs for people who want to help us share Free Software concepts in Indonesia (http://libreoffice.puskomedia.web.id/lowongan/). We are trying to make our members prosperous. For next year, we are planning either a seminar or a workshop to gather the community face-to-face, and educate people about free software and especially LibreOffice. For the future, we are also thinking about a 3rd collaboration book project: “Lebih Dekat dengan LibreOffice Calc”.We hope that our community becomes useful either for LibreOffice newbie or our country Indonesia. So we can share the spirit of free software to

We hope that our community becomes useful both for the LibreOffice newbie and our country Indonesia so that we can share the free software ethos to the whole country.

TDF 2016 Annual Report has been published

The Annual Report of The Document Foundation for the year 2016 is now available as a PDF document, in three different versions: English Low Resolution, English High Resolution, and German.

Documents can be downloaded from the following links:

English Low Resolution (7.4MB): https://tdf.io/ar2016low
English High Resolution (22.7MB): https://tdf.io/ar2016high
German: https://wiki.documentfoundation.org/File:TDF2016AnnualReportDE.pdf

The annual report is also available for print-on-demand on Lulu, at the following address: http://www.lulu.com/shop/the-document-foundation/annual-report-2016/paperback/product-23265884.html.

Taming the LibreOffice Help System

LibreOffice’s help system needs to evolve and be more effective for users.

LibreOffice’s help system was designed in 2003-2004 and released in 2005. Since then it has not evolved, except for the introduction of an online version hosted in a wiki server (and accessible from LibreOffice when the local help is not installed).

I worked recently to transform our ancient help system into a modern browser-based version. The partial result is available in the (temporary) website at https://helponline.libreoffice.org – please be advised that this is still work in progress.

The XML help pages are transformed into pure, almost static and responsive HTML. This approach has some advantages:

  • Works in every browser
  • Provides the current functionality of the help system
  • Preserves the current development, help authoring, release engineering and translation process as it is
  • You can read the help pages in your mobile phone or tablet
  • It’s easy to add extra markup for better search engine indexing

The disadvantage is an increase in disk storage on the server.

Transforming XML into HTML for every browser

The help pages were designed when the minimal standard HTML was version 3.2 and, since then, many developments have brought us HTML5 in all major browsers. There is little advantage now to keep the current XML, and all of its designed functionality can be replaced and improved by HTML, CSS and JavaScript, for example, adding better navigation and multimedia contents.

The new Help page layout benefits of many modern technologies

(more…)

Month of LibreOffice: Stickers in action!

Back in May we had a Month of LibreOffice, celebrating contributions all across the project, from code and documentation through to translations and bug reports. 304 members of our worldwide community won stickers, and we’ve received some photos of them in action – so here they are!

The first is from Gabriele Ponzo, who is in The Document Foundation’s Membership Committee and already has plenty of LibreOffice stickers:

Next up is Osoitz E who helps to translate and localise LibreOffice into Basque:

Franklin Weng promotes LibreOffice and the Open Document Format in Taiwan, and sent us this photo:

Finally, Buovjaga from our QA community has a novel use for his sticker:

We’ll be repeating the Month of LibreOffice in November, so you’ll have another chance to grab a sticker – but you can get involved with our friendly community at any time. Join us and help make LibreOffice even better for millions of people around the world!

LibreOffice Conference 2017 in Rome – register now!

This year’s LibreOffice Conference will take place from 11 – 13 October in Rome, Italy. It’s a great opportunity for LibreOffice developers, users, supporters, translators and other members of the community to meet up, share ideas and make plans for future versions of the software.

And you can join us! On our conference website you’ll find a registration form, along with useful practical information. We’re still working on the website and conference programme, so stay tuned to the site for more information.

Also: if you’re attending and want to give a talk or presentation about what you’re doing with LibreOffice, check out the Call for Papers. There are many different topics and “tracks” in the programme, so whether you want to talk about development, QA, marketing, outreach, migrations or something else, submit your idea. The deadline for submissions is August 15.

We look forward to seeing you at the conference!