Thank you for a great 2023!

Thank You for Everything We Achieved Together in 2023 🤝

At the end of the year, we like to look back at what we have achieved as a team alongside our worldwide network of partners and the community. 2023 was a particularly significant year for us as we celebrated ten years of Collabora Productivity, adding another productive decade to our mission of bringing document editing and trillions of existing documents into the free world!

 

 

In March we held another successful COOL Days conference, this time in Cambridge, which brought together our team, partners and the community. We are looking forward to another great event in April 2024 – join us!

As well as our own events, our team also attended over ten locations to present talks, meet partners and share Collabora Online with the wider community. You can keep up to date with our adventures on our events page.

2023 saw many organisations and users throwing off their proprietary shackles, and embracing the freedom open-source solutions bring. In particular, we saw many educational institutions reconsidering their relationship with Microsoft 365 and Google Workspace amid privacy concerns, great strides being taken by local and national governments such as the openDesk project in Germany, and increasing numbers of private companies taking back control of their document storage and editing needs.

Collabora Online, Collabora Office and our mobile apps have all seen performance improvements and increased functionality. In July, we released the new major release of our flagship product Collabora Online 23.05, which included increased interoperability, performance boosts and a whole range of new features and accessibility improvements. Thank you for your support! Let’s take a deeper dive into what we have achieved together this year. 💜

 

Collabora Online 22.05 → 23.05

Our flagship product, Collabora Online saw marked improvements in 2023, introducing many exciting new features and a big focus on accessibility, working to bring the best digital experience we can to all our users, regardless of their abilities or challenges.

  • February 2023: Zotero plug in, PDF and EPUB export options, insert page number dialog, Duden Corrector plugin, easy hyperlink pop up editor
  • March 2023: linking API, improved conditional formatting from XLSX files.
  • April 2023: interoperability improvements.
  • July 2023: major release 23.05 introducing dark mode, expanded keyboard shortcuts, initial screen reading support, document themes, multi-page floating tables and accessibility improvements.
  • August 2023: further updates to keyboard shortcuts and more performance improvements.
  • September 2023: new font previews and barcode/QR code functionality.
  • October & November 2023: a focus on polishing and bug fixing with over 70 improvements.
  • December 2023: STYLEREF, floating tables properties, re-designed PostMessage for integrators and developers.

See the full release notes for Collabora Online 23.05 and COOL 22.05.

 

CODE: Developing a Rock-Solid Enterprise Version 💪

The latest major release of the Collabora Online Development Edition (CODE) 23.05 was released in June. CODE always appears in advance of the corresponding version of Collabora Online – the Development Edition contains all new features which are extensively tested before becoming available in the Enterprise version (COOL). An overview of CODE releases for 2023 can be found in the release notes but will mostly mirror those of Collabora Online. You can find the conversations about CODE on social media, by searching for the hashtag #cool_dev on Mastodon or Twitter.

 

Powerful New Features for Collabora Office on the Desktop 🖥️

August 2023 saw the latest major release of Collabora Office, our long term supported desktop Office Suite for Windows, macOS, and Linux. This release brought a number of powerful productivity features focusing on accessibility and improving user experience. The new features contain code that was contributed to LibreOffice 7.4, 7.5 and 7.6. Collabora Office for Windows is available through the Microsoft Store. The latest version for macOS can be bought from the App Store. We also appreciate those who help us test the latest features inside our unstable snapshots.

  • August 2023: major release of Collabora Office 23.05 including dark mode, interoperability features, document themes, 64-bit zip support, advanced editing features for tables and forms and so much more!
  • September 2023: MS Office interoperability improvements including further support of document themes, floating tables and pivot tables.
  • December 2023: Collabora Office 23.05.6 – STYLEREF, floating tables properties and advanced header and footer functionality.

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

Our major release for mobile and tablet devices in September 2023 brought more of the functionality from Collabora Online into the pockets of our users, as well as improving the current user experience and making navigating on smaller screens easier. Now you can use dark mode, improved form controls in Writer, Sparklines, consistent dialogs and a better UX for users on smaller screened devices.

 

