Updates from the Document Liberation Project

We mostly focus on LibreOffice on this blog, but The Document Foundation also oversees the Document Liberation Project (DLP), which develops software libraries to import and export many different file formats. If you have some old documents or spreadsheets from legacy office software, for instance, the DLP can help you to access that data – giving control back to you.

Many well-known free and open source programs use DLP libraries, such as Inkscape, Scribus, Calligra and of course LibreOffice. A few days ago, there were some DLP updates, so here’s a quick summary:

libvisio 0.1.7

libvisio is a library that helps software to import documents from the Microsoft Visio diagramming and vector graphics application. It turns this:

Into this:

In libvisio 0.1.7, various conversion fixes were made, and a few memory leaks were plugged thanks to OSS-Fuzz. Check out the full release notes here.

libabw 0.1.3

Meanwhile, libabw was also updated. This is a library to import documents from AbiWord, a free software word processing tool. In libabw 0.1.3, a memory access error was fixed thanks to OSS-Fuzz, while expanding entities by the XML parser were disabled as well as a preventative measure.

Learn more and get involved!

The Document Liberation community is always looking for help: if you have old documents or files in legacy formats that you can’t open (or which don’t look right when opened in free software tools), let the project know! You can help the community to better understand file formats by submitting examples, and test new releases.

To learn more about DLP, check out 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.

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 6.3: 10 days of stats

On August 8, The Document Foundation announced the release of LibreOffice 6.3 with new features, performance boosts and compatibility improvements. A big thanks to our volunteer community and certified developers for making this release happen!

So, ten days later, let’s check out some stats…

429,848 downloads of LibreOffice 6.3

These are just stats for our official download page, of course – some Linux users will have acquired the new release via their distribution’s package repositories. And we still maintain the LibreOffice 6.2 branch, which has been tested for longer.

416,396 visits to our website

Our main website is the central resource for all things LibreOffice, including downloads, release notes, help, community assistance and more. On release day, we updated the New Features page, system requirements and other details.

54,059 views of the press release

Our announcement on the TDF blog got a lot of hits – but of course, it was also posted on our mailing lists and translated into other languages as well.

34,001 video views

We made a video highlighting some of the big changes in this release, and it has been viewed over 34,000 times. In large part, this is thanks to articles on technology websites that embedded it. Also, the video has subtitles in eight languages, thanks to our awesome community!

25,151 Twitter impressions

Our announcement tweet was also liked by 243 people, and retweeted 139 times. We also announced the release on Mastodon, with 85 boosts.

But it doesn’t stop here – our community is already working on the next release, LibreOffice 6.4! Join in and help with design, marketing, documentation, QA and many other tasks, pick up some valuable experience contributing to a well-known FOSS project, and let’s make it the best release ever!

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!