Recent Contributions from Collabora to LibreOffice

We’re continually contributing improvements to the LibreOffice code-base as a member of the community (Collabora Online Forum). Here are a few highlights of the last week’s work on behalf of our customers.

“Collabora is a commercial organisation; of course we serve the needs of our paying customers, but it is a real pleasure to be able to contribute alongside the development community to LibreOffice,” said Michael Meeks, General Manager of Collabora Productivity. “It, not only, helps us offer our customers business values and benefits other companies can’t, but it provides us with an incredibly robust development and support resource.”

There’s a lot going on in the community and here are few current projects that demonstrate what people are hacking.

Enabling Calc support for 16384 columns by default

Over the last couple of weeks Luboš Luňák (Llunak) has been working for Collabora on the 16k columns support in Calc. There’s been a lot of work on this already by Noel Grandin and others, but so far this has been hidden behind the experimental option, and normally documents open only with the “normal” 1024 columns support. The goal of this work is to finish the 16k support stable enough for it to be the default, so that people who need this many columns can finally get them without any complications.

If all goes well, and so far Luboš doesn’t see why it shouldn’t, LibreOffice 7.4 will ship with 16k columns being the default. Calc users will then be able to get a lot more columns to work with.

This work is funded/sponsored by DEVxDAO as part of its mission to support Open Source and transparent research and development of emerging technologies and frameworks. Interestingly finishing this work was also a project that was proposed by to be funded by TDF, and ranked as one of the top requested features, it is great that this budget can now be re-applied to another task.

If you have ever been bitten by the “too many columns” dialog box then, why not find out more about what Luboš is working on.

Word-style border fixes in Writer: pages, tables and paragraphs

Miklos Vajna (vmiklos) has been looking at Writer and how it can better render Word-style borders around pages, tables and paragraphs.

Word users expect to able to import their documents to Writer and experience high-fidelity rendering. This means Writer has to support the way page / table / paragraph borders are painted according to the OOXML model as well. This is all done conditionally, so existing ODF documents are left unchanged.

As a result of this work, Writer now has a set of improvements to better render Word-style borders around pages, tables and paragraphs.

Thanks must go to Docmosis and TUBITAK that have made this work by Collabora possible.

Find out more and take a look at some of the improvements that have been made.

Sparklines in Calc

Sparklines are mini charts available in OOXML (XLSX) documents that up to now were not supported by LibreOffice Calc.

Tomaz Vajngerl explained that to add support in LibreOffice for sparklines, they first needed to be read into the LibreOffice data model, but the data model for sparklines didn’t exist, so it first needed to be created. Once the data model was ready we could render the sparklines in the cell area.

Currently the code for this is in a feature branch (feature/sparklines), but it’s in the process of being up-streamed to master. The feature will be available in LibreOffice 7.4.

Thanks to the funding of NGI and the European Union, this missing feature is now being implemented. This project has received funding from the European Union’s Horizon 2020 research and innovation programme under grant agreement No 871498.

Find out more about the work going into the development of sparklines in Calc.

These are just a sample of the good work going on to support and develop LibreOffice for the next release. If you’d like to find out more about what Collabora is doing or, perhaps, you’d like to get involved then please visit the Collabora Online User Forum.

Talks and Slides by Collabora at FOSDEM 2022

FOSDEM 2022 – The Talks and Slides from the Collabora Team

Whether on-site in Brussels or as an online event like the last two years, FOSDEM is and remains the largest and most important gathering of Open-Source developers in Europe. We’d like to express our gratitude to the community and the organisers. The Collabora team gave numerous talks in the LibreOffice Technology devroom. Missed a presentation? Below you will find links to all videos and to the downloads of the slides.

 

Gülşah Köse

LibreOffice Technology devroom

OOXML Document Analysis

Collabora developer Gülşah Köse explains how we respond when we receive a problematic OOXML document from a customer and demonstrates the solution to a sample bug. See details

Watch the talk!
Download the slides!

 

Miklos Vajna

LibreOffice Technology devroom

Document Themes in LibreOffice Impress and Elsewhere

LibreOffice has been capable of handling colour palettes on its UI for a while. Meanwhile, the competition introduced document themes, which are a fixed set of 12 colours, to be attached to various parts of documents. See what we have done to bring themes to LibreOffice and find out what still needs doing and how you can help. See details

Watch the talk!
Download the slides!

 

Gökay Şatır

LibreOffice Technology devroom

Canvas For Rendering UX

Gökay Şatır shows why we chose to use Canvas for rendering the UI and the document, and explains the structure we created to execute this task. See details

Watch the talk!
Download the slides!


Mert Tümer

LibreOffice Technology devroom

Editing Simulation

