The Month of LibreOffice, November 2021 begins – Join in and get cool merch!

Love LibreOffice? Want to boost your skillset and learn new things? Then join the Month of LibreOffice! The software is a worldwide, community open source project – and many people who help to improve it, actually started out as regular users of the software.

So in November, we want to encourage you to get involved, join our community, and have fun. You can build up valuable skills for a future career – and you don’t need to be a programmer. There are many ways to help make LibreOffice awesome, as we’ll see in a moment.

And best of all: everyone who contributes to LibreOffice in the next four weeks can claim a cool sticker pack, and has the chance to win extra LibreOffice merchandise such as mugs, hoodies, T-shirts, rucksacks and more (we’ll choose 10 participants at random at the end):

How to take part

So, let’s get started! There are many ways you can help out – and as mentioned, you don’t need to be a developer. For instance, you can be a…

  • Handy Helper, answering questions from users on Ask LibreOffice. We’re keeping an eye on that site so if you give someone useful advice, you can claim your shiny stickers.
  • First Responder, helping to confirm new bug reports: go to our Bugzilla page and look for new bugs. If you can recreate one, add a comment like “CONFIRMED on Windows 10 and LibreOffice 7.2.2”.
  • Drum Beater, spreading the word: tell everyone about LibreOffice on Twitter or Mastodon! Just say why you love it or what you’re using it for, add the #libreoffice hashtag, and at the end of the month you can claim your stickers.
  • Globetrotter, translating the user interface: LibreOffice is available in a wide range of languages, but its interface translations need to be kept up-to-date. Or maybe you want to translate the suite to a whole new language? Get involved here.
  • Docs Doctor, writing documentation: Whether you want to update the online help or add chapters to the handbooks, here’s where to start.

We’ll be updating this page every few days with usernames across our various services, as people contribute. So dive in, get involved and help make LibreOffice better for millions of people around the world – and enjoy your sticker pack at the end as thanks from us! And who knows, maybe you’ll be lucky enough to win bonus merch as well…

Let’s go! We’ll be posting regular updates on this blog and our Mastodon and Twitter accounts over the next four weeks – stay tuned!

LibreOffice project and community recap: October 2021

Here’s our summary of updates, events and activities in the LibreOffice project in the last four weeks – click the links to learn more!

  • Meanwhile, we have a new LibreOffice development blog thanks to Hossein Nourikhah, who recently joined us as a Developer Community Architect. He’ll be posting regular tips and tutorials for making changes to the software’s source code, and submitting patches.

  • During the month, we uploaded more videos from our recent LibreOffice Conference 2021. Check out the full playlist on YouTube – and we’re also adding them to PeerTube as well. Most of the videos are online now, but a few more are still to come – we’ll post updates here on the blog.

  • And on the topic of the conference: although it was online again this year, due to the pandemic, the local German community in Hamburg organised a small “hybrid” event. They could meet in person, but also take part in the online sessions. Hopefully we’ll have more face-to-face meetings early next year!

  • The Free Software Foundation Europe is starting a new competition: Youth Hacking 4 Freedom. This gives young people the chance to receive cash awards for participating in free software project, and to travel to Brussels to meet the other winners.

  • In the middle of the month, we announced LibreOffice 7.2.2, the second bugfix release in the 7.2 family. It includes 68 bug and compatibility fixes.

  • Got an idea for a great project or event that could benefit the LibreOffice community? We at The Document Foundation can give you financial support from our budget. For example, you may want to organise a localisation sprint to translate LibreOffice into your native language, or want to buy merchandise for an upcoming event. Whatever it is, if it benefits the community as a whole, we want to hear your ideas!

  • As part of our regular “Community Member Monday” series, we talked to Hlompho Mota who’s working on the Sesotho LibreOffice translation project in Lesotho. He also told us about the challenges facing adoption of free and open source software in his country.

  • LibreOffice took part in the Google Summer of Code 2021, and in October we summarised the results. Thanks to Bayram Çiçek, Sary Nasser, Akshit Kushwaha, Balázs Sántha, Panos Korovesis, Anshu Khare and Tushar Kumar Rai for their great work!

  • And finally, Rafael Lima from the Brazilian LibreOffice community is working on an extension to remove blank cells in LibreOffice Calc. It has four modes (single column, single row, blank rows and blank columns). Rafael is looking for more help to test and improve the extension, so if you find it useful, please give him a hand!

