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 Online 21.11 Delivers New Features and Interoperability Improvements

Powerful Document Collaboration in a Secure, Private Cloud Environment

Cambridge, January 20, 2022 – Today we are pleased to announce the availability of a major new release of Collabora Online, which makes collaborative editing even more productive. This new release enhances personal and team productivity with design improvements, as well as smoother document interchange through improved interoperability, better performance and more.

Collabora Online is the collaboration suite that offers businesses and professionals the best features, interoperability, LTS, and custom support in open source, while respecting user privacy and corporate data security.

 

Addressing the Needs of Our Users

This new major version of Collabora Online is a further example of our ongoing development and commitment to ensuring it continues to address the evolving needs of our users in a rapidly changing world where choice, distributed working, privacy and data security have never been more important.

 

Quicker Functional Sidebar

The new Sidebar is “native” to your browser, thus much more responsive and always functional and easy to use

Collabora Online 21.11 introduces a new “native” sidebar. It is both a performance and usability improvement. It is now drawn directly on the screen by the browser by JavaScript, and no longer constructed on the server and then sent to your browser, making it far more responsive and natural looking. With its more snappy responding buttons and controls, it is a major improvement for all users!

The new sidebar at a glance:

  • Polished appearance
  • Better user experience
  • Faster responding buttons
  • Faster responding drop-down menus.
Collabora Online 21.11: Many elements, like dropdown menus, respond much faster in the new native Sidebar

 

View Documents More Easily

A number of new buttons in the NotebookBar improve the user experience when viewing documents. Zooming, full-screen view or switching the sidebar on and off are now accessible via clear buttons in the layout tab, and no longer only via the status bars or the burger menu. It makes these frequently used functions even easier to find.

 

Performance Improvements

Collabora Online 21.11 brings together many performance improvements that we have been working on through the 6.4.x lifecycle as well as some more advanced optimisations. These are rather hard to screenshot for your viewing pleasure for obvious reasons, but the next two images are a try at least.

There is a lot to tell on asynchronous save, accelerating of JavaScript, saving network traffic, improved multi-user editing and more. Specifically, in spreadsheets, we’ve made auto-spell checking and AutoFilter quicker. Take a look at this performance blog post for more background from a technical point of view.

 

Ongoing Work!

We continue to work to profile and optimise uses-cases that are important to our users, and the upcoming 21.11 micro-releases will exhibit more continuous improvement in this area – as well as ongoing improvements to our document pixel compression to make things even faster and lighter. It’s well worth staying up-to-date with the latest releases.

 

Right-to-left Support Available for All Document Types

Collabora Online 21.11 now supports right-to-left (RTL) text input within all modules. This makes it easier to create and edit documents in Persian or Arabic. The text direction can be set in the “Format” tab under the option “Page Style” (or “Slide Style” for presentations). The code in Collabora Online can detect several RTL language settings and will mirror the user interface accordingly.

 

Calc-Excel Compatible Formulae Improvements

Many functions in Calc have been improved both to extend interoperability with Excel, and to add new functionality. Support for sheet-local scoped names has been added to INDIRECT(), and both TEXT() and OFFSET() have been adapted to various corner cases to behave identically to the competition. TEXTJOIN() and CONCAT() now handle array & matrix arguments row-wise for improved compatibility. In addition, functions that use powerful regular expressions now correctly honour case-insensitivity flags.

 

Interoperability Boosted by Improved PPTX Import

Collabora Online 21.11 includes many interoperability improvements around the import of PPTX files, which we had already implemented in Collabora Office. Images within shapes – even those converted to greyscale or mirrored – are displayed online true to the original.

 

Better Shadow Effects

In earlier versions, shadows used to be rendered as solid copies of objects. The new Blur option now allows for a more realistic rendering of the shadows. The options of the feature can be accessed via the Shadows tab in the Area dialog or directly through updated “native” Sidebar. This feature was initially developed during a GSoC 2020 for the LibreOffice project mentored by Collaborans and then implemented with further refinements in Collabora Office 21.06 and is now also available online.

 

Glow and Soft Edge Effects for Shapes

