LibreOffice project and community recap: January 2023

Montage of images from this post

Here’s our summary of updates, events and activities in the LibreOffice project in the last four weeks – click the links to learn more…

  • We started the year back looking back at the previous one – 2022! Here’s a quick recap of what we did in the LibreOffice community. Well, just a few of the many things 😉 Thanks to everyone who contributed last year! (PeerTube version of this video here.)

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.

LibreOffice 7.4 banner

Calc Guide cover

  • Some sad news: we heard that Carlos Parra Zaldivar, a long-time collaborator in the community, member of The Document Foundation and advocate for Free Software, passed away on November 20th. Rest in peace, Carlos.

Carlos Parra Zaldivar

Draw Guide cover

  • Then we talked to Afshin Falatooni from the Persian-speaking LibreOffice community, about his work on the blog and in the QA project.

Afshin Falatooni

  • Later in the month, we at The Document Foundation stated our position on the EU’s proposed Cyber Resilience Act. If the Cyber Resilience Act becomes EU law without clarification, the impact on several European-based open source projects, such as products based on LibreOffice technology, could have devastating (unintended) consequences.
  • TDF has many websites and services: this blog, the LibreOffice website, our wiki, the extensions website, Weblate and many more. To improve them and keep them up-to-date, TDF now has a new Web Technology Engineer, Juan José González! We had a chat with him, to learn more…

Juan José González

FOSDEM logo

Keep in touch – follow us on Twitter, Facebook and Mastodon. Like what we do? Support our community with a donation – or join us and help to make LibreOffice even better!

Welcome Juan José González, TDF’s new Web Technology Engineer!

Photo of Juan José

Here at The Document Foundation, the non-profit entity behind the LibreOffice community, we have many websites and services: this blog, the LibreOffice website, our wiki, the extensions website, Weblate and many more.

To improve them and keep them up-to-date, TDF now has a new Web Technology Engineer! So let’s get to know him…

Tell us a bit about yourself!

My name is Juan José and I am from México. I moved from my beautiful hometown to Guadalajara nearly thirteen years ago looking for a good job as a developer and I fell in love with the city. In Guadalajara I met my wife, my friends and many free software enthusiasts.

Since the first day, I realized that there were local communities around free software so I like to keep in contact with them, and contribute with technical talks about various topics.

I studied a masters degree in Computer Science, where I got interested in the semantic web and the automated reasoning discipline behind it. I’ve been working as a web developer for more than a decade now.

I am so happy that I found this position at The Document Foundation – I am determined to contribute as much as I can to improve our existing web sites and web apps that support the foundation’s efforts.

Were you using LibreOffice before you joined TDF?

I used LibreOffice to write the final project of my bachelor degree, I can say that LibreOffice was the first application for what I consider myself a power user (that was 10 years ago – but I have lost most of my talents sadly). I also remember writing an essay about the importance of open document formats, and my references included many people from the LibreOffice community.

This role marks my first time actively contributing to LibreOffice – so I hope I can help the project significantly.

ODF logo

What’s your new role at TDF?

I joined the Foundation as the new Web Technology Engineer, where I will dedicate my time to support, fix and improve the experience of our websites.

I believe it’s a great role since the web has become the default entry point to all people that want to interact with LibreOffice, from being an end-user, to collaborate on the software’s development. I have adopted the mission to facilitate this interaction.

What are you working on?

I am starting on the extensions site – it’s the place where you can get templates and extensions for LibreOffice. I am replying to reported issues by improving the web experience. I also want to keep an eye on the experience of the end user, taking care of both ends: extension developers and the users.

We’re really happy to have Juan José on board! LibreOffice users and community members can give him feedback and help via the website mailing list. Looking forward to seeing all the great things to come 😊

The Document Foundation releases LibreOffice 7.4.5 Community

LibreOffice banner

Berlin, January 26, 2023 – The Document Foundation announces the release of LibreOffice 7.4.5 Community, a maintenance release which solves a crash affecting a large number of users. The new release is immediately available from https://www.libreoffice.org/download/ for Windows (Intel and ARM processors), macOS (Apple and Intel processors), and Linux.

All LibreOffice users are invited to update their installation to LibreOffice 7.4.5, as the older versions have reached the end of life and are not maintained.

LibreOffice offers the highest level of compatibility in the office suite market segment, with native support for the OpenDocument Format (ODF) – beating proprietary formats for security and robustness – to superior support for MS Office files, to filters for a large number of legacy document formats, to return ownership and control to users.

LibreOffice Technology Platform