Performance measurements are really challenging. This presentation by Mert Tümer covers how we can achieve reliable and repeatable performance tests by implementing clever tools that simulate realistic use cases. See details

Watch the talk!
Download the slides!

 

Jan Holesovsky

LibreOffice Technology devroom

LibreOfficeKit Recent Developments

LibreOffice can be used by other applications via its C++ API called LibreOfficeKit. Primary use cases for this are document conversion and editing in Collabora Online. The LibreOfficeKit is currently being expanded. Jan “Kendy” Holesovsky talks about these recent developments See details

Watch the talk!
Download the slides!

 

 

Michael Meeks

LibreOffice Technology devroom

Online Performance – Making Collaborative Editing Quicker

Collabora Online has a novel model that re-uses the core LibreOffice Technology to provide rich collaborative editing. Recently, we have been focusing our development on improving the look and feel of document editing. Watch Michael Meeks talk about how Online performance wins are making browser-based collaborative editing quicker. See details

Watch the talk!
Download the slides!

 

Szymon Kłos

LibreOffice Technology devroom

Building Collabora Online UI Based on the LibreOffice Components

JSDialog is a “framework” for sharing UI components between Collabora Online and LibreOffice. It was used to bring the Sidebar, the NotebookBar, and dialogs to the web. It provides native HTML widgets connected to the original LibreOffice code, giving the user rich editing options even on mobile devices. Watch Szymon Kłos‘ talk for a brief summary of what has already been done and how it works. See details

Watch the talk!
Download the slides!

 

Pranam Lashkari

LibreOffice Technology devroom

Collabora Online on Kubernetes – Setup & Deployment

See this talk by Pranam Lashkari for a comprehensive demonstration of how to deploy Collabora Online using Kubernetes. See details

Watch the talk!
Download the slides!

 

Ashod Nakashian

 16:00 – 16:30 – LibreOffice Technology devroom

Collabora Online: Async-Saving Design and Testing

This talk explores the challenge of saving and uploading documents to the storage server in an asynchronous way, to improve performance, user experience and also ensure higher reliability and resiliency. Ashod Nakashian covers both the design and the challenges of testing a highly critical component of a production product.

See details Join video & conversation

Watch the talk!
Download the slides!

 

Henry Castro

LibreOffice Technology devroom

Macro Dialog Feature

Watch Henry Castro‘s talk on the implementation of a Macro Selector Dialog on the client side to execute VBA macros on the server side. See details

Watch the talk!
Download the slides!

 

 

About Collabora Online

Collabora Online 21.11 is our latest enterprise quality release. It’s suitable for large-scale deployment, and comes with SLA, enterprise support with signed security updates as well as interaction with product management, helping to direct our development priorities. Collabora Online integrates flawlessly into Nextcloud, ownCloud, Seafile, and many of the major file sync & share, groupware and hosting solutions. It’s ideal for organizations that want to collaborate on documents, without losing control over them or compromising on privacy. With the ability to host it on your own hardware or to integrate it into a trusted environment, Collabora Online is the ideal online office suite for digital sovereignty. Enterprises interested in using Collabora Online can check out our home page for more information on partner integrations and online demos. Hosting and Cloud businesses that wish to add Collabora Online to their product portfolio can become a partner. For any questions or tailored solutions, do not hesitate to contact hello@collaboraoffice.com.

 

Collabora at FOSDEM 2022

FOSDEM 2022 – Europe’s largest Open-Source Developers Meeting

FOSDEM 2022 will again take place as an online event. During two days the latest technical achievements of developers from all over the world will be presented. Our team is represented with 10 talks on the different aspects of LibreOffice Technology in the corresponding devroom.

Day 1: Saturday, February 5th 2022

Monica Madon (Canonical), Marius Quabeck (Nextcloud) and Pedro Silva (Collabora)

13:00 – Ubuntu stand

Contributing to Open Source Projects with Ubuntu, Nextcloud, and Collabora

Are you interested in contributing but don’t know where to start? Tag along and be part of the digital sovereign revolution! Everyone is welcome to join.

See details Join video & conversation

 

Gülşah Köse

14:30 – 15:00 – LibreOffice Technology devroom

OOXML Document Analysis

Collabora developer Gülşah Köse, will explain how we respond when we receive a problematic OOXML document from a customer and demonstrate the solution to a sample bug.

See details  Join video & conversation

 

Miklos Vajna

16:00 – 16:30 – LibreOffice Technology devroom

Document Themes in LibreOffice Impress and Elsewhere

LibreOffice has been capable of handling colour palettes on its UI for a while. Meanwhile, the competition introduced document themes, which are a fixed set of 12 colours, to be attached to various parts of documents. See what we have done to bring themes to LibreOffice and find out what still needs doing and how you can help.

See details Join video & conversation

 

