Welcome to The Document Foundation Planet

This is a feed aggregator that collects what LibreOffice and Document Foundation contributors are writing in their respective blogs.

To have your blog added to this aggregator, please mail the website@global.libreoffice.org mailinglist or file a ticket in Redmine.

27 March, 2020



At Collabora, we invest a lot of hard work to make LibreOffice's features available in an online environment. Recently we greatly improved the Collabora Online mobile UI, so it's more smooth to use it from a mobile device. While putting more and more work into the software, trying to support more and more different platforms, we need also to spend time improving the test frameworks we use for automatic testing. These test frameworks make sure that while we enrich the software with new features, the software remains stable during the continuous development process.

End-to-end testing in the browser

One step on this road was the integration of cypress.io test framework into Collabora Online code. cypress.io is an end-to-end test run in the browser, so any online application can be tested with it. It mainly allows us to simulate user interaction with the UI and check the event's results via the website's DOM elements. That allows us to simulate user stories and catch real-life issues in the software, so our quality measurement matches the actual user experience.

When I investigated the different alternatives for browser testing I also checked the Selenium test framework. I didn't spend more than two days on that, but I had an impression that Selenium is kind of "old" software, which tries to support many configurations, many language bindings which makes it hard to use and also makes it stuck in the current state, where it is. While cypress.io is a newer test framework, which seems more focused. It is easier to integrate into our build system and easier to use, which is a big plus because it's not enough to integrate a test framework, but developers need to learn how to use it too. I saw one advantage of Selenium: the better browser support. It supports all the main browsers (Chrome, Mozilla Firefox, Safari, Internet Explorer), while cypress.io mainly supports only Chrome, but it improves on this area. Now it has a beta Mozilla Firefox support. So finally I decided to use cypress.io and I'm happy I did that because it nicely works.

cypress.io in Collabora Online

So cypress.io is now integrated into the Collabora Online code and we already have 150 tests mainly for mobile UI. As we submit most of our work to upstream, these tests are also available in the community version of the software. It's integrated into the software's GNU make based build system, so a make check will run these tests automatically. This is also part of the continuous integration system, so we can catch any regression instantly, before it actually hits the code. It's recommended to all developers of the online code to get familiar with the test framework, so it will be easier to understand if a test failure indicates an issue in their proposed patch. There are a set of useful notes in the source code, in the readme file

25 March, 2020

  • Mail chew, S&M call, partner call.
  • Really pleased to see Collabora Office 4.2.1 for Android out - with a lot of rather important fixes, performance improvements, UI pretifications and much more.


Document Freedom is based on Open Formats, such as ODF or Open Document Format, the ISO standard native file format of LibreOffice and other FOSS office suites.

What is an Open Format?

When you save a document on your computer, it is stored in a computer file. Whether it is a text file, a picture, a video or any other kind of work, it is saved with a specific coded structure, known as the file format.

To be able to share data, software programs must be able to communicate with each other. It implies that no barrier whatsoever may hinder the exchange of data and the related write or read operations. For such a seamless exchange to be possible, software programs are required to be “interoperable”.

Interoperability is guaranteed when it relies on open standards, i.e. public technical specifications, freely usable by everyone, without restriction nor compensation, and maintained by an open decision-making process. File formats based on these open standards are “Open Formats”.

Where software interoperability is set aside, or if a program editor does not give access to the key information for interoperability or if the file design recipe is kept undisclosed, or if the file design recipe is available but is not followed by the program, file formats are considered to be “closed” and do not allow interoperability. For a software user, choosing between an Open File Format or a closed one has a deep impact on the ownership of and the access to his/her own data and their availability over time.

What are the benefits of Open Formats?

  • Open Format documents are readable and writable, by oneself or by third parties.
  • Open Format document readability is guaranteed over time as the format evolves without disruptions.
  • Open Formats have the advantage of being freely usable by many software programs, enabling interoperability.
  • Open Formats support freedom of choice as they do not promote any company’s specific format. They help avoid the monopolistic position of software editors who aim at locking users through their own proprietary formats.

Free Software and open formats, the perfect duo!

