UK Government Digital Service joins The Document Foundation Advisory Board

Berlin, July 22, 2019 – The Document Foundation (TDF) announces that the UK’s Government Digital Service (GDS) has joined the project’s Advisory Board, effective immediately.

The Government Digital Service (GDS) is part of the UK Cabinet Office [1]. It leads the digital transformation of Government in the UK, helping people interact with government more easily and supporting government to operate more effectively and efficiently.

In July 2014, the UK Cabinet Office announced the selection of the Open Document Format (ODF) for sharing and viewing government documents.

The Open Standards Team within GDS support and encourage the use of open standards in government. Their aim is to help identify and contribute to open standards for software interoperability and to promote data formats that will help to meet user needs across the UK government and support the delivery of common components.

“GDS has been a long-term supporter of the adoption of Open Document Format, and their participation in the TDF Advisory Board represents a strong endorsement of the project’s commitment to the advancement of open standards and ODF”, says Simon Phipps, TDF Director.

John Strudwick, Interim Director for Service Design and Assurance at GDS, said: “GDS are delighted to have joined the Advisory Board of TDF. We believe that open standards are important in meeting the needs that users have of Government and that ODF plays a big role in helping to deliver this.”

TDF Advisory Board’s (AB) [2] primary function is to represent supporters of the project, and to provide the Board of Directors (BoD) with advice and guidance. In addition, the AB is at the kernel of the LibreOffice ecosystem, and as such is key to the further development of the project.

[1] https://www.gov.uk/government/organisations/cabinet-office
[2] https://www.documentfoundation.org/governance/advisory-board/

Annual Report 2018: LibreOffice Online

LibreOffice Online is a cloud-based version of the suite that end users can access via a web browser. It uses the same underlying engine as the desktop app, so that documents look identical across the versions. But where did it come from, what happened in 2018, and how can you deploy it on your infrastructure? Read on to find out…

Some History

Development of LibreOffice Online started back in 2011, with the availability of a proof of concept of the client front-end, based on HTML5 technology, produced by SUSE. In 2015, this proof of concept was re-written into an initial Online Development Edition by Collabora, allowing advanced users to check out LibreOffice in the cloud for the very first time.

In 2016, the first source code release of LibreOffice Online, a cloud office suite which provides basic collaborative editing of documents in a browser by re-using LibreOffice desktop’s “core engine”, was added to the master branch for the announcement of LibreOffice 5.3.

This last development brought collaborative editing to LibreOffice Online, a feature which transforms the application into a state of the art cloud office suite – the first to natively support the ISO/IEC standard Open Document Format (ODF) with collaborative editing features.

The rendering fidelity of LibreOffice Online is equivalent to that of the desktop software, and interoperability matches that of LibreOffice thanks to the support of both standard and proprietary document formats. LibreOffice Online has been developed mainly by Collabora, a leading contributor to the LibreOffice codebase and community.

LibreOffice Online in 2018

The main feature in online office suites is collaborative editing, and LibreOffice Online is no exception. The server module, which is key for this feature, is improved with every new major release of LibreOffice, with a focus on performance and security.

The graphical user interface was enhanced with the release of LibreOffice 6.1 by exposing various dialogs in LibreOffice core to the web browser. These dialogs were:

  • Writer: Find & Replace, Edit Style, Hyperlink, Special Character, Index Entry, Character, Paragraph, Bullets & Numbering, Table Properties, Spelling & Grammar, Word Count, Change Tracking Management, Insert Header & Footer, and Column Formatting
  • Calc: Ability to Add Autofilter, Ability to Filter Items via Autofilter Popup, Format Cell, Sorting Functionality, Support for Hidden Tabs, Support for Chart Data Series Editing, and Data Validation
  • Impress: Position & Size, Line and Area

The most significant improvements and new features announced at the time of LibreOffice 6.2 were the following:

  • Performance: improvements of scroll wheel, zooming, disk space, session and cache management, reduction of latency and unnecessary animation, and avoidance of repeated re-layout of comments & red-lines
  • Mobile: simplification of user interface, improvement of on-screen keyboard and cursor handling, addition of context toolbar and cleaning of other toolbars, and improvements to comment rendering
  • Integration: insertion of remote graphic from integration, addition of configurable time-limit for document conversion, installation of sample webserver config snippets, and addition of hosting/capabilities endpoint to list online features
  • Document signing: integration of Vereign compatible authentication and document signature, new LibreOfficeKit signing and certificate APIs, configuration to enable/disable the signature, and addition of a signing infobar
  • Other features: opening PDF files in a new tab instead of downloading them, improving configuration options for track changes, addition of a new shape insertion toolbar and of missing configuration defaults, and cleaner and more attractive 404 error reporting