Events 🗓️

COOL Days 2023 took place in Cambridge, with more than 50 participants joining from our team, partners and the community. We presented 45 lightning talks showcasing our talented developers’ work across the year, held workshops and discussions with our partners about the importance of data protection in Europe, shared our development roadmap, and further discussed how to mutually support our sales and marketing efforts as part of our partnership. The community dived into a LibreOffice Hackfest and of course we had a great time socialising and team building around historic Cambridge.

 

 

 

As well as our own annual conference, our team attended events across Europe presenting talks, meeting partners and sharing Collabora Online, as well as presenting a keynote at the LibreOffice Conference for Latin America in Mexico.

2023 Events

 

Date Event Location Links
17th – 18th January 2023 Univention Summit Bremen, Germany Blog
4th – 5th February 2023 FOSDEM Brussels, Belgium Blog & Talks
6th – 8th March 2023 CS3 Barcelona, Spain Talk Recording
28th – 29th March 2023 COOL Days Cambridge, UK Blog, Live Stream
16th – 17th September 2023 Nextcloud Conference Berlin, Germany Blog & Talks
20th – 23rd September 2023 LibreOffice Conference Bucharest, Romania Blog & Talks
28th – 29th September 2023 SeaDays Mainz, Germany Talk
7th – 9th November 2023 Smart Country Convention Berlin, Germany openDesk Blog
9th – 10th November 2023 LibreOffice Congreso Latin America Mexico City, Mexico Keynote
6th – 7th December 2023 Open Source Experience Paris, France Talk Slides

 

LibreOffice Community & Contributions to 7.5 and 7.6

Collabora Productivity is part of the ecosystem developing and advancing LibreOffice technology. We are the largest contributor to the LibreOffice codebase, with our developers contributing many commits to the LibreOffice core.

LibreOffice 7.5 and LibreOffice 7.6 saw many improvements from the team at Collabora – here is just a snapshot of some of the commits this year.

  • Content controls – added plain text type, combo box, PDF export, titles and tags. (Miklos Vajna, Collabora)
  • Impress now supports cropped video for media shapes. blog post (Miklos Vajna, Collabora)
  • Citation handling: added plumbing in Writer to build Zotero-like functionality. blog post (Miklos Vajna, Collabora)
  • Keyboard navigation through forms (Justin Luth, Collabora)
  • Replacing strings with numbers in Calc tdf#126109 (Noel Grandin, Collabora)
  • Find and replace in very large Calc sheets tdf#150749 (Noel Grandin, Collabora)
  • Added page number wizard in Insert menu for easy one-step insertion of the page number in the header/footer tdf#86630 (Paris Oplopoios / Justin Luth, Collabora)
  • Initial machine translation is available, backend by DeepL translate (Mert Tumer, Collabora) core commit e20d2tdf#34058
  • Added pivot table compact layout. core commit 2f8d1 (Dennis Francis, Collabora)
  • Display soft breaks as line breaks at fontwork. tdf#148000 (Attila Szűcs, Collabora)
  • Added support to open multi image tiff files tdf#155444 (Rashesh Padia, Collabora)
  • Auto fitting text scaling algorithm has been changed so it works similar to MS Office. (Tomaž Vajngerl, Collabora)

Of course, we also had many of our developers share their work in the LibreOffice Technology devroom at FOSDEM this year. You can find links to their talks and slides in our blog.

 

Partners

This year we have welcomed 20 new partners from across Europe, Australia and South America including Oodrive, Salesframe, Aridhia and unodata. We are very happy to have a growing partner network allowing more and more users to take control of their data.

Team

This year we have seen our team grow, adding another 17 people to our core team at Collabora Productivity within our Sales, Marketing and Technical teams, with 50% of these coming from the Collabora Online Community. We love to hire smart people who have contributed to the Open Source community. This allows us to provide a richer experience for our partners and customers.

Collabora Online Community Contributions