Free Software are programs that offer four freedoms to users: the liberty to copy and to distribute the software to others, the right to use it for every kind of use, the right to study it in order to know its functioning, and the right to modify in order to improve it. Free Software designers usually favour existing Open Formats, and contribute to their evolution.

Furthemore, as Free Software developers publish their source code (the software design recipe), recording methods and format descriptions used are de facto distributed with the software.

Open Formats and Free Software share the same goals: to be at the service of eveyone and to ensure users the full ownership and control over their data as well as perennial availability of those data.

Let’s celebrate Document Freedom Day 2020 by sharing with other people the information about the importance of Open Formats. Create your own DFD

24 March, 2020

  • Mail, call with Mike, some hacking; tech team call. Dug into unit tests, pwrt. parallelizing them. Movie in the evening.


Many schools, colleges and universities around the world use LibreOffice to get their work done every day. The free and open source office suite, compatible with Microsoft Office and a successor to OpenOffice(.org) with many extra features, includes a complete set of powerful tools for students and teachers:

  • Writer – word processor
  • Calc – spreadsheet
  • Impress – presentation tool
  • Draw – for technical drawings, brochures etc.
  • Math – formula editor
  • Base – database

Benefits in education

Because LibreOffice is free and open source software, students and teachers can download and install it on as many machines as they like, without worrying about license fees, subscriptions or audits. If you’re a teacher, you can be sure that your students won’t suddenly be locked out of their documents for not renewing a subscription. They can keep working, as long as they like!

As well as the desktop app, there’s also LibreOffice Online, a cloud-based version of the suite that students can access via their web browsers. You can set up LibreOffice Online on your own infrastructure, with help from professional support services.

Additionally, LibreOffice is backed up by a rich ecosystem, with many companies and resources available to help users:

One more benefit, especially for IT students and teachers: because LibreOffice is open source, anyone can study how it works and make improvements. See what you can do for LibreOffice here!

Give it a try – download LibreOffice for Windows, macOS and Linux



Help us celebrate the Twelfth Anniversary of Document Freedom Day by making a paper dove!

Download the dove template and the instructions from this link: https://tdf.io/dfd1, and once you are done with your dove take a picture of it and upload your photo using this link: https://tdf.io/dfd2.

#DFDDove2020 #DFD2020

23 March, 2020

  • Mail chew; planning call; more various admin. Lunch with the kids - all studying studiously up-stairs; nice. Back to some development.

22 March, 2020

  • Feeling rather unwell; up early, helped J. who despite her consumptive cough, tidied up in the garden a little. Sang a bit with the babes & enjoyed a talk from All Souls.
  • Pizza lunch; out for a walk on the gallops together - ~no-one there. Slept exhaustedly in the afternoon. Watched Point Break with the babes.

21 March, 2020

  • Cleaned a ton of dust out of my office - helped J' get the garden tidied up, bought trampoline parts. Watched Jabberwocky with the family.
  • Managed to get my PHP hack working in the evening.

20 March, 2020


I submit a new gallery for LibreOffice called Icons. It show some usefull icons/symbols which can be used in all LibreOffice apps. If you search for app icons they area already available in the GUI widget prototyping extension.

Please test the extension and give me feedback.


For the LibreOffice 7.0 release I work on galleries. One which is ready for testers is a new/updated arrows gallery.

You can test the arrow gallery by install the extension (upload to the extension page was done. Pending for the review.)

  • Mail chew; partner call, tried to prop up some ESG stocks a little; worked on PHP proxy sockets.
  • Last day of school; H. had a final party with her train-sharing friends here.

19 March, 2020

  • Mail, patch reading; worked on mobile border setting in Calc, and handed over to Pedro for beautification.
  • Amused to see Pedro's videos of Android, comparing features vs. Google Docs on mobile. Ever wondered how to: re-size an image or how to apply a master page to a slide there ?
  • Took babes to music lessons in the evening; back to bed.


Berlin, March 19, 2020 – The Document Foundation announces the availability of LibreOffice 6.4.2, the 2nd minor release of the LibreOffice 6.4 family, targeted at technology enthusiasts and power users. LibreOffice 6.4.2 includes several bug fixes and improvements to document compatibility.