Collabora Online 21.11 introduces further features allowing to manipulate shapes in a more granular way. Once a shape is selected, you can choose the radius of the Glow effect and its Soft Edges within the sidebar using the Effects parameter. Furthermore, you can select the colour and the degree of transparency of the effect. This function improves interoperability as it can be used for all shapes across Writer, Calc, Impress and Draw.

 

Consistent Use Of Language Identification

The basic model of language annotation that Collabora Online inherited from the LibreOffice core explicitly assigned languages to regions of text. This can easily lead to unexpected results when documents created in one local language (without specifying it further) are opened by another user with a different local language setting. Instead of a powerful, but potentially confusing multi-languages result, Writer now resets the language to the user’s UI locale if no document language had been defined. The current behaviour is more consistent.

 

Shadowed Tables For Use in ODS and PPTX Presentations

Shadow effects are a great way to add depth and appeal to elements. They are available for many objects, such as shapes, and include a range of feature enhancements and parameters, such as the blur effect and transparency. For tables within presentations, shadows are now also available in Collabora Online through the Table Properties dialog.

 

Miscellaneous Changes

In addition to the larger features, there are, of course, numerous smaller changes:

  • Internet Explorer 11 – dropped. This saves significant code complexity in some areas e.g. copy-paste, simplifies testing, and removes legacy javascript polyfills.
  • Auto-cleanup – on by default. We now, by default, are more aggressive towards processes that are idle and are consuming a large amount of CPU, after around five minutes of this behaviour they are killed, to disable that checkout the ‘cleanup’ section in coolwsd.xml.
  • cool conversion. We have migrated our legacy loleaflet and lool paths to browser and cool – which impacts a number of configuration files and binaries. Integrators should continue to use the URLs they receive from the hosting/discovery end-point. Those with reverse proxy and/or HA setups may need to update their proxy configuration with a simple search & replace, please refer to updated documentation of proxy settings. For more information, please read our upgrade notes.

 

Thanks to the Community

This release is a community effort and we fully appreciate and acknowledge their hard work that has made it possible!  A few weeks ago, we already celebrated the wonderful work of these people in this blog post.

 

 

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

 

Thank you for an exciting 2021!

Looking at what we have achieved together 🤝

At the end of the year, we like to look back at what we have achieved as a team – in cooperation with our worldwide network of partners and the community. The year 2021 was again dominated by the global pandemic. While it had little impact on our work processes, it meant that personal encounters remained very rare.

At the same time, we launched the first COOL Days, a new event that brings together people interested in Collabora Online and LibreOffice technology. Collabora Online, Collabora Office and our mobile apps have all seen major performance improvements and increased functionality this year. At the end of the year, we released CODE 21.11, which previews what our flagship enterprise product, due out in early 2022, will look like. Thank you, for your support this year. See what we have achieved together this year. 💜

🆕 Collabora Online includes new functionalities and better performance 💻

This year Collabora Online has undergone a number of important updates. In addition to interoperability and user experience, there was a strong focus on performance enhancements. Many ground-breaking new functionalities already celebrated their premiere in the 6.4 release branch. With the release of CODE 21.11, more new implementations from the desktop were added.

Collabora Online 6.4 adds ground-breaking features

Pivot Tables in Collabora Online 6.4.x
Select & run macros in Collabora Online 6.4.7
Anchors in Collabora Online 6.4.10
Anchors in Collabora Online 6.4.10

 

⚡️ Powerful new features arrive for Collabora Office on the desktop 🖥️

Collabora Office 21.06 brings enhanced productivity and smooth migration

June 2021 saw the major release of our desktop product Collabora Office. This release brought many UX improvements and smoother document interchange. Collabora Office 21.06 was focused on performance and making migration simpler for organizations. This release introduced a new numbering system, based on the year and month of its release, and many powerful features like a style inspector, better access for extensions and improved PPTX filters and many more.

Improved PPTX import in Collabora Office 21.06
Powerful new Style Inspector tool in the Sidebar of Collabora Office 21.06
Collabora Office 21.06 makes it easier and more convenient to find and install extensions

Collabora Office 6.4 saw many updates and improvements

  • April, version 6.4-33: Printed publications can now make use of Gutter Margins and PPTX import improvements for shaped bitmaps arrive
  • May, version 6.4-39: Improvements on XML import have been implemented
Add Gutter Margins to text documents in Collabora Office 6.4-33
True to the original PPTX import if shaped bitmaps in Collabora Office 6.4-33