Keep in touch – follow us on Twitter, Facebook and Mastodon. Like what we do? Support our community with a donation – or join us and help to make LibreOffice even better!

LibreOffice extension to remove blank cells – Help to improve it!

Rafael Lima from the Brazilian LibreOffice community is working on an extension to remove blank cells in LibreOffice Calc. It has four modes (single column, single row, blank rows and blank columns). Here’s a quick animation of it in action:

So far, the main functionality is there, but Rafael would like to improve it. We asked him for some more info…

What does the extension do?

The main purpose of this extension is to remove blank cells to easily compact data. For instance, suppose you have a table with data and then you delete the contents of some rows. The next thing you might want to do is remove these blank rows to compact your table. By using the Remove Blank Cells extension this can be done with a single click.

Currently the extension supports four modes to remove blank cells. The simplest one is when you select a single row or column, then the extension will detect the selection and compact the data removing all blank cells. However, if a matrix is selected, then a message will be displayed and you can choose if blank rows or blank columns are to be removed.

When did you start making it?

I started writing the extension in February this year and finished the first version in less than one month. Then I kept testing it and working on improvements and the final version was finished in July.

At first the extension focused on my use case, because in my work with data analysis I often have to remove blank rows and columns. However, after seeing many people asking about how to remove blank cells in LibreOffice, I decided to pack it and make it available for everyone since it might be useful for other people.

What are the current limitations of it?

The main limitation of the extension is when the user wants to process very large tables (with tens of thousands of rows), which might take some time to finish. In these cases a progress bar is shown so the user can keep track of the data processing.

Moreover, the extension still does not support translations, so the user interface is only available in English. I plan to support translations in the next release.

How can people help to improve it?

Because this is the first released version of the extension, I would appreciate having more people testing it and reporting issues on the extension’s GitHub page.

I would also like to invite the community to create a better icon for the extension, so that it would be more in line with the default icon theme in LibreOffice.

In the future I will also need some assistance with translating the extension’s strings.

So, everyone is welcome to try out the extension – and if you have some technical knowledge, jump in and help Rafael and the community to improve it! Check out the wiki for more information on extension development.

Ten more videos from the LibreOffice Conference 2021

Here are some more videos from the LibreOffice Conference 2021! Check out the playlist, using the button in the top-right – or scroll down for links to individual videos:

Please confirm that you want to play a YouTube video. By accepting, you will be accessing content from YouTube, a service provided by an external third party.

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.

Individual links

Note: many of these are also available on PeerTube, and more will be added…

Stay tuned for more videos from rooms 2 and 3 of the conference!

LibreOffice and Google Summer of Code 2021: The results

Google Summer of Code logo

This year, LibreOffice was once again a mentoring organization in the Google Summer of Code (GSoC), a global program focused on bringing more student developers into free and open source software development. Seven projects were finished successfully. Students and mentors enjoyed the time, and here we present some of the achievements, which should make their way into LibreOffice 7.3 in early February 2022!

You can experiment with the new features by using daily builds and report any problems in our bug tracker.


100 Paper Cuts by Bayram Çiçek

Mentors: Muhammet Kara (Collabora), Heiko Tietze (TDF)

100 Paper Cuts aims to improve user interface, implementing enhancement requests and solving the most annoying issues on the user experience (UX) side of LibreOffice.

Bayram fixed six bugs from different topics. Most notable are border preview not showing the diagonal border option, a bug where cropping flipped images occurred at the wrong side, and mouse-over effect for different palettes in the area tab.

Learn more about 100 Paper Cuts in the final report.

Screenshot of diagonal borders


Integrate .ui dialogs with translation tooling/string search webservice to help translators by Sary Nasser

Mentors: Christian Lohmaier, Olivier Hallot (TDF)