Gökay Şatır

 17:00 – 17:30 – LibreOffice Technology devroom

Canvas For Rendering UX

Gökay Şatır will present why we chose to use Canvas for rendering the UI and the document, and explain the structure we created to execute this task.

See details Join video & conversation

 


Day 2: Sunday, February 6th 2022

Mert Tümer

 12:00 – 12:30 – LibreOffice Technology devroom

Editing Simulation

Performance measurements are really challenging. This presentation by Mert Tümer covers how we can achieve reliable and repeatable performance tests by implementing clever tools that simulate realistic use cases.

See details Join video & conversation

 

Jan Holesovsky

 13:00 – 13:30 – LibreOffice Technology devroom

LibreOfficeKit Recent Developments

LibreOffice can be used by other applications via its C++ API called LibreOfficeKit. Primary use cases for this are document conversion and editing in Collabora Online. The LibreOfficeKit is currently being expanded. Jan “Kendy” Holesovsky  will talk about these recent developments.

See details Join video & conversation

 

Michael Meeks

 14:00 – 14:30 – LibreOffice Technology devroom

Online Performance – Making Collaborative Editing Quicker

Collabora Online has a novel model that re-uses the core LibreOffice Technology to provide rich collaborative editing. Recently, we have been focusing our development on improving the look and feel of document editing. Come and hear Michael Meeks talk about how Online performance wins are making browser-based collaborative editing quicker.

See details Join video & conversation

 

William Gathoye

14:00 – Ubuntu stand

Setting up a Nextcloud Instance with Collabora on Ubuntu

Keeping full control over your personal data and documents, is more and more important. Learn how to create your own personal cloud with this easy built-in installation.

See details Join video & conversation

 

Szymon Kłos

 15:00 – 15:30 – LibreOffice Technology devroom

Building Collabora Online UI Based on the LibreOffice Components

JSDialog is a “framework” for sharing UI components between Collabora Online and LibreOffice. It was used to bring the Sidebar, the NotebookBar, and dialogs to the web. It provides native HTML widgets connected to the original LibreOffice code, giving the user rich editing options even on mobile devices. Szymon Kłos will talk for a brief summary of what is already done and how it works.

See details Join video & conversation

 

Pranam Lashkari

 15:30 – 16:00 – LibreOffice Technology devroom

Collabora Online on Kubernetes – Setup & Deployment

See this talk by Pranam Lashkari for a comprehensive demonstration of how to deploy Collabora Online using Kubernetes.

See details Join video & conversation

 

Ashod Nakashian

 16:00 – 16:30 – LibreOffice Technology devroom

Collabora Online: Async-Saving Design and Testing

This talk will explore the challenge of saving and uploading documents to the storage server in an asynchronous way, to improve performance, user experience and also ensure higher reliability and resiliency. Ashod Nakashian will cover both the design, as well as the challenges of testing a highly-critical component of a production product.

See details Join video & conversation

 

Henry Castro

17:00 – 17:20 – LibreOffice Technology devroom

Macro Dialog Feature

Come and hear Henry Castro talk on the implementation of a Macro Selector Dialog on the client side to execute VBA macros on the server side.

See details Join video & conversation


 

 

About Collabora Online

Collabora Online 21.11 is our latest enterprise quality release. It’s suitable for large-scale deployment, and comes with SLA, enterprise support with signed security updates as well as interaction with product management, helping to direct our development priorities. Collabora Online integrates flawlessly into Nextcloud, ownCloud, Seafile, and many of the major file sync & share, groupware and hosting solutions. It’s ideal for organizations that want to collaborate on documents, without losing control over them or compromising on privacy. With the ability to host it on your own hardware or to integrate it into a trusted environment, Collabora Online is the ideal online office suite for digital sovereignty. Enterprises interested in using Collabora Online can check out our home page for more information on partner integrations and online demos. Hosting and Cloud businesses that wish to add Collabora Online to their product portfolio can become a partner. For any questions or tailored solutions, do not hesitate to contact hello@collaboraoffice.com.

 

Collabora presenting the 2021 LibreOffice & Online growth infographic

In the aftermath of this year’s LibreOffice conference, we are glad to provide you with the latest update 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.

Despite the challenges posed by the global pandemic in general, the statistics around LibreOffice collaboration are impressive. Although the total number of contributions to the LibreOffice core has slightly dropped compared to the year before, our developers remain top code contributors to LibreOffice with 4188 code commits (32.3%). The popular Collabora Online Development Edition (CODE), for home use & small teams, saw over 70 million Docker image pulls! We are glad to acknowledge, that the move of Collabora Online to GitHub has resulted in an increased number of contributions from the community. We are truly grateful to the growing number of partners, customers and volunteers for making this work possible.

