LibreOffice monthly recap: August 2019

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

  • On August 8, we announced LibreOffice 6.3, a new major release with better performance, a large number of new and improved features, and enhanced interoperability with proprietary document formats. 10 days later, we followed this up with a look at some statistics – there had been 430,000 downloads of the new version, and 54,000 views of the press release. Check out some of the new features in this short video:

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 we’re gearing up for the aforementioned LibreOffice Conference 2019, we’re also looking ahead to proposals for the 2020 event. The Document Foundation received two different proposals for the organisation of LibOCon 2020, from the Turkish and German communities. TDF members are voting to decide on exactly where it will take place, so stay tuned for the announcement…

  • In recent months, we’ve been putting content from our Annual Report 2018 on the blog, and this month we looked back at hackfests last year. These were opportunities for developers to meet face-to-face, work on new ideas, and enjoy good food and drink! In 2018, we had hackfests in Brussels, Hamburg, Tirana and Munich.

  • The Document Liberation Project (DLP) is a sister project to LibreOffice, which develops software to read and write data from proprietary and legacy document formats. This helps LibreOffice and other apps to access archives of data, freeing users from vendor lock-in. On August 21, we posted about updates from the DLP. If you have some old documents from legacy office software that you’d like to open in LibreOffice, give the developers a hand!

  • Finally, we started a new marketing campaign highlighting the fact that LibreOffice has no forced registration, subscriptions, payments or vendor lock-in. As many software vendors are pushing users towards online subscription models, the LibreOffice community is proud to offer a fully free, no-strings-attached office suite that people can use any time, any place, without worrying about subscriptions or “authentication” servers not working.

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!

Annual Report 2018: LibreOffice Hackfests

Most LibreOffice developers are working from their home offices, so hackfests provide a unique opportunity to spend some time working shoulder-to-shoulder with their peers. In 2018, LibreOffice developers and community members met at four hackfests in Brussels, Hamburg, Tirana and Munich.

Brussels (Belgium), February 5-6

The first hackfest of the year was organized at ICAB in Brussels immediately after FOSDEM, the largest European gathering of FOSS developers and advocates, which is organized every year at ULB (Brussels Free University) during the coldest weekend of the winter season. The hackfest was attended by over 30 people, equally split between those focused on development and those taking care of non technical tasks such as localization, documentation, certification and marketing. In term of development, there were achievements in various areas of the office suite and in quality assurance.

Hamburg (Germany), April 6-8

The community gathering started with a walk through the fascinating Hanseatic city of Hamburg, with its river, canals and lake in the centre (Binnenalster), and a sample of local food at the Groeninger Privatbrauerei.

On Saturday, around 45 people attended the hackfest, divided in two groups: the first focused on coding for fixing bugs and working on new features, and the second on the meeting of the German-speaking LibreOffice community. Developers worked on different topics, like making drawing layers ODF conformant, migrating old database to HSQLDB, speeding up VLOOKUP, and improving LibreOffice Viewer on Android, plus other random bits related to bugs, regressions and new features.

German community members discussed about bringing in potential new contributors, developing materials for courses (both online and in schools) about LibreOffice, and creating a new “Get Involved” flyer and page on the website, both in German. And at the end, we relaxed with drinks and food!

Tirana (Albania), September 27

As part of the LibreOffice Conference in Tirana, Albania, this “hacknight” was held at the Destil from 7:30PM to 11PM with over 100 participants, which have covered tasks such as development, localization, documentation, quality assurance, certification and marketing. In fact, the conference brings together a large number of community members from around the globe, and the hackfest is for many contributors the very first opportunity to meet face-to-face after months or even years of interaction on mailing lists and IRC.

Munich (Germany), October 26-28

In late October, CIB hosted a hackfest at modulE in Munich, Germany, with 25 participants over the three days. The meeting started with a few presentations on Friday evening, with Andreas Kainz showing the amazing progress on the NotebookBar design. During the event developers were able to fix several bugs and polish some new features for the upcoming LibreOffice 6.2 major release, while German community members discussed non-technical topics such as marketing and local events. Of course, there was Italian pasta, like in every hackfest in Munich. The meeting ended with a quick city tour and beer at the world-famous Hofbräuhaus.