Mac users will be happy to know that the issue of blurry fonts on Retina displays has been resolved.

LibreOffice 6.4.2 represents the bleeding edge in term of features for open source office suites, and as such is not optimized for enterprise class deployments, where features are less important than robustness. Users wanting a more mature version can download LibreOffice 6.3.5, which includes some months of back-ported fixes.

LibreOffice 6.4.2’s change log pages are available on TDF’s wiki: https://wiki.documentfoundation.org/Releases/6.4.2/RC1 (changed in RC1) and https://wiki.documentfoundation.org/Releases/6.4.2/RC2 (changed in RC2).

LibreOffice’s individual users are helped by a global community of volunteers: https://www.libreoffice.org/get-help/community-support/. On the website and the wiki there are guides, manuals, tutorials and HowTos. Donations help us to make all of these resources available.

LibreOffice in business

For enterprise class deployments, TDF strongly recommend sourcing LibreOffice from one of the ecosystem partners to get long-term supported releases, dedicated assistance, custom new features and other benefits, including Service Level Agreements (SLAs). Also, the work done by ecosystem partners flows back into the LibreOffice project, benefiting everyone.

Also, support for migrations and trainings should be sourced from certified professionals who provide value-added services which extend the reach of the community to the corporate world and offer CIOs and IT managers a solution in line with proprietary offerings.

In fact, LibreOffice – thanks to its mature codebase, rich feature set, strong support for open standards, excellent compatibility and long-term support options from certified partners – represents the ideal solution for businesses that want to regain control of their data and free themselves from vendor lock-in.

Availability of LibreOffice 6.4.2

LibreOffice 6.4.2 is immediately available from the following link: https://www.libreoffice.org/download/. Minimum requirements are specified on the download page. TDF builds of the latest LibreOffice Online source code are available as Docker images: https://hub.docker.com/r/libreoffice/online/.

LibreOffice Online is fundamentally a server-based platform, and should be installed and configured by adding cloud storage and an SSL certificate. It might be considered an enabling technology for the cloud services offered by ISPs or the private cloud of enterprises and large organizations.

All versions of LibreOffice are built with document conversion libraries from the Document Liberation Project: https://www.documentliberation.org.

Support LibreOffice

LibreOffice users are invited to join the community at https://ask.libreoffice.org, where they can get and provide user-to-user support. People willing to contribute their time and professional skills to the project can visit the dedicated website at https://whatcanidoforlibreoffice.org.

LibreOffice users, free software advocates and community members can

18 March, 2020

  • S&M call, CP all-hands, out to admire the empty shelves / aisles at Tesco locally. Bought some components for a new ultra-cheap, purely mechanical ventilator design I've been mulling over driven by compressed air. Worked late.

17 March, 2020

  • Mail, admin, monthly mgmt meeting; more admin. Accelerated Android copy by two orders of magnitude by not serializing to JSON, but the (old) Java / binary object serialization; hmm.


In the age of the cloud, most people think they don’t have “real” files any more, as these have been replaced by pointers in an online system. They don’t realise they have lost their freedom until they download the file to edit it on their laptop. At that point, they realize that without buying a proprietary office suite they are unable to access their very own contents, as these are hostage of a proprietary file format. Something that wouln’t have happened if they had chosen the standard Open Document Format (ODF), which can be fully implemented by any software vendor without special permission, and without having to reverse engineer an obfuscated pseudo-standard format owned by a single company.

Back in 2012, European Commission Vice President Neelie Kroes said: “Open standards create competition, lead to innovation, and save money,” while announcing the publication of a new policy to help public authorities avoid dependence on a single ICT supplier. At the time, following the recommendations of the new approach against lock-in could save the EU’s public sector more than € 1.1 billion a year.

Working with open standards – rather than specifying a single ICT brand, tool, system, or product – when procuring ICT systems could save taxpayers’ money. However, many organisations were either lacking the expertise to decide which standards are relevant to their ICT needs, or fearing that the initial costs of change would be too costly and might lead to loss of data. As a result, after eight years they still remain locked into their ICT systems or into a relationship with only one provider. How much are we globally losing – in term of end user or taxpayer money – by sticking to the insane decision of using proprietary or pseudo-standard document formats?

