LibreOffice 7.2: A week in stats

One week ago, we announced LibreOffice 7.2, our brand new major release. It’s packed with new features, and has many improvements to compatibility and performance too. So, what has happened in the week since then? Let’s check out some stats…

473,308 downloads

These are just stats for our official downloads page, of course – many Linux users will have acquired the new release via their distribution’s package repositories.

44,814 Tweet impressions

The announcement Tweet was viewed almost 45,000 times, and had 418 likes and 187 retweets. We’re also on Mastodon, a FOSS-friendly federated microblogging service: our Mastodon toot had 48 likes and 45 shares. Meanwhile, the Facebook post reached 7,604 people, with 297 reactions and 32 shares.

15,156 video views

Our LibreOffice 7.2 New Features video has been popular, with 57 comments and 522 likes. (We also uploaded the video to PeerTube, an open source, decentralized and federated video platform.)

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.

1077 upvotes on Reddit

As always, we posted the announcement on the /r/linux subreddit, where it had 1077 upvotes and 161 comments. We also have our own dedicated /r/libreoffice subreddit – check it out!

A huge thanks to our worldwide community of volunteers, and certified developers, for all their work on this release!

Community Member Monday: Jessé Moreira

Love LibreOffice too? Want to help us spread the word about it, and other free and open source software (FOSS) projects? Then we appreciate your help! Everyone can raise awareness about the importance of FOSS and open standards, like the OpenDocument Format, LibreOffice’s native format.

For instance, Jessé Moreira from the Brazilian Portuguese LibreOffice community has created a set of tutorial videos. Here’s what he has to say:

Hello! I am a high school math teacher. I love LibreOffice and make videos demonstrating educational software applications. I have a channel that talks about libreoffice in Portuguese on Odysee and YouTube.
I intend to continue promoting LibreOffice by recording videos and contributing to the incredible project. Greetings from Brazil!

Thanks, Jessé! We have more videos created by other community members too. Recently, we talked to Harald Berger from the German community about how he makes his tutorials. To anyone reading this who also wants to contribute videos in their language, drop us a line and let’s work together!

And one more thing: Jessé recently became a Member of The Document Foundation, the non-profit entity behind LibreOffice. This means that he can help to steer the project and vote for the Board of Directors, amongst other things. All LibreOffice contributors are welcome to become Members and help us to keep doing awesome things:

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 flyer for schools and universities: extra design

Our LibreOffice New Generation project aims to bring new – and especially younger – contributors into the LibreOffice community. Earlier in the year, we created a flyer for schools and universities, and we’ve sent out printed versions to many people around the world.

Now, here’s an alternative design, thanks to Rizal Muttaqin and the Indonesian community! Click the image to get the original SVG file, if you want to make updates and translations (Vegur font required). And if you’d like some printed flyers to hand out in a school or university, drop us a line and let us know

Translations

Annual Report 2020: Attracting new contributors to LibreOffice

Bringing new community members on board and helping them get started is an essential part of our work. Here’s what we did in 2020

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


Onboarding tools and sites

Joining a large and established project like LibreOffice can be daunting for many. The software has a large codebase, and its sub-projects use a wide array of tools. In recent years, we’ve made efforts to simplify the onboarding process by linking more services together with SSO (single sign-on), thereby reducing some of the complexity. In addition, we’ve created Easy Hacks and similar “bite size” projects in other areas, so that newcomers can get involved quickly and achieve something – without months of work.

Currently, we have two websites that function as starting points for new contributors: What Can I Do For LibreOffice and Get Involved. The former was set up by LibreOffice’s Albanian community, and lets users click through topics of interest, until they find something they want to do. The latter is a regular page, with a list of sub-projects inside LibreOffice, and quick steps to make initial contact.

Throughout 2020, we posted regular “Community Member Monday” interviews on this blog. In many cases, we emphasised how these contributors started off as regular LibreOffice users, but wanted to “scratch an itch” and start to make changes to the software. We highlighted the ways in which other community members helped newcomers to start working on projects, and used these as “success stories” on our social media accounts, encouraging others to make the step-up from being a user to an active contributor.