LibreOffice Online Positioning

LibreOffice Online is server software which – to be fully functional – must be integrated with a service that provides file storage and authentication. As such, it can be considered an enabling technology for the public cloud of ISPs, or the private cloud of enterprises and large organizations, when it is integrated – for example – with enterprise file sync and sharing software, or a groupware solution.

The Document Foundation does not plan to develop or deploy a public cloud solution similar to existing products from Google and Microsoft, because this would not be in line with the original mission of the project. The task is therefore open to ISPs and providers of open source cloud solutions, with many options already available on the market.

Given the mission-critical nature of LibreOffice Online, The Document Foundation will not be maintaining binaries for enterprises, because this would create expectations which could not be fulfilled by volunteer-based support. However, builds of the latest code, suitable for home users and those who wish to contribute to development – which is encouraged – are available as Docker images.

Annual Report 2018: New releases of LibreOffice

Thanks to your generous donations, and contributions from our ecosystem of certified developers, we released two major releases of LibreOffice in 2018: 6.0 on January 31, and version 6.1 on August 8.

In addition, 14 minor releases were also made available throughout the year, for the 5.4, 6.0 and 6.1 branches. Meanwhile, several Bug Hunting Sessions were held in preparation for the new major releases. These typically took place on a single day between set times, so that experienced developers and QA engineers could help new volunteers to file and triage bugs via the IRC channels and mailing lists. The Bug Hunting Sessions for LibreOffice 5.4 were held on April 27, May 28 and July 3 – while those for LibreOffice 6.2 took place on October 22, November 19 and December 21.

LibreOffice 6.0

On January 31, LibreOffice 6.0 was officially released after six months of development. This included a new ePUB filter, for saving documents as eBooks, while support for opening QuarkXPress documents was added as well. Other new features included: a revamped special characters dialog; OpenPGP support for signing and encryption on all desktop platforms; a brand new web browser-based help system; and better flexibility when using custom dictionaries.

In addition, LibreOffice 6.0 lets users perform mail merge operations using data from tables inside Writer itself, while in Calc, new commands were added to select unprotected cells on protected or unprotected sheets. Impress was also improved thanks to 10 new templates, designed for home and business use. This video summarises the improvements:

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.1

Later in the year, on August 8, LibreOffice 6.1 was made available. This release included many new features such as Colibre, a new icon theme for Windows based on Microsoft’s icon design guidelines, which makes the office suite visually appealing for users coming from the Microsoft environment.

The image handling engine was reworked to be significantly faster and smoother thanks to a new graphic manager and an improved image lifecycle, with some advantages also when loading documents in Microsoft’s proprietary formats.

Then there was the reorganization of Draw menus with the addition of a new Page menu, for better UX consistency across the different modules, along with a major improvement for Base, only available in experimental mode: the old HSQLDB database engine has been deprecated, though still available, and the new Firebird database engine is now the default option (users are encouraged to migrate files using the migration assistant from HSQLDB to Firebird, or by exporting them to an external HSQLDB server).

Finally, Online Help pages were enriched with text and example files to guide the users through various features, and are now easier to localize. Check out the other 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.

This was all possible thanks to your donations! Support our community today, so we can keep improving LibreOffice, organising events and sharing knowledge. Thank you!

The Document Foundation and LibreOffice Online at OW2con 2019

OW2con 2019 is the annual open source event bringing together the OW2 community, technology experts, software architects, IT project managers and decision-makers from around the world. The conference will be hosted by the Orange Gardens Innovation Center, Paris-Châtillon, on June 12-13, 2019.

The central theme of OW2con 2019 is: “Open Source Toward Industry Maturity”. Indeed, with open source becoming mainstream, IT developers, vendors, users and even open source organisations such as OW2 have to adapt. Today, open source projects are becoming increasingly competitive and all IT developers, vendors and users must have an open source strategy.