The Collabora Online Community kept growing and helped to improve the software through their commits, feedback, and translations. You can see from the stats above that our Community is doing great things! You too, can help to make Collabora Online better. Join the discussions in our forum, join our community calls every Thursday at 12pm CET, translate strings on Weblate, file bug reports or feature requests on GitHub and spread the word on Collabora Online!

 

The Collabora Online SDK ⚙️

The 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. This year we continued to add to our information to enable better integrations and clearer guidance.

A small sample of some 2023 updates:

 

Thanks to all who helped out!

It has been an exciting year here at Collabora Productivity, and we are so grateful to everyone who has been involved in 2023, and indeed for the past ten years – customers, partners, staff, and the community. We couldn’t have achieved any of these things without everyone working together so well. We have big plans for 2024 and are anticipating an even more exciting year ahead. We look forward to sharing it with you!

Don’t hesitate to get in touch with us, if you’d like to partner with us, or to download Collabora Online. Thank you for the great support this year. We wish you all a Merry Christmas and a Happy New Year!

Thank You!

 

News by Collabora Directly into your Inbox 📨

Keep up to date with our public newsletter. If you would like to receive regular updates with all the news and updates about Collabora Online, Collabora Office and future events, please sign up to our newsletter.

Thank you for a marvellous 2022!

Thank You for Everything We Achieved Together in 2022 🤝

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. Luckily, the year 2022 was less dominated by the global pandemic. Throughout the year, international travelling became easier and in-person events and conferences became much more common again. However, the world kept being shaken. The Russian assault on Ukraine emphasized once again the massive importance of digital sovereignty, as Michael Meeks pointed out in several of his talks, like his Digital Sovereignty talk at the SFScon22.

Collabora held the first in-person COOL Days 2022 in Berlin, which brought together partners, the team, and the community. Collabora Online, Collabora Office and our mobile apps have all seen major performance improvements and increased functionality. We released the new major release of our flagship product Collabora Online 22.05, including performance boosts and impressing new features. Thank you for your support! Let’s take a look at what we have achieved together this year. 💜

Collabora Online 22.05: New Features and Better Performance 📈

With the release of version 22.05, Collabora Online reached new heights in performance, interoperability and usability. Many exciting features that had earlier been implemented and fine-tuned inside CODE 22.05, have been introduced this month.

Collabora Online 22.05 Brings Grammar Checking, Giant Spreadsheets and Performance Wins

Grammar check in a Writer Document in Collabora Online 22.05
Sparklines in Collabora Online 22.05
Translate using DeepL in Collabora Online
Consistent Language identification in Collabora Online 21.11

 

CODE 22.05 Cutting-Edge Features and Path to a Rock-Solid Enterprise Version 💪

The latest major release of the Collabora Online Development Edition CODE 22.05 was released in June. Versions of CODE always appear in advance of the corresponding version of Collabora Online. The Development Edition contains all new features which are extensively tested before being incorporated into the Enterprise version. An overview of CODE releases for the year 2022 can be found in the release notes. You can find the conversations about CODE on social media, by searching for the hashtag #cool_dev on Mastodon or Twitter.

 

More Groundbreaking Major Releases: Collabora Online 21.11✌️

The Year 2022 saw two major releases. In January, we released the enterprise version 21.11 of Collabora Online. It included a complete redesign of the sidebar, enhancing its responsiveness and had a strong focus on performance enhancements.

Collabora Online 21.11 Including a New Sidebar, RTL Support and Performance Boosts

  • January 2022, major release 21.11 introducing a quicker, “native” sidebar, right-to-left support, Calc-Excel compatible formulae and improved PPTX import
  • March 2022, Collabora Online 21.11.2 including Accessibility Checker, faster rotation of bitmap graphics, and an improved UX
  • April 2022, Collabora Online 21.11.3, dynamic configuration of multiple hosts and improvements for complex commenting cases
  • May 2022, Collabora Online 21.11.4, toggling between Compact View and Tabbed View now available through the user interface, several functions added to the UI’s
  • June 2022, Collabora Online 21.11.5, support of emphasis animations (spin, grow, shrink) in SVG presentation engine of Collabora Online Impress
  • August 2022, Collabora Online 21.11.6, many fixes added including the zoom factors in the glow and soft edge effects and the CSV import dialog
  • October 2022, Collabora Online 21.11.7, fixed selection of candidates for Japanese IME input, UI for adding print ranges in Calc, and override CheckFileInfo
  • October 2022, Collabora Online 21.11.8 several fixes like the SVG export of text fields, a memory leak related to the remote config feature, UI fixes