🧰 CODE 21.11 provides insights into the upcoming enterprise version 📄

CODE 21.11 is the herald of our new enterprise version to be released next year. The current development edition introduces the full range of new features and performance enhancements for testing. Among other things, it contains the new native sidebar, improved interoperability and a number of new effects for objects such as glow, soft edges or blurry shadows. The numerous performance improvements include asynchronous save, JavaScipt acceleration, more efficient network traffic, and improved multi-user editing. Learn more details in our announcement.

New “native” Sidebar in CODE 21.11
CODE 21.11 includes a new “native” Sidebar
Apply glow and soft edge effects to objects in CODE 21.11
Improved PPTX import/export filters in CODE 21.11

🆕 Many new features for Collabora Office for Android, iOS & Chrome OS📱

Large, user-friendly UI on tablets
CSV Import in Collabora Office on Android
Moving Sheets in Collabora Office on Android
Smart connectors in presentation in Collabora Office on Android
VBA macros in Collabora Office for Android

 

🏠 Small scale work-from-home-solution and ARM64 support 👨‍💼

In March, together with our partners at Ubuntu and Nextcloud, we introduced a work-from-home solution for the Raspberry Pi including the easy-to-use Collabora Online built-in server. In April, we announced that CODE now also officially supports the ARM64 platform.

Canonical, Nextcloud and Collabora deliver work-from-home solution to Raspberry Pi

📰 Amazing news, interesting figures 📈

Over 250 partners worldwide

In 2021, our large network of amazing partners kept growing. We can now rely on over 200 partners from more than 50 countries. We help each other to promote open source, privacy & digital sovereign solutions and re-invest the proceeds into creating great new software. Find a Collabora partner in a special field or area! Or become a partner yourself!

 

CollaboraOffice.com available in four new languages

We continued dedicating a lot of effort to make our website and the information about our products easily available to a larger set of people. This year we implemented translations in Simplified Chinese , Japanese 🇯🇵, Russian 🇷🇺 and Czech 🇨🇿 to the available options on collaboraoffice.com. Thanks a lot to the translators. Also, the community translating Collabora Online kept growing. Would you like to help to translate our software to your language? Join our translation team on Weblate!

collaboraoffice.com is available in new languages, including japanese.

 

Collabora’s Contributions to LibreOffice 7.1 and 7.2

Collabora is part of the ecosystem developing and advancing LibreOffice Technology. Our developers responsible for many commits to the LibreOffice core. Many of the new features in LibreOffice 7.1 and LibreOffice 7.2 like Smart Art improvements, blurry shadows for objects, gutter margins or the possibility to add visible digital signatures to existing PDF files have been implemented by Collaborans. Find more details of our 7.1 contributions in our blog.

PDF signing improvements by Collabora in LibreOffice 7.1

 

Updated LibreOffice growth infographic 2021 📈

We updated the popular LibreOffice growth infographic. Despite the challenges posed by the global pandemic, the statistics around LibreOffice collaboration are impressive. Over 210M active LibreOffice users, over 70M pulls from the CODE Docker image, 500K installs of the Collabora Office mobile apps, and more than 12K code commits from the community and the ecosystem to the LibreOffice code. Have a look at the numbers!

 

🎙️ Together at a distance – a year of online conferences 👏

The major events – foremost the large international conferences – had to take place online due to the global pandemic. Nevertheless, also new events emerged. We were part of the Open Source Day for Enterprises in Russia. For the first time, Collabora hosted the COOL Days, a virtual conference completely focused on Collabora Online. While most conferences took place online, there have also been a few opportunities to meet in person. For instance, in France, at the Open Source Experience and on at the it-sa fair in Nuremberg and some smaller German events like digital + souverän.

A fresh breeze on the calendar – COOL Days 2021

This year we hosted the COOL Days for the first time. A two-day online event that focused exclusively on topics related to Collabora Online. The first day, the Developer Day, focused on technical topics. The second day, the Business Day, dealt with questions of marketing and digital sovereignty. The schedule is available on our website, the videos from the Developer Day can be found in our playlist on YouTube.

FOSDEM 2021 went online

