LibreOffice localisation sprint: Bengali

LibreOffice’s localisation communities translate the software’s user interface and documentation. They help to make a powerful office suite available to millions of people around the world, in over 100 languages! Biraj Karkamar reports on a recent localisation event in India:

Ten people participated in our sprint in Kolkata, on November 11. We made contributions together for the Bengali-India locale.

On November 4, we had pre-meetup on localisation portal basics. I gave the participants basic details on how to add suggestions and submissions in the portal. Also that day, participants created their profiles on the portal.

But in main event, we started with introductions, then we had a short recap on the pre-meetup. Then we had a hands-on portal. I showed the style guide of bn-IN locale translation, which we follow in open source localisation. Then the sprint started – which was almost five hours long.

Overall, the event was good and productive. Of course, it was fun too!

Thanks to Biraj and the community for their great work! See which other languages LibreOffice supports, and if your language isn’t on the list, help us to make it happen! Here are a few more photos from the event:

Community Member Monday: Cathy Crumbley

At our recent LibreOffice Conference in Tirana, Albania, we invited community members across the globe to join us. Cathy Crumbley from Massachusetts, USA, has recently been involved in the documentation project, and flew over to meet us. Here’s what she had to say:


Tirana on the Move

I was surprised and grateful to be invited to attend the conference in Tirana. It turned out to be a marvelous experience and I would like to share some of what I learned.

The local organizers of the conference, Open Labs, did a wonderful job. This is an amazingly active group that, even though it is all volunteers and relatively small, manages to organize several large conferences a year in addition to working on various open source projects. It also played a significant role in convincing the city of Tirana to adopt LibreOffice.

On the first day of the conference, Tirana Mayor Erion Veliaj talked about his support for open-source software and his vision for Tirana. Wearing jeans and a Nirvana T-shirt, he said that of all of the cities in Europe, Tirana has the lowest average age (27) and that nine-tenths of young people who come to study in Tirana stay in Tirana. I could see this in the large numbers of young people hanging out in numerous coffee shops. Indeed, Tirana (at least downtown) feels like a vibrant city, but this large influx of young people cannot be good for the hinterlands they have left behind.

The Current Business Model

The business model for LibreOffice and other open source software has depended on donations, sponsorships, and volunteer time. Most of the donations come from the download section of the LibreOffice website. However, third-party websites increasingly offer LibreOffice downloads without a donation link, reducing the likelihood of donations.

What I had not appreciated before LibOCon was the extent to which the business model depends on contributions from companies that provide technical support services. That is, by improving the software for their clients, they improve the code for everyone. (Shows how little I knew about open source software.) I learned that three companies have been responsible for the majority of contributions to the LibreOffice code: Collabora, Red Hat, and CIB. All three of them were at the conference and are playing a major role in making LibreOffice even better.

With an estimated 200 million LibreOffice users worldwide, it was surprising that only one other person from the USA was at LibOCon. Before coming, I had a sense that LibreOffice is more common in Europe than in the USA, but had not realized the extent of the difference. In fact, Italo Vignoli, who is responsible for marketing and public relations, identified the USA and India as key markets to develop.

A New Strategy

Global marketing is challenging. However, LibreOffice is being framed as not just another office suite but as a community resource. Community support and translation services have enabled it to be available in over 110 languages. It is helping to preserve several languages that are considered endangered – such as Breton, Upper Sorbian, and Scottish Gaelic in Europe. Indeed, the case could be made that UNESCO should deem it a global resource for preserving local communities.

While the LibreOffice business model has been working relatively well till now (although increasing numbers of download sites without a donation link is a threat), the Document Foundation leadership has an ambitious vision for increasing its support for local communities. This will require more funding than currently received through donations.

Thus, Italo Vignoli introduced plans for fundraising – that is, actively soliciting donations. As he said, “the project is solid, but not scalable in economic power.” This initiative will focus on three positive values:

  1. The advantages of being open source
  2. Preserving languages
  3. Helping young people and minorities

Much of the focus will be on not just the LibreOffice program but on the ways it can help communities. It sounds highly unusual for open-source software to make this kind of ethical pitch, much less conduct active fundraising. I am proud to be associated with such a vision.
Attracting larger donations will require more in-person contacts and the vision is that everyone in the LibreOffice community will play a role in fundraising. So, buckle up.

Hope for Track Changes?

While LibreOffice is otherwise a fabulous program, there is one feature that has sometimes prevented me from using it. When editing longer or more complex documents, track changes can run so slowly that it becomes unwieldy to use.

I understand that there are significant reasons why track changes can run so slowly and that it is not easy to overcome these problems. Thus, I was heartened to learn that Michael Stahl at CIB is undertaking the challenge of improving track changes. Recognizing that he has limited funding and time, I wish him much luck.

Glimpsing the Future of Documentation