RTL support introduced in Collabora Online 21.11
Fast image rotation in Collabora Online 21.11.2
Consistent Language identification in Collabora Online 21.11

 

Powerful New Features for Collabora Office on the Desktop 🖥️

Collabora Office 22.05 Continues Enhancing Productivity and Interoperability

May 2022 saw the latest major release of Collabora Office, our long term supported desktop Office Suite for Windows, macOS, and Linux. This release brought a number of powerful productivity features like spreadsheets with 16,000 columns, sparklines to Calc (funded by the EU’s Horizon 2020 research and innovation programme) and saw linked paragraph and character styles arrive in Writer. The new features developed by Collabora are now also available in LibreOffice 7.4. Collabora Office for Windows is available through the Microsoft Store. The latest version for macOS can be bought from the App Store. Furthermore, we are encouraging you to help us test the latest features inside our unstable snapshots.

Further updates throughout the year included additional features & improvements:

  • September 2022, Collabora Office 22.05.6 including chart data tables, document themes in Impress, and content controls in Writer
  • November 2022, Collabora Office 22.05.8 new Content Control features (combo box, titles, tags) PDF export of the content controls mapped to PDF forms
16384 columns available in Calc in Collabora Office 22.05
Sparklines in Collabora Office 22.05
Enhanced interoperability of transparent shadows in tables in Collabora Office 22.05

Collabora Office 21.06 Saw Updates and Improvements

Numerous Fixes & Updates for Collabora Office 6.4

Moreover, the Collabora Office 6.4 branch saw numerous updates, mostly including fixes and performance and interoperability improvements. You can find these changes documented inside the release notes.

 

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

Collabora Office Brings Powerful Office Productivity to Your Pocket

This year saw a major update of Collabora Office for Android, iOS & Chrome OS including numerous advanced productivity features, excellent document compatibility and a much improved user experience. The first major release to version 21.11 included performance improvements, a faster & responsive toolbar on tablets, enhanced contextual Toolbars, better shadow effects and much more.

  • April 2022, Collabora Office 21.11.3 for Android, iOS & Chrome OS – major release including Contextual toolbars, improved PPTX import, blurry shadows, soft edges for objects
  • August 2022, Collabora Office 21.11.6 for Android, iOS & Chrome OS – improved user experience and fixes
Improved Import of PPTX with Shaped Images

 

Contextual Toolbars enhancing the user experience
Improved Shadow Effects
Glow & Soft Edge effects

 

 Amazing News, Interesting Figures 📈

280 Partners Worldwide

In 2022, our large network of amazing partners kept growing. We can now rely on over 280 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!

 

Collabora’s Contributions to LibreOffice 7.3 and 7.4

Collabora is part of the ecosystem developing and advancing LibreOffice technology. Our developers are responsible for many commits to the LibreOffice core. Thanks to the sponsorship of our clients, we were able to introduce many new features and improvements to LibreOffice 7.3 and LibreOffice 7.4. The LibreOffice 7.3 release saw many performance focused enhancements (increased PDF export speed of some complex documents, faster loading of large RTL documents and insertion of large charts, rendering improvements in the Skia-based rendering backend and introduction of a Skia-based rendering backend on macOS). We also introduced numerous new features and interoperability improvements to LibreOffice 7.4. This version saw the arrival of native rich text and checkbox content controls support from Word, remote LanguageTool grammar checking, support for sparklines (funded by the EU’s Horizon 2020 research and innovation programme) and the use of 16384 columns in Calc and support for WebP images. Find more technical background on some of our contributions inside this blog. More great stuff is going to arrive in LibreOffice 7.5. We appreciate any help in testing. You’ll find the latest features in a Collabora Office snapshot or a pre-released Dev-Version of LibreOffice.

