TDF Annual Report 2020

The Annual Report of The Document Foundation for the year 2020 is now available in PDF format from TDF Nextcloud in three different versions: low resolution (4.7MB), medium resolution (18MB) and high resolution (24.7MB). The annual report is based on the German version presented to the authorities in April.

The 54 page document has been entirely created with free open source software: written contents have obviously been developed with LibreOffice Writer (desktop) and collaboratively modified with LibreOffice Writer (online), charts have been created with LibreOffice Calc and prepared for publishing with LibreOffice Draw, drawings and tables have been developed or modified (from legacy PDF originals) with LibreOffice Draw, images have been prepared for publishing with GIMP, and the layout has been created with Scribus based on the existing templates.

All pictures are licensed under the Creative Commons Attribution-Share Alike 4.0 License, courtesy of TDF Members from all over the world. Stock photos are CC0 by Pixabay.

Lothar Becker, Chairman of TDF Board of Directors, has written in the welcome address:

You will learn that our jubilee year was one of the most successful in our history. With all activities that took place, despite the situation that we could rarely meet in-person, it is really really incredible how the local communities and all supra-national activities carried on. And furthermore we grew in every aspect: our community base has more contributors than ever, and we had an impressive number of releases of LibreOffice, with a lot of code contributions – especially for the new major release of LibreOffice 7.0. And last but not least, the financial report of the foundation shows a year better than ever.

Certainly, we also had some shortfalls last year, starting with the lack of personal meetings and the consequences in the relationships between members – but also with changes and moves in the community and its ecosystem within. And let’s not forget the members of the community who suffered from bad health because of the pandemic situation. But overall, we could feel lucky and proud coming out of this year strengthened as described in this annual report. For all shortfalls, we are working hard in all TDF bodies (the Board, the old and new Membership Committee, the Advisory Board, the team led by Florian Effenberger), with the whole membership as well as national and international parts of the community.

So for all these activities, code and non-code contributions, personal engagements and donations we truly say a big THANK YOU, thank all of you for being with TDF in such a special year for every one of us.

