Best Wishes from TDF

Dear community members, TDF members, Advisory board members, team members, membership committee and board!

Another year marked by the global pandemic is coming to an end these days. In addition to all the depressing news and circumstances that affect us all, there are also pleasing and uplifting developments.

Apart from the painfully missed opportunity to meet in person, be it in the local communities or at our annual conference, we have nevertheless achieved so much together, worked together and brought our foundation forward, so that we can already say that it was one of the most successful years for and with our project.

I would like to thank all of you on behalf of our project. Everyone has contributed to the success story in different ways. All the contributions intertwine, and without these individual parts the whole thing would not be possible and so successful. Especially in these times. Thank you very much again for this.

And it is precisely this commitment, this proof of the resilience of our project during this time, that allows me to look to the future with good cheer. Please continue to support our community in so many ways in the coming year, every contribution is needed.

After two very intensive and busy years, I myself will say goodbye to the board, but after a short phase of rest, I will continue to work with you in the project in one or two different places again. I wish the newly elected board all the best!

I wish you and your beloved ones a few days of recreation at the end of this year and a stable good health for the next one.

Thanks again and hope to see you all with your contributions in the new year again,

yours
Lothar Becker
as chairman of the board

2021: The Year the LibreOffice Documentation Team Shined

Seasons Greetings

2021 is ending, so let’s recap our achievements and look forward for 2022. It has been a very tough year for all of us in our professional or personal matters, and for sure worsened by the persisting pandemic, even with the release of the COVID vaccines.

But this year was a great documentation year after all. We closed the gap between the LibreOffice major releases, and the update of the corresponding User Guides. By the year end, we will have all of our version 7 guides updated to the LibreOffice release 7.2, and ready to continue for the forthcoming release – 7.3 – due in early February 2022. The goal of tracking the software release closely was achieved, and now we are in a steady state of small updates between releases.

The updates and enhancements of the guides was an effort of all the team, coordinated by Jean Weber (Writer and Getting Started Guide), Steve Fanning (Calc and Base guides), Peter Schofield (Impress and Draw guides), Rafael Lima (Math guide). A number of volunteers also worked in each guide by writing and reviewing contents and suggesting improvements. A special thank to Jean Weber for making the guides available for sale on paper by Lulu Inc. The sad note of the year was the passing of Drew Jensen, a prominent member of the LibreOffice community for many years, and a documentation volunteer.

Coordinators

In the last quarter – thanks to The Document Foundation’s budget – some master documents bugs were fixed under contract by Michael Stahl of Allotropia, and now we can safely assemble our guides with master documents, and produce PDFs with hidden sections and correct navigation indexes in PDF readers.

Our documentation community also had a nice contribution of Jean Pierre Ledure, Alain Romedenne and Rafael Lima, for the development of the ScriptForge macro library, in synchronization with the much-needed Help pages on the subject, a practice rarely followed by junior developers of LibreOffice. As we know, undocumented software is software that’s lacking; features that are unknown to the user can be a cause of costly calls to the Help Desk in corporate deployments. ScriptForge developments came together with its documentation, a proof of the ScriptForge team’s professional maturity.

Special thanks to Steve Fanning for his leadership of the Calc Functions wiki pages maintenance. The wiki pages were initially developed by Ronnie Gandhi in 2020 under the Google Season of Docs programme, and are now run by Steve, providing richer content about the functions, with better descriptions, new examples, and other reference information. The in-depth review of the Calc Function wiki pages gave very good feedback for the Help pages, which also lead to Help improvements. The Calc functions wiki pages are available for translation, thanks to the dedication of Ilmari Lauhakangas.

Very important as well: we also had a team of Help page bug smashers, closing Help documentation bugs and gaps, fixing typos and improving quality, a must-have update to keep LibreOffice in-shape for its user base. Our Help pages, which are part of the LibreOffice code, have also been refactored continuously for better maintenance and code readability. The L10N team of volunteers (localization and translators) were quick in flagging typos and English mistakes – while translating the Help and the User Interface.