Community Member Monday: Sanjog Sigdel

Members of The Document Foundation – more formally known as the “Board of Trustees” – are a crucial part of our community. They are people from across the globe who contribute time, effort and skills to the LibreOffice and Document Liberation projects, whether on a voluntary or paid basis. Today we’re talking to Sanjog Sigdel, a new TDF Member from our Nepalese community…

To start off, tell us a bit about yourself!

I’m currently a Graduate Student pursuing my MTech. in IT degree here in Kathmandu University, Dhulikhel, Nepal. Besides that, I am also a part-time instructor in a private college near the University: NIST College Banepa.

I love knowing how new technologies work and also love exploring new places. Unitil now I have traveled almost 30 districts of Nepal via trekking, project monitoring and tours. I’ve been using Linux-based operating systems (mainly Ubuntu) since 2012. And I am also a FOSS activist/volunteer. I teach my students to use open source software and most of them are using Linux, LibreOffice, and Python programming in the Nano text editor 🙂

Why did you decide to become a member of TDF?

Language translation is something I believe helps a large number of people in using all kinds of software. It breaks the digital divide created by language differences. Since 2017, with the guidance from my mentor, Mr Saroj Dhakal, I I have been contributing to LibreOffice localisation (L10N). I am currently the Project Reviewer for the Nepali language translation in the LibreOffice project.

Since I am already part of The Document Foundation, being a member and presenting myself as a formal representative of TDF in open source communities in Nepal could help other open source volunteers to join the FOSS Movement. Also, I will be working as a resource person for Kathmandu University Computer Club, an undergraduate computer club in the Department of Computer Science and Engineering, in case they want to conduct any FOSS Activities. There I can pitch ideas around translating LibreOffice and hacking on the source code.

Anything else you plan to do in the future?

I am planning to conduct a LibreOffice localization event for the Nepali Langauge on Software Freedom Day, working together with Kathmandu University’s Open Source Community. I will update other TDF members on the mailing list soon.

Cheers to Sanjog for his contributions! And to everyone reading this who’s involved in the LibreOffice community, check out this short video and consider becoming a TDF Member too…

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 Conference 2020 Proposals

The Document Foundation has received two different proposals for the organization of LibOCon 2020 from the Turkish and German communities. When this has happened in the past, in 2012 (Berlin vs Zaragoza) and 2013 (Milan vs Montreal), TDF Members have been asked to decide by casting their vote.

This document provides an outline of the two proposals, which are attached in their original format.

TURKEY: ISTANBUL

City. Istanbul, formerly known as Byzantium and Constantinople, is the most populous city in Turkey and the country’s economic, cultural and historic center. Istanbul is a transcontinental city in Eurasia, straddling the Bosporus strait (which separates Europe and Asia) between the Sea of Marmara and the Black Sea. With a total population of around 15 million residents in its metropolitan area, Istanbul is one of the world’s most populous cities, ranking as the world’s fourth largest city and the largest European city. (Source Wikipedia)

Entity. Tubitak Ulakbim (Pardus) will handle legal and financial responsibilities on behalf of LibreOffice Turkish community. Tubitak Ulakbim is a research institute which support FOSS (mostly Pardus Linux and LibreOffice) and ODF in Turkey, targeting primarily public institutions. Each year, it funds and/or supports many FOSS events in Turkey.
Tubitak Ulakbim (Pardus) has agreed to support the event by covering expenses up to an amount of approximately 25,000 Euro.

Venue. Boğaziçi University (BOUN), İstanbul. The main venue has three conference rooms of different sizes and a foyer area, plus other conference rooms in a nearby building (at walking distance) which can be used in case of need. All conference rooms are in the same campus. Almost all areas in the venue are wheelchair-accessible. BOUN is extremely sensitive to this topic.

Team. Muhammet Kara: main contact. Nurcan Tür, Enes Kıdık, Furkan Tokaç, F. Ahmet Kara, M. Çağrı Dolaz, Ülkem Kasapoğlu, Ömer Çakmak, Doğa Deniz Arıcı, Berkay Aktunç.