The number of worldwide Collabora Online partners has raised to 230, the Collabora Office app for Android, iOS and Chrome OS saw 500,000 installations and the last year’s joint online conference by LibreOffice and SUSE did welcome over 130 participants from all over the world.

Would you like to see some previous versions of the info graph? Please find them here: 2020, 2019, 2018, 2017 & 2016.

So, without further ado, please have a look at the updated LibreOffice growth infoGraphic on 2021 here:

 

Try Collabora Office and Collabora Online!

Talks and Slides by Collabora at the LibreOffice Conference 2021

Watch the talks and download the slides of Collabora’s contributions to LibOCon 2021

The LibreOffice Conference 2021 (LibOCon) was held from September 23rd to 25th as an online event. Developers from Collabora have contributed a significant number of talks on various aspects of LibreOffice technology, like interoperability or performance improvements, and regarding Collabora Online and the ecosystem. Did you miss any of those? Don’t worry! The talks are available for you on YouTube. We also encourage you to download the slides of the presentations available in this overview.

Day 1: Thursday, September 23rd, 2021

Michael Meeks: Collabora Keynote

Michael Meeks, Managing Director of Collabora Productivity and member of the LibreOffice Board, looks at the latest developments around LibreOffice from an organizational and ecosystem perspective. See details

Watch the talk
Download the slides!

Noel Grandin: I feel the need… The need for speed…

Optimization is a lengthy process. But also an adventure that requires a bit of detective instinct and plenty of exploratory talent. Discover which adjustments are being made to make LibreOffice even faster and better performing. See details

Watch the talk
Download the slides!

Marco Cecchetti: Some improvements for the SVG export filter

Marco Cecchetti reports on progress around the use of SVG in presentations and the improvements in performance and storage requirements on export. See details

Watch the talk
Download the slides!

Tomaž Vajngerl: Improved document searching with LibreOffice

Collabora developer Miklos Vajna introduces the latest enhancements to LibreOffice and Collabora Online search that visualize hits across different documents. See details

Watch the talk
Download the slides!

Mike Kaganski: Multi-column support in LibreOffice 7.2

The new feature, its relevance, obstacles and implementation status. Mike Kaganski shares his experience, how interesting was it to work on this. See details

Watch the talk
Download the slides!

Day 2: Friday, September 24th, 2021

Cor Nouws: A year of COOL …

Find out about the improvements that LibreOffice technology in the browser experienced. Hear about success stories and new features in Collabora Online! See details

Watch the talk
Download the slides!

Michael Meeks COOL performance

Recently, we have been focusing our Collobora Online development on improving the feel and slickness of document editing. Come and hear about the things that we’ve found and fixed, both in COOL and also in the LibreOffice core to improve the experience! See details

Watch the talk!
Download the slides!

Sarper Akdemir: PPTX footer export & import interoperability

Sarper Akdemir outlines the challenges around the export & import of Footers in PPTX and how they have been mastered. See details

Watch the talk
Download the slides!

Miklos Vajna: Gutter margin in Writer page styles

LibreOffice was already capable of handling various margins in Writer page styles. A missing piece was the support for the gutter margins. Find out, how this was implemented! See details

Watch the talk
Download the slides!

Tomaž Vajngerl: Built-in “Xray” like UNO object inspector

When developing macros and extensions in LibreOffice, it is very useful to have an object inspector. The Document Foundation put up a tender to create a built-in Xray-like UNO object inspector. It was awarded to Collabora, and we are now in the process of implementing it. See details

Watch the talk
Download the slides!

Tomaž Vajngerl: PDF and other graphic improvements

The LibreOffice technology in Draw is key to PDF annotations, and the support of a recently added review-based workflow. Find out, how this has been implemented! See details

Watch the talk
Download the slides!

Day 3: Saturday, September 25th, 2021

Szymon Kłos: JSDialogs improvements over the past year

JSDialogs is a LibreOffice component used to share UI elements with Collabora Online. Hear about the most recent updates added. See details

Watch the talk
Download the slides!

Follow us for more insights on LibreOffice technology


Collabora Productivity created Collabora Online and is the driving force behind putting LibreOffice in the Cloud. Collabora provides a wide range of products, as well as consulting services for enterprises and governments. Powered by the largest team of certified LibreOffice engineers in the world, Collabora is a leading contributor to the LibreOffice Technology codebase and community. Collabora Office for Desktop and Collabora Online provide a business-hardened office suite with long-term support. Collabora’s multi-platform policy is completed with Collabora Office for iOS, Android, and Chrome OS. Collabora Productivity is a division of Collabora, the global software consultancy dedicated to providing the benefits Open Source to the commercial world, specializing in mobile, automotive and consumer electronics industries. For more information, follow us  on Twitter, LinkedIn and YouTube.