Europe’s largest open-source event had to take place as an online this year. However, this did not stop our team and the open-source community from presenting themselves and their latest developments. Collabora was present with a whole series of talk covering Collabora Online and LibreOffice technology. Find the videos of our FOSDEM 2021 talks and more slides available for download in our blog.

 

“Collabora Online for your documents” by Michael Meeks. Download the presentation!
“How Collabora Online development improves LibreOffice” by Jan “Kendy” Holešovský. Download the presentation!
“Porting LibreOffice to macOS on Apple Silicon” by Tor Lillqvist. Download the presentation!

Collaborans contributing strongly to the LibreOffice conference

In contrast to last year’s joint conference, this year’s LibreOffice conference was hosted solely by The Document Foundation. The Collabora team presented 12 talks this year. All links to the videos and the slides for download can be found in our blog.

Download “Collabora Keynote” by Michael Meeks
Download “PDF and other graphic improvements” by Tomaž Vajngerl
Download “JSDialogs improvements over the past year” by Szymon Kłos

 

💪 A welcoming and vibrant COOL community 🤝

More than a year after moving the work on Collabora Online out of the TDF infrastructure and onto GitHub, we can say that it was a good decision. We have lowered the barriers to participation while increasing the transparency of the project. New, active members have been found, keeping in touch via the Telegram channel, and supporting the work on CODE and Collabora Online. Once a week, always on Thursdays, the community meets for a call.

Users can now easily file issues on GitHub, and the community answers questions from home users in the forum. The minutes of the community meetings can also be found there. Another great way to get involved is to help translate. At the same time, we are happy to be an important ecosystem partner of the LibreOffice community helping to advance LibreOffice Technology.

 

Showcasing our Consultancy work 💻

Our developers have a superb expertise in LibreOffice technology and implement new features and enhancements. This year, we did set up a page showcasing some of those implementations we realized on our client’s request – to the benefit of everyone. Find out more!

 

Presenting the benefits of Collabora Online for educational institutions 👩‍🎓

Scalable, reliable, privacy respecting and secure! Collabora Online is an ideal solution for modern learning environments. We have put together a web page with the many benefits of Collabora Online in educational institutions. Learn more!

 

The Collabora Online SDK ⚙️

Collabora Online SDK describes the main methods that allow you to interact with different Collabora Online components. Find installation guides, frequently asked questions, Post Message API and documentation on exiting integrations and on how to create new ones on our new SDK pages.

Google Summer of Code 2021 ☀️

This year, the Collabora team again provided mentors for LibreOffice projects within the Google Summer of Code. Among the topics mentored were interesting implementations such as the VCL graphics backend, the text style deck and revisions to the SVM format. Detailed information on these and other projects can be found in our GSoC 21 article.

News by Collabora directly into your inbox 📨

This year, we have updated our public newsletter. We made it visually more appealing and lowered the frequency of the mail outs. If you would like to receive regular updates like this one on the news on Collabora Online, Collabora Office and the COOL Days please sign up to our newsletter, that is mailed approximately 6 to 8 times per year.

 

Summary

It has been a very busy year here at Collabora Productivity. We enjoy seeing the Collabora Online Community grow and keep on advancing our mission to make open-source rock. We continued giving users privacy and businesses control over their data. We managed to achieve excellent results, and had a good time working on them – despite the challenging conditions that 2021 persisted. The first edition of the COOL Days was a real highlight for us. We have big plans for 2021, and hope there will be more possibilities to meet in person on conferences and on events. Don’t hesitate to get in touch with us, if you’d like to partner with us, or to buy from us. Thank you for the great support this year. We wish you all a Merry Christmas and a Happy New Year!

Thank You!

CODE 21.11 delivers key features for secure, easier and faster online document collaboration

This new major release includes a brand new side bar, performance enhancements and interoperability improvements

Cambridge, November 25, 2021 – Collabora announces the availability of Collabora Online Developer Edition CODE 21.11. This major new release targets the three key areas: ease of use, performance and interoperability. The release demonstrates the company’s mission to the technology leader in collaborative editing. Collabora Online businesses the most effective and secure document creation environment with dedicated support and depth of development horsepower.

CODE 21.11 is the herald of the next major business supported Collabora Online release. This free developer version includes all features and enhancements that will be available in our enterprise version, expected early December. CODE releases allows everyone to learn about new features early.