Linked paragraph and character styles in Writer
Example with 3 types of sparklines

 

Collabora Online Community Contributions #cool_dev 📈

The Collabora Online Community kept growing and helped to improve the software through their commits, feedback, and translations. You can see from the stats above that our Community is doing great things! You, too, can help to make Collabora Online better. Join the discussions in our forum, translate strings on Weblate, file bug reports or feature requests on GitHub and spread the word on Collabora Online!

 

The Collabora Online SDK ⚙️

The 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. Of course, we added new documentations to the SDK this year for new features like the DeepL Translator (sponsored by Adfinis) or the LanguageTool Grammar Checker.

 

Starting at a Distance, Coming together in Person Again 🤝

The beginning of the year 2022 was still heavily impacted by the global pandemic. Major events like FOSDEM 2022 or the FOSSASIA Summit 2022 took place as remote events. Others had been rescheduled to a later date, like the Univention Summit. Luckily, throughout the year, travelling became easier again, and many conferences, such as the LibreOffice Conference in Milan, and the Nextcloud Conference in Berlin, could take place in person again. In October, we held our own COOL Days in Berlin – for the first time as an in-person meeting with the Collabora team, community and our partners.

COOL Days 2022 in Berlin

This year, for the first time ever, we were able to host the COOL Days as an in-person event. The three-day event focused exclusively on topics related to Collabora Online – and on some fun and team building experiences. Read the wrap-up of our activities from the community day, the partner day and the tech day on our blog. All the recordings of the talk from the Tech Day can be found on our playlist on YouTube, many slides can be found inside our repository on GitHub. The next COOL Days are coming very soon… Join us in Cambridge in March 2023!

COOL Days 2022 Impressions

Ready for take-off? We went skydiving.
Joining staff and partners at the COOL Days
Developer talks at the Tech Day

COOL Days 2022 Videos

Using DeepL in Collabora Online by Jan Holesovsky
Dynamic Font Download by Tor Lillqvist
PDF Export Advanced Options by Miklos Vajna

 

FOSDEM 2022 – A Massive Remote Experience

Whether on-site in Brussels or as an online event like 2022 – FOSDEM is one of the major gatherings for Open-Source developers. The Collabora team held several talks on Collabora Online and LibreOffice technology. Find the all videos of our talks in our FOSDEM 2022 playlist and all the slides in our blog.

Click image to download slides, click here for the video
Click image to download slides, click here for the video
Click image to download slides, click here for the video

 

Collabora at the LibreOffice Conference in Milan

This year’s LibreOffice Conference was held in Milan and saw many talks by the Collabora team. All the recordings are available in our YouTube playlist and the slides can be downloaded from our blog.

Click image to download slides, click here for the video
Click image to download slides, click here for the video
Click image to download slides, click here for the video

 

News by Collabora Directly into your Inbox 📨

Keep up to date with our public newsletter. If you would like to receive regular updates like this one on the news on Collabora Online, Collabora Office and future COOL Days events, please sign up to our newsletter.

 

Summary

It has been a very busy year here at Collabora Productivity. We have enjoyed 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 some challenging conditions that persisted in 2022. The Berlin edition of COOL Days was one of the highlights for us this year. We have big plans for 2023, some of them unfolding already in early spring! Don’t hesitate to get in touch with us, if you’d like to partner with us, or to download Collabora Online. Thank you for the great support this year. We wish you all a Merry Christmas and a Happy New Year!

Thank You!

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!

Thank you for your support in 2020!

 

It is a good tradition at the end of the year to reflect on what we have achieved as a team and together with our partners and the community, and remember with gratitude all the hard work that so many have put in.