Tender to implement the new TDF Membership Committee’s web-based tooling (#202105-01)

Introduction

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

The main activity of the Foundation’s Membership Committee (MC) is to administer membership applications and renewals following the criteria defined in the Foundation’s statutes.

Tender description

We are looking for an individual or company to implement the new TDF Membership Committee’s web-based tooling.

The tasks consists of developing and implementing this tooling. All of the mentioned features and requirements are explained in detail in the provided document “MC tooling specifications”, which is to be considered a part of this tender. The document lists which items are a part of the deliverables and therefore have to be part of the bid.

Note that this tender also contain some optional items, which are marked respectively. All items that are not explicitly marked as optional are to be considered mandatory.

The solution we seek, and as such the scope of this tender, is to implement the new TDF Membership Committee’s web-based tooling that will support the Membership Committee during the daily business.

Decision criteria

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.

Amongst the decision criteria for the bids are qualification, references, price, and completeness of fulfillment, as well as documentation. We expect bidders to provide documentation on the code, optionally also on the system administrator part.

Requirements

We prefer the use of a secure programming environment. As such, we strongly prefer Python/Django or Ruby on Rails over PHP. The use of server-side Java has to be discussed with TDF’s infrastructure team before bidding. In order to do so, please get in touch with us using the e-mail address below.

We strongly prefer the use of FOSS software and libraries, i.e. for DBMS, crypto and mailing.

The delivered software, code, documentation and all associated parts shall be published under an OSI approved license (see https://opensource.org/licenses) with TDF as owner of the copyright as well as all transferable rights. TDF intends to make the deliverables available to the general public.

Proposed milestones

Milestone #1 – Defining of the architecture; initial prototype with testing and knowledge sharing (with the Membership Committee) about the new solution; usability improvements. Main process elements like voting are tested and work fine. Implementation of the database and the management back-end user interface to interact with it. Import of member information from the old database.

Access to the current production database can be granted to the successful bidder after signing a privacy and non-disclosure agreement. Otherwise, and less preferred, a database with anonymized sample data will be provided.

Milestone #2 – Handling of a new request to become a member of TDF.

Milestone #3 – Have the membership renewal process working.

Milestone #4 – Move the full daily work of the membership committee to the new platform; all voting can be done directly with the new platform. The implementation of reporting and mail system must be completely functional for:

  • Receipt of application
  • Mail for accepted applicants
  • Mail for denied applicants
  • Mail for pending applicants
  • Quarterly report on accepted members in English
  • Quarterly report on accepted members in German

Milestone #5 – Implement and test:

  • Reminders for MC members
  • All time-triggered jobs
  • Quarterly report as CSV file
  • Database integrity check by checking the signature and re-reading this file
  • Deleting of obsolete records cleanup

Required skills

  • Extensive knowledge of Python/Django or Ruby on Rails
  • Extensive knowledge of front-end and back-end development of web-based applications
  • Extensive knowledge of design and implementation of accessible web-based applications
  • Experience in working on open source projects

Other skills

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

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.

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.

TDF is looking forward to receiving your applications for the aforementioned tasks, your offer in form of a fixed-time, fixed-budget approach, and the duration period for the implementation in calendar weeks of the mentioned milestones after the final awarding of the tender, via e-mail to a committee at tender20210501@documentfoundation.org no later than June 23, 2021.

Applicants who have not received feedback by July 21, 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 11, 2021. Questions can be sent informally to the above e-mail address, and answers will be made public in a collected and anonymized form.

Projects selected for LibreOffice in the Google Summer of Code 2021

In March, we announced that LibreOffice will be participating in the Google Summer of Code (GSoC), a programme that connects students with free and open source software projects. GSoC helps students to implement new features, and provides them with financial support along the way.

Well, the projects have been selected, so here they are!

  • Bayram Çiçek – 100 Paper Cuts: This aims to improve LibreOffice’s user interface, implementing enhancement requests and solving the most annoying UX (user experience) issues.
  • Anshu Khare – Sidebar: It’s planned to revamp the current styles deck sidebar and to merge paragraph and character styles into one Text Style deck. Furthermore, the student wants to rework the filter workflow. Here’s a mockup (click for larger):

  • Tushar Kumar – Implement an interface for external data source import in Calc: Currently, Calc’s back-end data provider supports CSV, HTML, XML and and Base’s data provider. This feature is not yet ready for production, however, so this project’s goal is to improve it. Here’s a mockup:

  • Balázs Sántha – Implement table styles in OOXML (.docx) support: At the moment, table styles found in .docx documents are converted into direct formatting at at Writer’s core level. This project aims to take a step towards a solution for handling proper table styles.

  • Panos Korovesis – Make the SVM format independent of the VCL metafile + tests for the format: This requires the completion of the tests regarding SVM, and then the separation of the read and write functionality of MetaActions to new distinct classes.
  • Akshit Kushwaha – Tests for the VCL graphics back-end: Add more test cases to the pre-existing tests, running those tests in every back-end, and implement a usable UI for the users to test the graphic’s feasibility themselves. This should make graphics rendering smoother.
  • Shubham Jain – Write missing unit tests: Extend the tests in Libreoffice. There are currently more than 1300 bugs fixes which do not have tests written for them, so this project aims to bring down that number.

Good luck to all the students – we appreciate their work on these important features and improvements! And thanks to our mentors for assisting them: Heiko Tietze, Xisco Fauli, lmari Lauhakangas, Olivier Hallot and Christian Lohmeier (The Document Foundation); Tomaž Vajngerl, Muhammet Kara, Luboš Luňák, Miklos Vajna and Mike Kaganski (Collabora); Thorsten Behrens (allotropia); László Németh and Markus Mohrhard.

From August 16 – 23, students will submit their code, project summaries, and final evaluations of their mentors. Find out more about the timeline here, and check out more details about the projects on this page.

Community Member Monday: Hüseyin GÜÇ

Today we’re speaking to Hüseyin GÜÇ from our Turkish community, who’s helping with translations and spreading the word. Last year, he updated us on a LibreOffice migration in a municipality in Turkey.

Tell us a bit about yourself!

I’m a passionate administrator and open source enthusiast, starting my career 26 years ago. I live in Istanbul, and enjoy keeping myself up to date with the latest in the open source world, and trying out the latest tools, features, and services around Linux. In my spare time, I participate in the Turkish translation of open source applications.

You recently decided to become a Member of The Document Foundation, the non-profit behind LibreOffice. Tell us about that…

I want the OpenDocument Format and LibreOffice application to be used in my institutions and city. For this reason, I wanted to support The Documentation Foundation individually.

Also, I am here because I think the LibreOffice community has a differentiation from other open source communities. You can install and use open source applications, but there is a need for the OpenDocument Format to become widespread in order to use the produced output.

Here, I want to be a part of this dissemination and I believe that there will be an opportunity for this. Open source usage in Turkey is not at the desired level yet. In addition, it is very sad that many individuals and institutions are unaware of the OpenDocument Format and LibreOffice. I want to strive to eliminate this problem.

Many thanks to Hüseyin for his contributions! Learn more about the Turkish LibreOffice community here. And if you want to spread the word about LibreOffice in your area, join our marketing community – we can help you!

The LibreOffice Calc Guide 7.1 is Here!

The LibreOffice Documentation community announces the immediate availability of the Calc Guide 7.1, with additions based on the the improvements in LibreOffice Calc 7.1, which was released in February this year.

Download Calc Guide 7.1

The Guide is the volunteer effort of many members of the documentation community. Revisions and enhancements on the contents are the work of Rafael Lima from Brazilian community, Martin Van Zijl and Kees Kriek from the Dutch community, Celia Palacios from the Hispanic language community. A special mention to Yusuf Keten from the Google Summer of Code program on new extensions and templates dialogs, to Steve Fanning for his editorial review and to Jean Hollis Weber for her improvements and organization of the text. The LibreOffice Calc Guide 7.1 update activities was coordinated by Felipe Viggiano from Brazil.

Celia, Jean, Kees, Steve, Rafael, Felipe

The book is available in PDF format and contains 545 pages, covering all basic and advanced features of the spreadsheet module of LibreOffice, and is a must-read book for exploiting the maximum of LibreOffice Calc.

Download the Calc Guide 7.1

LibreOffice Design Community Work in 2020

Design has been one of the major focus points of LibreOffice in the last few years, and has produced new icon sets and a number of incremental updates to the user interface – menus, toolbars and the SideBar – and the creation of the brand new NotebookBar…

(This is part of The Document Foundation’s Annual Report for 2020 – the full version will be posted here on the blog soon.)


Improvements in LibreOffice 7.0

Icon Themes

A new Sukapura icon theme, based on Apple’s color palette as defined in macOS Human Interface Guidelines for Visual Design, was developed to become the default on macOS. The Sukapura icon theme is based on the Colibre icon theme and developed to fit macOS desktop environment in mind. (Added by Rizal Muttaqin)

The Colibre icon theme was adopted as default for the Windows operating system was refreshed based on the new Monoline style iconography implemented by Microsoft Office 365. The goal of the Monoline style is to have a consistent, clear, and accessible iconography to communicate action and features with simple visuals, ensure the icons are accessible to all users, and have a style that is consistent with those used elsewhere in Windows. (Rizal Muttaqin)

Sifr was polished and updated, with fewer icons falling back to Breeze or Colibre, while the unmaintained Tango icon theme was removed from core, but is still available as an extension. (Rizal Muttaqin, Heiko Tietze)

Dialogs

The Windows Installer was updated with new icons and images, based on LibreOffice 7.0’s visual theme. (Bayu Rizaldhan Rayes, Rizal Muttaqin, Muhammad Rivan)

Impress Presenter Screen

The Impress Presenter Screen shows on the personal computer or laptop screen when the presentation is projected on a second screen or a projector. The screen shows both the current and the next slide, plus optionally the speaker notes, plus a timer and some presentation controls such as arrows to go back and forth.

The visual appearance of the screen was refreshed, according to the user interface design. The extra white border pixel in the box was removed as well as the blurred shadow, while the background has been darkened to make the icons in the bottom bar more visible.

Three buttons were added: the first two to pause and resume the timer, which are useful to get the complete control on the timing of the session which was missing in the past, and a third to exit the Presenter Screen, in addition to the Esc button used in past versions. (Rizal Muttaqin)


Improvements in LibreOffice 7.1

Icons

The Elementary icon theme has been updated to be more consistent with Elementary branding colors, which are named after natural elements such as fruits. (Rizal Muttaqin)

Dialogs

LibreOffice offers several User Interface options, from the traditional one based on Toolbars and Menus, with Sidebar, to the different NotebookBar alternatives, which are more familiar to users migrating from proprietary solutions. To help users choose the best User Interface for their preferences or habits, a new dialog window was added to select the UI during the first start. (Heiko Tietze, TDF)

NotebookBar

A new widget providing styles preview was added to the tabbed NotebookBar. (Szymon Kłos, Collabora)


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!