50 Open Badges awarded for top LibreOffice translators!

A few months ago, we announced Open Badges for LibreOffice contributors. These are custom images with embedded metadata, awarded to our most active community members to say thanks for their great work!

The metadata describes the contributor’s work, and the badge can be verified using an external service. Open Badges are used by other free software projects, such as Fedora.

Anyway, today we’re awarding 50 Open Badges to the most active members in our localisation community, based on Weblate activity so far this year. Congratulations to everyone who got a badge – we’ve emailed it to you! Here’s the list of winners:

  • Joan Montané
  • Adam Rak
  • jwtiyar ali nariman
  • Paul Roos
  • Mihkel Tõnnov
  • Modestas Rimkus
  • Adolfo Jayme Barrientos
  • Donald Rogers
  • Valter Mura
  • eglejasu
  • Stanislav Horáček
  • Asier Sarasua Garmendia
  • Kolbjørn Stuestøl
  • Dimitris Spingos
  • Xosé
  • Tolmantas
  • Andika Triwidada
  • Baurzhan Muftakhidinov
  • Mihail Balabanov
  • tmtfx
  • Còdaze Veneto
  • Cheng-Chia Tseng
  • Karl Morten Ramberg
  • Christian Kühl
  • Stuart Swales
  • Ming Hua
  • Tuomas Hietala
  • Bachka
  • Andreas Pettersson
  • Yaron Shahrabani
  • Євген Кондратюк
  • Sérgio Marques
  • Jean-Baptiste Faure
  • Jørgen Madsen
  • Michael Wolf
  • gpopac
  • Ayhan YALÇINSOY
  • Miloš Šrámek
  • Milo Ivir
  • Ingmārs Dīriņš
  • Xuacu Saturio
  • Xandru Martino Ruz
  • kees538
  • Rhoslyn Prys
  • Khairul Aizat Kamarudzzaman
  • SteenRønnow
  • Sveinn í Felli
  • Jeanmi2403
  • kompilainenn
  • vpanter

We’ll be issuing more badges in the coming months, so stay tuned to the blog for more…

LibreOffice monthly recap: July 2020 – News, events and more…

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

  • At the start of the month, we announced a Bug Hunting Session for LibreOffice 7.0 RC1. Yes, the next major release is just around the corner! You can still help us to test it before the official announcement, which is due next week…

  • But we’re still maintaining the LibreOffice 6.4 branch, and on July 2, we announced LibreOffice 6.4.5. It includes over 100 bug fixes and improvements to document compatibility and interoperability with software from other vendors.
  • In recent months, TDF and the community have been discussing marketing plans for the next five years. How can we keep the LibreOffice project sustainable in the long term? Volunteers are a huge part of the project and we’re immensely grateful for them, but companies in the ecosystem also write the majority of the source code to implement new features, so it’s important that they prosper too. See the first update and second update.
  • On July 13, we talked to Khairul Aizat Kamarudzzaman about his work in the LibreOffice community, helping with advocacy and marketing. He recently decided to become a Member of The Document Foundation – welcome on board!

  • Speaking of Members, TDF’s Membership Committee has elections coming up. The mission of the Committee is to administer membership applications and renewals following the criteria defined in the Foundation’s Statutes.

  • July 19 marked 20 years of free and open source office suites, as Sun Microsystems announced on July 19 2000 that StarOffice, which it recently acquired, would become free and open source software. This, of course, became OpenOffice, and lives on today in the form of LibreOffice, the most active and developed successor project.

  • With the ongoing coronavirus pandemic, many communities are meeting online, such as the Spanish-speaking LibreOffice community. They had a live broadcast with a series of talks, over six hours, covering translations, migrations and LibreOffice Online.

  • The joint openSUSE + LibreOffice conference will take place in October, and we’ve extended the Call for Papers until August 4. Join us, give a talk about your favourite topic, and let’s share knowledge together!

  • Lastly, we talked to Sandra Louvezo, another new TDF Member, about her experiences in the LibreOffice community in Congo. A big thanks to Sandra, and everyone in our growing LibreOffice communities in Africa, for all their great work.

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!

