LibreOffice project and community recap: October 2022

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

  • Throughout October, we edited and uploaded videos from our recent LibreOffice Conference 2022. So far, there are 36 videos from talks and presentations – with more to come! Here’s the playlist:

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.

  • Our documentation team released an updated edition of the LibreOffice Calc Guide 7.4 (revision 1) with new contents on sparklines and conditional formatting. Typos and last minute mistakes and formatting were also fixed in this release. Great work!

  • Meanwhile, we released LibreOffice 7.4.2, the second minor update to the 7.4 branch. All users are recommended to update, for maximum reliability and security.

  • Dominique Welt, Ph.D. Candidate and instructor at McGill University, told us about a presentation: “Using LibreOffice Base to Teach Relational Database Management”.

  • On October 20, TDF announced the availability of LibreOffice for Windows on the Microsoft Store, to support end users who want to get their desktop software from Microsoft’s own sales channel. There’s a convenience fee of €4.59, which will be invested to further support development of the LibreOffice project. But the suite will remain free of charge to download from the main website.

  • Finally, we launched a new “Liason” role in the Native Language Communities. This role aims to improve the communication between the global projects, The Document Foundation and the local communities. This communication should be directed in two ways: keep local communities informed on what is happening internationally, and keep the international community informed of what is achieved by the local communities. If you’re interested, we look forward to hearing from you 😊

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!

Do something awesome! Join the Month of LibreOffice, November 2022

Love LibreOffice? ❤️ You’re not alone – tens of millions of people use the software every day. And hundreds of people around the world collaborate to improve the suite, update its documentation and help to spread the word. Join them!

In the coming four weeks, we’d love it if you 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.4.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 Calc Guide 7.4 is updated

The Documentation Team has released an updated edition of the LibreOffice Calc Guide 7.4 (revision 1) with new contents on sparklines and conditional formatting. Typos and last minute mistakes and formatting were also fixed in this release.

The guide is now available for download in PDF and ODF format and an online version is also available in the Bookshelf project.

The LibreOffice community is grateful of the volunteer work of Skip Masonsmith, flywire and Roman Kuznetsov for their contributions. The job for the next release of the Calc Guide is ready to start.

Download the latest LibreOffice Calc Guide 7.4 at the documentation website or the bookshelf page.

Reference: https://blog.documentfoundation.org/blog/2022/08/31/libreoffice-calc-guide-7-4-is-released/

LibreOffice project and community recap: September 2022

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

  • Our biggest event in September was the LibreOffice Conference 2022! This was the first in-person conference since 2019, due to the pandemic, and it was a great opportunity to meet face-to-face, share ideas and make plans for the future of our projects. We live-streamed presentations – and will be uploading the videos next week. Stay tuned!

  • In September, we released two new updates for LibreOffice: 7.3.6 and 7.4.1. All users are recommended to upgrade 👍

  • LibreOffice is, as always, free of charge to download from our website. But now we’re offering it in the Mac App Store for a small price, to cover the costs of placing it there, and helping to fund future development on macOS-specific improvements. So if you want to get regular updates via the App Store and help to fund future development, you can get it there. (But it will remain totally free on the LibreOffice website, as mentioned.)

  • Help tocCrowdfund audio recording and playback in LibreOffice presentations! LibreOffice’s presentation tool, Impress, includes a bunch of features for home and office use. But one thing that’s missing is recording and playback for audio comments in presentations. This project aims to crowdfund the feature.

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!

The Latin American LibreOffice 2022 Conference was a success!

Female volunteering, interoperability, professional training, migration, Python based macro development and much more were highlighted themes at the event held at the Catholic University of Brasilia in the capital of Brazil.

Daniel A. Rodriguez writes:

The Latin American LibreOffice Conference gathered around 400 people, among them students and IT professionals, and was opened to the public on Thursday August 25th in a ceremony presided by Prof. Wesley Sepulvida, representing UCB, Lothar Becker (formerly on the Board of Directors of The Document Foundation) and Olivier Hallot representing the LibreOffice community.

The conference was organized entirely by volunteers, and followed up on the first event held in the city of Asunción in Paraguay in 2019. Brasilia was chosen to host the conference in 2022 because of its importance in the Latin American context and its excellent infrastructure. The lectures and workshops were given by members of the LibreOffice community from Italy, Spain, Mexico, Brazil and Argentina, on August 25 and 26 at the Catholic University of Brasília, on the Taguatinga campus.

Italo Vignoli (Italy – TDF) and Olivier Hallot (Brazil – TDF), founding members of The Document Foundation, opened the lectures, presenting the sustainability of free software projects and the history of LibreOffice in Brazil, respectively. At the end of the morning, the participants took the official photo of the event.

