LibreOffice Documentation Team Activities in 2020

In 2020, the documentation community released many updated guidebooks, translated them into several languages, and participated in the Google Season of Docs

(This is part of The Document Foundation’s Annual Report for 2020 – the full version is here.)

New and translated guides

In January 2020, just before release of LibreOffice 6.4, the Documentation Team was proud to announce the Math Guide 6.4, an update of the previous version (4.0), updated to cover all of the innovations included in the latest release of the software. The guide was updated by Roman Kuznetsov and revised by Dave Barton from the documentation community. This was followed by the Calc Guide 6.2, a long-awaited update of the old Calc Guide 4.4.

In May, the guide to Base for LibreOffice 6.2 was released, covering, LibreOffice’s database component. It was updated by Pulkit Krishna, Dan Lewis, Jean Hollis Weber, Alain Romedenne, Jean-Pierre Ledure and Randolph Gamo. Another update in May was the Getting Started Guide 6.4 – the introductory guide for the latest LibreOffice 6.4, aimed to the general public interested to quickly get familiar with the software. It’s available as a PDF for offline reading, and ODT (OpenDocument Text) for editors and translators.

In summer, the Documentation Team announced the availability of the LibreOffice Draw Guide 6.4, the complete handbook for the drawing tool of LibreOffice. The guide was updated from the existing release (4.3) and include all the improvements developed since early 2014, when the last version of the guide was published.

Then there was the LibreOffice Calc Guide 6.4, the complete handbook for the spreadsheet tool. It was also updated from the existing release (6.2) and included all of the improvements developed in Calc since then.

In October, the Math Guide 7.0 was published – being the first guide based on LibreOffice 7.0. The effort was mostly carried by Rafael Lima and reviewed by Jean H. Weber. The new guide covers were designed by Rizal Muttaqin and Drew Jensen. The final publication was carried by Olivier Hallot. This was followed by the Calc Guide 7.0, a team effort of Steve Fanning, Gordon Bates, Kees Kriek, Annie Nguyen, Samantha Hamilton, Olivier Hallot and Jean Hollis Weber, coordinated by Felipe Viggiano.

Many guides were also translated in to various languages, thanks to our worldwide communities. For more information on their work, and the specific guides that they translated, see the “Native Language “Projects” section of this Annual Report.

Google Season of Docs

For the second year in a row, The Document Foundation was accepted as an organization in the Google Season of Docs, a programme whose goals are to give technical writers an opportunity to participate in contributing to open source projects, and to give open source projects an opportunity to engage the technical writing community.

In 2020, TDF’s documentation community offered a wide range of projects for technical writers, and extended the reach by providing projects for e-learning, mathematical documentation and code-oriented documentation.

TDF received several applications, containing important information including the technical writer’s resumés, proposals for project schedule and suggested deliverables. After a careful evaluation by the project mentors, TDF accepted the application of Ronnie Gandhi, a computer science undergraduate student enrolled at IIT Roorkee, India.

Steve Fanning, who had already worked as coordinator of the Calc Guide, served as mentor with Olivier Hallot as second mentor. Ilmari Lauhakangas and Olivier managed the administrative aspects of the project on behalf of The Document Foundation.

Ronnie worked on improving the descriptions for Calc’s functions, adding statements describing each function’s compliance with the Open Document Format for Office Applications (OpenDocument) Version 1.2 specification. Each function was also supplemented by extra use cases, illustrations and external references (where applicable).

Access the Extensive Calc Functions Description on The Document Foundation’s wiki. Thanks to Ronnie for all his work, and the mentors for assisting him on his journey.

Like what we do? Support the LibreOffice project and The Document Foundation – get involved and help our volunteers, or consider making a donation. Thank you!

Announcing the winners in the Month of LibreOffice, May 2021!

At the beginning of May, we started a new Month of LibreOffice, 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…

Fantastic! This makes it the most successful Month of LibreOffice ever, slightly overtaking the results from May 2020.

