Updated LibreOffice growth infographic (2020)

Right after celebrating a great LibreOffice 10th Anniversary, we are delighted to present the 2020-version of our LibreOffice growth infoGraphic, including beautiful visuals and interesting numbers! We do hope you appreciate it and would love to hear your feedback. And of course it is great if you find the format, in which it is presented, convenient to share.

Many numbers are again up. Our devs are top code contributors to LibreOffice with 7518 code commits. And the popular “Collabora Online Development Edition” (CODE), for home use & small teams (find details here), has over 50 million Docker image pulls! We are extremely grateful for all partners and customers working with us to make this possible.

Would you like to see the previous versions; these are here: 2019, 2018, 2017, 2016, 2015, & 2014.

Soon there will be the  LibreOffice Conference 2020 (October 14 to October 16), where you can meet developers, including of course our developers, and other contributors from the community, and attend the online sessions of the talks of our developers.

So.. check out the updated LibreOffice growth infoGraphic on 2020 here:

 

Try out Collabora Office and Collabora Online!

Implementing Vulkan-capable LibreOffice user interface using the Skia library

This work by Collabora Productivity was possible thanks to AMD.

LibreOffice 7.0, just released, includes a new drawing backend based on the Skia library, which allows LibreOffice to use the modern Vulkan API to graphics operations. This Visual Class Library (VCL) backend is the default on the Windows platform, superseding the OpenGL-based backend.

Working on the future of graphics for office productivity

Having multiple VCL backends has its benefit to integrate with different operating systems, but each backend performing its own rendering implementation is far from optimal, since we cannot add new rendering functionality and assume that it will work cross-platform. Many backends across different platforms and toolkits miss optimized paths for various rendering tasks. This adds complexity and makes it hard to ensure that rendering objects happens in an accelerated way everywhere.

Another problem is that multiple backends regularly perform the same type of mapping from VCL’s APIs to what a modern toolkit provides these days. This duplication means not only maintenance cost, but also can lead to having to fix the same bug at multiple places.

Moving away from GDI and OpenGL

The VCL library is responsible for widgets (buttons, controls, etc.) and basic rendering. It does not implement the drawing directly, but it provides an internal API, which is implemented by various backends that implement the actual graphics operations. These backends usually adapt LibreOffice to each platform , for example the ‘win’ backend is used on Windows, the ‘kf5’ and ‘gtk3’ backends are for Unix-like platforms using the KDE Frameworks and the Gtk3 graphics toolkit respectively and there is a ‘headless’ backend used by tests that does not render to the screen.

Each VCL backend uses an underlying graphics API available on the platform to perform the graphics operations. The Cairo library is used by some Unix-like and ‘headless’ backends, the ‘osx’ backend uses the macOS Quartz. On Windows, the ‘win’ backend has several plugable drawing implementations:

  • GDI drawing. This code is relatively old and has several limitations, such as not being double-buffered.
  • OpenGL drawing. This code provides GPU-accelerated drawing. OpenGL is used directly, so all relevant code including OpenGL shaders needed to be implemented in LibreOffice. The OpenGL API is also slowly being phased out in the industry.
  • Skia drawing. The Skia library hides implementation details, and provides several rendering methods, including Vulkan API.

Integrating Skia and Vulkan

The Skia library is not shipped in a binary form, not even by 3rd-party providers such as Linux distributions. It is provided only as source and the usual way to use it in a project is to ship it with that project. LibreOffice includes Skia as a 3rd-party library and fortunately building it using the LibreOffice gbuild system is reasonably simple. An additional complication is that Skia provides a new release roughly every 6 weeks, and generally only the latest release receives any fixes, requiring repeated updates. Since Skia is continually evolving, each update may also require adjustments (although so far it seems they are generally small).

Collabora’s developers taking the first hurdles

The Skia API is generally well documented, but it appears to be mostly aimed at developers already working on a project using Skia, such as Chrome. Important classes have their API well described, but it can be difficult to find tutorials for them and some classes are harder to understand at the beginning (for example, SkPixmap, SkBitmap, SkImage and SkSurface are all classes representing a drawable, but it was unclear at the beginning what the suitable use cases would be for each for them).