In the early afternoon, Daniel Rodriguez (Argentina – TDF / UNAU) spoke about the implementation of a version of LibreOffice Online at the Alto Uruguay National University in Argentina, and Rafael Silveira (Brazil) presented the migration project to LibreOffice at Nuclebrás Equipamentos Pesados (NUCLEP). Simultaneously, in the computer lab Henderson Matsuura Sanches (Brazil – TDF) gave a workshop with practical tips about how to do an End of Course Paper in LibreOffice.

Xisco Fauli (Spain – TDF) presented the testing procedure of LibreOffice, followed by Lothar Becker (Germany – TDF) who talked about entrepreneurship with free software. Roberto Salomon (Brazil – Chief architect for Latin America at SUSE) spoke about the future that opens up with the technological innovations that are arriving in Brazil. In the closing of the first day, Prof. Andre Lima (UCB) spoke about open source solutions for LGPD compliance. In the workshops, Rafael Lima (Brazil – TDF) led the work on python scripting with a full room.

On the second day, Gustavo Pacheco (Brazil – TDF) shared with the audience details about the importance of being careful when investing in cryptocurrencies and how LibreOffice can help in decision making. He was followed by Olivier Hallot who presented the different ways of documenting software projects. Tulio Macedo (Brazil – TDF) presented the challenges of more accessible documentation. Simultaneously, Xisco Fauli led the session on software bug identification and confirmation. At the same time, Felipe Marra, Rafael Osiro and Giovanni Favorim from UCB led a workshop on software versioning control with the git tool. Prof. Remis Balaniuk (UCB) gave an introductory workshop on python.

In the afternoon, Italo Vignoli spoke about digital sovereignty. Followed by Olivier Hallot who presented migration strategies between office suites. Eliane Domingos (Brazil – TDF) talked about female volunteering in the LibreOffice project. At the same time, Mauricio Baeza (Mexico – TDF) gave a workshop about creating extensions for LibreOffice. In parallel, Prof. Cleto Spotto (UCB) analyzed snippets of LibreOffice code in a C++ workshop.

Henderson Matsuura showed how to install and use Mendeley in Writer, followed by Olivier Hallot who covered first steps in developing code for LibreOffice. Jackson Junior (Brazil – TDF) presented his experiences in standardizing documents at the Secretariat of Environment and Urban Planning (SEMAPU) of Olinda, Pernambuco, and Prof. Cleto Spotto (UCB) conducted an introductory workshop on LibreOffice Math. Finally, Prof. Hially Vaguetti (UCB) showed how to make academic presentations in LibreOffice Impress.

The conference was closed by Prof. Wesley Sepulvida, who thanked The Document Foundation and the LibreOffice community for their presence. In return, Olivier Hallot thanked the Catholic University of Brasilia for its hospitality and the volunteers and speakers for their participation in this first face-to-face event after the pandemic.

Now we look forward to meeting more people at the LibreOffice Conference 2022 in Milan, at the end of this month!

Community Member Monday: Jean-Baptiste Faure

Today we’re talking to Jean-Baptiste Faure from the LibreOffice localisation community

Tell us a bit about yourself!

I am Jean-Baptiste, living in a small town near Lyon in France.

I retired in 2021, and until then I was working as a researcher in hydroinformatics in a public research institute. I was developing numerical simulation software for the study of river flows and their dynamics: mainly floods and pollutant transport.

What are you working on in the LibreOffice project right now?

Currently my main contribution to LibreOffice is the French localization of the UI. So I am less active in Quality Assurance than previously, but I continue to build several versions of LibreOffice for my own use and QA needs.

Note: it is very easy to build LibreOffice on Linux – do not hesitate to try.

Why did you choose to join the project, and how was the experience?

Well, from my point of view, LibreOffice is the natural continuation of the OpenOffice.org project. I started with StarOffice 5.1 in 1998 because I needed a word processor able to write mathematical equations under Microsoft Windows, and I never liked Latex. 😉

In 2008, I was elected to succeed to Sophie as lead of the French speaking community. I managed the QA tests for the French localized versions of OpenOffice.org.

When LibreOffice was launched, it was clear for me that it was the future. Joining the project was proof.

Let’s not lie to ourselves, the experience is not a smooth one. Current debates about LibreOffice Online are an example, but certainly that will not be the last crisis. But LibreOffice is too central and important to be stopped by such crises. I want to believe that the community is strong enough to overcome theses problems.

Anything else you plan to do in the future? What does LibreOffice really need?

The Document Foundation, through LibreOffice and its other projects, has the mission to empower the user. Free software should make the user less dependent on software and service providers, and give him back the power over the computers he uses, more or less without realizing it.

More concretely, I think that the development effort of LibreOffice should focus in particular on the elimination of regressions, and on the frugality of the software to reduce its ecological impact.

Many thanks to Jean-Baptiste for all his contributions. All LibreOffice users are welcome to get involved, learn new skills – and make LibreOffice even better for millions of users!