Products based on the LibreOffice Technology platform – the transactional engine shared by all LibreOffice based products, which provides a rock solid solution with a high level of coherence and interoperability – are available for major desktop operating systems (Windows, macOS, Linux and Chrome OS), for mobile platforms (Android and iOS), and for the cloud.

For enterprise-class deployments, TDF strongly recommends the LibreOffice Enterprise family of applications from ecosystem partners – for desktop, mobile and cloud – with a large number of dedicated value-added features and other benefits such as SLA (Service Level Agreements): https://www.libreoffice.org/download/libreoffice-in-business/. All code developed by ecosystem companies for enterprise customers is shared with the community and improves the LibreOffice Technology platform.

Availability of LibreOffice 7.4.5 Community

LibreOffice 7.4.5 Community is available from: https://www.libreoffice.org/download/. Minimum requirements for proprietary operating systems are Microsoft Windows 7 SP1 and Apple macOS 10.12. LibreOffice Technology-based products for Android and iOS are listed here: https://www.libreoffice.org/download/android-and-ios/

The Document Foundation does not provide technical support for users, although they can get it from volunteers on 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 with a donation at https://www.libreoffice.org/donate

Change log page: https://wiki.documentfoundation.org/Releases/7.4.5/RC1

TDF position on EU’s proposed Cyber Resilience Act

THE DOCUMENT FOUNDATION
Summary of Issues of the Cyber Resilience Act (in the current status)

Introduction

The Cyber Resilience Act (CRA) sets out a number of cybersecurity and vulnerability management requirements for manufacturers (Annex I) and will require products to be accompanied by information and instructions for users (Annex II). Software vendors will also be required to conduct a risk assessment and produce technical documentation (Annex V) to demonstrate compliance.
Currently, the text implies that if a developer or supplier derives commercial benefit from OSS, it would be subject to the Cyber Resilience Act. It even implies, in relation to the distribution of software, that open source producers or developers could be held liable if their open source projects are used commercially.

If the Cyber Resilience Act becomes EU law without clarification, the impact on several European-based open source projects, such as products based on LibreOffice technology, could have devastating (unintended) consequences.

The Commission recognises that not all products in our society are equally dependent. The Cyber Resilience Act therefore distinguishes between products and critical products, reflecting the level of cybersecurity risk associated with these products. On the other hand, the CRA ignores the security risks associated with files created by the software covered by the act itself, which can have even more devastating consequences (according to security expert Kaspersky Labs, in 2018, 70% of all malware worldwide was carried by documents created by the most widely used office suite).

Software developers must declare compliance with the requirements of the Cyber Resilience Act and therefore take responsibility for compliance in one of three ways. They can either:

  1. perform a self-assessment, or
  2. apply for a product examination by an auditor and then set up checks and balances for their development processes, or
  3. apply for an assessment of their quality system by an auditor.

These options come with a growing administrative/compliance burden.

The Cyber Resilience Act attempts to exempt open source software from its provisions. But there’s some problematic language about how the CRA draws the line between commercial and non-commercial use of OSS, which could affect all products based on LibreOffice technology and many other products based on open source software.

This is the text of the Open Source Software exception:

In order not to hamper innovation or research, free and open-source software developed or supplied outside the course of a commercial activity should not be covered by this Regulation. This is in particular the case for software, including its source code and modified versions, that is openly shared and freely accessible, usable, modifiable and redistributable.

While the Cyber Resilience Act does not define commercial activity, the EU Blue Guide to the implementation of EU product legislation does:

Commercial activity is understood as providing goods in a business related context. Non-profit organisations may be considered as carrying out commercial activities if they operate in such a context. This can only be appreciated on a case by case basis taking into account the regularity of the supplies, the characteristics of the product, the intentions of the supplier, etc. In principle, occasional supplies by charities or hobbyists should not be considered as taking place in a business related context.

For the purposes of the Cyber Resilience Act, there is a real risk that software based on LibreOffice technology will be considered to be made in the course of a commercial activity, and thus subject to the legislation, based on the following:

  1. Products based on LibreOffice technology are developed by the majority of full-time employees of ecosystem companies or by individuals who make a living from consulting services related to their project work.
  2. Products based on LibreOffice Technology are goods in a business-related context because they are intended to provide software that can be used immediately by businesses or employees in their daily work.
  3. The Document Foundation has never missed a LibreOffice release in 12 years.
  4. Products based on LibreOffice technology are high quality software that matches the quality of commercial products.

So the features of a product based on LibreOffice technology are equivalent to those of commercial products.

Charging for support also makes open source a commercial activity. The Document Foundation does not charge for support, but it certifies professionals who are supposed to charge companies for consulting and support, and encourages companies to adopt professionally supported software.