Volunteer platforms

Also in 2020, we used a number of online volunteering platforms to “recruit” new community members. These are websites which link people who are keen to volunteer with projects that may interest them. Users can browse organisations and projects in their country/region, see the list of open tasks, and then get in contact. We found that many people were volunteering because they wanted to do something for the public good, outside of their work – while others were looking to bridge gaps between jobs.

We set up accounts and listed projects on various volunteering platforms, including VolunteerMatch and Idealist (English), Vostel (German), Vapaaehtoistyo (Finnish), TuDu (Polish) and HeroClan, Um sem um tam and Zapojim se (Czech). Here’s what our projects look like on VolunteerMatch:

In terms of results, we received messages from various volunteers throughout 2020. For instance, one person reached us via Idealist and expressed interest in helping out with the LibreOffice website redesign. Although he didn’t have time to contribute in the long run, he introduced us to Christine Louie who took the redesign efforts further, and started to work (with other volunteers) on design concepts, user profiling and other tasks. So this was an example of a volunteering platform creating a network of helpers.

In the German community, we were contacted by Sabine Achilles who offered to help out with translations of the software and website content. She worked on translating various blog posts from English to German, which we posted on our German blog.

In 2021, we continue to explore other volunteering platforms. Ilmari Lauhakangas, responsible for Development Marketing at TDF, also schedules interviews with new contributors to give them personal contact from the start, and explain our tools and processes.

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!

Design the LibreOffice Conference 2021 logo!

Our next LibreOffice Conference will take place from September 23-25, 2021 (and it’ll be online, due to the ongoing pandemic situation). LibreOffice developers, supporters and users from around the world will share their work, ideas and suggestions. And we’ll have fun with online social events and more!

But we need a logo. For last year’s conference, we had a competition and Kukuh Syafaat from Indonesia won with this great design, which includes the openSUSE logo too, as it was a joint conference:

So, got some ideas for this year’s conference? We’d love to see them – please send them to us! And also check out the rules below. Deadline is July 27 – please send your design to mike.saunders@documentfoundation.org with the subject line “LibreOffice Conference 2021 logo submission”. The conference organisers will select the winning logo – and the winner will receive a bonus “mystery pack” of goodies and merchandise!

Rules

  • The logo should be licensed under the Creative Commons Attribution-ShareAlike 4.0 International. Attribution will be given on the conference website and other materials, but you agree that the logo can also be used without attribution where there is limited space (eg on T-shirts and stickers).
  • The design must be original and should not include any third party materials.
  • Both monochrome and colour formats are essential for submission.
  • Submissions must be in SVG format.
  • The design should reflect the LibreOffice community.
  • The logo should avoid the following things:
    • Brand names or trademarks of any kind.
    • Illustrations that may be considered inappropriate, offensive, hateful, tortuous, defamatory, slanderous or libellous.
    • Sexually explicit or provocative images.
    • Violence or weapons.
    • Alcohol, tobacco, or drug use imagery.
    • Discrimination based on race, gender, religion, nationality, disability, sexual orientation or age.
    • Bigotry, racism, hatred or harm against groups or individuals.
    • Religious, political, or nationalist imagery.
  • The logo should follow the LibreOffice Branding Guidelines.

So, let’s see your ideas! And thanks in advance for all suggestions. We plan to announce the winner at the start of September. Stay tuned!

Annual Report 2020: Website, blogs and social media

We use our website, blogs and social media channels to raise awareness about our work, share information and encourage new contributors to join the LibreOffice community

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


Social media

In January 2020, our Twitter account had 29,340 followers; by the end of the year, we had grown this to 36,996. Our most popular tweets were for major releases, but we also tweeted customised images for “Community Member Monday” interviews with short quotes, encouraging more users to get involved with LibreOffice projects.

In addition, we focused not only on our own tweets, but also retweeting announcements from the LibreOffice ecosystem and community members. We liked and retweeted messages of support from end users – many of whom were surprised and thankful that a large project would show them support. To keep the content flowing, we used automatic tweeting tools to post daily LibreOffice tips, using the same content from the “Tip of the day” box in the app itself.