Open Document Format is a well designed and flexible open document standard format to store information in a future proof and portable way. Probably its best feature for regular users is that they won’t really notice they are using it, as things just work as expected independently from the specific product used to create the original document. Contents are preserved, and the document has the same visual look even when accessed with a different software running on a different operating system, as with ODF the way you store documents is not related to the software you work with. ODF files are platform independent and do not rely on any specific piece of software whatsoever.

Open Document Format does have a number of obvious advantages which make it unique:

  • ODF documents are smaller in size than their legacy and proprietary equivalents, because they are structurally simpler, and as such are more robust
  • Content as well as media objects (images, movies, etc) are directly accessible and easy to work with from outside the office application, even for non technical users
  • The simple XML syntax is human readable and easy to understand, and this allows to easily recover documents by unzipping the file and access the content

16 March, 2020

  • Mail chew, admin, calls, finally got to some code in the late afternoon.

15 March, 2020

  • Breakfast with my parents, All Saints, back for a fine roast lunch; admired his new(er) Prius with Dad. Watched a film with H. until babes returned exhaustedly from 'Alive', read stories and put them to bed.

14 March, 2020

  • Went for a run with Julia, poked at finances a little. Spent some time Aralditing M's laptop, and finally got to dis-assembling and gluing my own; good. Watched Bones with J. while she felted. M&D arrived, lovely to see them.

13 March, 2020

  • Mail chew; code reading, TDF BoD call(s). Patch review.
  • Interested to read the latest Cambridge Paper on AI & simulated relationships. Interesting to think about what children might mis-learn when interacting extensively with a (usualy female voiced) slave-'person'; should they say please ? do they build a shallow and instrumentalised understanding of relationships; and more.
  • Customer call, worked at sockets.

12 March, 2020

  • Mail chew - worked on cypress bits - seemingly my mobile user-agent is not happy, screenshare with Tamas Z and got a couple of fixes in; nice. Music lessons in the evening.

11 March, 2020

  • Mail, S&M call, poked at CSS horrors - why do we use a Vex JS dialog class when doing it by ourselves would be so infinitely easier ? amazing. Call with Pedro. Ferried M. to ballet; band practice.

10 March, 2020

  • Mail chew, sync with Miklos, tech. call, sync with MikeK. Mail, worked from church while H. practiced. Got some sockets to behave eventually.


As mentioned in a previous such report, a hack week is when we are allowed to hack on anything we want in LibreOffice for a few days at Collabora. I used this time to implement core support for padded numbering in Writer.


Padded numbering is a style where you insert 0 characters in front of an otherwise normal (Arabic) numbering, making sure that the result always has at least N characters. Up to now, you had to number your content manually to have this effect, while Word supports this feature.

OOXML supports padding up to 2, 3, 4 and 5 characters. Padding up to 2 characters is the older feature, supported in DOC and RTF as well, so I focused on that piece.

Results so far

Here is how the current, the baseline and the reference rendering of padded numbering looks like:

Figure 1. numbering-padded2.docx, current
Figure 2. numbering-padded2.docx, baseline
Figure 3. numbering-padded2.docx, reference

You can see how 0 is inserted before 1..9, but not before 10.

How is this implemented?

If you would like to know a bit more about how this works, continue reading… :-)

Then I found that footnote numbering needs explicit handling, so added support for padding in that case as well:

Finally I had a little bit of remaining time, so I extended support for the recently added Chicago numbering:

Future work

Padding up to 3, 4 and 5 characters would be possible to do, but it’s DOCX-only, and uses a different markup, planned to be done later.

All this is available in master (towards LibreOffice 7.0), so you can grab a daily build and try it out right now. :-)

09 March, 2020