In 2021 we also launched the LibreOffice bookshelf, another download page for LibreOffice guides that, different from the current documentation.libreoffice.org server page, the bookshelf can be cloned and installed in organizations, libraries, colleges and schools, for immediate availability in controlled environments, as well as online reading of the guides. The ODF chapters were transformed into static HTML pages and are ready to display on computers, tablets and cell phones, bringing LibreOffice user guides closer to its public, anywhere, anytime. The conversion process is extensive and has been addressed in the LibreOffice 2021 Conference. It was also extended to the Portuguese translation of the guides, and can easily extended for other languages. Note: converting ODF documents into web pages is far beyond a simple export to HTML.

2022

For 2022, besides keeping the guides updated with the software releases and our wiki pages, we can elaborate on new projects and enhancements.

In the last couple of years, from reading users’ questions and feedback on TDF’s communication channels (mailing lists, Telegram channels, Ask LibreOffice and more), it became clear that the user community is permanently asking for support in writing macros for automating documents and converting from other suite macros. This calls for a new guide, probably a Scripting Guide for which contents shall address the use of the scripting languages by the casual user. The project is under construction and is open to editorial guidelines.

Scripting Guide

In the same direction of script documentation, the LibreOffice API documentation – created by automated tools – is excessively directed at skilled programmers, and falls short in readability, especially for the casual macro programmer. The project under construction is to illustrate the API pages with code snippets, as much as possible – a task suitable for newcomers and would-be programmers.

The bookshelf project shall be enhanced with new guide releases, new languages, and also demand for upstream control of the guide chapter formatting. Under discussion in the documentation team call meetings, it is interesting to write some sanity checks scripts for chapters compliance to the template, remove of unlisted styles, cleaning of direct formatting, object anchoring and more. These checks are important because the same visual output can be the result of very different techniques.

Portuguese bookshelf

Seasons Greetings!

LibreOffice has been awarded the Editor’s Pick badge by Software Informer

This is Software Informer’s editor rating.

Work with document files either imported from programs like MS Word, Excel and other office tools or created natively in formats like ODF or PDF compatible with modern and open standards. Editing, copying and incorporating data in databases is possible.

LibreOffice is an open-source free alternative to heavy commercial office suites like MS Office. While having generally the same functionality, LibreOffice is more open to modification and updates, making it a more attractive suite if you want a comfortable and adjustable tool for working with documentation.

LibreOffice consists of several tools capable of working with documents of any type, from standard Word files and Excel tables to presentations and Publisher files. There’s a word processing and desktop publishing tool called Writer; spreadsheet program Calc; tool for creating effective multimedia presentations called Impress; a sketching tool named Draw; database manager Base; formula editor Math; advanced chart and diagram creator Charts. Every tool has all the features of an advanced editor for the kind of files you could work with. The tools work stable and fast, they are easy to use even if you’re not an experienced user of office tools.

LibreOffice adds several unique features into its programming, such as the support for ODT documents and the ability to incorporate various plugins and extensions. You can always add new templates for various documents.

Open-source tools sometimes disappoint by being attempts to copy a licensed product. LibreOffice is different in that, it’s a genuinely good product itself.

Two ODF Toolkit releases in a row!

ODF is the Open Document Format, the native format used by LibreOffice (and supported by many other apps too). Then there’s the ODF Toolkit, a set of Java modules that allow programmatic creation, scanning and manipulation of ODF files. Svante Schubert writes with some updates:

We are happy to announce that there have been recently two ODF Toolkit releases in a row. These were our first releases at The Document Foundation (TDF), after the migration of the project to TDF in 2019:

  • With the 0.9.0 release, we have our last JDK 8 release (due to a switch of the Java Doc Taglet API we are using). After this release, we dropped the so-called “Simple API” (which was once forked from our ODFDOM doc Java Package by IBM, but not merged back, leaving lots of duplicated code that was unable to embrace our new change API). And the XSLT Runner Ant plugin will be removed in a future release, as we are no longer using Ant but Maven (to avoid maintenance of untested functionality).
  • With the 0.10.0 release, we support the next JDK 11 LTS version and our new change API that was implemented by myself for Open-XChange’s web office OX Documents – thanks to them, especially Malte Timmermann and Rafael Laguna for keeping the Apache License 2. Unfortunately, OX forked before I started there and it took me several months – and some sponsorship from a PrototypeFund project – to merge manually every file and enable all tests again (which some OX colleagues had disabled as they took too long…). (Please check out the PrototypeFund: Any German taxpayer may apply with an open-source project/idea!).

I would like to thank also all those numerous folks assisting us to make this work – especially recently in pushing this forward!