We are a group of enthusiast volunteers who love LibreOffice, and would like to see LibreOffice/ODF widely used and known in Turkey, along with other FOSS projects. We see LibOCon as a very good opportunity to integrate the local and the global community, with a positive impact on the local community.

LibOCon2020 Turkey Proposal

GERMANY: NUREMBERG

City. Nuremberg is the second-largest city of the German federal state of Bavaria after its capital Munich, with 511,628 inhabitants in 2016. The city lies about 170 kilometres (110 mi) north of Munich. (Source Wikipedia)

Entity. The organization is lead by the openSUSE community and it’s legally supported by SUSE.

Dates. The proposal is to organize the conference during week 42, from October 12 to October 18, 2020, including internal pre-meetings and conference. The geek number 42 is the “Answer to the Ultimate Question of Life, the Universe, and Everything”.

Venue. Z-Bau, a large building with many rooms of several sizes, and a large outdoor area with a beer garden. With four event rooms, two outdoor areas and various project rooms, there is plenty of room for events of all kinds. The entire area is barrier-free and the various rooms are equipped with basic technical equipment for events and day-to-day operations.

Team. Douglas DeMaio and Marina Latini: main contacts. Andrew Wafaa, Axel Braun, Simon Lees, Christian Boltz, Gertjan Lettink, Richard Brown.

2020 will be an important milestone date for both the LibreOffice and the openSUSE project. LibreOffice will celebrate its 10th birthday while openSUSE will achieve the 15th anniversary of the project. One more notable connection between the two communities is the historically strong relationship between the core LibreOffice development team and SUSE, given that a big number of core developers were all working together at SUSE.

LibOCon2020 Germany Proposal

LibreOffice Community at FrOSCon 2019

LibreOffice development takes place mostly via the internet: volunteers, certified developers and other community members collaborate on programming, design, quality assurance, documentation and other tasks. But we also like to meet up in person, to share information, bring new people into the project, and have fun!

So on the weekend of 10 and 11 August, we attended FrOSCon 2019 in Sankt Augustin, a town just outside Bonn, Germany. FrOSCon is one of the largest free and open source software (FOSS) conferences in the country, with around 2,000 attendees. Most of the visitors know about FOSS already, but some had only learnt about it recently, and were eager to discover more.

Gerrit Großkopf, Uwe Altmann, Stefan Unverricht and Mike Saunders from the German-speaking LibreOffice community had a stand with flyers, stickers and a computer demonstrating LibreOffice 6.3 and LibreOffice Online. Indeed, many visitors to the stand had no idea that LibreOffice Online existed, and were eager to try it out on their own infrastructure.

Other common topics at the stand included LibreLogo, macros, mail merge and other features in the suite. We even had a couple of visitors who demonstrated minor bugs that they’d found in the software, which have been useful for creating bug reports.

In addition to helping with the stand, Stefan gave a lecture about “LibreOffice Online in EGroupware” (German) – the video is available at media.ccc.de. Stefan also translated the slides into English and linked them in the lecture program. The presentation slides are supplemented by web links, and some screenshots of the LibreOffice Online and EGroupware integration.

Overall, it was great to meet so many passionate and dedicated FOSS fans, and we hope we’ve encouraged them to take part in the LibreOffice community. If you’re reading this and would like to organise (or attend) an event near you, drop us a line on our marketing mailing list and we’ll get you started!

LibreOffice Asia Conference Report: Part 2

How does your software affect the autonomy of countries?

Author: Kuan-Ting Lin – click here for part 1

Foreword: the LibreOffice Asia Conference was successfully held in May 2019 in Tokyo. Kuan-Ting Lin, a university student and civic tech reporter also attended this conference and gives his observations here. In Part II, Kuan-Ting starts with the Open Document Format, and expounds on how to form an open government and better autonomy of Taiwan.

The “Taiwanese Language channel” (tâi-gí-tâi) of the Public Television Service (PTS) in Taiwan started its broadcasting service in July 2019. This channel became possible only because the National Languages Act was approved in parliament. This policy was rooted by many in the decision to improve expression, alleviation of limits on speeches, and the consolidation of autonomy following the new law.