Sary automated the adding of screenshots to our translation platform, Weblate, while associating them with translatable words. This will greatly help translators by providing context for their work.

Learn more about the translation tooling in the final report.


Tests for the VCL graphic backends by Akshit Kushwaha

Mentors: Tomaž Vajngerl, Luboš Luňák (Collabora)

LibreOffice adapts its user interface to different operating systems with the help of its graphics toolkit Visual Class Library (VCL). Thanks to Akshit’s work, we have a working suite of automated graphics rendering tests. There is now also the ability for users to run the tests manually, inspect the results and attach them to our bug tracker in case there is a problem.

Learn more about the tests in the final report.

Screenshot of VCL tests


Improving table styles by Balázs Sántha

Mentors: László Németh (independent), Michael Stahl (allotropia)

This project resulted in fixes for the most annoying Writer table style issues. Further work is needed to provide full DOCX compatibility.

Learn more about DOCX tables styles in the final report.


Make SVM (StarView Metafile) format independent of the VCL Metafile + tests of the format by Panos Korovesis

Mentors: Tomaž Vajngerl, Miklos Vajna (Collabora)

Thanks to the work of Panos, the SVM file format is handled independently of internal VCL constructs, which will make important reorganisation of the VCL code possible. Panos also created automated tests for the SVM format.

Learn more about the SVM project in the final report.


Show text styles together in the sidebar by Anshu Khare

Mentors: Mike Kaganski, Tomaž Vajngerl (Collabora), Heiko Tietze (TDF)

Both paragraph as well as character styles are essential means to format text. Many users struggle with this concept and use direct formatting. Also, we don’t show both at once, and the two style families are not obvious to spot for casual users.

In order to improve the handling of styles (and as necessary preparation for the styles highlighter), Anshu started to rework the code. The new code makes it now possible to merge both lists into one view. A first patch was also part of the project – although it is not finished yet.


Implement Interface for external data source import into Calc by Tushar Kumar Rai

Mentors: Markus Mohrhard (independent), Heiko Tietze (TDF)

The data provider allows to import various data such as local CSV files or streams from external sources, and to apply transformations like adding/removing rows or columns, formatting and numerical operations with the data before it is inserted into the sheet. Plus, to update the data by still applying the transformations is just a click.

The project aimed to rework the user interface. Tushar organized the layout according the user workflow and common UI principles and made the workflow of adding/removing transformations easy to understand. He also added a couple of transformations.

Learn more about the data provider project in the final report.

Screenshot of Data Provider


Wrapping up

Many thanks to all students who spent their summer time improving LibreOffice. You are awesome! And special thanks also to the mentors who always put so much love and energy into these tasks. That’s what makes LibreOffice rock.

Now we are looking forward to next year’s GSoC. If you are interested, why not prepare early? Learn more at out wiki page where some ideas are listed.

Participating in GSoC is a great way to build your skills, and show future employers what you’re capable of!

Announcing the election for the next TDF Board of Directors

Marina Latini, on behalf of the Membership Committee, writes:

On October 18, we officially announced the upcoming election for the next Board of Directors of The Document Foundation, the non-profit entity behind LibreOffice.

As per § 7 II of our statutes (binding German version and non-binding English translartion) the Board’s term lasts two years. The current Board started its duty on February 18, 2020. Therefore, the old Board remains in charge until the end of February 17, 2022, so the new Board will be in charge the day after that, which is February 18, 2022.

That upcoming term will then (regularly) end on February 17, 2024, so the next election of the Board of Directors will take place before.

As per § 6 III, only members of the Board of Trustees of The Document Foundation, as well as current members of any of its bodies, are eligible to be elected into the Board of Directors, and the election is prepared and supervised by the Membership Committee (§ 7 II).

The active electoral right is reserved to those who have been members of the Board of Trustees before this announcement (§ 7 II).

§ 6 III also states that members of the Board of Directors or their deputies may not be members of the Membership Committee and vice versa. This means that current members of the Membership Committee are eligible to be elected, but with the acceptance of their new role they lose their current role in the MC. For clarification, they have to step down from the Membership Committee, with effect no later than to the beginning of the new term of the Board of Directors, the minute before accepting to become a member of the Board of Directors.