Tender for implementing support for a dedicated, built-in UNO object inspection tool in LibreOffice (#202007-02)

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 support for a dedicated, built-in UNO object inspection tool in LibreOffice, to start work as soon as possible.

In order to make working with UNO objects easier and to avoid the need to always install extensions before debugging, it is necessary to be able to inspect UNO objects in a running LibreOffice instance effectively.

This task involves reading the existing Basic IDE Watch code, evaluating how it can be improved based on ideas implemented in external tools like xray and MRI and extending the Watch code to be a first-class inspector that allows focusing the relevant part of the UNO API for opened documents and also based on your current selection (similar to what is possible in web browsers).

A good part of the features are implemented already. Work carried out under this tender will therefore mostly consist in making the features more accessible and more stable, adjusting the UI and refactoring things.

The work has to be developed on LibreOffice master, so it can get released in the next major version.


The following required features need to be implemented:

  • Dockable toolbar that can appear at the bottom of a document frame, similar to find-bar.
  • Left-hand side of the toolbar exposes a snapshot of a useful subset of the DOM as a tree view: Writer paragraphs, Calc sheets, Impress slides
    • This tree widget should populate its content on-demand whenever possible in order to ensure performance.
  • Point&click inspect mode (similar to F12 in Chrome): combine Help -> What’s this (point on something & then an action) and normal selection, so it’s possible to point on something (e.g. an image), make it the current selection and automatically launch DevTools on it. Perhaps rename ‘DevTools’ to something else.

    Note that this is mostly UI work, ThisComponent.CurrentController.Selection in Basic already gives access to the current selection in a not-so-convenient way.

  • Right-hand side: show details in a table about the current selected item in the “DOM tree-view”, which is implemented as part of the watch window in the Basic IDE:
    • object’s UNO properties
    • object methods
    • supported services and interfaces
  • User documentation for the new dialog is mandatory.
  • Brief developer documentation for the newly introduced classes is required.
  • Whenever adding new functionality, it should be considered if it’s possible to test the functionality with automated tests with reasonable amount of effort.

The following are optional features:

  • Configuration support: remember which tabpage was open last time (properties, methods, etc.)
    • Remember sorting settings (prioritize paragraphs/sheets/slides and other relevant properties or sort alphabetically)
  • Click on value for details: primitive types
    • This is useful if the user selected lots of text for inspection, we can’t show all the content in a table cell, but can if a multi-line edit replaces the table widget.
  • Click on value for details: re-launch DevTools on a sub-object on the right-hand side. This is already handled to a large degree in the existing watch variable code, which represents the object already as a tree.
    • This allows recursion: double-click on a value with a complex type, which has its own properties, methods, etc -> inspect it.
  • Show implementation name of object
    • If a consistent name is provided by the object, this can allow jumping to the relevant C++ code from DevTools easily.
  • Copy&paste support:
    • Normally content of a table in a widget is not easily copy&paste-able. It can help debugging if add explicit support to copy the table content still, e.g. all property names and their primitive values.
  • Improved presentation of the DOM for Writer/Calc/Impress:
    • The inspector tool could be just a generic presenter for any UNO object, but in practice macro and extension authors are interested in a subset of the extremely rich and generic API we provide.
    • The idea is to select a few key properties for each component, so it’s trivial for the user to see how to access the most important details of a document:
      • Writer: style families, paragraph list, text portion list, etc.
      • Calc: sheets, columns, cells, named ranges, etc.
      • Impress: slides, shapes, etc.

Required skills

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

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.

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.
Further discussions on this tender took place on the public board discussion mailing list of The Document Foundation.

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 (incl. optional tasks) to take in the region of 60 days of work. Bidders are free to bid on the required features only. Bidders who bid on both the required and optional features are asked to provide a breakdown in terms of costs for each.

TDF is looking forward to receiving your applications for one or more of the aforementioned tasks, your financial expectations and the earliest date of your availability, via e-mail to a committee at tender20200702@documentfoundation.org no later than September 1, 2020.

Applicants who have not received feedback by October 15, 2020 should consider that their application, after careful review, was not accepted.

Community Member Monday: Sandra Louvezo

Today we’re talking to Sandra Louvezo, who is helping to spread the word about LibreOffice and FOSS in Congo. Also, she recently became a Member of The Document Foundation, the non-profit entity behind LibreOffice…

To start with, tell us a bit about yourself!

I was born on August 31, 1984 in Pointe-Noire, the economic capital of Congo-Brazzaville. I achieved a BAC+3 in Human Resources Attaché at the Magrebin Institute of Science and Technology in Tunis, Tunisia (IMSET) in 2008.

Then I returned to Congo in 2009, where I worked for five years in local companies as an Accounting Assistant – Claims Writer – Head of Life and Health Insurance services at the Huet de Baroquer group, under the H branch in B Congo Insurance. Then I was Director of Human Resources in a service subsidiary and provision of Health, Safety and Environment (HSE) staff for two years.

For the past two years, until now, I have started my own business as a motivational and personal development coach, as well as a nutritional coach and caterer.

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

In Pointe-Noire I belong to a community called “Librists”. Our goal is to help people discover the world of open source software here in Congo – which very few people know about. I am responsible for training people to use the LibreOffice suite, and we have named the training “SPRINT”, which lasts 60 days per component starting from Writer, Calc, Impress etc.

The aim of this sprint is to help users learn the applications, and get their comments, to then bring back to the LibreOffice Francophone community, to which I also belong. Then we can continue to improve LibreOffice.

Why did you decide to become a member of TDF?

I decided to become a member in order to raise awareness, mobilize people, and bring LibreOffice to my country and Africa in general. Discovering LibreOffice and open source was a delight for me, and I want to teach others this life lesson: contribute back to open source, and help make the world a better place.

Anything else you plan to do in the future?

I am training to prepare the next SPRINT, which will start from the end of July to the beginning of August 2020 in several African countries such as: Congo Brazzaville, Cameroon, the Democratic Republic of Congo, Togo, Senegal and Benign. For 60 days, users will learn to use and discover LibreOffice Writer in the form of exercises, and the answers will be returned at the end of ech day.

The goal is to be present, so that each African country discovers LibreOffice and builds a mini community around it, before we start to offer the application to the different companies that have everything to gain from using it.

Thanks to Sandra for all her contributions! Our native language communities are always open for more help – so if you want LibreOffice and its website localised in your language, give us a hand!

Annual Report 2019: Social media and video channel

(Note: this is a section from The Document Foundation’s Annual Report 2019, which will be published in full very soon.)

Social media

In January 2019, our Twitter account had 22,907 followers; by the end of the year, we had grown this to 28,775. Our most popular tweets were for major releases, but we also produced some campaigns, such as “NO” in August. Accompanying the text “Don’t get trapped by your office suite”, this tweet included an image with a striking “NO” next to “registration, forced payments and vendor lock-in”. The tweet gained over 80,000 impressions, thanks to likes and retweets, while our community translated the graphic.

In April, we joined Mastodon, a Twitter-like open source, federated and self-hosted microblogging service. Fosstodon – a Mastodon server set up specifically for free software projects – kindly accepted our request for an account, so we set up this account and started posting content, often more focused on technical users, compared to our tweets and Facebook posts. By the end of the year, we had over 3,100 followers, and have been engaging with other users who have questions and suggestions.

Our Facebook page growth was smaller, from 54,045 page likes to 55,985, and on April 2, Google officially discontinued its Google+ service. We had over 16,000 followers at the time, but that number had gradually been reducing, as most users had been aware for many months that Google was closing the service for personal accounts.

Throughout the year, we investigated tools to automate and enhance our use of social media. For instance, we set up PostPickr to automatically tweet prepared messages and graphics at regular intervals.

YouTube channel

Our YouTube channel grew from 7,231 subscribers and 1,147,772 video views in January 2019 to 9,351 subscribers and 1,544,818 video views by the end of the year. The “LibreOffice 6.2: New Features” video amassed over 100,000 views:

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.

…while the video for LibreOffice 6.3 had over 70,000:

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.

Meanwhile, our community helped out with tutorial videos – in particular Harald Berger of the German community, who produced a series of professional-looking step-by-step guides to installing and using Libreoffice.

Thank you

TDF would like to say thank you to the many native language social media groups, organised by local communities that support LibreOffice. They are really helping to spread the word around the globe.

If you find LibreOffice useful, support us with a donation so that we can continue to build our community, share knowledge, and improve LibreOffice for everyone!

LibreOffice Tips & Tricks: Converting 4:3 Slides into 16:9 Slides

(clicking on the image will open a large view of the same)

Today, the majority of screens and projectors is using the 16:9 aspect ratio, while in the past has been using the 4:3 aspect ratio. So, many people have a large number of slide decks based on the old 4:3 aspect ratio, which have to be converted to the new 16:9 aspect ratio. Using LibreOffice Impress in the right way, which means that all slides are based on a slide template, the conversion procedure is rather trivial, and this blog post provides a step by step tutorial.

Of course, we start by opening the old 4:3 slide deck, and switching to the Slide Sorter view. We select all slides using the Edit > Select All menu command, and then we copy all slides using the Edit > Copy menu command.

 

 

To create the new 16:9 slide deck, we use the File > New > Templates… menu command. From the Templates window, which opens on top of the 4:3 slide deck, we select a 16:9 template. In this case, we will open the “tdf-greenliberation” template on the lower right corner of the Templates window.

 

 

 

The new 16:9 slide deck will open showing the title slide, but we will switch to the Slide Sorter view to paste the 4:3 slides.

 

 

 

You have to select one of the slide thumbnails before using the Edit > Paste menu command.

 

 

 

A dialog windows will show up almost immediately, asking if you want to scale the objects to reflet the different slide size of the target document. The answer is NO.

The result will be the following. All the pasted 4:3 slides will now have the 16:9 aspect ratio, but the slide master will still be the old one. This is expected, so no need to panic.

 

 

 

Using the Master Slides section in the Sidebar, and right clicking on the template of choice, you can change the aspect of all slides at once.

 

 

 

Using the same procedure, you can change the aspect of individual slides to reflect specific needs. For instance, this is the tile slide after the Title Master has been applied.

 

 

 

Some slides will still need some specific tweaks to make their aspect compatible with the new slide master. For instance, the size of this text has to be reduced to avoid overlaps with slide master elements.

 

 

 

Of course, all visual elements have to be resized, as they will use more vertical space than allowed by the 16:9 aspect ratio, or moved, to maintain the visual appearance.

 

 

 

Once all slides have been edited, this will be the final result. Believe me, it takes more time to describe the process than to apply it to a slide deck.