LibreOffice is in the Google Summer of Code 2023!

GSoC logo

Everyone loves having shiny new features in LibreOffice. But how do we get them? Many are developed by volunteers and people in the ecosystem.

But another great source of new features is the Google Summer of Code (GSoC), a global, online program focused on bringing new contributors into open source software development. GSoC Contributors work with open source organisations on a 12+ week programming project under the guidance of mentors.

And we’re happy to announce that for 2023’s GSoC, LibreOffice is once again taking part!

Find out more here

LibreOffice and Google Summer of Code 2022: The results

Google Summer of Code logo

This year, LibreOffice was once again a mentoring organization in the Google Summer of Code (GSoC), a global program focused on bringing more student developers into free and open source software development. Two projects were finished successfully. Students and mentors enjoyed the time, and here we present some of the achievements, which should make their way into LibreOffice 7.5 in early February 2023!

You can experiment with the new features by using daily builds and report any problems in our bug tracker.


VBA Macros – Tests and missing APIs by Hannah Meeks

Mentors: Tomaž Vajngerl (Collabora), Thorsten Behrens (allotropia)

Hannah worked on an area that is important for power users dealing with Microsoft documents. Her work both improves VBA compatibility in LibreOffice and makes it easier to add missing functionality in the future.

Learn more about the VBA Macros improvements in the final report.


Extend Z compressed graphic format support by Paris Oplopoios

Mentors: Tomaž Vajngerl (Collabora)

Paris got off to a flying start with the originally defined goal, which was to add import functionality for Z compressed EMF and WMF graphics and thus to improve compatibility with Microsoft documents. In the end, he also implemented exporting of WMZ, EMZ and SVGZ graphics, replaced homegrown PNG export code with one that uses libpng and added automated tests for PNG export in addition to tests for the Z compressed formats.

Learn more about the graphics improvements in the final report.

Wrapping up

Many thanks to all contributors who spent their summer time improving LibreOffice. You are awesome! And special thanks also to the mentors who always put so much love and energy into these tasks. That’s what makes LibreOffice rock.

Now we are looking forward to next year’s GSoC. If you are interested, why not prepare early? Learn more at out wiki page where some ideas are listed.

Participating in GSoC is a great way to build your skills, and show future employers what you’re capable of!

Lox365 extension: XLOOKUP (and more) for LibreOffice Calc

More news from the LibreOffice subreddit! User goose_pirate posted about an extension:

Hi everyone, I made this little extension for LibreOffice Calc which adds a few functions, currently FILTER, SORT, and XLOOKUP. I hope others will find this as useful as I do.

XLOOKUP is a function for finding things in a table by range or row. We asked goose_pirate for a bit of background on the extension:

I’ve been using both Excel and LibreOffice for many years and found the new(er) Excel functions like XLOOKUP to be really nice compared to the old VLOOKUP or INDEX MATCH. I wanted to use it in LibreOffice too, so I wrote this extension.

How I made it: I researched information about LibreOffice extensions, dissected a few such extensions made by others, and finally started my own. It wasn’t too bad, I was surprised no one has made something similar yet.

Great work, goose! 😊

Learn more and download here (in the “build” folder)

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

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.

This feature is important in eLearning: in contrast to video recordings, audio recordings are stored per slide, and can be adjusted to match the individual pace of the presentation. This is particularly suitable in school, academic as well as corporate environments to make learning content and product presentations more interactive.

So, how can we get this feature in LibreOffice? Well, the CH Open association, which has been promoting open systems and standards in the Swiss ICT landscape for over 40 years, is organising a crowdfunding campaign to implement the feature. The project is estimated to cost €62,000 in total – with various milestones along the way.

Click here to learn more and participate!

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.

LibreOffice ecosystem interview: Michael Meeks at Collabora Productivity

Following our interviews with Caolán McNamara at Red Hat and Thorsten Behrens at allotropia, today we’re talking to Michael Meeks from Collabora Productivity:

Tell us a bit about yourself!

I’m Michael Meeks, a Christian, husband and enthusiastic open source developer. I run Collabora’s Office division with the assistance of an amazing team – leading our Collabora Online and Office products, and supporting customers and partners. I’ve served as a Director of the The Document Foundation from its founding until recently, and have contributed to both the OpenDocument Format and OOXML standardization.

