Index of Training Videos about LibreOffice

In order to make it easier for users to find training videos about LibreOffice, we have created a comprehensive index updated to the end of April 2022 using the open source Zotero bibliography and reference management software.

The index is published on this blog in the Media Hub section (clicking on the Media Hub menu, you will open a drop down menu with Press Releases and Index of Videos).

At the moment, indexed videos are only in English (although there are also videos in other languages, which have still to be indexed), and have been grouped by topic: LibreOffice, LibreOffice Writer, LibreOffice Calc, LibreOffice Impress, LibreOffice Draw, LibreOffice Base, LibreOffice Math, LibreOffice Interviews and LibreOffice Talks.

The next task is to create an index of documents relevant for The Document Foundation and LibreOffice, covering topics such as open source software, open standards, change management, sustainability, interoperability, digital citizenship, migrations, openness, digital sovereignty and document formats, to mention only the most important. The objective is to provide educational materials to all LibreOffice stakeholders, as a background for training and presentations, or as a simple but comprehensive source of information.

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!