On other social media platforms, we focused on growing our account on Mastodon, a Twitter-like open source, federated and self-hosted microblogging service. In 2019 we set up https://fosstodon.org/@libreoffice and started “tooting” content, often more focused on technical users, compared to our tweets and Facebook posts. In 2020 we worked more on expanding our activities here, and from January to December, we grew our follower base from 3,297 to 4,879.

Our Facebook page growth was smaller, from 56,095 page likes to 58,516. We’ve noticed a gradual reduction in activity on Facebook over the last few years, which reflects its changing audience, and the move towards newer mobile applications. Nonetheless, Facebook still provides a good opportunity to interact with end users of LibreOffice, and every day we checked in to answer questions, get feedback, and post announcements/tips about the software.


YouTube channel

Our YouTube channel grew from 9,975 subscribers and 1,587,341 video views in January 2020 to 12,807 subscribers and 2,042,731 video views by the end of the year. The LibreOffice 7.0: New Features video (a fantastic production by the Indonesian community) amassed over 120,000 views – while the video for LibreOffice 6.4 had over 60,000. We also added some presentation videos from the LibreOffice Conference 2019.

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.


TDF website (documentfoundation.org)

The Document Foundation’s website provides general information about the foundation (overview, statutes, code of conduct, financials and reports) and its governance (board of directors, membership committee, members, advisory board, and engineering steering committee), and about LibreOffice certification, including a list of certified developers, and professionals for migrations and trainings.

During 2020, the website was visited 146,261 times, with 196,802 page views. Continent-wise, the largest chunk of visits were from Europe (57%), followed by North America (22.8%) and Asia (12.4%). And for operating systems: the most visits were from PCs using the Windows (64.1%) operating system, followed by macOs (9.2%) and GNU/Linux (9.0%), while for browsers: Chrome had (38.4%), followed by Firefox (22.1%) and Microsoft Edge (14%).


LibreOffice website (libreoffice.org)

The LibreOffice website provides information about the office suite and the document format, the various download options, how to get help, how to contribute to the project, events where users can get to know LibreOffice, and how to make a donation to support the project and the community.

In 2020, we added a language selector to the top-right bar of the website. This was implemented in response to a demand from the native language projects: many website visitors, using languages across the world, thought that the site was only available in English.

Even though we have a dedicated page listing the native language projects and their respective websites, it’s hard to find. So we added a bar at the top, with some of the most-used languages to attract attention, and a link to a page listing all language versions of the website.

Meanwhile, work progressed on a redesign of the website. LibreOffice’s current website has been largely the same for several years, and while initially it looked fresh and modern, it needs to be updated – especially to remove clutter and complexity, and work better on mobile devices. Volunteer Christine Louie helped to push this forward, and other volunteers joined in with designs and collecting feedback from users. We hope to show the results of this work in 2021.

During 2020, the English LibreOffice website was visited 19,939,066 times, with 47,589,717 page views. Most visits were from Europe (53.4%), followed by Asia (16.7%), North America (15.8%) and South America (10.3%), from PCs using the Windows operating system (83.1%), followed by macOS (6.6%) and Linux (3.7%), and the Chrome browser (49.3%), followed by Microsoft Edge (18.4%) and Firefox (17.9%).


Blogs

TDF’s blogs (such as this one) are essential for communicating activities inside and around the project, including new releases of LibreOffice, community events and support for other free and open source initiatives. In 2020, they were used to post regular interviews with community members and provide updates from team members about documentation, marketing, QA, design and more.

Blogs were also maintained by various native language communities including Japanese, French, Spanish, German and others. Thanks to the hard work of community members, we had press releases, tips and other articles translated into many languages, and picked up by local media organisations.

These native language blogs complement the information provided by the main blog in English, and by the two blogs managed by members of the design and the quality assurance projects, which provide updates about activities for the upcoming major releases.

In 2020, the blog had 184,538 page views (146,170 unique page views). The press releases for LibreOffice 6.4 and 7.0 were the most popular posts, followed by posts for minor bugfix releases.

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!