During OW2con 2019, The Document Foundation and LibreOffice Online will be presented during two different talks:

  1. Breakout SessionAdding LibreOffice To Your Online Solution, managed by Michael Meeks (Collabora), Philippe Hemmel (Arawa) and Thorsten Behrens (CIB), on Wednesday June 12, from 1:45pm to 3:45pm.
    LibreOffice Online can be integrated into cloud solutions, as in the case of Nextcloud, ownCloud, Pydio and Seafile. The software is 100% open source and can be the perfect solution for GDPR issues in organizations. During the session it will be possible to get an overview of the application, and ask both technical and business-related questions.
  2. TalkIntroducing The Document Foundation, by Simon Phipps (TDF/OSI), on Thursday June 13, from 9:45am to 10:00am.
    The Document Foundation is one of OW2’s newest Affiliate organisations, and is a global charity based in Germany that works to promote open source productivity tools. Its flagship project, LibreOffice, is available across major desktop platforms and continues the fourth decade of impact from the code that started life as Star Writer on CP/M.

More information about OW2con 2019 are available on the event website: https://www.ow2con.org/view/2019/.

Annual Report 2018: The Document Foundation

Every year, The Document Foundation produces an Annual Report, detailing its activities in the projects and community. We’ll be posting parts of it here on the blog, while we prepare a final printed version…

Election of TDF Chairperson and Deputy

In February, the Board of Directors of The Document Foundation – during its first meeting of the new term – confirmed Marina Latini in the role of Chairwoman, and appointed Björn Michaelsen to the role of Deputy Chairman.

Marina said: “Our project is growing fast with contributors from several countries, and we need to focus much more on lowering the barriers to being a really welcoming community. I would like our community to become as inclusive as possible, and never leave out those who, just in appearance, look different to us. Openness is a state of mind.”

Björn, who had previously served as a Deputy on the Board, added: “I am encouraged to see strong contributors to the project as new candidates in this election, and hope to share the duty of serving with them, together providing a strong and reasonable voice of independent and unaffiliated input in the Board. Ultimately, I hope after this one last term I can confidently leave TDF’s Board with many new diverse and independent voices in all parts of the project and foundation, and retire back to spending my contributions more on – for instance – the source code again.”

New Advisory Board member

In May, TDF announced that BPM-Conseil, a company focused on open source business intelligence and based in Lyon (France), had joined the project’s Advisory Board. BPM-Conseil will develop the integration of LibreOffice with its business intelligence solutions Aklabox and Vanilla, and also create business intelligence-related extensions for LibreOffice.

BPM-Conseil is focused both on development of open source business intelligence solutions and on the related consultancy and integration activities. The company has a large roster of clients in France, such as the Ministries of Environment, Energy and Sea, Lyon Metropole, Nimes Metropole and City, La Rochelle Agglomeration, Haute and Basse Normandie, the Aveyron Department, and the University of Corsica.

Tenders

In 2017, TDF launched four tenders aimed at sharing knowledge about improving LibreOffice in several strategic areas, where the tasks are beyond the capabilities of independent volunteer developers. In 2018, companies selected to implement two of the tenders reported back on their work.

