LibreOffice installer improvements coming, thanks to Ximena Alcaman, Rachael Odetayo and Outreachy

Ximena Alcaman

Today we’re talking to Ximena Alcaman, who is working on LibreOffice installer improvements as part of the Outreachy programme. Outreachy provides internships to people subject to systemic bias and impacted by underrepresentation in the technical industry where they are living.

Ximena is working alongside Rachael Odetayo on the LibreOffice installer, and is being mentored by Marina Latini and Jussi Pakkanen, with support from sponsors SUSE and The Document Foundation. Let’s learn more…

To start with, tell us a bit about yourself!

Hi! My name is Ximena but most people call me Xime and I’m from Chile. I have a degree in Business Administration, but I recently switched to the tech world to become a software developer. In my free time, I enjoy coding and trying out new technologies. I also like to learn new languages and travel to new places. When I’m not doing all that, you can probably find me in the garden or in the kitchen baking something (hopefully) delicious!

How did you get involved in Outreachy?

I came across a post about the Outreachy internships and it immediately caught my attention. At first, I wasn’t very familiar with open-source, but after doing some research, I soon realized that it was the perfect opportunity for me to gain experience and build my tech career through this internship. On top of that, the chance to be a part of a fantastic community like LibreOffice and to contribute to a product used by millions is truly exciting.

What are you working on in LibreOffice right now?

The Windows installer is a crucial component of the LibreOffice project, as it’s the primary way in which millions of users can install and use the office suite on their computers.

However, the current installer for LibreOffice is based on old code, which makes it difficult to maintain.

Our project aims to address this issue by upgrading to a more modern installer, which will make maintenance a lot easier. We’re using tools like the WiX Toolset and MSI Creator to rework the LibreOffice Windows installer. Our goal is to move away from an outdated infrastructure and upgrade to a more modern one.

Mockup installer screenshot

How can others help out with the things you’re working on?

We’re in the early stages of this project and we could definitely use help from the community. For example, we’re currently trying to localize the right pipeline for the installer and gather the necessary information to build a proper JSON file. However, gathering all the necessary information within the large LibreOffice codebase can be quite difficult. So, if community members can help us to locate the necessary files, it would be greatly appreciated! We would also welcome any testing or bug reports as we continue working on the project.

After this experience, what is your opinion of Equity, Diversity and Inclusion? Did the Outreachy program give you a new perspective or is there anything you would like to highlight?

After this, my belief in the importance of equity, diversity and inclusion has only been reinforced. The Outreachy program has been an incredible experience as it has provided me with the opportunity to work alongside people from different backgrounds and experiences. Outreachy allowed me to learn and grow in a welcoming and supportive environment, which I think is something crucial for underrepresented groups in the tech industry. I believe that having a diverse and inclusive environment is essential for innovation and creativity, and also for creating a more equitable society.

Outreachy logo

Did your opinion of open source change after this experience? How?

Before this experience, I had limited knowledge and understanding of open source, so I had the idea that it was only for advanced students from tech careers or experienced developers. However, my participation in the program has changed my perspective. Outreachy offers opportunities for people of all skill levels and backgrounds, so this made me feel more welcome and included as a newcomer in open source communities.

Is there any contribution, experience, anecdote you would like to share from your time in the Outreachy programme? Would you recommend the program?

When the contribution period started, I had doubts about my programming skills and almost waited for the next cohort to apply again. It took me about two weeks to finally contact my current mentors and I also contacted Ilmari, who kindly provided guidance and support throughout that period. I highly recommend the Outreachy programme for anyone interested in open source, as it provides valuable opportunities to get involved in open source communities and gain experience.

Follow Ximena on WordPress and Twitter. And stay tuned for our next interview, with Rachael Odetayo!

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.