One of the biggest challenges for LibreOffice documentation has been the need for more volunteers. The lack of volunteers has meant that user guides have not been able to keep up with new major versions, much less keep up with twice-yearly updates.

This can have cascading effects, since some language communities (but not all) base their translations on the English versions. We talked about some strategies for recruiting and retaining volunteers, and I am hopeful that we can increase the number of active volunteers.

A small group of us in Tirana (Olivier Hallot, documentation coordinator, Leo Moons, Cor Nouws, and I) discussed various strategies to make the process of documentation easier. Olivier presented plans for gradually integrating user guide and help file texts. The results will be greater efficiency and less duplication of efforts. Also, user guides can be available as updates are made (rather than waiting for an entire guide to be updated before releasing it).

Ignorance as a Strength

At the end of the conference, there was a time for “lightning talks.” These are opportunities for people to give brief (5-minute maximum) presentations about something that they had not already presented. I was encouraged to say something about my approach to documentation and briefly talked about my motto: “ignorance as a strength”. It reflects my belief that for documentation, it is useful to involve people who are not already experts – that is, people like me.

Because I started with little knowledge of LibreOffice, I had few preconceived notions. I had to test and sometimes research every feature to make sure that I understood it and that it worked as described. I was also in a good position to ensure that the text and underlying assumptions were clear to new users. If I already knew the program, I think I would be more likely to focus mainly on updating text and overlook potential problems.

Thank You

Attending the LibreOffice Conference 2018 gave me the opportunity to meet many interesting, kind, and dedicated people. I was impressed with the number of people actively involved as contributors. The conference helped me understand how The Document Foundation works; appreciate the vital roles of numerous volunteers; hear about the amazing extent to which LibreOffice is being used worldwide; and learn about its potential for helping local communities and supporting social change. It also helped me feel part of this significant and powerful community.
Thank you to The Document Foundation for inviting me and for organizing the conference, especially Sophie Gautier.

And thank you to the local organizing team from Open Labs: Silva Arapi, Jona Azizaj, Marinela Gogo, Suela Palushi, Nafie Shehu, Anxhelo Lushka, and Redon Skikuli. Fabulous job, everyone!


Thanks to Cathy for her report, feedback and kind words! We’re glad she could join us, and get to know the community in person. If you’re reading this as a user of LibreOffice, but would like to get more involved and join our community, check out this page for lots of ideas – and we look forward to meeting you!

It’s the final week of the Month of LibreOffice, November 2018…

…and if you haven’t yet been awarded a sticker pack, you still have a few days to get involved, help to improve LibreOffice, and join our friendly community! Here’s how it works:

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.

So far, over 260 sticker packs have been awarded, so if you’ve contributed to the project, your name (or username) should be somewhere in the list! (If we’ve missed a contribution, let us know in the comments below.)

But if you’re not on the list, here are some ways to get your stickers:

  • Answer questions from users: Over on Ask LibreOffice there are many users looking for help with the suite. We’re keeping an eye on that site so if you give someone useful advice, you can claim a shiny sticker.
  • Help to confirm bugs: go to our Bugzilla page and look for new bugs. If you can recreate one, add a comment like “CONFIRMED on Windows 10 and LibreOffice 6.1.2”. (Make sure you’re using the latest version of LibreOffice.)
  • Spread the word: Tell everyone about LibreOffice on Twitter! Just say why you love it or what you’re using it for, add the #libreoffice hashtag, and at the end of the month you can claim a sticker. (We have a maximum of 100 stickers for this category, in case the whole internet starts tweeting!)
  • Translate the interface: LibreOffice is available in a wide range of languages, but its interface translations need to be kept up-to-date. Or maybe you want to translate the suite to a whole new language? Get involved here.
  • Contribute code: The codebase is big, but there are lots of places to get involved with small jobs. See our Developers page on the website and this page on the wiki to get started. Once you’ve submitted a patch, if it gets merged we’ll send you a sticker!
  • Write documentation: Another way to earn a badge is to help the LibreOffice documentation team. Whether you want to update the online help or add chapters to the handbooks, here’s where to start.

So dive in and have fun! At the end of the month, we’ll post an update on this blog, explaining how to get your sticker pack. Stay tuned!

The Municipality of Tirana moves to open source software and open standards by migrating to LibreOffice

Berlin, November 22, 2018 – The Document Foundation (TDF) announces that the Municipality of Tirana, the biggest in Albania, is moving to open source software and open standards by migrating to LibreOffice. The project is a further step in a large deployment of open source technologies in the city’s IT infrastructure, and follows the successful migration to Nextcloud.