Firstly, Collabora was selected for the tender “improve image handling in LibreOffice (#201705-01)”. A new image life-cycle was developed, with simpler memory management for handling images and new swapping strategy. The results were incorporated into the LibreOffice 6.1 release – and a more detailed technical description of the work is on the blog, in order to share knowledge and experience from this project with the developer community and the general public.

The second tender, “implement HSQLDB binary format import in LibreOffice (#201705-03)”, was also assigned to Collabora and implemented by Tamás Bunth. He developed a mechanism to import database files with high fidelity from the HSQLDB binary file format, used by many existing ODB files, by reading the Java serialization code, and writing a filter to import all data into LibreOffice Base. The objective was to remove the legacy Java/HSQLDB database and to simplify the move to Firebird. More details are provided here.

Highlights of activities

Throughout the year, TDF supported initiatives and campaigns from other organisations that promote free and open source software. For instance, in February, we joined “I love Free Software Day”, a campaign by the Free Software Foundation Europe (FSFE). As they explain: “We should remember the power of a simple ‘thank you’ to motivate Free Software contributors in their important work for society. And the 14th of February is the ideal day to do that.”
March 27 was “Document Freedom Day 2018”, a campaign about open standards and document formats, aimed at non-technical people. The goal is to make regular users more aware of interoperability issues, and the importance of storing documents (and indeed any kind of data) in open and standardised formats. This helps users to avoid vendor lock-in, giving them more freedom to use the software they want – and this is also important for governments, companies and organisations.

In September, we joined the “International Day against DRM”. DRM, or Digital Rights Management, is a set of access control technologies for restricting the use of proprietary hardware and copyrighted works, by controlling the use, modification, and distribution of copyrighted works. Instead of educating users, companies prefer to restrict them from exercising their legal rights under the copyright law.

DRM is an epidemic spreading across the web, infiltrating homes, classrooms, workplaces, and just about everywhere else users can go. Tools, technologies, books, games, movies, and music are coming to us locked down with DRM, whether they are streaming or claim to be locally hosted. TDF supports the International Day Against DRM as part of its daily fight to make content sharing available to all individuals, and to educate them to adopt open standards to foster innovation.

Document Liberation Project

TDF also hosts and supports the Document Liberation Project (DLP), a sister project of LibreOffice, which fosters the development of software libraries that can import and export data in many different file formats. DLP libraries are used by many free and open source software projects, such as Inkscape, Scribus and LibreOffice, and help users to get control of their data – especially from old and proprietary file formats. In 2018, new libraries were added to the DLP project and the community produced videos encouraging people to contribute. Learn more about DLP in this quick 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.

This was all possible thanks to your generous donations – support us today!

Sophie Gautier talks about the project

You are one of the people who have been around from the beginning of The Document Foundation, and one of the oldest members of the community (including the years of OpenOffice.Org). How were you involved in the project?

I was using StarOffice 5.2 and was contributing support on the French speaking users list. When Sun Microsystems was about to open source the code and create the OpenOffice.org project, they invited me to join and support the community. From there, I’ve been involved in various tasks like localization, quality assurance or documentation.

We are getting close to the 10th anniversary of the LibreOffice project, and the 20th anniversary of the FLOSS office suite. Which are the milestones of this long history?

I may not remember all of them, but I guess the creation of the Native Language projects with the French speaking one as a Proof of Concept in 2001. Then the many community supported projects such as marketing, documentation, etc.

And then of course, the birth of the LibreOffice project. Since then I’ve the impression that each year is a milestone 😉

There have been so many exciting things to do in each corner of the project. The community is pushing a lot of good ideas and energy. Considering the work done on QA, UX/Design and marketing for the product or the community, the new help system and the size of our infra, we have achieved more than we could even imagine ten years ago!

You have been involved in the localization of the software since the very first version, and now you are coordinating the activity of native language projects. Can you talk about the localization activity?

Localization is a complicated task, and sometime tedious. LibreOffice is a big software with thousands of different strings. Localization happens at the end of the software making process, so the workload depends on development, UX/Design and marketing projects.

Recently, there have been changes on the strings format for almost the entire interface of each module, on the help system and more and more marketing activities. Each localization member should be very proud of his/her work.

We want to cover more languages because localization is a way to preserve those languages, preserve the local culture and give all users the opportunity to express themselves in their own language. This is where my activities lie: understand the needs of localizers, voice their concerns, update the workflow and try to make them happy to translate the different projects.

You have been a member of the team for almost six years, with a number of different responsibilities. From your point of view, how well did the project during this time?

Happy to say: fairly well 🙂 The task was not easy but I believe we are doing right. Some people would like to see more things happening, or the project going faster or further. But we are a diverse community with different cultures, different business or occupations and different time zones!

We need to keep people together on the same path, to preserve the soul of the project. It’s not easy to keep an eye on the horizon on a daily basis, but our directors are doing that since the beginning and they are doing it very well if you look at the foundation’s results.

I can see my colleagues of the team working hard on each critical part of the production process, and at the same time taking care of the community, trying to answer end user questions and help independently from what they have on the table. I’m proud and very happy to be part of this team, and happy to see how mature the foundation has became. Every day I’m learning something new, either from them or from the community. I’m thankful for that 🙂

With the growth of the project and the community, you are now moving to the position of Foundation Coordinator. Can you describe this role?

I’m taking care of several foundation activities, like helping to organize LibOCon and Advisory Board meetings, and handling several administrative tasks. I’m also directly involved in L10n/NL, marketing and certification projects.

I follow what is happening in other parts of the project, and try to bring my help and my knowledge where needed. For example, when the work began on the UX, I helped the team with my knowledge of the product and its philosophy.

The change will happen mainly in the administrative parts, where an assistant will be hired by the foundation. That should leave me more time to push some projects we want to put in place, like the travel support program, Open Badges, moving to another translation tool, etc.

Looking at the next decade, which are the top challenges for LibreOffice?

One of the most important challenges for open source projects is to make the community of volunteers and ecosystem participants thrive. Our developers are securing this by constantly enhancing tools and processes, but at the same time users and contributors are evolving, and we need to reinvent ourselves almost every day. This also means to re-evaluate processes and tools, looking at them in perspective.

Last, but not least, the product has to further evolve according to changes in the market, and we have to invest to make the online version more popular amongst users and increase the number of adoptions and contributions to the project.