Similarly, it is not obvious how to use Skia in a new project. There does not seem to be any actual developer introduction to Skia in the documentation, nor does thereseem to be any documentation on how to setup a new or standalone project using Skia. There is a Hello-World example in the examples/ directory that is based on platform integration code that is not part of the Skia library itself but is inside a sk_app/ directory in the tools/ directory. That code was usable for LibreOffice, but required patching to cover LibreOffice needs (for example, the code created a new graphics context for each toplevel window, and Skia requires proper graphic context to be used in drawing operations, but LibreOffice code sometimes does not know which toplevel window will use the result of a drawing).

LibreOffice is a fairly old codebase, and still uses relatively old concepts such as paletted bitmaps, low-resolution bitmaps (such as 4bpp) or drawing that uses the XOR operation on pixels. Skia, being a relatively new library, has features that assume modern concepts are used (for example, RGB bitmaps are required to be 32bpp with unused alpha channel, 24bpp RGB bitmaps are not supported).

 

AMD Skia / Vulkan integrated in a alpha-release of LibreOffice 7.0

 

Once the initial learning period is over, Skia is consistent in its API and reasonable flexible to use allowing progress to be relatively fast. Code using Skia is very readable, and using Skia makes future maintainance tasks easier to perform. Even some old concepts, such as LibreOffice using a separate bitmap for alpha channel, sometimes interpreted as 8bpp and sometimes as alpha, later blended with data bitmap to get the actual result, could be mostly implemented using Skia API, making them GPU-accelerated.

Nice performance and even room for improving

While there were some concerns about how performance would be affected by moving to Skia compared to OpenGL driver and and hardware implementations that have been heavily optimized over the past several decades, it turns out that performance within LibreOffice is at least equivalent to the OpenGL version and synthetic benchmarks show that there is room for improvement.

Benefits for LibreOffice technology

While somewhat complicated at the beginning, using Skia in LibreOffice has been in general a rather pleasant experience. In the future LibreOffice’s use of Skia could be extended to other platforms, reducing the number of platform rendering APIs used, eliminating duplicated code, reducing bug count and generally improving quality.

For comparison, LibreOffice OpenGL drawing code is roughly 12k lines of code, while Skia drawing code is only 4k.

Apart from the immediate benefits, moving to Skia and Vulkan on Windows paves the way for a single, powerful, hardware-accelerated rendering API cross-platform.

Moving to Skia on Windows required about 7 person-months ol, which lets us use Vulkan acceleration without large implementation costs. It will be interesting to see how much time is saved in the next few years from the reduced maintenance cost. The resulting work is mature enough that there is no real negative change in performance, and we have not started heavily optimizing yet.

Collabora Office 6.4 Released

Cambridge, August 4th, 2020 – Today we release Collabora Office 6.4 providing businesses and professionals with the best features, interoperability, LTS and custom support in open source while respecting user privacy and company data security. Changes in Collabora Office 6.4 also support new and enhanced features in Collabora Online.

Excellent Interoperability and World Class Support

Collabora Office 6.4 offers excellent interoperability with all major office formats. Import text documents, spreadsheets and presentations from MS Office files or the Open Document Format and save them just as easily. We maintain the world’s largest team of certified LibreOffice developers and offer our customers a long-term supported version of LibreOffice. Version branch 6.4 of Collabora Office will be supported until August 2023 at least.

New Features in Version 6.4

In addition to improving performance and interoperability, Collabora Office 6.4 brings a number of practical improvements to your work. The newly implemented functions can be found all over the suite. The following are some outstanding examples.

 

Adding Visible Signatures to Existing PDF Files

Collabora Office already had the capability to add a digital signature to an existing PDF file. This still works the same. That signature however is (and was) only visible on the status bar and in file properties; there is no visible signature in the PDF file. Now in Collabora Office 6.4 adding a visible signature has been made possible. You start this new feature by selecting the PDF file with File > Digital Signatures > Sign existing PDF.

 