Of course, this year was marked by the worldwide Corona pandemic. Early during the outbreak, we had published a statement on how far Covid-19 affected our work. Even though our structure – most of our team works remotely from the home office – meant that we were much less affected by difficulties than other companies, we too have friends, colleagues and relatives whose health were affected and also have kids we had to homeschool this year. Nevertheless, this has not affected our customer’s support, and there has been a significant up-tick in interest from people who want to collaborate on their documents without surrendering their data.

Despite all challenges, 2020 has been a very productive year at Collabora. We released important major releases for all our products – Collabora Online actually even saw two major releases, and Collabora Office arrived on Android and Chrome OS. Although conferences have only been possible online since March, we could present ourselves and our work quite well there. By moving to GitHub, a lot of fresh air and many dedicated people got in touch with Collabora Online.

Here is a summary of what we achieved together!

Collabora Online – two major releases, many improvements

The year 2020 saw two major releases of Collabora Online introducing handy new features and substantial UI and UX improvements.

Collabora Online 4.2 brings the feature rich Sidebar

In March, we introduced the Sidebar to Collabora Online 4.2. The versatile Sidebar hosts many of the most used features and provides a much improved user experience for the PC browser.

A version packed with new features

With Collabora Online 4.2 we also introduced an enhanced Colour picker with Conditional Formatting and the Function Wizard in Calc. We also added rich copy/paste, made working with images and tables much more easy and added the possibility to configure the Table of Contents. Find all the details in the Collabora 4.2 announcement.

 

The new colour picker
The Function Wizard in Calc
Collabora Online table of contents
Rich table of contents in Writer

 

Exciting 4.2 updates throughout the year

Many updates followed throughout the year:

  • April: brought improved PDF handling and support of Asian date formats in Calc in version 4.2.2.
  • May: Support for dropdown lists in form fields in ODT & DOCX and other text file formats and the handling of tabstops directly on the ruler in version 4.2.3
  • June: Multiple slide selection on slide pane, handling of tab stops, improved word count on phones and many other features arrive in version 4.2.4

Find all the exciting details in the Collabora Online 4.2 release notes!



Collabora Online 4.2.9: New options in comment threads


Collabora Online 4.2.12: Edit Chart titles from the Sidebar

 

Collabora Online 6.4 introduces the NotebookBar

 

In November, we released Collabora Online 6.4. This version introduces the (optional) new NotebookBar with its well-organized tabs and the possibility to collapse it to save space.

 

Collapse the NotebookBar for more space

 

This version also included leap in version numbering. This aligned with our desktop version and now reflects more accurately the level of development, since much of the technology is shared by both products.

 

Collabora Online 6.4 added many new features like the possibility to freeze panes in Calc, many interoperability improvements like, transparent text (in both Impress and Writer) and gradient backgrounds and better SmartArt import in Impress. Find all the details in our announcement.

Freeze rows & columns in Calc
Gradient backgrounds in Impress
Annotations in PDF documents

 

Collabora Office sees a new major release and powerful updates

In August 2020, we released Collabora Office 6.4. Our business-hardened and long term supported LibreOffice derivative brought a number of practical improvements to the workflow on desktops.

Security, encryption, PDF – new features on the Desktop

Naturally we had back-ported many of the new features to our supported Collabora Office 6.2 release as updates.

Padded Numbering was one of the results of this year’s hack week at Collabora and premiered in Collabora Office 6.2-9. Later this year it became part of Collabora Office 6.4 and LibreOffice.

Collabora Office 6.2-9: Padded numbering

In July, introducing the possibility to send encrypted PDF with Mail Merge, we added a privacy option to Collabora Office 6.2.-21. This also became available in Collabora Office 6.4 and LibreOffice.

Collabora Office 6.2-21: Send encrypted PDF with Mail Merge

Security features and PDF handling are focus topics. The option of adding visible digital signatures to PDF arrived in Collabora Office 6.4 in August.

Collabora Office 6.4 PDF signing.