As always, your feedback on possible issues is much appreciated! CODE is the collaboration suite offering home users and early adapters the best features, interoperability in open source, while respecting user privacy and data security.

Get CODE 21.11

Work easier and faster with the good looking and improved UI

CODE 21.11 comes with a significantly faster and better looking user interface..A major improvement for all users.

The new major CODE release is recognized immediately from the brand new Sidebar

Ease of use is enhanced with both a performance and usability improvements. Leveraging our expertise in the mobile space, the Sidebar is built locally by the browser which is fast. Thanks to snappy and responsive buttons and controls, the Sidebar is intuitive and easy to use. This approach reduces the data transfer from the server to the browser. In addition, the widgets can be styled using the same CSS as other UX components, enhancing the look and consistency of the Sidebar across multiple platforms.

The Sidebar is now drawn directly on the screen by the browser through JavaScript, and no longer constructed on the server and then send to your browser. Earlier versions rendered the Sidebar as images on an HTML canvas. CODE 21.11 uses JSON files with the information of the Sidebar, an approach that we had applied earlier for the mobile implementations.  This approach reduces the data transfer from the server to the browser, and also the widgets can now be styled using the same CSS as other UX components, enhancing the look and consistency of the sidebar.

CODE 21.11: Fast & responsive “native” Sidebar

New handsome view functions in the NotebookBar

New buttons in the NotebookBar improve viewing documents. Zooming, full-screen view or switching the sidebar on and off are now accessible via clear buttons in the layout tab, and no longer only via the status bars or the burger menu. The NotebookBar makes these frequently used functions even more easy to find.

A major release with many performance improvements

CODE 21.11 brings together many performance improvements that we have been working on through the 6.4.x lifecycle as well as some more advanced optimizations. These are rather hard to screenshot for your viewing pleasure for obvious reasons, but the next two images are a try at least.

There is a lot to tell on the subject:

  • Asynchronous save
  • accelerating of JavaScipt
  • saving network traffic
  • improved multi-user editing
  • specifically in spreadsheets, we speeded up auto spell checking and AutoFilter.

Improved multi-user editing

One of the test-cases we use, generates text at around ten times the speed of a normal typist. This is something we have been optimizing along with scalability to larger numbers of concurrent editors of the same document. Read more details here, or a deeply technical blog on optimizing for a larger number of users. Or simply watch this video of a torture test of an intense multi-user editing session showing old, 6.4.x, and 21.11 versions from top to bottom.

Optimizing pathological loads – old/6.4.x/21.11

Don’t miss all details in the special blog post!

We publish a specific blog post with more interesting details, ready this week. I can be found here. It is mostly technical but comes with some nice graphics too. Make sure you do not miss it. Follow our announcements on social media (see the footer of this website).

Improving performance is ongoing work! We continue to work to profile and optimize uses-cases that are important to our users, the upcoming 21.11 micro-releases will exhibit more continuous improvement in this area – as well as ongoing improvements to our document pixel compression to make things even faster and lighter. It is well worth staying up-to-date with the latest releases.

Spreadsheets benefit with Excel compatible formulae improvements and extensions

Relentless focus in Calc to extend interoperability with Excel, and to add new functionality do show. Support for sheet-local scoped names has been added to INDIRECT(), and both TEXT() and OFFSET() have been is adapted to various corner cases to behave identically to the competition. TEXTJOIN() and CONCAT() now handle array & matrix arguments row-wise for improved compatibility. In addition, functions that use powerful regular expressions now correctly honour case-insensitivity flags.

PowerPoint PPTX Interoperability boosted

PPTX import improvements include managing images within forms – even those converted to greyscale or mirrored – are displayed online true to the original. This had been implemented in Collabora Office before.

More attractive and realistic shadow effects also enhance interoperability

A new Blur option does now allow for a more realistic rendering of shadows. The options of the feature can be accessed via the Shadows tab in the Area dialog or directly through updated “native” Sidebar.  This feature was initially developed during a GSoC20 for the LibreOffice project mentored by Collaborans and then implemented with further refinements in Collabora Office 21.06 and is now also available online.

Glow and Soft Edge effects for shapes – more than just interoperable

New features manipulate shapes in a more granular way. Once a shape is selected, you can choose the radius of the Glow effect and its Soft Edges within the sidebar using the Effects parameter. You can select the colour and the degree of transparency of the effect.
Not that these interoperability features apply to all shapes across Writer, Calc, Impress and Draw.