General Activities

  1. LibreOffice 6.3.5 was announced on February, 20
  2. LibreOffice 6.4.1 was announced on February, 27
  3. LibreOffice was present at FOSDEM and many presentations about LibreOffice were given on February, 1
  4. A 2 days Hackfest took place in Brussels right after FOSDEM
  5. Michael Weghorn implemented native PopupMenus for the qt5/kf5 VCL plugin
  6. Stephan Bergmann (Red Hat) fixed blurry text in macOS and did many code cleanups
  7. Jim Raykowski continued to improve Navigator in general and its context menu
  8. Seth Chaiklin made many Help update patches
  9. Luboš Luňák (Collabora) continues to polish Skia library in LibreOffice
  10. Maxim Monastirsky added Highlighting tab for shapes and comments to Format>Character dialog in Writer and in Calc
  11. Noel Grandin (Collabora) did many cleanups under the hood, including changes that speed up development
  12. Jan Holešovský (Collabora) enabled spell-checking on Android
  13. Caolán McNamara (Red Hat) continued the crucial user interface backend work and also did many cleanups to the code
  14. Mike Kaganski (Collabora) made it so decimals input into Calc are represented with the correct precision value
  15. Michael Stahl (CIB) improved DOCX exporting of footnote separators and rotated text fields
  16. Jan-Marek Glogowski (CIB) fixed several qt5/kf5 issues
  17. Xisco Fauli (TDF) added basic unittests for LWP files
  18. Gábor Kelemen (NISZ) fixed issues with missing titles and period separators in charts
  19. Tünde Tóth (NISZ) improved label placement for stacked area charts and fixed XLSX exporting of chart line markers
  20. Bakos Attila (NISZ) fixed chart wrap setting with DOCX import and shape anchoring to table with DOCX export
  21. László Németh (NISZ) fixed several issues with tables in imported DOCX files
  22. Szabolcs Tóth (NISZ) fixed inherited list level of custom styles with DOCX import
  23. Balázs Varga (NISZ) fixed several issues with chart label positioning with OOXML import and export
  24. Miklos Vajna (Collabora) fixed several DOCX import and export issues and implemented semi-transparent text for Writer
  25. Eike Rathke (Red Hat) improved handling of named references in Calc
  26. Julien Nabet fixed the precision and scale for decimal and numeric fields in Firebird databases
  27. Armin Le Grand improved the performance of rendering dashed lines
  28. Arnaud Versini added minimum support for PDF/A3
  29. Serge Krot (CIB) fixed DOCX exporting of bold text under certain conditions
  30. Andreas Kainz made many UI improvements in Sidebar
  31. Rizal Muttaqin made many improvements in most of the icon themes
  32. Heiko Tietze (TDF) added a note in the UI for Draw page renaming conflicts
  33. Jens Carl moved several Java tests to C++

Reported Bugs

679 bugs, 98 of which are enhancements, have been reported by 442 people.

Top 10 Reporters

  1. Xisco Faulí ( 32 )
  2. sdc.blanco ( 22 )
  3. Roman Kuznetsov ( 21 )
  4. NISZ LibreOffice Team ( 16 )
  5. Mike Kaganski ( 13 )
  6. Rizal Muttaqin ( 13 )
  7. Robert Großkopf ( 9 )
  8. Kevin Suo ( 9 )
  9. stdedos ( 8 )
  10. Timur ( 7 )

Triaged Bugs

668 bugs have been triaged by 95 people.