Collabora implemented the Vulkan-capable rendering using the Skia library in LibreOffice 7.0. Download the slides from Luboš Luňák’s talk on this!

LibreOffice 7.0 Vulkan-capable rendering arrived

 

Collabora Office for iOS & Android

After the highly acclaimed release for iOS last year, we released Collabora Office for Android in February 2020.

Collabora Office for Android and iOS
Collabora Office brings rich editing experience to phones

This is the first time a fully function mobile office suite based on LibreOffice technology became available for Android. We have documented the long road to this point and the many supporters involved in the Collabora Office for Android and iOS credits.

An attractive layout & rich in features

Copy & paste rich text objects
Sheet editing options in context menu
Collabora Office for iOS and Android text document
Editing your text file
Collabora Office for iOS and Android presentation
Editing the content of a presentation

Thanks to the success of our mobile apps, we have expanded the LibreOffice user base by half a million mobile installations, as can be read in our annual LibreOffice infographic.

Adding more features to the mobile devices

Throughout the year we kept adding important new features to the mobile devices like tab stops & page set-up panels, improved word count, support for Asian fonts, and the possibility to open password-protected documents.

Collabora Office for Android & iOS 4.2.3: Page setup panel for text files on phones
Collabora Office for Android & iOS 4.2.4: Improved Word count on mobile devices
Collabora Office for Android & iOS 4.2.6: Writer document with different Asian fonts
Trying to open password protected files on Collabora Office for Android.
Trying to open password-protected files on Collabora Office for Android.

Version 6.4 – Another major release for mobile devices

The work on our mobile apps had its climax in the release of Collabora Office 6.4 for Android & iOS in November, which brought new features (e.g. gradient backgrounds, transparent text) from Collabora Online to mobile devices and introduced the NotebookBar to tablets.

 

 

Collabora Office for Android & iOS 6.4: The NotebookBar becomes available on tablets
Collabora Office for Android 6.4: The first Darkmode elements are beeing introduced

Collabora Office for Android & iOS are now available via the Play Store & App store. Additionally, we also offer an .apk file for download and made the repository available on F-Droid.

Collabora Office ships on Chromebooks

After making Collabora Office available on Android, this summer, we completed our multiplatform strategy by making Collabora Office available for Chromebooks as well.

The Chrome OS version is also available via the Play Store and is now also available as version branch 6.4. Interested in the technical background? Check that out in this talk:

from Jan Holesovsky’s talk “Chrome OS as a new platform” at oSLO2020 available on YouTube

Download the slides of “Chrome OS as a new platform” by Jan Holesovsky at oSLO2020

CODE 6.4 and a growing vibrant community on GitHub

 

In September, we released the Collabora Online Development Edition 6.4. This showcased all the cool new features, interoperability improvements and the new NotebookBar that would two months later become available in the enterprise edition of Collabora Online 6.4.

Collapsed NotebookBar

 

Open NotebookBar

Use the hamburger menu to access more options

The release of CODE 6.4 also marked the beginning of our initiative to lower the barriers to join the project. A few weeks later we announced moving the source code of Online to GitHub making it easier for interested people to get involved, and tackling some of the intriguing community marketing problems we faced.

The community rocks

This year we invested a lot of time, effort and passion to make Collabora Online & CODE a more accessible and fun project to work on. We created a forum for users to find support, many easy hacks and assigned developer Muhammed Kara as a community mentor, helping people getting on board. Why are we doing all this? Read about it in our FAQ!

 

Screenshot of GitHub Pulse for Collabora Online
Development Activity on Collabora Online GitHub Repository from November 27, 2020 to December 04, 2020

Regular round-ups and calls

Part of our efforts to grow a vital, transparent and welcoming community are Muhammet’s regular Community Round-ups published on our blog, as well as weekly community calls on Jitsi. We really appreciate all the new contributions we saw coming in this year from so many people, checkout their names & credits in the round-ups.

An engaged team of translators

Want to get involved in another way than contributing code? Join the engaged community of translators over on hosted Weblate to make Collabora Online available in more languages. Thank you to the dedicated team of translators.