There is one more notable limitation: Per § 8 IV of the statutes, a maximum of 1/3 members of the Board of Directors is allowed to work on an employment basis for the same company, organisation, entity or one of its affiliate organisations.

Nomination of candidates fulfilling the above requirements, as well as self nomination is welcome. In total, at least seven Board of Directors members are required, and given there are enough candidates, up to three deputies can be elected (§ 7 II). As deputies are on duty quite often, we encourage many candidates to participate.

Re-election of current members of the Board of Directors is permitted (§ 7 II).


Please send nominations and self-nominations via e-mail to elections@documentfoundation.org (which reaches the Membership Committee in private) and at the same time to board-discuss@documentfoundation.org (which is a public mailing list).

We kindly ask nominees who would like to stand for election to provide a statement of up to 75 words – longer statements will be cut off at the maximum – on their candidacy as continuous text (so no bullet lists or multiple paragraphs). In addition, you have to provide and keep up to date your full name, e-mail address and your corporate affiliation, if any, or state the lack of an affiliation, and please announce that you will provide information on all future changes as soon as possible. Specifically, it is necessary to indicate all information regarding § 8 IV of the statutes.

Discussions with the candidates and questions to them as well as questions about the election should take place on the public board-discuss@documentfoundation.org mailing list. For details on how to use the mailing list, see here.

Eligible voters will receive further details via email prior to the start of election, including a summary of the candidates, details on how to access the voting system, and instructions on how to independently verify the vote count. Please ensure the Membership Committee has your recent and correct e-mail address on file. For questions, you can reach the Membership Committee in private at elections@documentfoundation.org.


Following the timeline set forth in § 7 II, requiring a 45 day advance notice, we hereby announce the following timeline for the election:

(00:00 is beginning of the day, 24:00 is end of the day)

  1. Monday, 2021-10-18: announcement of the election; and start of the nomination phase
  2. Thursday, 2021-11-25, 24:00 CET/UTC+1: end of the nomination phase (one week before the election starts, as per § 7 II)
  3. Friday, 2021-12-03, 00:00 CET/UTC+1: official start of the election (at least 45 days after announcement of the election, as per § 7 II)
  4. Monday, 2021-12-13, 24:00 CET/UTC+1: end of the election
  5. Tuesday, 2021-12-14: announcement of the preliminary results of the election and acknowledgement of role
  6. Wednesday, 2021-12-15, 00:00 CET/UTC+1: start of the challenging phase
  7. Monday, 2021-12-20, 24:00 CET/UTC+1: end of the challenging phase
  8. afterwards: official announcement of the final results
  9. Friday, 2022-02-18: new Board of Directors officially in charge, and election of a Chairperson and a Deputy Chairperson from among its members

Live sessions with the candidates: Between the end of the nomination phase (Thursday, 2021-11-25, 24:00 CET/UTC+1) and the official start of the election (Friday, 2021-12-03, 00:00 CET/UTC+1), the Membership Committee will organise public – and if possible recorded – live sessions, where members of the Board of Trustees can ask questions to the candidates. Everyone, also non-members, is invited to join these sessions. We will also make available to the general public the recordings and the answers given.

Questions to the candidates: In addition, after the end of the nomination phase (Thursday, 2021-11-25, 24:00 CET/UTC+1), the Membership Committee will provide a set of questions to all the candidates. All candidates are kindly invited to send their answers, which will also be made available to the general public.

Be advised that the newly elected Board of Directors will only be in charge from February 18, 2022 on. The current Board of Directors will however include them in the decision making process, to ease up the transition.

Challenges to this announcement with respect to the deadlines outlined have to happen no later than seven (7) days after this announcement, via e-mail to elections@documentfoundation.org (which reaches the Membership Committee in private).

Challenges to the preliminary results of the election have to happen until the deadline set forth above, via e-mail to elections@documentfoundation.org (which reaches the Membership Committee in private).