Projects selected for LibreOffice in the Google Summer of Code 2022

The LibreOffice Google Summer of Code projects have been selected for 2022.

  • Hannah Meeks – VBA Macros – Tests and missing APIs : We support VBA (Visual Basic for Applications) Macros in LibreOffice, but the implemented API isn’t complete and the API functions aren’t largely tested. The consequence of this is that the VBA macros in OOXML documents don’t run as intended in LibreOffice, which causes compatibility problems. The goal of this project is to add tests for the functions already implemented and then look for what functions are missing for a method or module and add them.
  • Paris Oplopoios – Extend Z compressed graphic format support: Some graphic formats are compressed with ZIP (deflate) to make them smaller, while the formats themselves don’t support compression. In LibreOffice we already support SVGZ format, but not other formats. The goal of this idea is to look at how SVGZ is implemented and extend that to other formats (EMF, WMF). The extended goal is to implement support for compressing in addition to extracting.

Good luck to the contributors – we appreciate their work on these important features and improvements! And thanks to our mentors for assisting them: Tomaž Vajngerl and Miklos Vajna (Collabora); Thorsten Behrens (allotropia).

From September 5 – September 12, contributors will submit their code, project summaries, and final evaluations of their mentors. Find out more about the timeline here, and check out more details about the projects on this page.

Last week of the Month of LibreOffice, May 2022!

So far, 233 sticker packs have been awarded in the Month of LibreOffice, May 2022. But there’s still one more week to go – so if your name (or username) isn’t on the list, join in, help to make LibreOffice even better, and get some cool swag! We’ll have 10 bonus pieces of merchandise to give away, to 10 lucky people…

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.3.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.

Join in, learn new things, and have fun! We’ll post the final results in early June…

Draw Guide 7.3

Peter Schofield and Kees Kriek are happy to announce the Draw Guide 7.3  with the latest LibreOffice Draw 7.3 developments.

Download Draw Guide 7.3

This 348 pages book covers the main features of Draw, the vector graphics component of LibreOffice. Using Draw, a wide variety of graphical images can be created.

Vector graphics store and display a picture as simple geometric elements such as lines, circles, and polygons rather than as a collection of pixels (points on the screen). This permits simpler storage and supports precise scaling of the picture elements.

Draw is fully integrated into LibreOffice. This simplifies exchanging graphics with Writer, Calc, and Impress. Images can be exported in many formats for use in other programs.

Thank you guys for the wonderful Draw Guide!

Kees Kriek
Peter Schofield
Peter Schofield

The full set of published LibreOffice guides is available in the LibreOffice Documentation Website and in the LibreOffice Bookshelf Project.

Join the Documentation Team

May 2022, Month of LibreOffice Awards

In May 2022, LibreOffice has received two Awards: SourceForge’s Open Source Project of the Month, and Software Informer’s Editor’s Pick.

This is a partial screenshot of the current SourceForge home page: https://sourceforge.net/ and this is SourceForge’s LibreOffice download page: https://sourceforge.net/projects/libreoffice/

This is Software Informer’s home page: https://software.informer.com/ and this is Software Informer’s LibreOffice download page: https://libreoffice.informer.com/

LibreOffice at the Univention Summit 2022

After two years of pandemic restrictions, more and more in-person events are now taking place. Members of the LibreOffice community attended the recent Univention Summit 2022 in Bremen, northern Germany. They had a stand with LibreOffice merchandise, talked to visitors and answered questions.

Thorsten Behrens, Chairperson of The Document Foundation’s (TDF) Board of Directors, said: “The event was super, and it was great to talk to people in-person again.”

Lothar Becker, who served on the Board from 2020 to 2022, added:

The representation of TDF and the LibreOffice project at the event, along with partners, was very well received – and perceived as important in terms of digital sovereignty, both for users and other projects and providers. Intensive discussions for the first time – also in person again – especially regarding integration topics, and the role of TDF, were very encouraging and motivating for all after the long period of the pandemic. The evening then offered the opportunity to continue these discussions in a more informal atmosphere.

Let’s wrap up with a couple more pictures from the event. We plan to attend many more this year – keep an eye on this blog for updates!

Annual Report 2021: Attracting new contributors to LibreOffice

Bringing new community members on board, and helping them to get started in the LibreOffice community, is an essential part of our work. Here’s what we did in 2021…

(This is part of The Document Foundation’s Annual Report for 2021 – we’ll post the full version here soon.)

Onboarding tools and sites

Joining a large and established project like LibreOffice can be daunting for many. The software has a large codebase, and sub-projects use a wide array of tools. In recent years, we’ve made efforts to simplify the onboarding process by linking more services together with SSO (single sign-on), thereby reducing some of the complexity. In addition, we’ve created Easy Hacks and similar “bite size” projects in other areas, so that newcomers can get involved quickly and achieve something without months of work.

Currently, we have two websites/pages that function as starting points for new contributors: What Can I Do For LibreOffice and the Get Involved page. The former was set up by LibreOffice’s Albanian community, and lets users click through topics of interest, until they find something they want to do. The latter is a regular page, with a list of sub-projects inside LibreOffice, and quick steps to make initial contact.

Throughout 2021, we posted regular “Community Member Monday” interviews on this blog. In many cases, we emphasised how these contributors started off as regular LibreOffice users, but wanted to “scratch an itch” and start to make changes to the software. We highlighted the ways in which other community members helped newcomers to start working on projects, and used these as “success stories” on our social media accounts, encouraging others to make the step-up from being a user to an active contributor.

In addition, we have accounts and projects listed on various volunteering platforms, including VolunteerMatch and Idealist (English), Vostel (German), Vapaaehtoistyo (Finnish), TuDu (Polish) and HeroClan, Um sem um tam and Zapojim se (Czech).

LibreOffice New Generation

In early 2021, we announced LibreOffice New Generation, a project to bring new – and especially younger – people into the LibreOffice community. While The Document Foundation is proud that our community is diverse and has people from all ages, younger people help to bring fresh ideas and approaches to the project. So we wanted to make it easier for everyone to join, get involved and have fun – regardless of age.

To achieve this, we set up the New Generation project with communication channels, contact points in the community, and initial ideas for things to work on. The community grew quickly, with 300 members arriving in the Telegram group within the space of a few weeks, and many ideas being proposed. One was to create a distinctive flyer that can be distributed in schools and universities, which not only explains what LibreOffice does, but how all users can also get involved and help to improve the software. New Generation community members created an initial design for the flyer, along with an update, and then translated it into several languages. TDF used funds from its marketing budget to get flyers printed and distributed to people around the globe.

Open Badges

We also continued to issue Open Badges, special, custom images with embedded metadata, confirming contributions from people in the community. For instance, we sent our personalised badges to French translators of the Math Guide, along with Brazilian Portuguese documentation team members and Czech documentation contributors.

Like what we do? Support the LibreOffice project and The Document Foundation – get involved and help our volunteers, or consider making a donation. Thank you!