Top 10 Triagers

  1. Xisco Faulí ( 159 )
  2. Dieter ( 83 )
  3. Julien Nabet ( 51 )
  4. Heiko Tietze ( 47 )
  5. Oliver Brinzing ( 25 )
  6. Aron Budea ( 22 )
  7. V Stuart Foote ( 22

04 March, 2020


libreOffice 6.4Mit jedem LibreOffice-Release tragen wir ein wenig mehr dazu bei, dass das Microsoft-Office-(fast)Monopol sich dem Ende nähert. Und wir sind stolz darauf! Auch Version 6.4 wurde von CIB mitentwickelt und enthält eine Reihe neuer nutzvoller Funktionen, die sicherlich wieder die Anzahl der Fans dieses beliebten Open Source Pakets erhöhen wird: Jetzt mit integriertem QR-Code-Generator. Die … LibreOffice 6.4 – Wieder dicht am Microsoft Office Paket dran weiterlesen

Der Beitrag LibreOffice 6.4 – Wieder dicht am Microsoft Office Paket dran erschien zuerst auf CIB Blog.

02 March, 2020

Rizal Muttaqin has added a new icon theme into LibreOffice. Its name is Sukapura. That icon theme will be a default theme for a new LibreOffice installation in macOS. It looks very nice for me.
The Sukapura icon theme will available in future LibreOffice 7.0 release.
But, if you want, you can install it right now using a Rizal's extension.

28 February, 2020

Jim Raikowski, one from LibreOffice's developers, has made many very nice Navigator improvements for Writer and Calc.
- Navigator's categories are gray if they don't have any items. It works in Writer and in Calc Navigators.
- New items Go To, Edit, Delete, Rename were added for all objects context menu in Writer's Navigator (Headings, Tables, Frames, Images, etc.)
- New items Promote/Demote level and Promote/Demote chapter were added to Headings context menu in Writer's Navigator
- Added a new feature "Outline tracking" for Headings in Writer's Navigator. You'll can find it in Hedings context menu in the Navigator. It can be in three states: Default, Focus, Off. Try click by your mouse in several place in your big text document with many headings. You'll see that Headings in Navigator will be selected automatically according to text cursor position.
- It was replaced the navigation toolbox with the navigate by elements control. 
It all will be available in future LibreOffice 7 release in early August 2020. But you already can try it right now if you'll install a LibreOffice's daily build from https://dev-builds.libreoffice.org/daily/master/current.html.
Thanks Jim for your great work!

26 February, 2020


Cambridge, February 27th, 2020, 12:00 CET – Today we are releasing Collabora Office for Android and iOS which will allow you to edit documents directly on your phone or tablet, guaranteeing your privacy and putting you in full control of your data and documents. This release fully integrates the iOS and Android apps into our Collabora Office product family. They are now a supported part of our business suite and come with every Collabora Office Enterprise subscription. Take a look: it’s a great app: feature rich, providing smooth editing, a polished user experience and lots of design goodness.

Rich editing for mobile devices – developed with your privacy in mind!

Collabora Office for Android and iOSFrom opening … to viewing … to a rich editing experience

Collabora Office for Android   (minimal version 5.0) and iOS is fully open source and brings you slick and useful editing features, like rich copy and paste, that the competition fails to deliver.
The app does not depend on external storage or services, so can be used offline. There is no longer a reason to hand over your data to somebody else to get rich mobile editing. Thus you can regain control over your documents and edit them without compromising your privacy!

One-handed touch tools for all sorts of editing


Collabora Office allows tables to be changed easily and in many ways. Handles in the document, as well as an attractive palette of tools, helps you perfect your table layout.
In our new mobile app, you will find the features where you expect them to be, giving you access to powerful functionality.

Slides and sheets at your fingertips

Choose layout and animations for presentations. A unique feature allows slide masters to be edited as well as applied.

Collabora Office for iOS and Android comes with a refined touch of usability. Sort the slides in your presentations using the convenient slide sorter. Scroll through the different sheets of your spreadsheet with the touch of a fingertip. Mobile document editing has never been easier and more fun.

Experience the polished user interface & design

Lay out of presentation in Collabora Office for iOS and AndroidFull control over layout of presentations

Rotating an image in a presentationRotate images with your fingertips

Text highlighting in a presentationHighlight text with the tool at the palette

Copy & paste rich text objects on mobile

Our mobile solution stands out from all its competitors because of the smooth way in which it facilitates editing on mobile devices. Collabora Office allows you to actually copy and paste rich document content on your iOS or Android device. Try it out!

Attractive icons and an attractive layout

Sheet editing options in context menu

Collabora Office for iOS and Android text documentEditing your text file

Collabora Office for iOS and Android presentationEditing the content of a presentation

Native platform document storage

Collabora Office gives you back control over your documents. This includes the freedom to decide where to store the documents you edit from your mobile device. Our app allows you to easily integrate with privacy respecting, open source storage services such as Nextcloud, ownCloud or Seafile as

Older blog entries ->