Having said all this, it is important to remind the reader that The Document Foundation provides software free of charge, on a non-profit basis, and under OSI-approved open source licences that permit further use, study, modification and redistribution, whereas ecosystem companies provide commercial software with service level agreements.

Impact Assessment

CE Markings for Software Products

Basically, the core of the proposed legislation is to extend the CE marking regime to all software products distributed in Europe. Our understanding is that this process will be applied to open source software that is made available under open source licences and distributed free of charge.

We are deeply concerned that the Cyber Resilience Act could fundamentally alter the social contract that underpins the entire open source ecosystem: open source software that is provided free of charge, that can be modified and redistributed free of charge, but without warranty or liability to the authors, contributors, or open source distributors.

Legally changing this arrangement through legislation is likely to have unintended consequences for Europe’s innovation economy.

Without a clearer exemption for open source, in order to comply with the legislation, The Document Foundation will need to develop, document and implement policies and procedures for each project to ensure that they comply with the requirements of the Cyber Resilience Act, including:

  • All development and post-release security requirements specified in Annex I, including the provision of notification and update mechanisms.
  • All the requirements for user documentation set out in Annex II.
  • All of the product technical documentation set forth in Annex V, including … complete information on the design and development of the product… including, where applicable, drawings and schemes and/or a description of the system architecture explaining how software components build on or feed into each other and integrate into the overall processing
  • For each release, prepare the documentation required by Annex V, including … an assessment of the cybersecurity risks against which the product with digital elements is designed, developed, produced, delivered and maintained…
  • Determine for each product whether it meets the definition of product with digital elements, critical product with digital elements or highly critical product with digital elements
  • For each product which is a product with digital elements, establish, complete and document a CE mark self assessment process
  • For each critical product with digital elements or highly critical product with digital elements engage with an external CE auditing body and complete the additional processes required to get the CE mark approval
  • For each individual release, document that the CE marking process has been followed (as described above), that an EU Declaration of Conformity has been written and signed by an officer of the Foundation, that the CE mark has been affixed, and that the technical documentation and EU Declaration of Conformity will be made available for at least 10 years after the release.

Note that we estimate that The Document Foundation’s projects release at least a dozen versions in any given year. It is not clear to us what the cost in time, resources and money would be to implement these external review processes. We assume that they would be substantial.

Article 4 (3)

Member States shall not prevent the making available of unfinished software which does not comply with this Regulation provided that the software is only made available for a limited period required for testing purposes and that a visible sign clearly indicates that it does not comply with this Regulation and will not be available on the market for purposes other than testing.

Projects based on LibreOffice technology make integration, nightly, weekly and milestone builds available under their open source licences indefinitely. The intent is to provide community testing and traceability. These binaries are marked as such, but the terms under which they are provided do not require that they be used for testing purposes only.

It is not clear how this requirement could be implemented by any open source project using modern CI/CD infrastructure and operating under the principle of transparency.

Even if the binaries are marked as for testing only, the open source licences under which they are provided permit uses other than testing. In addition, it is common practice to provide interim builds for extended periods of time to allow testers access to previous builds for problem identification and resolution.

Discontinuing this practice would be very disruptive. And any solution based on making intermediate builds available under non-open source licences would be impossible for projects based on the LibreOffice technology, as TDF does not own the copyright and obtaining the consent of all contributors would be impractical.

In summary, compliance with the proposed requirements of the Cyber Resilience Act would be a significant blow to open source development best practices.

Article 5 (1) and Section 1 of Annex I

(1) Products with digital elements shall be designed, developed and produced in such a way that they ensure an appropriate level of cybersecurity based on the risks

This would probably ask for the development and enforcement of written policies that require each project to assess its level of cybersecurity risk and to implement processes to ensure that the level of risk and justification for the development processes adopted are determined.

(k) ensure that vulnerabilities can be addressed through security updates, including, where applicable, through automatic updates and the notification of available updates to users

With few exceptions, products based on LibreOffice technology do not require registration and do not provide a mechanism for notifying all users that an update is either available or required. Implementing these requirements would require a whole new infrastructure to be mandated across all projects.

Article 5 (2)

In general, The Document Foundation can deal with many of the requirements, as it has a security team and TDF is also a CVE numbering authority. However, there are two notable elements in the requirements.

(1) identify and document vulnerabilities and components contained in the product, including by drawing up a software bill of materials in a commonly used and machine-readable format covering at the very least the top-level dependencies of the product

This would impose a legal requirement to produce SBOMs for all projects based on the LibreOffice technology, which would be a very significant effort, and would also require active monitoring of all dependencies for known vulnerabilities.

(3) apply effective and regular tests and reviews of the security of the product with digital elements