Getting involved

It’s never been easier to get in touch with the project. You can ask questions in the Collabora Online forum or chat with us on Freenode, Matrix or Telegram or just drop us a mail at hello@collaboraoffice.com. Or use #cool_dev on Twitter or Mastodon to talk with us about Collabora Online on social media.

Important announcements, interesting figures

Our partner network hits 200

2020 has been an excellent year to close new partnerships. We now have can rely on over 200 partners from more than 50 countries, we help each other to promote FLOSS, 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 why not become a partner yourself!

CollaboraOffice.com available in 8 languages

This year, we dedicated a lot of effort to make our website and information about our product available to even more people. At this point collaboraoffice.com is available in English , German , Spanish , French , Traditional Chinese , Italian , Portuguese and Turkish . And we have only just begun…

 

Updated LibreOffice growth infographic 2020

We also updated our popular LibreOffice growth infographic. With some impressive numbers… Over 200M active LibreOffice users, over 50M pulls from the CODE Docker image, 500K installs of the Collabora Office mobile apps, and over 16K code commits from the whole community to LibreOffice. Have a look at the numbers!

 

Collabora Online as default in Nextcloud 19

In June, Nextcloud Hub 19 started to ship Collabora Online as the default office application, featuring an easy installation with just a few clicks.

Collabora Online with ownCloud Infinite Scale

In October we announced that Collabora will be integrating Collabora Online with ownCloud Infinite Scale.

Events and conferences 2020 – virtually different

Events were dominated by the global pandemic for most of the year. Sadly there were few opportunities to meet in person.

FOSDEM 2020

In February, FOSDEM 2020 could take place as the last big meeting of the open-source community with many presentations by Collabora developers.

FOSDEM 2020: Download “Bringing Collabora Online to your web app” by Michael Meeks
FOSDEM 2020: Download “LibreOffice turns 10 & what’s next” by Michaeal Meeks
FOSDEM 2020: Download “Integrate Collabora Online with web applications” by Andras Timar

Find all our FOSDEM talks in our playlist on YouTube and more slides for download in our blog.

oSLO 2020 – open SUSE & LibreOffice conference

The LibreOffice conference – this year co-organised by the open SUSE community – took place as an online event. Our team was involved with no less than 15 talks.

oSLO 2020: Download “Bringing The Notebookbar to Online” by Szymon Klos
oSLO 2020: Download “OOXML / PDF Digital Signing in Draw and elsewhere” by Miklos Vajna
oSLO 2020: Download “Implementing Vulkan-capable drawing using the Skia library” by Luboš Luňák

The talks are available in our playlist on YouTube and the complete set of slides can be found in our blog.

LibreOffice developement Workshop in Eskişehir

Collabora sponsored an impactful four-day LibreOffice development workshop during the Free Software Winter Camp at Anadolu University in Turkey. We wrote an article about the impressive results. Two participants of the workshop later went on to work GSoC projects for the LibreOffice project.

Google Summer of Code 2020

In addition to the Collabora Online community, our developers were very committed to this year’s Google Summer of Code. Read about the LibreOffice projects we mentored and the successful new implementations that resulted from these GSoC projects. Participants in the Google Summer of Code often become long-term contributors to the project.

 

Summary

In summary, it has been a busy year here at Collabora Productivity. This overview only sums up a small part of the great things we have been working on alongside the community. We have advanced our mission to make open-source rock; giving users privacy and businesses control over their data. We not only produced excellent results, but also had a good time working on these things – despite the challenging conditions that 2020 offered. If you’d like to get involved its easy to partner with us, buy from us, or get involved in the growing Collabora Online community. We have lots of plans in the pipeline for 2021 and hope there will be more possibilities to meet in person on conferences and on events. We would like to thank the whole team, particularly our great partners, and customers who make our work possible, and the community of developers and users who make it fun. We look forward to continuing the successful work with you in 2021! Have a very Happy Christmas & a peaceful New Year.

Thank You!