Addding visible signatures to existing PDF files
Ad visible signatures to existing PDF files

Read all details in this blog post.

 

Send Encrypted PDF Files with Mail Merge

One of the very handy and well established features of Collabora Office Writer, is Mail Merge that directly sends out PDF files. In version 6.4 this function has been extended so that you now can send encrypted PDF files. This enhances the privacy options of your workflow. Find more details in our blog.

 

Encrypt your PDF when sending them with Mail Merge

 

Padded Numbering Up to 5 Characters

Padded Numbering allows you to work with list numbering using a prefix. This is now possible up to four zeros. The feature that was introduced in an earlier version was limited to prefixes of two zeros.

 

A Padded Numbering list with a prefix of two zeros in Writer

 

Set Distance of Shapes to the Bottom of the Page

It can be very handy to specify the vertical position of a shape in text documents by setting the distance at the bottom of the page content area. Until now, this was not possible, although you can do so with the distance at the top of the page content area. If you tried to do the same from the bottom, the shape would be pushed below the margin. Collabora Office 6.4 now fixes this. You can set a negative value for the position to the bottom of the page content area, and the shape will stay in that position. Also when for example the page size is changed, or when other content is added or moved. More details are described in this blog.

 

 

Export Larger Pages from Draw using PDF 1.6

Using PDF 1.6, exported PDFs can now be larger than 508 cm (200 inch). Before the size was limited because of the possibilities of the PDF 1.5 specification. Since PDF files from Collabora Office, or more specifically from Draw, can be used to create banners, a limitation of 5 meters only is of course, impractical. More background on this can be found in this blog.

 

Export large PDF from Draw

 

Semi-transparent Text in Writer

Collabora Office 6.4 supports semi-transparent text, as it is also supported by Microsoft Word for DOCX files. So this again represents an interoperability improvement. In this blog you can find more details.

 

Interoperability improvement. Semi-transparent text in Writer

 

Upstream LibreOffice and more…

Collabora Office is based on the stable LibreOffice branch with extra features and fixes. Collabora Office 6.4 has the capabilities as described in the LibreOffice 6.4 release notes, of which quite some, especially these for our customers, have been introduced in earlier versions of Collabora Office. Of the 6.4 features, quite some have been added by our Collabora Productivity team. As an outstanding example, we feature the Full PDF Export for Spreadsheets.

Full-Sheet Previews option on the PDF Export Dialog
Full-Sheet Previews option on the PDF Export Dialog

 

Updates & Security advisories

News on all 6.4-updates are in the release notes. And for security updates, pls check this page.

 

About

Collabora Office is the LibreOffice-technology based suite for professional, mobile, and online use. Collabora Office 6.4 provides businesses and professionals with the best features, interoperability, LTS and L3 support.
Collabora is privileged to work with so many great contributors to the LibreOffice project and appreciates all the amazing work done by so many that is also included into Collabora Office 6.4. This, our annual release, contains much work that was contributed to LibreOffice 6.3 and then LibreOffice 6.4. These cover all manner of areas from significantly improved filters, performance improvements, 95+% of online features and improvements, rendering along with a powerful redaction feature.
Please do find the full credits here.

Migrate with our demo of Collabora Office 6.4

You can try Collabora Office 6.4 yourself! Just head to the Collabora Office page and request your demo today, or just click the button below.

Try the Demo

Add Visible Digital Signatures to Existing PDF Files in Collabora Office 6.4

Collabora Office already had the capability to add a digital signature to an existing PDF file. The PDF file was to be selected, starting with File > Digital Signatures > Sign existing PDF. This still works the same now. The file is then opened as read only in Draw and the button Sign Document on the notification bar, allows you to add a digital signature. That signature however is (and was) only visible on the status bar and in file properties. There is no visible signature in the PDF file.

Now in Collabora Office 6.4 it is possible to ad visible signatures too.

 

