LibreOffice project and community recap: April 2024

InstallFest 2024 Prague

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

Schleswig-Holstein banner

Adam Seskunas

InstallFest 2024 Prague

Screenshot of PDF export dialog box

Kira Tubo

LibreOffice Bookshelf

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

Calc Guide and Writer Guides available for browsing

LibreOffice Guides in HTML

The Documentation team just published the Calc Guide and Writer Guide as on-line pages in the Bookshelf at https://books.libreoffice.org

Presented as web pages, the guides contents can now be accessed with your favorite browser and use the browser resources to navigate, bookmark and reference pages.

Together with the PDF versions, the guides web pages can be downloaded and installed in local networks using a simple web server.

Happy reading!

Community Member Monday: Kira Tubo

Kira Tubo

Tell us a bit about yourself!

I live in San Jose, California, USA. I’ve lived around the Bay Area my whole life, after my parents moved away from the Philippines when I was about a year old.

I have had experience as a CRM (customer relations management) administrator, which partially functioned sort of like an internal tech support position, and I’ve also done crowdsourced testing and a11y (accessibility) testing as a side hustle. So I’ve had a lot of experience with troubleshooting and manually testing software.

My hobbies/interests are: reading, walking, video games/board games, and my dog.

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

Right now, I am attempting to write C++ unit tests in LibreOffice. As someone with rudimentary coding skills, it is quite challenging but interesting to learn.

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

For the longest time, I’ve been wanting to contribute my technical skills to an open source project and learn about test automation. I saw some forums that suggested LibreOffice, and I thought it may be a good fit because I have also used the product (albeit lightly) in the past. What I like about the LibreOffice project is that there is a dedicated wiki for those interested in QA (not just development). Because of this, it is fairly easy to get started with contributing.

Since I’ve joined the project, I’ve helped the QA team with bug triaging, regression testing, bibisecting, etc. I’ve also submitted patches to Gerrit for some easy code fixes and updated the LibreOffice help documentation. I’ve learned so much and picked up a lot of new skills along the way. But there is definitely a lot more to learn, which is exciting!

I’d also like to say that the people working on the LibreOffice project are fantastic. They acknowledge the work that you do and are more than happy to help you when needed (shoutout to Ilmari Lauhakangas for taking the time to explain how things work to me). So for anyone feeling overwhelmed or hesitant about joining, don’t be! We are all friendly here 🙂

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

One of these days, I’d like to look into writing UI unit tests with Python, and maybe also unit tests for a11y (accessibility). As for improvements, I think perhaps it would be great if the wiki would be a little more beginner-friendly for those who want to get into writing unit tests, especially if they don’t have much development experience yet.

Many thanks to Kira for all her contributions! Every LibreOffice user is welcome to get involved, find out what they can do in our community, and learn new skills along the way 👍

Insights from the InstallFest 2024 conference in Prague

InstallFest 2024

Our Czech community reports back from a recent event…

For the third time, the LibreOffice project had its own booth at InstallFest 2024, and here we present our experiences from the event.

On the weekend of 16th and 17th March 2024, the InstallFest 2024 conference took place at the Faculty of Electrical Engineering of the Czech Technical University in Prague. The conference was held after a two‑year break and under the direction of a new team led by Jan Langmaier. This year, according to the organisers’ estimates, about 300 visitors attended, making InstallFest a successful follow‑up to previous editions. Unfortunately, higher participation is limited by the space capacity of the chosen venue.

The lack of space also affected the LibreOffice booth, which had to be a bit aside from the main event. On the other hand, anyone heading to one of the main lecture halls could not miss us – our exclusive position made us unmissable. Even so, there were far fewer visitors at our booth than in previous years.

Feedback gained at InstallFest

Conferences of this type appeal mainly to the younger generation, who must not be absent. It is therefore not surprising that young people from primary or secondary school are well represented among the visitors at the LibreOffice stand. This year, however, this was significantly more disproportionate than at other times – it can even be said that young people dominated. We always interviewed them, asking what they use LibreOffice for, how long they have been using it, whether it is used at school, where they go, and whether their classmates know about the suite.

The answers were generally similar. LibreOffice tends to be used by young people for basic tasks such as writing texts, creating presentations for school and so on. Those who create presentations in Impress for school assignments have to convert their presentations to PPTX format. Surprisingly, we’ve had good feedback on compatibility with this format, although it is of course problematic.

InstallFest 2024

Very few visitors know about the cloud or mobile versions of LibreOffice, but there are some. We were surprised that one high school student reported using the cloud‑based, non‑paid version of OnlyOffice; after learning about the circumstances (ie that this software is in Russian hands and thus subject to EU sanctions), he understood why the institute he was working with (apparently a non‑profit of some sort) did not want to purchase the paid version of OnlyOffice. It simply cannot.

Many visitors would welcome some changes in LibreOffice’s user interface. While some prefer the traditional toolbar layout, others prefer a Microsoft Office‑like look and feel – either for personal taste or for ease of transition from Microsoft Office. LibreOffice allows you to use different interfaces, but this option is hidden in the menus. Visitors would appreciate if, when LibreOffice is first launched, a wizard were displayed to guide the newcomer through the various setup and customisation options, including user interface selection.