I’d started some decades ago working on the Linux desktop in the GNOME project around the Gnumeric spreadsheet, first as a volunteer, then for Ximian – which was involved in the open-sourcing of OpenOffice.org. Since then, I’ve been involved with improving the codebase, although the name of my employer has changed from Ximian, Novell, Attachmate, Micro Focus, SUSE – and finally being spun out alongside a brave and talented subset of the SUSE LibreOffice team to Collabora Productivity some nine years ago.

What does Collabora Productivity provide in the LibreOffice ecosystem?

One big piece we do is improving the awesome LibreOffice Technology core engine / APIs, and performance for Collabora Online – which provides a real alternative to Microsoft Office 365 – with collaborative editing in the browser. We spend time working hard on integrations with popular open source products like Nextcloud, ownCloud, Seafile, EGroupware, and proprietary ones such as HiDrive, Filr – as well as helping hosting providers like Strato provide LibreOffice Technology to their users en-masse.

Around Collabora Online, we have a mission to allow you to control your documents. That means full control from open source software, open standard file formats, through to on-premise hosting, and full network control. It is encouraging to see the growing consensus these days between e.g. The European Pirate Party (enthusiastic Collabora Online users) talking positively about the importance of Digital Sovereignty, and at another pole – for instance, the head of the UK’s MI6 warning on the BBC:

“The data-trap is this: that if you allow another country to gain access to really critical data about your society, over time that will erode your sovereignty.”

For Collabora’s customers, we also take a new LibreOffice version each year and freeze this as our Long-Term Support (LTS) base; we create many hundreds of fixes and feature patches which we contribute up-stream, as well as back-porting the latest fixes to our enterprise branch: much as is done for an enterprise Linux distribution. We sell that toegher with services and support as Collabora Office. We also maintain a tool (Collabora OLE Automation Tool) to ease migration of vertical applications that use Visual Basic / OLE2 integration that makes LibreOffice behave like Microsoft Office via COM. In addition, we maintain Collabora Office and LibreOffice Windows Group Policy Templates – these make it easy to manage lots of LibreOffice machines via Group Policy.

Another strand of work is re-packaging Collabora Online / LibreOffice Technology as responsive mobile apps for Android and iOS, as well as Chrome OS. By delivering LibreOffice-based document editing to everyone’s browsers, PCs and mobile devices, we give people a real alternative that lets them choose their own document formats, security profile and threat model – real digital sovereignty.

What has Collabora been working on in LibreOffice 7.3?

We’ve been working on lots of things: some of the team have done a lot for interoperability, e.g. Miklos improving writer’s paragraph styling, or Dennis making charts more compatible, or Sarper re-working our PowerPoint header/footer interoperability. There is a constant stream of improvements based on customer feedback here.

Another big set of improvements in LibreOffice 7.3 are from Lubos and Noel around the performance of file opening, rendering, editing of documents as well as improving calculation threading. One particularly important piece here was the work done to very significantly improve performance of lots of editors in a single file – which has been back-ported to make Collabora Online very much faster in our latest releases.

We are looking forward to upgrading to LibreOffice 7.3 in the next months, and not having to carry these back-ports forward.

What new features are you particularly happy with?

I’ve been really pleased with the work we’ve done alongside AMD around Skia rendering – in LibreOffice 7.3 we make that the default for macOS (users, please report any problems), which for the first time allows us to share a single, modern rendering API between macOS, Linux and Windows for rendering – which is a huge step in the right direction.

What’s more: adding WebP support for images – interestingly, Firefox now requires this as a copy/paste format for images, and it’s long overdue to have this high quality format from Google supported.

Looking beyond this release, what else are you planning to do?

We work continuously on LibreOffice, all around the code from ongoing clean-ups, performance work, unit-tests (particularly important to avoid customer tickets regressing) and so on. We have a few things that are in the works currently.

Another thing that Tomaz, Sarper and Miklos will debut in LibreOffice 7.4 is the start of colour theme support for shapes, to allow us to re-style documents more deeply by changing the theme and palette. This should also help with interoperability and templating.

We’ve also added Sparkline support, providing a very pretty and useful way to quickly visualize data for LibreOffice 7.4.

You can read about the history of these from Edward Tufte.

Lubos has been working hard on jumbo sheets – allowing much larger number of columns in sheets (and more rows too) which should make interoperability much smoother for people with large spreadsheets.

And of course lots more – we’re expecting LibreOffice 7.4 to be packed with new and enhanced feature / function from the whole community – and Collabora.

Find out more