Susanne Mohn asked on the German-language user’s mailing list how to create a colour wheel with LibreOffice. It was not about the colours themselves, but about the geometry. How do you create a circle or ring with equally sized sectors?
Very different solutions were proposed. Susanne Mohn, Harald Berger and I (Regina Henschel) have created a page in the LibreOffice Wiki so that these do not remain hidden in a thread. Due to the development process, some sample files are in German, but the page itself is in English.
Colour wheels can be used to create “doughnut charts” of data. Have fun exploring!
The Document Foundation and LibreOffice support the international campaign @endof10 https://endof10.org/
The countdown has begun. On 14 October 2025, Microsoft will end support for Windows 10. This will leave millions of users and organisations with a difficult choice: should they upgrade to Windows 11, or completely rethink their work environment?
The good news? You don’t have to follow Microsoft’s upgrade path. There is a better option that puts control back in the hands of users, institutions, and public bodies: Linux and LibreOffice. Together, these two programmes offer a powerful, privacy-friendly and future-proof alternative to the Windows + Microsoft 365 ecosystem.
The real costs of switching to Windows 11
The move to Windows 11 isn’t just about security updates. It increases dependence on Microsoft through aggressive cloud integration, forcing users to adopt Microsoft accounts and services. It also leads to higher costs due to subscription and licensing models, and reduces control over how your computer works and how your data is managed. Furthermore, new hardware requirements will render millions of perfectly good PCs obsolete.
This is a turning point. It is not just a milestone in a product’s life cycle. It is a crossroads.
The new path: Linux + LibreOffice
These two programmes form the backbone of a free and open computing environment based on open standards. For individual users, public administrations, schools and businesses, this combination offers more than enough: it is mature and secure, and is already in use worldwide for mission-critical workloads. Furthermore, using open standards protects users against any attempts by software developers to control them.
Here’s what this alternative offers:
A modern, stable and unrestricted operating system, accessible to all users thanks to intuitive distributions that allow each user to choose the configuration that best suits their needs. It also offers regular updates, long-term support versions and communities where people can help each other and develop their digital knowledge together.
Unlike Windows 11, Linux works with all personal computers that ran Windows 10, meaning there is no need to replace your old PC. Those with even older computers can also find a suitable version of Linux, extending their useful life and reducing electronic waste.
LibreOffice is a complete office suite offering word processing, spreadsheets, presentations, drawing and database tools. It respects freedom and data because it is based on an open, standard document format (ODF), and is compatible with Microsoft’s proprietary formats (DOCX, XLSX and PPTX). This gives users control, as Microsoft cannot decide to end support at any time, as it is doing with Windows 10.
LibreOffice is supported by a global community of volunteers, consultants, and companies who provide free and paid professional support, ensuring the ongoing development of the software and the prompt resolution of security and operational issues. There are no licence fees, telemetry or vendor lock-in.
Both Linux and LibreOffice are based on transparency. This means that all documents saved in the standard format will always be available because the format is open, and all documentation is available online. They also do not require a user licence subscription that protects the software vendor more than the user, and which contains incomprehensible legal clauses.
Both the operating system and the software are managed by foundations, not companies. All activities, including development, quality assurance, problem-solving and the release of new versions, take place in public because users have the right to control the quality of the digital tools they use and entrust with their content.
What does migration look like?
Replacing Windows and Microsoft Office is not as difficult as it seems, either at an individual or corporate level. Many organisations around the world have already done so, and many others are planning to do so right now, precisely because they no longer want to be subject to the commercial strategies of Microsoft and its partners.
These are the key steps:
Start by testing Linux and LibreOffice on a second partition of your PC (for individuals) or in less critical departments (for companies).
Check the compatibility of your software configuration with Linux and LibreOffice; most office tasks can easily be transferred or adapted with minimal effort.
Build documentation to learn how Linux and LibreOffice work and organise training if necessary.
Find a consultant who can help with the migration process, such as someone certified by the Linux Professional Institute or The Document Foundation (for LibreOffice).
This is not a radical change, but rather a gradual, tailor-made transition depending on user needs.
It is important to start immediately
Microsoft is forcing users’ hands, but it is also opening a door. Now is the time to challenge your assumptions and take back control of how your personal computers work, how long they last, and most importantly, how your content is managed.
Linux and LibreOffice are not just alternatives; they are superior choices that most users have not considered until now because they trusted Microsoft — perhaps too much. This trust has been betrayed by the decision to abandon a functioning operating system such as Windows 10, purely to sell more products and lock users in further, which cannot be justified by any technological assessment.
The end of Windows 10 does not mark the end of choice, but the beginning of a new era. If you are tired of mandatory updates, invasive changes, and being bound by the commercial choices of a single supplier, it is time for a change. Linux and LibreOffice are ready — 2025 is the right year to choose digital freedom!
The Document Foundation and LibreOffice support the international campaign @endof10 https://endof10.org/
LibreOffice stands out as a privacy-respecting open source office suite. Unlike proprietary alternatives, the software is designed with privacy, user control and transparency in mind.
(This is part of The Document Foundation’s Annual Report for 2024 – we’ll post the full version here soon.)
Introduction
Concerns about end user privacy in the digital world have grown significantly over the past two decades, with increasing awareness of data collection, user tracking and online surveillance. Many proprietary applications, including office productivity tools, often collect vast amounts of user data, in most cases without clear user consent.
All this has been clearly documented by Shoshanna Zuboff in her book: The Age of Surveillance Capitalism, which is defined as a new economic strategy that uses the activities and experience of the individual as a free raw material for hidden commercial practices of extraction, prediction, profiling and selling.
In this context, open source software differs substantially because respect for the user and for privacy are part of the ethical principles that guide the development of all applications. And LibreOffice stands out as the only office suite – open source or not – that respects privacy. Unlike proprietary alternatives, LibreOffice is designed with privacy, transparency, and user control of content in mind. The software does not collect telemetry data by default, does not include intrusive tracking functions, and allows users to work completely offline.
The following is a list of LibreOffice features and settings which help ensure end-user privacy, making the software a preferred choice for individuals, businesses and government institutions that prioritise data security.
No data collection or telemetry by default
One of the most significant privacy benefits of LibreOffice is its lack of telemetry by default. Unlike proprietary office suites that constantly send usage data back to their developers, LibreOffice does not collect or send any personal data without the user’s consent.
There are no background processes that track document usage, keystrokes or user activity.
LibreOffice does not create a unique user ID or track document interactions like some proprietary office suites do.
There is no built-in cloud storage requirement, ensuring that files remain on the user’s device unless manually uploaded elsewhere.
Optional telemetry with user consent
LibreOffice offers an optional telemetry feature, but it is entirely opt-in and requires explicit user consent. The collected data will only be used to improve the functionality of the software and will never be shared with third parties.
Full offline functionality
Unlike cloud-based office suites such as Google Docs, Microsoft 365 or Apple iWork, LibreOffice is a fully offline suite.
No forced cloud storage: documents remain on the local computer, reducing the risk of unauthorised access.
No dependence on an Internet connection: users can work in completely isolated environments.
No third-party server involvement: documents are never stored on a corporate server unless explicitly uploaded by the user.
For security-conscious organisations such as government agencies, law firms and healthcare providers, this offline capability ensures that sensitive documents never leave the internal network.
Open Document Format (ODF) for privacy and transparency
LibreOffice uses the Open Document Format (ODF) as its default file format. Unlike proprietary formats such as Microsoft’s DOCX, XLSX and PPTX, ODF is an open standard, which means:
It does not contain hidden tracking elements or embedded metadata that can leak user information.
It guarantees the integrity of the data in the long term because the format is fully documented, and the documentation is publicly available. Furthermore, the documentation corresponds to the format currently used by the software, unlike what happens with Microsoft 365 where the documentation is stuck at 2008.
It does not contain proprietary encryption mechanisms that could be exploited for surveillance or unauthorised access.
Control over metadata
Metadata can contain sensitive information such as: author details, document history, and editing timestamps. LibreOffice allows users to remove all metadata before sharing a document to ensure that private information is not inadvertently shared with external parties.
Strong encryption and password protection
LibreOffice provides robust document encryption to prevent unauthorised access. Users can protect their documents with strong passwords and encryption settings. This prevents unauthorised users from opening or modifying the file.
In addition, LibreOffice supports GNU Privacy Guard (GPG) encryption for users who require public key cryptography to secure their documents.
No cloud lock-in: freedom to choose storage
Unlike Microsoft 365 or Google Workspace, which force all users to store documents in their respective cloud ecosystems, LibreOffice allows full control over file storage. This flexibility ensures that no third party can access user data without explicit permission.
Users can:
Store files locally on their hard drive or external storage.
Use self-hosted cloud services such as Nextcloud or ownCloud for increased privacy.
Store files on USB drives, encrypted partitions or private network servers.
Macro security and malware protection
Macros are often used in office documents for automation, but they can also be exploited to deliver malware. LibreOffice includes robust macro security settings to protect users.
By default, LibreOffice blocks macros from untrusted sources.
Users can only enable macros if they are signed with a trusted certificate.
The security level can be configured to prevents malicious actors from using macros as an attack vector.
Transparency and open source code
One of the biggest privacy benefits of LibreOffice is its open source nature. Unlike proprietary office suites that operate as black boxes, LibreOffice’s source code is publicly available and regularly audited by the security community. This level of transparency and user control makes LibreOffice a trusted alternative to closed-source office suites.
No hidden spyware: because anyone can inspect the code, LibreOffice cannot contain hidden trackers or surveillance tools.
Independent security audits: governments, cybersecurity experts and researchers can verify LibreOffice’s privacy claims.
No forced updates: users have complete control over when and how they update LibreOffice, avoiding unwanted feature changes or telemetry settings.
Conclusion
LibreOffice is the most privacy-conscious office suites available today. With no telemetry by default, full offline functionality, strong encryption, metadata control and open source transparency, it provides users with a secure and private environment for document creation and collaboration.
For individuals, businesses and governments concerned about privacy and digital sovereignty, LibreOffice is a reliable, free and ethical alternative to proprietary office suites.
As privacy concerns continue to grow in the digital age, LibreOffice remains committed to ensuring that users retain full control over their data: a core principle that sets it apart from many commercial alternatives.
With LibreOffice 24.8 close to end of life, all users are invited to update their free office suite to the latest release
Berlin, 6 June 2025 – The Document Foundation is pleased to announce the release of LibreOffice 25.2.4, the fourth maintenance release of the LibreOffice 25.2 family for Windows (Intel, AMD and ARM), MacOS (Apple Silicon and Intel) and Linux, available for download at https://www.libreoffice.org/download [1].
With LibreOffice 24.8 approaching the end of life, this release – which includes dozens of fixes and enhancements that further improve the suite’s performance, reliability and interoperability – is ready for production environments. We invite all users to update their installation as soon as possible.
LibreOffice 25.2.4 is based on the LibreOffice Technology, which enables the development of desktop, mobile and cloud versions – either from TDF or from the ecosystem – that fully support the two ISO standards for document formats: the open ODF or Open Document Format (ODT, ODS and ODP) and the closed and proprietary Microsoft OOXML (DOCX, XLSX and PPTX).
Products based on the LibreOffice Technology are available for all major desktop operating systems (Windows, macOS, Linux and ChromeOS), mobile platforms (Android and iOS) and the cloud.
For enterprise-class deployments, TDF recommends a LibreOffice Enterprise optimized version from one of the ecosystem companies, with dedicated value-added features and other benefits such as SLAs and security patch backports for three to five years.
English manuals for LibreOffice 25.2 Write, Impress, Draw and Math are available for download at https://books.libreoffice.org/en/. End users can get first-level technical support from volunteers on the user mailing lists and the Ask LibreOffice website: https://ask.libreoffice.org.
LibreOffice users, free software advocates and community members can support The Document Foundation and the LibreOffice project by making a donation: https://www.libreoffice.org/donate.
At the beginning of May, we began a new Month of LibreOffice campaign, celebrating community contributions all across the project. We do these every six months – so how many people got sticker packs this time? Check it out…
This is a huge increase over the last campaign, in November, which had 301 winners. So that’s fantastic work, everyone! Hundreds of people, all across the globe, have helped out in our projects and communities. And those are just community contributions, not including the hundreds more from our ecosystem and certified developers!
We’re hugely thankful for the work – and, of course, everyone who’s listed on the wiki page can get a sticker pack, with the stickers shown above.
…and we’ll send you a bunch of stickers for your PC, laptop and other kit. (Note: your address will only be used to post the stickers, and will be deleted immediately afterwards.) If you contributed to the project in May but you’re not on the wiki page, please let us know what you did, so that we can add you!
There is one more thing…
And we have an extra bonus: ten contributors have also been selected at random to get an extra piece of merchandise – a LibreOffice hoodie, T-shirt, rucksack or snazzy glass mug. Here are the winners (names or usernames) – we’ll get in touch personally with the details:
Takenori Yasuda
koyotak
Andrew Kopf
HiTom
bantoniof
Dominick
Jeremy Norvell
skyandrews
Johan van der Knijff
Yashodhan Sawardekar
Congratulations to all the winners, and a big thanks once again to everyone who took part – your contributions keep the LibreOffice project strong. We plan to have another Month of LibreOffice in November, but everyone is welcome to see what they can do for LibreOffice at any time!
Xisco Fauli, Ilmari Lauhakangas and Mike Saunders from The Document Foundation, the non-profit organisation behind LibreOffice, discuss Quality Assurance (QA) in free and open source software . (This video is also available on PeerTube.)
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.
If you accept this notice, your choice will be saved and the page will refresh.
Transcript
Mike Welcome to episode three of the LibreOffice and Open Source podcast. I’m Mike Saunders from the Document Foundation, the small non-profit organisation behind the LibreOffice project and community.
In the last two episodes, we talked about marketing free and open source software such as LibreOffice – the challenges and the opportunities as well. And then we talked in the second episode about design, UX, UI in LibreOffice and open source software – the challenges of making changes to user interfaces that people have been using for years, but also some of the cool things happening.
But today we’re going to talk about how we test half a million documents in LibreOffice. Yeah. So we sit down and load half a million documents into LibreOffice. File, Open, File Open and check the compatibility. Yeah, we’re very committed. Of course not – we do that automatically. I’m going to talk about that a bit later, because we’re talking in general today about LibreOffice QA – quality assurance – as well.
So how do we make sure that the software stays strong and stable and reliable when we add new features to LibreOffice, how are they tested and integrated before they go out to millions and millions of people as well.
How do we handle bug reports? So somebody submits a bug with the software. What makes a good bug report as well? And how do we maintain compatibility? There are billions and billions of documents out there in mostly Microsoft formats. So how do we make sure that LibreOffice stays compatible with them when things are changing, the formats are changing?
Microsoft’s famous transitional format makes life extra difficult for many of us. So, let’s talk a bit about QA. I’m joined, as mentioned, by two of my colleagues at The Document Foundation. So, again, we are the small 15 people non-profit organisation. But of course we at The Document Foundation are backed up by a community of hundreds of people making LibreOffice as well.
But I’m joined by Xisco Faulí, who is a QA engineer – I think is your title. Xisco is that right?
Xisco Yes, you’re right. Yes.
Mike And you’ve been at TDF for a few years now. I think the same as me.
Xisco More or less. I joined TDF in 2016. So it’s almost 10 years next year. And I joined as a QA engineer and since then I’ve been doing that.
Mike How did you get involved in QA before that? What’s your background leading to this?
Xisco Yeah, that’s a good question. So before that I studied computer science in the university and at the same time there was – and it’s still going – the Google Summer of Code program. So I first joined LibreOffice as a Google summer of Code student and then after that I got a job as a QA engineer in another company, and at that time I also contributed to the project doing QA as a volunteer as many other people do.
Nowadays they spend their time volunteering doing different things in the project and, yeah, I was doing QA – and then at some point the QA offer was published – this job position – so I applied and I got the position.
Mike And our other guest in this episode is Ilmari Lauhakangas – I think—have I pronounced that correctly?
Ilmari Yeah, Ilmari Lauhakangas
Mike Excellent. Yeah. Who does various things. We all do various things at TDF as well. There’s a lot of overlap in what we do and overseeing the community. But yeah, Ilmari, tell us a bit about what you do at TDF and how you got to this point.
Ilmari I was hired by TDF in 2019 to do mentoring and recruitment of volunteers. So I focus on onboarding new people and I do it for basically most of the areas where you can contribute. So in addition to quality assurance, development, design, documentation – so I also do stuff like web development for TDF applications and stuff like that.
And of course, there’s always room to grow at TDF, so it’s nice. And I got my start as a volunteer at around 2014. And back then I was contributing to a couple of open source projects. And I was wondering, how someone who does not know programming that well might help developers and kind of save them time to focus on the stuff that matters.
It hadn’t really occurred to me that testing bugs would be such an impactful thing. So when I somehow ran into the topic in the context of LibreOffice, I kind of really got excited and really put a lot of effort into regularly testing bugs. So that was a nice experience.
And even before that I had done some recruitment for other open source projects. So yeah, I was kind of motivated to see what was possible – like how can we collaborate as a team and how to organise all the information for contributors.
I was kind of impressed even at that time – like over 10 years ago – how well organised the whole thing was. There were these easy tasks for developers mainly, and all the information was laid out quite nicely in the wiki and then there were people helping, chatting, sending emails and it was quite a supportive experience back then.
Mike Yeah, the recruitment, the mentoring that Ilmari mentions is a big thing of what we do as well and in many other free and open source software projects – because it’s nice to have a load of users – we talk about having around 200 million users – but if nobody’s contributing, then what does that mean?
So a big part of what we do as well as doing our work in marketing, design, QA is mentoring people who want to contribute to the project, but often don’t know where to start – and of course we try to make that easier, but LibreOffice is I think 7 million lines of source code has quite a complex build system (although I think that’s been simplified a lot over the years).
So when people come to us and say “I want to contribute, but where do I start I’m daunted?” Then Ilmari often does interviews with them – just a chat to say right where do you want to go, instead of sending people straight to a big wiki page – which is helpful for some people they like that approach, but often it’s nice just to have a chat and say “Right what do you want to do and where can we get started”.
Of course we’re hugely international project as well – I’m in Germany, Ilmari’s in Finland and Xisco’s in Spain – so that’s just a few, but we have contributors in I think the majority of the 190-ish countries in the world.
Ilmari Yeah. And it was nice for me to discover bug testing. I didn’t have any experience any training on it. So everything I know I learned in the context of LibreOffice originally, and it was nice to have such a low threshold for contributing. So you don’t really need to know anything.
Just follow the steps and then you can progress to more challenging investigations and yeah. It’s also quite a pleasant thing to do – like a very calm activity. So usually when your software crashes you get mad, but in case of QA you’re glad that it crashed because you found something interesting or you could reproduce something. So there’s not that much stress in it as an activity. So that was nice as well to discover.
Mike Yeah. And we see as well over the years, lots of contributors in the LibreOffice project who started out on with QA and testing some things – confirming some bugs and then as we’ll talk about in a moment – but they’re moving on to other stuff in the project as well.
So I think it is a good kind of onramp to contributing. But how does the QA team work then? I guess most of the work is centred around the Bugzilla instance we have. Is that right Xisco?
Mike Yeah that’s correct. So Bugzilla is the bug tracker where all the issues are reported, and where developers coordinate and check the issues that they have to fix or they have to work on. So yeah basically the QA activities around Bugzilla – we have to deal with the reports that the users report in Bugzilla and once we deal with those reports we have to talk with the developers and try to find someone to work on those reports.
Mike And, so when a bug comes into Bugzilla it’s not automatically marked as new. Somebody first has to confirm it. Xisco, is that right?
Xisco Yeah, that’s correct. That’s called triage. It’s basically the same that is done in hospitals for instance. When a new patient comes in, we have to do some triaging and see what’s the problem. So we do the same here. When a new report comes in we check the report; we see if they if the information provided is enough to reproduce the issue and then once we try to reproduce. If we succeed to reproduce it, then we try to analyse it and try to have as much information as possible to help developers, to make their life easier. So for them it gets easier to fix those issues.
Mike And on the QA blog which we’ll link to in the notes, you post monthly reports as well Xisco about the number of bugs fixed. I think it’s often like 400 or 500 issues resolved.
Xisco Yeah that’s correct. We have a monthly report where we talk about QA and development activities. It’s a picture of what’s going on. Not everything is mentioned there because we have list of top 10 QA triagers for instance.
So it’s not like we only have 10 people. We have hundreds of contributors, but we only list the most relevant or the most active ones. But yeah, it’s a way to, at least from my point of view, it’s a way to say thank you to all these people contributing in QA – to say, okay, your work is it’s really appreciated and well, at least you’ve been listed here in these metrics and, at least from my side, it’s a way to say thank you to them.
Mike And occasionally on the other blog on the main TDF blog, we’ve posted some stories about a bug report coming in and then a developer jumping in two hours later to look at something and then resolving the issues. I know that’s not always the case.
Some things take a lot more time, but there have been some stories of bugs being resolved in a few hours because everyone’s in the right place at the right time – and those make nice stories as well.
What I also find interesting, as somebody who’s not involved in QA but watches a lot of what you guys are doing, is the ability to pinpoint exactly where a change took place that caused a problem.
So we do a new major release of LibreOffice every six months. About once a month we have a point release with largely bug fixes or security updates.
But I see that when you guys get a report, a bug report comes in, you can analyse, often pinpoint the exact code change that caused this issue, if it was a code change that made it happen. It could just be another general bug. But if a code change somewhere in the past in all the years of development, you can identify the exact build of LibreOffice – even a development snapshot. And I think, Ilmari, this is called bibisecting. I have no idea how to pronounce it…
Ilmari So it comes from binary bisecting. So we can say bibisecting. So we emphasise binary here because we offer repositories which contain thousands of runnable LibreOffice versions. So each code change can be run as a program – as a binary. So this is a very convenient way for contributors to participate. They don’t have to have a development environment. They don’t have to wait how many hours it would take to do the building of each of these – like, I don’t know, 13 tries when you’re testing a specific bug.
So you might have to do the same steps like 13 times in a row. So it can be a bit tedious, but it’s also very powerful way to help developers. And yeah, obviously if we go into practical things, it will take a lot of space on your computer if you want to really have a long history of the different versions. But of course most of the old issues have already been analysed.
So a new contributor can do a lot of good work with just a handful of the newer repositories.
And yeah, it’s really nice to be able to help developers in this way. And it’s also kind of a way to learn more about the code, in a kind of a soft-landing way. So you get closer to the source code. You can read it exactly where the issue is and learn about it that way.
Mike Thousands of builds that must be take up quite a bit of space.
Ilmari Yeah, it does have some kind of compression benefits there. So they don’t exactly take like terabyte per repository. It only takes like seven gigabytes about per repository. So, not that bad.
Mike But it’s still a very practical thing to have. But where do you even start then if you get a bug report and you really don’t know in the last few years which change may have caused this issue? Do you jump between two dates and say, “Well, it could have happened between a change in 2015 to now – and then we’ll go with these binary builds and try and narrow down the time?” Or how do you approach it?
Ilmari That’s a good point because as the history grows longer, the tedious part also gets longer. So a part of it is when you’re an experienced triager you already kind of remember when some feature was introduced. So maybe you remember this is not inherited from like before 2010 or something like that. So you can immediately select some version that is not super old and then go from there. But yeah, it can be like an intuitive process in a way.
But usually you start from a reasonably old version and then check is it is the bug here and then kind of bisect it or divide the whole testing process manually first – and then you rejoice when you find the version where it appeared in. And obviously the bug report itself may contain already a mention that it wasn’t in this version; it was in this version. So then you can see okay I’ll start with this that the reporter pointed out and yeah, so we get a lot of benefit from the user testing.
Like discussed earlier we mostly do analysis of user reports. So we are kind of in a huge debt to our users for providing all of these manual testing experiences, because we don’t really even have time to do manual testing much ourselves. Although that does happen when we test reports we do discover new issues as well.
Mike And I noticed in the last few years one of the priorities has been to keep the number of unconfirmed bug reports down. I think is that still the case, Xisco? Is that one of the priorities and what are some of the other priorities of the QA team at the moment?
Xisco Yeah, the that’s one of the priorities. Sure. But it’s really tough to keep the number of unconfirmed bugs low because we keep receiving new reports every week. I would say around 100 reports every week, and all of them have to be triaged manually. So yeah, it’s a lot of work recurrent work to do.
So yeah we try to keep volunteers that we have and sometimes it goes up and sometimes it goes down, but that’s one of the priorities here. Another priority is to keep the number of regressions as slow as possible. Of course, the more regressions we have, the worse the quality of the software is and it’s very important – every time we have a new major release – of course there’s going to be regressions it’s software, so there’s always issues. So the one priority is to try to fix those regressions as fast as soon as possible. Yeah, that’s also very important. So then when we have a new major release then we can have a fix within one month in the next minor release for that version.
Ilmari Yeah, you mentioned regression. So to clarify kind of you can have an existing feature which worked fine and then there was some code change which broke something in that feature. That’s called a regression. But on the other hand, you can introduce a new feature, but you overlooked something and it doesn’t really work like you intended.
So that’s kind of like a general bug or an implementation issue – however you want to call it. But yeah, the regressions are the ones that are the target of the detective work. So for the bisecting and such. And sometimes it’s kind of unfortunate that we can’t go back in history beyond like 2012 or something like that. Around that time like we don’t get the precise bisecting ability because things get complicated. The build system was not that high quality back then and you can imagine it’s kind of having a time machine or wishing to have
Mike I remember when the LibreOffice project started like you said – you talked about 2012 and 2010 – the LibreOffice project started, and I was working as a Linux journalist at the time and one of the earliest things the LibreOffice project was trying to do was to modernise the build system. And I guess now looking back at it, it’s not just to make life easier for developers and potential developers, but to make it possible to do these tests more easily as well. So, but Xisco, you talked about how a lot of things have to be done manually, like of course triaging new bug reports that come in, but a lot of things can be automated as well. At the beginning of the episode I mentioned this half a million documents which can be automatically tested. So tell us a bit about automatic testing.
Xisco We have a virtual machine that basically takes thousands of documents from the internet and from public repositories like Bugzilla and other bug trackers and some forums, and downloads those documents. And then recurrently it tries to import those documents, export them, reimport them, reimport them again. So basically this is trying to find crashes or asserts in those documents.
This is something that has been done for many years by Caolán, and it’s has improved a lot the quality of the software because before we had this automation, there were many reports from users saying that LibreOffice was crashing. From time to time, we still get reports about crashes when importing or exporting documents, but it has reduced a lot the number of such reports and it helps a lot in that matter.
We also have another kind of automation. We also have unit tests. So basically nowadays it’s kind of common to see when there is a fix for an issue, to also have a unit test for that fix. So this way we make sure that this is going to work forever and in the future we are not introducing a regression for that fix. So we know for sure it’s going to work – and at the moment I don’t know how many we have, but we also have thousand of unit tests that have been written and added to the codebase in the last years.
This has increased a lot since LibreOffice project started. Before that we had some unit tests, but recently we have many of them and it’s helping a lot with the quality of the software.
Ilmari About the automated tests – if we have so many tests, how can we still get bugs? Well, the explanation is you can’t predict the future. So you can’t really write a test for every possible scenario. So, there will always be something due to the complexity of the software. So, the test writing is often reactive. So when it’s not in conjunction with introducing a new feature, if it’s reacting to a regression, then you have this integration test.
So you write a scenario where you kind of simulate what a user would do. You might have some simple document and manipulate it somehow. So it’s not like a very small atomic unit test. It’s a more broad test, but it’s good because it will also catch things that you might not even know about. So yeah, that’s kind of a one way of future proofing, but it can never be.
Xisco And it’s surprising to see how changing one part of the code might impact on another different part of the code. So yeah, you think: oh this change is going to be safe. I’m not going to break anything, and then a few months later someone reports that something completely unrelated gets gets a regression. So yeah, that’s the magic of LibreOffice.
Mike And whenever I’m looking around on Bugzilla, and seeing what new reports are coming in, when people have to submit a bug report or when people choose to submit a bug report, they have to fill in different things – different bits of information about the software. Because I know from handling the LibreOffice social media side, we also get bug reports via social media, but they tend to be: “LibreOffice doesn’t work – why not?” Or “Why did LibreOffice stop working after the latest update?” – with no information which updates
Those are not the most useful bug reports because there’s no standardisation of what information needs to be required, but Xisco, what makes then a good bug report, what does a good bug report that you guys can work with, what does it need to include?
Xisco Considering that LibreOffice runs on different platforms, different environments, it’s really important to provide as much information as possible.
If you have to record your screen to show how to report the issue, then that’s going to be helpful – providing the document because many times a specific problem might happen with a specific document, but not within a general case. So attaching that document is really help helpful as well. Providing the steps to reproduce the issue. So yeah, basically the more information is provided the better.
Mike Yeah, definitely. You see the big difference it makes – a bug report with a huge amount of information versus a generic “Yeah, this doesn’t work”.
So we’ve talked about what the QA project does and some of the different tools as well. Anybody listening to this, or watching it as well, who thinks, “Right, I want to get involved. I want to get some experience in QA. I want to help out with the LibreOffice project.” Ilmari, you talked about this a bit at the beginning, about how you got involved and, but what is a good way for people to help out and get involved in QA? What steps to reproduce should they take?
Ilmari So people navigate things differently. We have this mentoring approach for people who are not that comfortable maybe absorbing large amounts of information, or are not at that stage in their learning that they would be comfortable jumping into a big project like this. But of course, it’s possible to navigate everything yourself. Our wiki documentation is quite clear. It also has quick start steps, so you can just drill down on the basic stuff – and of course we recommend to start with the basics. So get comfortable with the simple confirming.
It can just be, if you think what is the simplest bug report, it can be “The document doesn’t look the same as in some other software”. Then you just confirm it. You open the document and notice – yes, that’s truem and there might be screenshots. So it can be extremely simple to verify these reports.
In my mentoring I meet with the mentees regularly in the chat – in the text chat – and I review their work. So we go through the reports that they commented on, and I give feedback, and after a couple of dozen basic tests, I already introduced this advanced bisecting technique to them. Which kind of sounds ambitious or at least sounded to me when I started doing it, because myself – I took quite a long time to really get into it, actually over a period of two years. It was somehow daunting to me to get into it, but I wanted to refine the documentation and the whole process of getting into it, and now we are getting quite good results.
Depending a little bit on the technical background of the person, we might have them doing bisecting like in a week or two when they were introduced to it. So they immediately can get results from it instead of just scratching their heads for weeks and weeks and trying to figure out what the thing is about. So that’s always kind of impressive to me how quickly they are able to get into it.
Mike Indeed – two weeks from checking how a document looks to doing bibisecting. That’s cool. So yes, thanks guys – I think that’s a good overview of what we’re doing in the QA project and some of the different challenges and opportunities as well. Anything else you’d like to add?
Xisco For someone new interested in contributed in QA, Ilmari is also doing weekly live sessions where – well maybe you can talk a bit about those because I think it’s interesting for someone new to see the way you think when you are triaging issues, or the thinking behind what your actions.
Ilmari That’s a good point – I forgot it. So I indeed do these kind of live streams. Not really live streams. I don’t use Twitch or YouTube or anything. Just have a conference room and people can join and ask questions.
I do it one hour at a time – I don’t prepare for it beforehand. So it’s very realistic. I just look at the list of reports and go through them one by one and explain what I’m seeing and what I’m going to do and stuff like that. So it gives a realistic view of the testing process.
Mike But not on Twitch – so we can’t make live donations while you’re doing it!
Ilmari Yeah, I don’t really understand all that stuff. Like, if we had thousand people in the chat like – chat is going brrrrrr! It doesn’t seem to mesh well with the testing – it would be too distracting.
Mike Quite probably. OK, thanks a lot Xisco and Ilmari – I think that was a good overview of what we’re doing 0 what you guys are doing – and again the hundreds of people in the community. When I look around on Bugzilla, and as we’re recording this we’re doing a Month of LibreOffice campaign, where I collect statistics from Bugzilla for people who are confirming bug reports, contributing, a lot of new volunteers as well.
So it really is a big group effort – and again anybody I think it’s a good way for anybody to get involved and yes, the simplest things, comparing a document, saying “Oh yes, in this bug report the same thing happens to me in this version on this operating system”
So I think it is a really useful, genuinely useful way to jump into the project, help out and make a difference as well to the software. So let’s wrap it up here then episode three of the podcast – we have more to come covering different topics as well in LibreOffice. So, thanks Xisco. Thanks, Ilmari.