The migration to LibreOffice is managed by the ICT Department, which has been following an open source approach when implementing many IT solutions, based on the strong belief that public IT infrastructure should use free and open source technologies (https://publiccode.eu). Thanks to LibreOffice, documents can now be exchanged and stored in the ISO standard Open Document Format, managed by OASIS, which represents the best solution to avoid proprietary lock-in.

Ermir Puka, the head of the ICT Department, believes that despite the resistance to change and the other big challenges facing the migration, using free and open source software and platforms like LibreOffice – supporting open standards – will guide the IT infrastructure of the municipality in the best interest of the citizens of Tirana.

The migration project has started with the HR Department, where most tasks are based on documents and spreadsheets. This has helped to identify many different issues during and after the migration, and has helped the process in other offices of the Municipality. The majority of the 1,000 desktops in the Municipality of Tirana have already been migrated to LibreOffice.

To further ease the migration, LibreOffice Writer and Calc manuals have been translated into Albanian, while the IT staff is working at an online learning course deployed on Moodle, the e-learning platform used by the Municipality. Activities are enthusiastically assisted by the local open source community, which gathers around Open Labs.

Coming up on November 19: Bug Hunting Session for LibreOffice 6.2 Beta 1

LibreOffice 6.2 is being developed by our worldwide community, and is due to be released in early February, 2019 – see the release notes describing the new features here. LibreOffice 6.2 will include a new (optional!) user interface design called the Notebookbarsee here for some screenshots. You can help us to test it, and make it super reliable!

After the first Bug Hunting Session for LibreOffice 6.2, which was held on October 22nd, we’re glad to announce the Second Bug Hunting Session on November 19th.

In order to find, report and triage bugs, the tests during the Second Bug Hunting Session will be performed on the first Beta version of LibreOffice 6.2, which will be available on the pre-releases server on the day of the event. Builds will be available for Linux (DEB and RPM), macOS and Windows, and can be run in parallel with the production version – so you can test without affecting your existing stable installation.

Mentors will be available on November 19th 2018, from 7 AM UTC to 9PM UTC for questions or help in the IRC channel: #libreoffice-qa and its Telegram bridge. Of course, hunting bugs will be possible also on other days, as the builds of this particular Beta release (LibreOffice 6.2.0 Beta1) will be available until mid December.

During the day there will be two dedicated sessions, one about the new KDE5 Integration between 11AM UTC and 13PM UTC and the other about the tabbed notebookbar from 15PM UTC to 17PM UTC, it is not experimental any more.

What has happened since the first Bug Hunting Session?

Since LibreOffice 6.2 Alpha 1 was released, 169 bugs have been reported against Alpha 1 by more than 40 people, of which 70 have been already closed, either by fixing them (30), as duplicates (27) or as invalid/notabug (13).

35 bugs have been reported for the ongoing KDE5 integration as a consequence of the dedicated session conducted during the first Bug Hunting Session.

Many thanks to the top five bug reporters: Telesto, Vera Blagoveschenskaya, Xisco Faulí, Andreas Kainz and Regina Henschel.

Quick report: LinuxDays and OpenAlt in Czech Republic

Want to help spread the word about LibreOffice, free software and open standards? Attend a local computing event, and tell people about it! Stanislav Horáček writes about some recent events in the Czech Republic…

With our LibreOffice booth, Zdeněk Crhonek and I attended the two biggest Czech FOSS events, LinuxDays in Prague and OpenAlt in Brno. We would like to share some of what we experienced:

– as usual, generally positive feedback from users, interest in new features and what is going on

– many questions about the status of LibreOffice vs. OpenOffice, the role of The Document Foundation etc.

– low awareness about LibreOffice Online; people were surprised that it is ready and that people are using it; some in interest in how to install it, others sharing experience that its deployment is too complicated

– more advanced users aren’t using LibreOffice so much, replacing it by simpler things like Markdown docs

– it’s nice that videos from the marketing team are available (about LibreOffice, join the community, new features…), showing them on the screen attracted visitors to the booth; but we’re missing a video about LibreOffice online (maybe an idea for the marketing team)

– discussion with someone from the National Technical Library in Prague (enthusiastic about FOSS, migrated client computers to Linux and LibreOffice, encouraging us to spread the word about it) and a representative of an organization trying to coordinate using FOSS in Czech municipalities (two towns running LibreOffice, with the intention to pay for some bug fixing)

– a meeting with the Slovak community (Miloš Šrámek and Andrej Kapuš) in Brno

– a meeting with the Czech localization community (Mozilla, Linux distributions), discussing mainly the possibility of a new Czech dictionary

– and a discussion with a marketing specialist who suggested ways to simplify the LibreOffice webpage (there are too many confusing subpages).

So in summary, we informed Czech FOSS people that there is active development of LibreOffice and that there is even some Czech community – thanks to organizers for the opportunity and to TDF for the support!

Thanks to Stanislav and Zdeněk for their help! Find out more: here’s the Czech LibreOffice website, Czech Ask site (for user support), and Czech mailing lists.