These would require a significant change to our community’s development processes to mandate a whole class of testing that is not currently mandated for our projects. This is a very significant effort, both to implement and to maintain.

Section 2 of Annex I “Vulnerability Handling Requirements”

(1) Products with digital elements shall be designed, developed and produced in such a way that they ensure an appropriate level of cybersecurity based on the risks
(2) Products with digital elements shall be delivered without any known exploitable vulnerabilities
(3) On the basis of the risk assessment referred to in Article 10 (2) and where applicable, products with digital elements shall:
(a) be delivered with a secure by default configuration, including the possibility to reset the product to its original state
(b) ensure protection from unauthorised access by appropriate control mechanisms, including but not limited to authentication, identity or access management systems
(c) protect the confidentiality of stored, transmitted or otherwise processed data, personal or other, such as by encrypting relevant data at rest or in transit by state of the art mechanisms
(d) protect the integrity of stored, transmitted or otherwise processed data, personal or other, commands, programs and configuration against manipulation or modification not authorised by the user, as well as report on corruptions
(e) process only data, personal or other, that are adequate, relevant and limited to what is necessary in relation to the intended use of the product (minimisation of data)
(f) protect the availability of essential functions, including the resilience against and mitigation of denial of service attacks
(g) minimise their own negative impact on the availability of services provided by other devices or networks
(h) be designed, developed and produced to limit attack surfaces, including external interfaces
(i) be designed, developed and produced to reduce the impact of an incident using appropriate exploitation mitigation mechanisms and techniques
(j) provide security related information by recording and/or monitoring relevant internal activity, including the access to or modification of data, services or functions
These would require a significant change to our community’s release processes to require certifications that there are no known vulnerabilities and to meet the many requirements listed.
(k) ensure that vulnerabilities can be addressed through security updates, including, where applicable, through automatic updates and the notification of available updates to users

Several products based on LibreOffice technology do not require any kind of user registration and do not provide a mechanism for notifying all users that an update is either available or required. Implementing these requirements would require a whole new infrastructure to be mandated.

Recommendation and Conclusion

We propose that all open source development and distribution activities should be excluded from the scope of the Cyber Resilience Act, without exception. This is the simplest solution to the problems previously described in the document.

In order to encourage open source developers and distributors to continue their activities, we believe it is important that the Regulation provides comfort and certainty to these organisations that their activities are exempt from the obligations of the Regulation. Although it is the aim of Recital 10 to clearly establish this exemption, we believe that including the FOSS exemption in the body of the Regulation itself would establish the exemption with greater clarity and certainty.

As an alternative, we suggest clarifying the interpretation of “commercial activity” in a way that is more appropriate to the context of open source software. This would recognise that not all efforts to generate recurring revenue (such as paid “technical support services”) should be characterised as “commercial activity”.

Even without the commercial activity qualifier, the wording of Recital 10 would still require companies that primarily monetise open source software, for example by charging for products incorporating such software, to comply with the Regulation, but would no longer cover organisations that make FOSS available to the developer community.

Community Member Monday: Afshin Falatooni

Afshin Falatooni

Today we’re talking to Afshin Falatooni, from the Persian-speaking LibreOffice community!

Tell us a bit about yourself…

I am from Iran, the city of Mashhad. I speak Persian (Farsi), and I love to contribute to LibreOffice! This January, I have just turned 46 years old. My favorite hobby is climbing, and if I have time, I usually go to the mountains on Fridays, which is the weekend holiday in our country.

I work as a book editor, typesetter and layout designer. I became interested in the LibreOffice project because of my job. Many editors and typesetters use Microsoft Word more than any other program, and I was one of them before I got acquainted with LibreOffice. But, now that I know the advantages of LibreOffice as a free software project, I use Writer as much as the norms of the publishing market allows me.

What are you working on in the LibreOffice project right now?

I write regularly on the Persian LibreOffice blog. My goal is to provide educational contents around LibreOffice there. Additionally, if I find a bug that is either directly or indirectly related to Persian language, in addition to reporting it to Bugzilla with the necessary screenshots and documents, I post it to the blog to make others aware of the important bugs.

We also have a Persian-speaking group in Telegram, where I answer questions as far as I can, alongside the other admin of the group.

Many years ago, I added a large collection of Persian words to OpenOffice.org project, which were likely to be written incorrectly. Using that word list, the Persian language was added as part of the OpenOffice.org auto-correction feature. The word bank continues to exist in LibreOffice, and is useful for the Persian speaking users.

Many thanks to Afshin for all his contributions 😊 All LibreOffice users are welcome to build up our native-language communities and reach more people around the world!