Great work, everyone! Hundreds of people, all across the globe, have helped out in our projects and communities. We’re hugely thankful for your contributions – and, of course, everyone who’s listed on the wiki page can get a sticker pack, with these stickers and more:

How to claim

If you see your name (or username) on this page, get in touch! Email mike.saunders@documentfoundation.org with your name (or username) from the wiki page so that we can check, along with your postal address, 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: 10 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 – we’ll get in touch personally with the details:

  • Michael Warner
  • Jorge Gustavo Rocha
  • Roland Kurmann
  • Astur
  • Alessandro Volturno
  • Harshita Nag
  • Érico Nogueira
  • Chris Shaw
  • Wanderer
  • María del Mar

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!

Tender to implement automated ODF filter regression testing (#202106-01)

The Document Foundation (TDF) is the charitable entity behind the world’s leading free/libre open source (FLOSS) office suite LibreOffice.

We are looking for an individual or company to implement automated ODF filter regression testing.

The default file format of LibreOffice is ODF, the Open Document Format. From time to time, there are regression bugs reported towards these filters, that involve loss of data. The respective unit tests do not provide sufficient coverage to prevent these regressions to happen.

The scope of this tender is:

  1. To implement an early warning system for such problems, to avoid them in the future and improve the overall quality of the software. As a recommended approach, we propose to use the ODFunDiff tool (https://git.libreoffice.org/odfundiff), which was developed specifically with the relevant functional and performance requirements in mind. Initial development of this tool was targetted towards LibreOffice 5.2/5.3, so updates to the code are likely necessary. Also, it may be necessary to fix some hypothetical additional non-determinism in LibreOffice, which was introduced in version 5.3
  2. Extend the crashtest report scripts (e.g. this one) with an additional report about ODF differences, which were detected during the 27,000 ODF roundtrips. This test should use last run’s ODF files as reference to compare against
  3. Raise and mention potential resource problems (like disk space) with existing infrastructure, e.g. the “crashtesting” virtual machine

Further information can be found in this presentation from a past LibreOffice Conference.

All technology standards of relevance, as well as their targeted versions for this tender should be declared or defined in the offer’s description of implementation.

A key item of the deliverables for this tender, and therefore also a decision criteria – besides qualification, references, price, and completeness of fulfilment – is extensive documentation about the approach chosen to implement the above items, covering more than just the pure implementation. We expect bidders to provide documentation on both the code and the non-code parts of this tender, e.g. methodology, structure and technical aspects. The Document Foundation will publish this under a free and open source license and make it available to the general public.

Required skills

  • Extensive knowledge of C++
  • Experience working on the LibreOffice source code

Other skills

  • English (conversationally fluent in order to coordinate and plan with members of TDF)

We use free, libre and open source (FLOSS) software for development wherever possible, and the resulting work must be licensed under the Mozilla Public License v2.0.

TDF welcomes applications from all suitably qualified persons regardless of their race, sex, disability, religion/belief, sexual orientation or age.

Bidders will get a preference for including a partner or independent developer who has not been involved in a successful tender before. For such developers, who have not yet been part of a successful tender bid, we aim on a best-effort basis, but without any guarantees whatsoever, to provide some mentoring in understanding the code base and the process in contributing to the code. We expect that time and efforts on the bidder’s side should not be part of the paid work for this tender. Please mention such need of LibreOffice development mentoring in your offer.

As always, TDF will give some preference to individuals who have previously shown a commitment to TDF, including but not limited to certified developers and/or members of TDF. Not being a member, or never having contributed before, does not exclude any applicants from consideration.

The task offered is a project-based one-off, with no immediate plans to a mid- or long-term contractual relationship. It is offered on a freelance, project basis. Individuals and companies applying can be located anywhere in the world.

When budgeting, we anticipated that this project (all items combined) to take in the region of 15 days of work. Should bidders’ assessment result in a significantly different number, please reach out to us before sending your bid, so we can clarify upfront.

TDF is looking forward to receiving your applications, your financial expectations offer in form of a fixed time fixed budget approach and the duration period for the implementation in calender weeks after the final reward of the tender, via e-mail to a committee at tender20210601@documentfoundation.org no later than June 30, 2021.

Applicants who have not received feedback by July 28, 2021 should consider that their application, after careful review, was not accepted.

All bidders are invited to ask their questions on this tender until June 23, 2021. Questions and answers will be made public in a collected and anonymized form.

LibreOffice monthly recap: May 2021 – Community activities

Check out our summary of what happened in the LibreOffice community last month…

  • Right on the first day of May, we started a new Month of LibreOffice, showing our thanks to everyone involved in the LibreOffice project and community. Everyone who contributes during the month can get a sticker pack – and a chance to win extra merch. We’ll announce the full winners here in the next few days!

  • Did you know that you can work with 3D objects in LibreOffice? Long-time community member Regina Henschel wrote a tutorial showing how to make a 3D globe, using a map and a sphere. Rather neat…

  • In May, TDF announced two bugfix updates for LibreOffice: 7.0.6 and 7.1.3. This marks the last release of the 7.0 branch – from here on, we will be maintaining the LibreOffice 7.1 series.

  • Meanwhile, the PowerPoint compatibility team reported on its recent work, showing how PPTX presentations are imported more accurately into recent versions of LibreOffice. Of course, when you’re working on a presentation in LibreOffice, its best to use its native format – OpenDocument.

  • LibreOffice is free and open source software, available for anyone to use, modify and share – and that will always be the case. At the same time, we really appreciate the contributions of companies in the wider LibreOffice ecosystem, who sell long-term support (LTS) versions and other benefits, and add many features to the codebase. So spread awareness of them, we’ve set up some LinkedIn pages for the “LibreOffice Enterprise” brands.

  • The Google Summer of Code begins! This is a programme that connects students with free and open source software projects.We announced the list of selected projects – and we’re really looking forward to seeing the results. Good luck to all the students, and thanks to the mentors for helping them!

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 for everyone!

Albanian Community Meeting – May 2021

While many pandemic restrictions around the world are still in place, some smaller events are finally becoming possible. Sidorela Uku from the Albanian LibreOffice community reports from a recent event in Tirana, which hosted the LibreOffice Conference 2018:

There were eight people present at this meeting. We had a short presentation about LibreOffice – what it includes, and its features. Also, we introduced the various ways how someone can become part of the community. We are planing to have more events in the future, as there are a few people interested in localization, but as well for people who want to switch and use LibreOffice. Also, we translated a few strings on the whatcanIdoforlibreoffice.org website, and pushed the changes to Gerrit.

Thanks to the community in Tirana for their work and support! It’s great to see some in-person events becoming possible again. LibreOffice users around the world are welcome to join our project, and help to build up local communities. If there’s no LibreOffice community in your area, drop us a line and we’ll help you to establish one!

LibreOffice IRC channels moving to Libera.Chat

Many projects in the LibreOffice community use IRC (Internet Relay Chat) to communicate. This is a real-time text-based communication protocol that’s popular amongst many free and open source software projects.

We are moving our IRC channels to a new host, Libera.Chat, which is run by a Swedish non-profit organisation. Here’s an alphabetical list of the current channels – for more information, see our wiki:

  • #libreoffice
  • #libreoffice-de
  • #libreoffice-design
  • #libreoffice-dev
  • #libreoffice-doc
  • #libreoffice-fi
  • #libreoffice-fr
  • #libreoffice-gsoc
  • #libreoffice-hackfest
  • #libreoffice-NLP
  • #libreoffice-qa
  • #libreoffice-telegram
  • #tdf-infra

Thanks to everyone who participates in our IRC channel discussions, and keeps LibreOffice moving forward!