Especially, I would like to congratulate Michael Stahl for officially becoming the co-maintainer of this project. Michael has been my long term colleague (from StarOffice Hamburg times) and helps me constantly drop procrastination and/or fix issues I am no longer capable to realize as I looked too long at them. In addition, Michael and I also serve as editors of the OASIS ODF TC. There at the ODF TC, we envision having a faster turn-around of ODF spec deliveries and making their information set more readable for downstream software as we are. Thanks to allotropia software GmbH, Michael’s employer, for providing him with the time for working on these tasks!

So what’s next? Obviously, it’s more than time to release an ODF Toolkit 1.0.0.

Personally, I would like to get the code generation right, but keep as much compatibility to prior releases as possible. Michael and my aim is to work from the end of January on this release (any helping hand is most welcome) 😊

There is also ODF 1.3, to be embraced by a release in the near future.

In February, I will likely have an online talk at FOSDEM, at the LibreOffice dev room about our project and what I intend to do next year.

In a nutshell, I was able to receive some NGI Search funding for this project to enable search in ODF documents.

Aside from the obvious search API – focusing on one higher-level based on user semantic and likely having also one lower-level based on XML, I would like to refactor my “spaghetti feature code” in the SAX parser that made the implementation of the changes hard to maintain. Sorry for that, not my first and likely not my last mistake – but I am learning! 🙂

We’re going to work out a more elaborate picture for the FOSDEM presentation.

Until then, have fun with the ODF Toolkit!

PRELIMINARY results of the elections for the next Board of Directors at The Document Foundation

TDF Membership Committee announces the PRELIMINARY results of the elections for the next Board of Directors at The Document Foundation.

The number of TDF Members who voted is 120, from a total amount of 211 eligible voters. This means that 91 TDF Members did not vote. The Membership Committee would like to thanks all the voters, as the elections are the most significant time of the year for TDF Members, because they can decide about the project’s governance.

Based on the PRELIMINARY results, the following candidates are elected as members of TDF Board of Directors, in order of preference:

Full Members:

  1. Thorsten Behrens
  2. Paolo Vecchi
  3. Jan ‘Kendy’ Holešovský
  4. Emiliano Vavassori
  5. Caolán McNamara
  6. Cor Nouws
  7. László Németh

Deputies:

  1. Gábor Kelemen
  2. Ayhan Yalçınsoy
  3. Gabriel Masei

Results were calculated using the same tooling and rules of previous elections, based on the single transferable vote (STV) voting system and the Meek algorithm (https://en.wikipedia.org/wiki/Counting_single_transferable_votes). The software used is OpenSTV (https://github.com/Conservatory/openstv).

The Membership Committee agreed on the ranking of the first six candidates, but is still discussing about the last four candidates.

Unfortunately, given that there are 10 candidates and 10 seats, OpenSTV 1.7 does not provide more than one round to rank all candidates that have not reached the threshold, and considers all candidates as elected. For more details, see: https://elections.documentfoundation.org/results.php?election_id=14. The Membership Committee will investigate this further, and will update TDF Members and the general public as soon as possible.

Before the results can be considered as final, we have the challenge phase from Wednesday, December 15, to Monday, December 20, at midnight CET (UTC+1).

TDF Members are invited to check their votes as explained after the voting, by using the anonymous token received at that time (each voter has received a different token, and is the sole owner of that token). Election results to verify are available here: https://elections.documentfoundation.org/votes.php?election_id=14.

If you have any questions or if you think that there were irregularities during the vote, please get in touch with the Membership Committee AS SOON AS POSSIBLE, and in any case no later than Monday, December 20, at midnight CET (UTC+1), using the email address elections@documentfoundation.org.

For reference, details of the whole election process have been outlined in the first announcement: https://listarchives.tdf.io/i/tFJzSYUUGcSjf0c0NtNiEOou.

Record number of LibreOffice downloads

The chart says it all! Last week, we had a record number of downloads for LibreOffice in a single week. More and more people are discovering the free and open source office suite, the successor to OpenOffice, that respects users’ privacy and freedom.

Downloads have been growing steadily over time, and one week ago we released an important security update, so we recommend downloading it, if you’re using an older version.

Thanks to everyone in our wonderful worldwide community for all their help! It’s thanks to you that LibreOffice keeps going from strength to strength. Let’s keep spreading the word together 👍