Adding a Visible Digital Signature

To achieve this, the procedure starts the same: select the PDF file with File > Digital Signatures > Sign existing PDF. Then, as the file is read only in Draw, choose File > Digital Signatures > Signature Line.
 
After opening the PDF for signing, again use File > Digital Signatures ..

The mouse pointer changes, and it is possible to drag a rectangle in the file. When the mouse is released, the dialog to select the signature appears.

 

When done, the notification bar now indicates the button Finish Signing. Click that and the digital signature will be confirmed. The rectangle, showing a picture and information about the signature, can be resized before signing is finished.

 

If needed, the signature image can be resized

After that, again all is read only – of course. It is possible however to add another signature, so that for example more people can sign.

 

Confirm signing the PDF file

Some more background details can be found in the developer blog by Miklos Vajna. Thanks to the Dutch Ministry of Defense in cooperation with Nou&Off who made this work by Collabora possible.

Read more about Collabora Office 6.4

Read all about the new Collabora Office 6.4. Or try it yourself! Just head to the Collabora Office page and request your demo today, or simply click the button below.

Try the Demo

Send Encrypted PDF files with Mail Merge

From now on the powerful Mail Merge feature will be even more useful: you can send encrypted PDF files directly from Collabora Office Writer!

A handy feature of Collabora Office Writer since long, is doing a mail merge that directly sends out PDF files. From now on you can make the PDF files encrypted, adding additional privacy option to your work. The feature will be available in Collabora Office 6.2-21 and 6.4, and has of course been pushed to the LibreOffice master branch as well. Thanks to Collabora for sponsoring this work and kudos for Gülşah Köse for doing the work. In this article we’ll show you how to set this up.

Mail merge preparations

Of course, you need to have done the usual preparations for mail merge. We’ll briefly show a few essential steps.

Set up the mail server

This allows you to directly mail the merged documents from Collabora Office.

  • Open (a file in) Writer.
  • Select Tools→Options → Collabora Office Writer → Mail Merge Email

And fill the fields like following (with your own information)

Filling in the user information for Mail Merge
  • Click the Server Authentication button and fill with your information and click OK.

If the first option is insufficient, then of course also fill in the other information.

Adding additional information for Mail Merge
  • From the Options dialog click the Test Settings button to see if your information is OK.

If so, you will see the following dialog. If not, check the information again.

Success! This dialog confirms the correct account settings
  • Click OK from the Options dialog. Then mail server should be set now.

Prepare the database / data source

Collabora Office can link to various data sources. In this case, of course an email address and a password to encrypt the PDF file must be provided by the database.

The simple table below, has fields / columns for emails and passwords.

Address data for Mail Merge can be compiled in a spreadsheet

You have to make sure that this data source is used.

  • Chose Edit→ Exchange Database…
  • Click View→Data Source to use that database in Collabora Office

Next steps are of course creating a template document with fields and content. It is not necessary that the email and password fields are in the template – you must select these later on.

Do the mail merge

  • To send the document use Tools→Mail Merge Wizard or click the icon on toolbar.

  • In the Wizard:
    1. Select Use current document and click Next
    2. Select E-mail message and click Next
    3. Click “Select the address list”. Select your sheet from the menu and click OK.
    4. Click “Finish”.

We are ready for sending documents.

  • Click the “Send Documents” icon from the toolbar
The Mail Merge icons can be activated via View > Toolbars > Mail Merge

Chose to save and send with password

As a last step, you will see the following dialog.

  • Chose “Send as Adobe PDF”
  • Then the password option will be available. Select it.
The final settings before your encrypted PDF will be sent

The password for each PDF file will be taken from the database of recipients, thus allowing the use of individual passwords.

  • Click the “Send Documents” button and wait for the process to finish.

That’s all. We hope you like this. 🙂

Test Collabora Office

If you want to learn more about our long term supported Collabora Office 6.2 (supported until December 2022 at least) and its possibilities and advantages for your organization, get info and a demo here!

Test Collabora Office