Version 21.11 – The new CODE release of the year

Starting with CODE 21.11, we are adopting the numbering of our online office suite to the scheme of our desktop product. The version number indicates the year and month of the first release of the current major version. CODE releases a major version annually and updates with fixes and improvements at approximately monthly intervals. As before, the updates are marked with a third consecutive number. We think that this kind of numbering makes it easier for CODE users to keep track of the versions.

Improved language handling in Writer

The basic model of language annotation that CODE had inherited from the LibreOffice core is that languages are explicitly assigned to regions of text. This can easily lead to unexpected results when documents that have been created in one local language (without specifying it further) are opened by another user with a different local language setting. Instead of a powerful but potentially confusing “multi languages” result, Writer now resets the language to the user’s UI locale if no document language had been defined. This more consistent behaviour was previously implemented in Collabora Office on the desktop, and is now also available online in Writer.

Shadowed tables for use in ODS and PPTX presentations

Shadows are now available for tables within presentations through the Table Properties dialog. The newly added shadow option includes different parameters such as blur and transparency.

Thanks to the Community!

Before we conclude with some final improvements and news, we really want to let you know about all the people that did the hard work, luckily often with joy and fun too, the community that made this release possible!
Shortly  before this release, we celebrated the wonderful work of these people in this blog  post. Do read it and join us in saying thanks!

Read the blog “our next major release was made more fun and beautiful by the community”

Miscellaneous changes

In addition to the larger features, there are of course a large number of smaller changes:

  • Internet Explorer 11 dropped. This saves some rather significant code complexity in some areas eg. copy-paste, simplifies testing, and removes legacy JavaScript polyfills.
  • Auto-cleanup on by default. We now by default are more aggressive towards processes that are idle and are consuming a large amount of CPU, after around five minutes of this behavior they are killed, to disable that checkout the cleanup section in coolwsd.xml.
  • cool conversion. We have migrated our legacy loleaflet and lool paths to browser and cool – which impacts a number of configuration files and binaries. Integrators should continue to use the URLs they receive from the hosting/discovery end-point. Those with HA setups may need to update their proxy configuration with a simple search & replace as/when we do our enterprise COOL release. Generally we have back-compatibility symlinks to make this migration process smoother and simpler.
  • Quarantine. We now have an experimental way (disabled by default) to slowly accumulate files which caused a problem with Collabora Online in a quarantine directory. This can help report issues see thequarantine_files section in coolwsd.xml.
  • Notebookbar by default. Integrations can now change the look and feel of Collabora Online easily, so we have added a new state default state to our user_interface setting to go with the classic vs. notebookbar options to allow using the integration’s default.
  • Dropped deprecated reuse_cookies. This setting was originally a workaround to aid with authentication, prior to having access_token. However, it proved much less useful than originally anticipated, primarily because cookies nowadays have security restrictions in browsers.
  • Initial simple OT undo/redo. In place of falling back to our ‘repair’ mode, we can now undo and redo simple edits in writer to different paragraphs which were made out-of order.
    Surprisingly this  has never been requested as a feature, but we made a start here.

LibreOffice Technology

CODE and Collabora Online are built with LibreOffice Technology by the LibreOffice community in which we love to participate. We cannot thank everyone involved enough for their passionate work.

Built with LibreOffice Technology

About CODE

CODE is the Collabora Online Development Edition. It contains the latest developments and is perfect for home users. It enables them to regain control of their own online documents and to host them themselves in a secure and private environment. For tech-enthusiasts, it is a low-threshold way to get involved and familiar with our online office solution. CODE will be improved continuously and our next supported and maintained Collabora Online product will be built from it. The code is available on GitHub.

Get CODE 21.11

Open source – so feel welcome to join

Collabora has invested significantly in bringing a host of new features and functionality to this latest release, and accounts for the overwhelming volume of contributions. However, we want to acknowledge all of our friends and colleagues who helped to contribute not only to this, but also to the underlying LibreOffice technology. All of our code is open source, and available to the public on GitHub. Would you like to be part of the Collabora Online success story? Check the new website for Online with information, easy hacks and a forum for Online, report issues, and participate today!