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.

Annual Report: TDF’s infrastructure in 2021

In 2021, the infrastructure team migrated our “Ask LibreOffice” site to Discourse, deployed a Decidim instance, and assisted with video streaming during the LibreOffice Conference.

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

LibreOffice’s infrastructure team is responsible for maintaining the hardware, virtual machines and services that enable the wider community to develop, market, test, localize and improve the software. The public infrastructure is powered by around 50 kernel-based virtual machines (KVMs) spread across four hypervisors, plugged to an internal 10Gbps switch, hosted at Manitu in St. Wendel (Germany), and managed with libvirt and its KVM/QEMU driver. The virtual disk images are typically stored in GlusterFS volumes – distributed across the hypervisors – except for some transient disks (such as cache) where the IOPS requirement is higher and the redundancy less important.

As 2021 marked another “pandemic year” with only online events, the infrastructure team helped to make these a pleasant experience from home. Notably, they deployed a Pretalx instance to manage conference submissions and the schedule, and put in place a streaming backend based on Jitsi/Jibri/RTMP during the annual conference, thereby providing several participation options to chose from.

Ask LibreOffice

After several months of tests and feedback from the community, the infra team also concluded the migration of LibreOffice’s Q&A platform (“Ask LibreOffice”) to Discourse. Over 65,000 questions and 130,000 replies from 50,000 users — spanning over 17 languages — were imported, with a focus on preserving post attribution and overall layout. The metric collection engines (Matomo as well as the public Grimoire Dashboard) were updated to reflect that change.

Also on the community participation front, the infrastructure team deployed a Decidim instance to structure debate and encourage democratic participation from community members. The instance is currently still under test.

On the Continuous Integration (CI) front, the team deployed new buildbots for Windows and Linux baselines, as well as a buildbot for the WebAssembly (WASM) effort. They also migrated and refactored the bibisect setup to better suit the needs of the quality assurance community.

Backends

As for the backends: Debian GNU/Linux 11 (codename “Bullseye”) was released in the middle of 2021, and the team upgraded most of TDF’s virtual machines accordingly during the second half of the year. However, for the lower layers of the virtualization stack, the upgrade is planned for 2022. Furthermore, lots of work was done in planning the restructuring of database engines, most notably around Point-in-Time Recovery; this work was driven by contributor Brett Cornwall. Finally, the team assisted the Membership Committee with the architecture of the back-end side of their new tooling.

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!

Build up your skills, and learn exciting new things!

LibreOffice is made by a worldwide community of volunteers, certified developers and many other people. Every summer, we participate in the Google Summer of Code programme: this is focused on introducing contributors to open source software development, and last year LibreOffice received a bunch of new features and improvements thanks to the work of several contributors.

We’re super happy to announce that LibreOffice, once again, is part of this year’s Summer of Code (GSoC). If you’re a contributor, want to improve your programming skills and receive a financial stipend to implement new features in LibreOffice, get involved! You can get in contact with us, show us that you’ve learnt the basics by working on an Easy Hack from the category “difficultyInteresting”, and then propose your project(s). We’re looking forward to hearing from you and seeing your work!

Click here to get started

Custom Shape Tutorial

Have you ever tried to draw special and complex shapes beyond the basic offerings of LibreOffice? A custom shape of the Fibonacci spiral defined by its equation and properties with handles to reshape size? Thanks to Regina Henschel, now you have a tutorial for drawing custom shapes of your own and use them in LibreOffice.

Currently, LibreOffice provides a lot of predefined custom shapes. They are grouped to the sets ‘Basic Shapes’, ‘Block Arrows’, ‘Symbol Shapes’, ‘Stars and Banners’, ‘Callouts’, and ‘Flowchart’. And all shapes from the ‘Fontwork Gallery’ are custom shapes too. But you can do more, much more.

Custom Shapes Tutorial

(more…)

Videos from FOSDEM ’22 – LibreOffice Technology devroom – now available

FOSDEM is a non-commercial, volunteer-organized European event centered on free and open-source software development – and one of the biggest such events of its kind. This year, it took place online again, due to the pandemic.

Many LibreOffice community volunteers and certified developers gave talks at the conference, and now the videos are available for all to see! So if you want to learn more about LibreOffice technology, open standards and community activities, click the link below and enjoy.

Explore the talks and watch the videos