After a long-time struggle, the state also sees a silver lining regarding another autonomy issue: document liberation.

What kind of autonomy do we give up for proprietary software?

The LibreOffice Asia Conference held in Tokyo in late May focused on the developments in document liberation in Asian countries. Italo Vignoli, one of the co-founders of The Document Foundation (TDF) that is behind the software, showed a map in a presentation: each country is depicted larger or smaller than its actual size according to its software license trade numbers.

The result was not a surprise: the USA seemed like a giant, while others were squeezed into a bunch of lines. Countries around the globe spend a lot on software licenses – and Taiwan is no exception. Taiwanese people pay tens of billions of New Taiwanese Dollars solely for Microsoft products every year.

Only with respect to trade affairs, Taiwan’s dependency on software products made by single country is damaging its bargaining power and is a threat to economic autonomy. In terms of the autonomy of speech, we are facing an even more serious crisis.

World map for software licenses import. The US becomes an one-pixel wide line between Canada and the Latin America. (Credit: Italo Vignoli)

For thousands of years, our writing and thoughts could only pass on with the help of paper. Then computers replaced paper with digital documents in just a few decades. The difference between paper and digital documents is that the latter are merely some electrical signals which cannot be touched or seen. When users try to open and edit these documents, we need “formats” based on people’s consensus to understand the meanings of different combinations of these electrical signals.

Take “.doc” and “.ppt” files saved by Microsoft Office as examples: these two “formats” are controlled by Microsoft, so it can decide all the rules. The ways to display different fonts, images and languages are Microsoft’s call. As Microsoft Office evolves, paying users may still experience failure to open documents generated by old versions of the software – or see different layouts of the same document in different versions of the software.

In other words, if we do not follow Microsoft’s rules, the appearance of a digital document could alter faster than a piece of paper fades. What you want to say, and how you want your speech to be displayed – the essential freedom of expression and autonomy – are quietly taken away by some companies.

Open format or fake copycat?

To end the domination of formats by Microsoft, some companies, government agencies and communities designed the Open Document Format, or ODF in short, and included a detailed framework of digital document files in it. ODF soon became an ISO standard in 2006. ISO standards are open for everyone to use and are easy to access online, so different developers can all follow them easily. With ODF on the table, we finally came to a consensus on a unified format of documents.

Microsoft joined the party by announcing its “Office Open XML” format and making it another ISO standard in 2008. Having “Office Open XML” in their hands, Microsoft seemed just as open as the ODF. But it didn’t take long for communities to find out that Microsoft wasn’t that open.

The software giant admitted that ordinary users of Microsoft Office save “Office Open XML” files that are not the “strict version” of the format by default. Describing the ISO standard submitted by itself as a “strict version”, and then leading customers to save non-ISO standard files not only make the concept of open standards ironic, but also give people reasons to doubt if the company is really willing to promote open standards.

Franklin Weng, an open standards activist in Taiwan and a board member of TDF also added that some features inside files saved in the so-called “strict version” format in Microsoft products are actually similar to those in “non-strict version” formats. “TDF was studying Office 2016 a couple of years ago. Whether a file is saved as strict OOXML (i.e. Office Open XML) or not, there is no significant difference in terms of file size and lines of XML code.” Therefore, it is debatable how strict the “strict” version claimed by Microsoft actually is.

Length of XML content. As you can see, the XML line numbers of OOXML 2016 Strict and Transitional are nearly the same. What is really saved in OOXML Strict format? (Credit: Italo Vignoli)

Since open formats belong to the public, they has to remain stable and to have a set of progress to review new or modified features, then implement it as a standard extension, thus not matching the style of commercial enterprises, which tend to launch new versions and features frequently in order to stimulate consumption.

Therefore, it is understandable that Microsoft is passive towards promoting open formats. However, for governments and civil society institutions, using a document format with an arbitrary decision-making process, high frequency of change, and non-observance to open standards is definitely not a reasonable policy for documents. It not only leads to more chaos when people exchange files, but also causes more trouble in terms of preserving important information for a long time. Imagine if 500 years in the future, our descendants want to open .docx files from today, yet its complicated document structure doesn’t match the specification Microsoft provides; in that time, there may be no Microsoft engineers able to solve the problems.

