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 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 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!

The Document Foundation announces LibreOffice 6.3

Berlin, August 8, 2019 – The Document Foundation announces LibreOffice 6.3, a feature-rich major release of the LibreOffice 6 family with better performance, a large number of new and improved features, and enhanced interoperability with proprietary document formats:

  • Writer and Calc performance has been improved by an order of magnitude based on documents provided by end users: text files with different bookmarks, tables and embedded fonts, large ODS/XLSX spreadsheets, and Calc files with VLOOKUP load and render more quickly. Saving Calc spreadsheets as XLS files is also faster.

 

 

 

 

 

 

  • The Tabbed Compact version of the NotebookBar user interface, introduced in LibreOffice 6.2, is now available for Writer, Calc, Impress and Draw. It leaves more space for user documents, spreadsheets and presentations on laptops with wide screens. In addition, the new Contextual Single UI is ready for Writer and Draw.

  • In Calc, a new drop-down widget in the formula bar replaces the old Sum tool, giving the user quick access to the most frequently used functions. Also, a new FOURIER function has been added, to compute the discrete Fourier transform of an input array.
  • Export as PDF has been improved with the support for the standard PDF/A-2 document format, which is required by several organizations for long term file storage. In addition, the design of editable PDF forms has been simplified with the addition of the Form menu to Writer, to further improve one of LibreOffice strongest features.
  • Documents can now be redacted to remove or hide sensitive information such as personal data before exporting or sharing the file, to help companies or organisations to comply with regulations.

  • On Windows, a proper console mode was added, with better output and error codes. This makes it easier to use LibreOffice to perform batch operations such as printing or converting many documents.
  • Interoperability with Microsoft Office proprietary file formats has been improved in several areas with export support for DOTX document templates and XLTX spreadsheet templates, import of charts from DOCX drawingML group shapes, import/export of SmartArt from PPTX files, to preserve editing capabilities in PowerPoint, and better XLSX Pivot table interoperability.

LibreOffice 6.3’s new features have been developed by a large community of code contributors: 65% of commits are from developers employed by companies sitting in the Advisory Board like Collabora, Red Hat and CIB, plus other organizations, and 35% are from individual volunteers.

In addition, there is a global community of individual volunteers taking care of other fundamental activities such as quality assurance, software localization, user interface design and user experience, editing of help system and documentation, plus free software and open document standards advocacy.

A video summarizing the top new features of LibreOffice 6.3 is available on YouTube:

LibreOffice for individual users

LibreOffice 6.3 represents the bleeding edge in term of features for open source office suites, and as such is targeted at technology enthusiasts, early adopters and power users. The Document Foundation does not provide any technical support to users, although they can get help from other users on mailing lists and the Ask LibreOffice website.

For users whose main objective is personal productivity and therefore prefer a release that has undergone more testing and bug fixing over the new features, The Document Foundation maintains the LibreOffice 6.2 family, which includes some months of back-ported fixes. The current version is LibreOffice 6.2.5, and all users are invited to update.

LibreOffice in business

For enterprise class deployments, TDF strongly recommend sourcing LibreOffice from one of the ecosystem partners to get long-term supported releases, dedicated assistance, custom new features and bug fixes, and other benefits. Also, the work done by ecosystem partners flows back into the LibreOffice project, benefiting everyone.

Also, support for migrations and trainings should be sourced from certified professionals who provide value-added services which extend the reach of the community to the corporate world and offer CIOs and IT managers a solution in line with proprietary offerings.

In fact, LibreOffice – thanks to its mature codebase, rich feature set, strong support for open standards, excellent compatibility and long-term support options from certified partners – represents the ideal solution for businesses that want to regain control of their data and free themselves from vendor lock-in.

Availability of LibreOffice 6.3

LibreOffice 6.3 is immediately available from the following link: https://www.libreoffice.org/download/. Minimum requirements for proprietary operating systems are Microsoft Windows 7 SP1 and Apple macOS 10.9. Builds of the latest LibreOffice Online source code are available as Docker images: https://hub.docker.com/r/libreoffice/online/.

LibreOffice Online is fundamentally a server service, and should be installed and configured by adding cloud storage and an SSL certificate. It might be considered an enabling technology for the cloud services offered by ISPs or the private cloud of enterprises and large organizations.

LibreOffice users, free software advocates and community members can support The Document Foundation with a donation at https://www.libreoffice.org/donate.

LibreOffice 6.3 is built with document conversion libraries from the Document Liberation Project: https://www.documentliberation.org.

Press Kit

The press kit, with background documents – Hybrid PDF, opened from within LibreOffice can be edited as normal ODT files – and high-resolution images, is here: https://nextcloud.documentfoundation.org/s/g4zsogp5qxE9bdH