We received a request from one tutor to allow multiplication of a combinational number by a combinational number in LibreOffice Calc, and also to simplify the notation of simple arithmetic operations such as multiplication and division. Currently this has to be done using verbally defined functions, so he would welcome the ability to use simple symbols typed from the keyboard.

InstallFest 2024

Although it would seem that office software cannot attract the attention of youngsters, one ninth-grader stayed with us for perhaps an hour. Obviously he was the record holder.

Zdenek Crhonek has a huge part in translating the LibreOffice manuals into Czech. These manuals are translated by a whole bunch of volunteers, and we displayed their covers here.
Traditionally, Collabora Online, the cloud version of LibreOffice, which is now very stable and usable and with a really extensive arsenal of features, attracted a lot of interest.

There were many interesting meetings of people who often only know each other from the virtual world; that’s what these conferences are for. A regular visitor to our booth is Ladislav Sieger, PhD., from the Faculty of Electrical Engineering CTU. He always has a problem to solve, an observation, or a comment.

After party

A very interesting opportunity (and meeting) was a visit to the basement of Strahov’s dormitories, where the SH Bastlíři (translated “DYI makers”) created their own facilities, a workshop that is available to (almost) everyone. Here you can come across a server rack on the ceiling of the toilet, a circular machine, a 3D printer and other interesting things. The visit to these premises was followed by a dinner at a nearby restaurant, where the participants from among the organizers (including speakers, technical staff, exhibitors) were taken by a chartered bus (!).

InstallFest 2024

Conclusion

The new organising team has done its task well. If there were problems, we are not aware of them; that is, they were of a completely minor nature. For us, the biggest problem was with the location of the stand; perhaps this played a role in the rather low attendance of interested people. Although we probably had the most space of all in the end and did not have to make any space constraints, we may not have reached as many visitors as we could have.

However, the other perspective should also be taken into account. Although LibreOffice plays a primary role in the world of open‑source software, it is considered a utility that does not attract as much visitor interest. Therefore, we have tentatively agreed with the organisers to change that next time on our side, and they have promised to help us.

Anyway, those who visited our booth hopefully took something away with them (besides stickers and leaflets), especially thanks to Zdeněk, who maintains a lively communication with LibreOffice’s front‑line staff and has information literally first‑hand. He can thus provide far more insider insight than one Czech community member alone on the stand could in previous years.

All of the talks were filmed and the recordings are available on YouTube.

Community Member Monday: Adam Seskunas

Adam Seskunas

Tell us a bit about yourself!

My name is Adam Seskunas and I currently live in San Diego, California. In my free time I enjoy outdoor activities, hiking, backpacking in the Sierra, rock climbing and surfing with my daughter Sofia. I have a degree in Computer Science from the University of Maryland Global Campus, and I’m an open source software enthusiast.

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

Currently I’m working on my first “Difficulty Interesting” Easy Hack, a nice description of which can be found on this page.

The Easy Hack involves the ASCII filter for LibreOffice Writer and the way it handles the output of tables. True to its name, the Easy Hack has been interesting! It’s been challenging and rewarding at the same time. I’d like to thank Hossein Nourikhah for providing the code pointers and background information, and Michael Weghorn for help in code review.

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

I’ve been using LibreOffice ever since I became interested in using Linux, when I was studying for my Computer Science degree, but I never had considered contributing. It’s such a large project, and I had no experience with C++. I just happened to see an advert on VolunteerMatch for bug testing, and answering the ad got me in contact with Ilmari Lauhakangas.

Ilmari would meet with me bi-weekly and he taught me how to verify bugs in Bugzilla and eventually got me into developing. Overall, joining the project been a fantastic experience, from Ilmari’s mentorship to all the people involved – everyone’s been great. I’d highly recommend it to anyone.

Anything else you plan to do in the future?

My plan is to apply and hopefully get accepted to do Google Summer of Code for LibreOffice. I’ve been talking to Hossein about ideas and I’m excited to get my application written and submitted.

What does LibreOffice really need now?

I’d say more contributors. There’s a robust community of contributors, but any project could use more. It’s a great way to meet people and gain some experience. I’d encourage anyone reading this and thinking about contributing to check out the wiki. There’s great information there and you can help in many different ways, not just development.

Many thanks to Adam for all his contributions! Every LibreOffice user is welcome to get involved and find out what they can do in our community 👍

LibreOffice project and community recap: March 2024

Nepali LibreOffice community meeting

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

TDF Board of Directors, 2024 - 2026

LibreOffice community at FOSDEM 2024

LibreOffice 24.2 cake

LibreOffice 24.2 Writer and Calc Guides

  • Also in docs news: in the middle of the month, we talked to Dione Maddern about her experiences joining the LibreOffice project. Thanks to Dione for all her contributions!

Dione Maddern

Czech LibreOffice Writer Guide 24.2

  • Later in the month, we celebrated Document Freedom Day, which raises awareness of how open standards and open document formats provide us with the freedom to read and write as we wish.

Document Freedom Day banner

  • March saw two updates to LibreOffice: 24.2.2 and 7.6.6. All users of these branches are recommended to get the latest versions.

LibreOffice donate banner

Globe

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