A good open format transforms contributions by the community and fuels progress

The monopolised “open format” is regrettable, but the multi-partied ODF format is right here to fix the problem. “ODF is open to many technical companies and communities, and it is more discreet in terms of enacting or revising the standard, which makes immediate and arbitrary changes impossible,” Franklin said.

At the LibreOffice Asia Conference, Mark Hung from Taiwan was invited to give a speech in the opening session keynote. The topic was “LibreOffice CJK (Chinese, Japanese and Korean) Bugs, Fixes and Stories.” Since the majority of the LibreOffice developers are from Europe and South America, the developers, who are usually more familiar with Latin characters, can barely understand the system of logographic scripts and thus are very likely to make some mistakes. Nevertheless, it is at this time that the community can utilise the power of elasticity: the more diverse the cultural backgrounds of participants are, the more easily the problems caused by lack of understanding can be solved.

Mark is exactly such a participant. In 2014, Mark was working for an organisation of around 400 people, and was responsible for transferring the document system to community-developed free software. At first, facing the mistakes in Chinese, Korean, and Japanese characters and Mark’s colleague’s unfamiliarity with new software, Mark gradually developed an operational Q&A to help them solve the problems.

Mark Hung. (Photo credit: Masataka Kondo)

Mark also found out a way to solve a bug that had been disturbing him for a long time. “I was working on a document, and then I thought why not try to look into what’s inside the document? … I decided to try to submit my patch to LibreOffice and to my surprise my patch got reviewed in one day and then it got merged.” Mark therefore became a LibreOffice developer and a community member.

In his five years of volunteering, Mark has dealt with dozens of CJK issues. He even noticed some slight issues, such as the difference between Taiwanese Chinese and Japanese regarding the placement of phonetic markers. Dae-Hyun Sung, another community member from Korea, also showed regional distinction. Dae-Hyun’s presentation mentioned different ways of writing for South and North Korea. These examples show community-driven attempts to include all the differences, instead of limiting the freedom of writing.

Franklin points out that these new features will be treated as extensions first. If they work well then they will be included in a revised ODF format. The whole process ensures that the community’s voice is constantly reflected, and that the versions of the format remain stable.

Shaping a future for governments, free software and open formats to support each other

In Taiwan, ODF is accepted as a national standard of digital documents called ODF-CNS15251. There still are many government agencies and schools that are buying Microsoft Office licenses, but with help from the civil society, the National Development Council has started the “Advancing ODF-CNS15251 to Be the Standard Document Format for the Government” programme, and has been encouraging other parts of the government to replace Microsoft solutions with LibreOffice. The goal of document liberation has transformed from a “mission impossible” to a future that can be expected.

In large companies’ international business strategies, Taiwan is merely a small market and has relatively little attention. But having the opportunity to participate in the development of ODF and LibreOffice, Asian members can finally meet their own needs of document production by themselves. The significance of the LibreOffice Asia conference is that the Asian community has become part of the collective development of LibreOffice.

In Taiwan, facing the native language policies and official documents in the indigenous language programme, Taiwanese people are able to take advantage of the flexibility of LibreOffice to include indigenous languages and other native languages in the software’s built-in dictionary. Native languages can no longer be sacrificed under business interests of companies. And technology can start to be the thing that positively revitalises native languages, instead of the being something that marginalises them.

The National Development Council of Taiwan has started to collaborate with local companies that designed the “NDC ODF Application Tools” based on LibreOffice. But Franklin has a further suggestion: “It’s already a huge leap forward that the National Development Council invested in software development, but I hope they will give some feedback to the community. As for the ODF standard, the government should be part of its making.” The communities alone won’t sustain a proper standard. Having all the benefits of document liberation, the government has obligation to help build a better future. Having a voice in the development of an international standard can also highlight the autonomy that belongs to Taiwanese people.

Thanks to Kuan-Ting Lin for his write-up and perspectives on ODF and LibreOffice in Asia! And on the topic of conferences, everyone is welcome to join our upcoming LibreOffice Conference 2019 in Almeria, Spain, from 10 – 13 September. See you there!