Collabora Office 22.05 brings features, performance wins, and excellent Interoperability

The new Collabora Office 22.05 brings improved performance and better interoperability

Cambridge, May 30th, 2022 – Today we are pleased to announce the availability of the new major release of Collabora Office. With improved interoperability, better performance, and new features we can enhance the productivity of all users. Collabora Office, for macOS, Windows and Linux, is an enterprise version of the world’s most popular open-source office productivity suite LibreOffice. It is the foundation for new versions of our online collaboration suite Collabora Online, and also will power our apps for iOS, Android and Chrome OS.

The whole suite offers businesses and professionals the best features, interoperability, Long-Term Support (LTS), and bespoke development services in open source, while respecting users privacy and corporate data security. For news and improvements in the consecutive updates, check this release notes page.

“Jumbo Spreadsheets” with 16k columns in Calc

Collabora Office 22.05 increases the maximum number of columns available in Calc to 16384

A frequently requested feature is that Calc in Collabora Office now supports up to 16384 columns in spreadsheets. This is a sixteenfold increase in the maximum number of columns compared to previous versions. This capability was previously available as an experimental feature, but with the current fine-tuning, it is now available to all users by default. Previously, Calc would display an error message on opening large sheets and crop the data in the extra columns. Combined with up to one million rows per spreadsheet, Calc can now handle enormous amounts of data on the right hardware. Previous performance improvements in Calc paved the way for this feature which also increases the interoperability with Excel spreadsheets from Microsoft. If you are interested in the technical details, we recommend you take a look at Luboš Luňák’s developer blog. This work was funded by DEVxDAO as part of their mission to support open-source and transparent research and development of emerging technologies and frameworks.

Sparklines are now available in Calc

Sparklines for Calc have arrived in Collabora Office 22.05

Sparklines are mini-charts found in Microsoft’s XLSX format. The support for them premieres with the release of Collabora Office 22.05. Sparklines are always defined for one cell, but different ones can be grouped together. There are three different ways of displaying Sparklines. They can be displayed as lines, bar charts or stacked as win-loss charts. The Sparklines feature can be accessed through the right-click dialog. The unique data for a Sparkline is defined in the data range.

All three types of Sparklines displayed horizontally and vertically

This feature was made possible by funding from NGI and the European Union’s Horizon 2020 research and innovation programme under grant agreement No 871498. For more information on the technical background, see Tomaz Vajngerl’s blog.

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

Improved rendering of Word-style borders for pages, tables & paragraphs in Collabora Office 22.05 Writer

In Collabora Office 22.05 we have been looking at Writer and how it can better render Word-style borders around pages, tables and paragraphs. Word users expect to be able to import their documents to Writer and have a rendering that is true to the original. A series of fixes to the way page, table, and paragraph borders of OOXML documents are imported into and painted in Writer meets this desire. This is done conditionally, so existing ODF documents are left unchanged. As a result of this work, Writer now has a set of improvements to better render Word-style borders around pages, tables and paragraphs. Thank you to Docmosis and TUBITAK for making this work by Collabora possible. Find out more about the technical background in Miklos Vajna’s development blog.

Linked paragraph and character styles arrive in Writer

caption

With the release of Collabora Office 22.05 Writer has now the ability to handle linked character styles and paragraph styles from Word documents. This improves interoperability and may improve the style previews and the UI of future releases. Earlier, links were lost on round-trips between Writer and Word which led to unwanted displays inside the style pickers. This work was made possible thanks to Docmosis. Find more details in the developer blog.

Adding links to shapes in Writer

It is now possible to add links to shapes in Writer

The latest version of Collabora Office introduces the ability to add hyperlinks to shapes in Writer. This option was previously only available in spreadsheets and presentations, but not in text documents. At the same time, links in shapes were previously also lost when importing Word documents, so this feature also improves interoperability. To make use of this feature, simply select a shape and choose the hyperlink symbol from the GUI. Editing of exiting hyperlinks is also possible through the right-click dialog. Many thanks to our ecosystem partner allotropia for implementing this.

Improved shadows for tables in presentations

The interoperability of transparent shadows in tables saw further improvements in Collabora Office 22.05

The way Impress handles shadows in tables saw additional refinements. Now it correctly renders shadows for table shapes, even if the shadow itself or the fill of the table cells have transparency. This is another enhancement of the compatibility with Microsoft’s PowerPoint with regard to the support of transparency in table cell fills and table shadows. We’d like to thank our partner SUSE for making this improvement possible, find more details in Miklos Vajna’s developer blog.

New PowerPoint-compatible screen sizes available in Impress

New PowerPoint-compatible screen sizes available in Writer

A few new PowerPoint-compatible screen sizes have been added to the Paper Format options inside the Slide Properties. The “Widescreen” option is currently used in PowerPoint, while the different “On-screen Show” options are used in previous versions of PowerPoint and Google Slides. Any exported file created with these sizes will be treated as a preset size (as opposed to a user size). The same applies on import. Thank you to Jun Nogate for the work on this!

Many performance improvements across all modules

In addition to improving interoperability, one of the main areas of activity for Collabora engineers is the continued improvement of performance. In the new main version of Collabora Office, significant performance improvements can be found in all modules, which were achieved by streamlining the code. For example:

  • The export speed of complex PDF documents has increased in Writer
  • The load speed of large RTL documents was improved in Writer
  • The rendering speed of complex Writer document has increased
  • Calculation performance improvements for Calc
  • Improved opening speed of XLSM & XLSX files
  • Improved inserting speed of large Charts in Calc
  • Improved speed of lookup functions in Calc
  • Improved speed for auto-filtering in Calc
  • Improved use of threads for calculations in Calc
  • Improvements on shape rendering in Impress & Draw

About Collabora Office

Collabora Office is based on LibreOffice technology for professional, mobile, and online use. Collabora Office 22.05 provides businesses and professionals with the best features, interoperability, LTS and L3 support. Collabora is privileged to work with so many great contributors to the LibreOffice project and appreciates all the outstanding work done by so many that is included into Collabora Office 22.05. This, our annual release, contains much work that was contributed to LibreOffice 7.3 and then LibreOffice 7.4, for a deep dive on detail and credits, please do peruse these. It’s easy to migrate to Collabora Office 22.05. You can try Collabora Office 22.05 yourself! Just head to the Collabora Office page and request your demo today!

Try the Demo

Thanks to the community!

Collabora has invested significantly in bringing many new features and functionality to this latest release, and accounts for a significant volume of contributions. However, we want to acknowledge all of our friends and colleagues who helped to contribute to this and the upstream LibreOffice technology. Find the details in either the release notes above or the LibreOffice community credits. We cannot thank everyone involved enough for their passionate work! LibreOffice is a friendly community offering many ways to get involved. Alternately, if you are interested in joining the Collabora Online community, you will find several easy ways to started inside our community hub – we look forward to
welcoming you.

Collabora Office 21.11 for Android, iOS and Chrome OS Lifts Mobile Productivity to the Next Level


Powerful Office Productivity in Your Pocket

Cambridge, April 13, 2022 – Today we are pleased to announce the availability of a new major release of Collabora Office for mobile devices and Chromebooks. This version of our free app for Android, iOS and Chrome OS includes numerous advanced productivity features, excellent document compatibility and a much improved user experience.

“Collabora Office on Mobile is a real alternative to proprietary office editors on Android, iOS and Chrome,” said, Nicolas Christener, CEO at Adfinis. “We are pleased to have contributed to Collabora’s work on this new version, which delivers a much-improved tablet sidebar and user experience.”

“This version of Collabora Office brings a year of work and improvement both from our team and the underlying LibreOffice Technology, ” said, Michael Meeks, General Manager of Collabora Productivity.  “We love to work alongside the community, as well as partners like Adfinis who understand the importance of digital sovereignty for enterprise customers wanting to edit their documents on the go.”

 

Performance Improvements

Collabora Office 21.11 for mobile devices has inherited many performance improvements that we have been working on through the 6.4 life-cycle and have already been included in the Collabora Online core. We have been accelerating JavaScript, and we’ve made auto-spell checking and AutoFilter quicker.

Faster and More Responsive Sidebar on Tablets

Collabora Office 21.11 introduces a sidebar for tablets. This is both a performance and usability improvement. It uses the same new JavaScript engine as Collabora Online 21.11, making it far more responsive and natural looking. With its more snappy responding buttons and controls, it is a major improvement for all users.

Contextual Toolbars Enhance User-Experience

The new contextual toolbar in Collabora Office 21.11 improves the usability of the mobile application. The toolbar (at the bottom of the app) now reacts dynamically to the active selection. For example, if a user selects text the bottom bar will display actions related to text. If the user selects a shape, the bottom bar changes to display only actions related to that particular object type (shape) or the selected element (table, shape, image). Thanks Andreas Kainz for working on this 🙂

 

Improved Import of PPTX with Shaped Images

Collabora Office 21.11 includes many interoperability improvements around the import of PPTX files, that had first been introduced to the desktop and to Collabora Online. Images within shapes – even those converted to greyscale or mirrored – are now displayed true to the original on the mobile app.

 

Better Shadow Effects

In earlier versions of the mobile app, shadows used to be rendered as solid copies of objects. The new Blur option now allows for a more realistic rendering of the shadows. This option can be accessed via the Edit button inside the mobile app and the Shadows option in the dialog. A checkbox allows you to activate the blur effect. You can customise the blur effect with the plus and minus controls.

 

Glow and Soft Edge Effects for Shapes

Collabora Office 21.11 introduces further options, which allow you to manipulate shapes in a more granular way. Once a shape is selected, you can add and change Glow effects and Soft Edges through the Effect dialog available in the Edit menu. In addition, it is now possible to choose the colour and the degree of transparency of the effect. This function is also an interoperability improvement and is available for shapes across all document types (Writer, Calc, Impress and Draw).

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.

 

Download Collabora Office 21.11

Collabora Office for iOS, Android and Chrome OS is available through the Play Store and App Store. We also provide the latest snapshot .apk for Android for download! While the iOS version is already available to all users, the Android and Chrome OS releases will be rolled to Play Store users gradually. A vibrant and welcoming community has evolved around Collabora Online & Collbaora Office. If you would like to get in touch or get involved, visit us in the forum or on GitHub.

 

About Collabora Productivity

Collabora Productivity is the driving force behind putting LibreOffice in the Cloud, providing Collabora Online and a range of products and consulting to enterprise and government. Powered by the largest team of certified LibreOffice engineers in the world, it is a leading contributor to the LibreOffice codebase and community. Collabora Office for Desktop and Collabora Online provide a business-hardened office suite with long-term, multi-platform support. Collabora Productivity is a division of Collabora, the global software consultancy dedicated to providing the benefits of Open Source to the commercial world, specializing in mobile, automotive and consumer electronics industries. For more information, visit www.collaboraoffice.com or follow Collabora Office on Twitter .

Collabora Online 21.11.3 Released – Dynamic Configuration of Multiple Hosts Saves Cost and Reduces Management Complexity

The latest update of Collabora Online brings significant configuration improvements allowing users to dynamically connect multiple WOPI hosts with a single Collabora Online Server. This makes Collabora Online easier to deploy and configure, especially when scaling to integrate with many different services. Collabora Online 21.11.3 also brings several improvements to the user experience, like the way complex commenting cases are handled. Several visual enhancements are also included. All the technical details of this version are available in the release notes.

Dynamic Configuration Saves Cost and Reduces Management Complexity

Collabora Online uses a WOPI-like protocol to interact with hosts who want to integrate Collabora Online. The improved admin configurations allow for multiple WOPI hosts with multiple aliases. This means you can use a single Collabora Online server with different software integrations at the same time as Nextcloud, ownCloud, EGroupware, Moodle, Alfresco or an Univention Corporate Server. It is possible to manage these hosts dynamically without a server restart. This makes Collabora Online much easier to deploy and configure, particularly when scaling to integrate with large numbers of different services. All of this saves cost and reduces management complexity, making this feature especially interesting for host companies. We have summarised the technical background information on Multihost Configuration inside our SDK documentation.

The comments section in Collabora 21.11.3 saw different visual and usability improvements

Improvements for Complex Commenting Cases

Icon of a collapsed thread

The way Writer renders comments has improved significantly with recent updates. When you respond to a comment, the original comment is visually highlighted and indented, making it much clearer to locate the referenced element inside the document. Collabora Online does now display comments in different ways depending on the window’s width. On smaller displays, comment threads will be displayed collapsed – as a small icon with an indication of the number of replies. This is particularly useful on laptops or tablets. On large screens comments we be displayed fully expanded. These overall visual improvements significantly enhance the look and feel of the comment section and make the collaborative editing processes more effective.

 

 

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.

 

Collabora Online 21.11.2.4 Brings Accessibility Checker and Improved UX

The latest update of Collabora Online brings several improvements regarding accessibility and the user interface. Also, the rotation of images has been accelerated, making the experience much better. Inside this blog, we are highlighting some of the latest features of the Collabora Online 21.11.2.4 update. All the technical details of this version are available in the release notes.

Accessibility Check Helps to Create Documents According to the PDF/UA Standard

Accessibility Check in Collabora Online 21.11.2.4

Collabora Online introduces the accessibility checker with the update to version 21.11.2.4. It helps to create documents according to the PDF/UA standard. Published as an International Standard in 2012 (ISO 14289), the PDF/UA format provides clear normative terms for achieving accessibility in the PDF format. The goal is to enable users to use documents without assistance from others, and to be able to receive the same value from the content as people without disabilities. This is accomplished by standardisation of the content structure within the PDF files and the technology capabilities available to the end user, including PDF readers and assistive technologies (AT).

The Accessibility Check is part of the first step in an ongoing journey to improve accessibility, both in Collabora Online (Browser) and Collabora Office (Desktop). The Accessibility Check button can be found in the Review tab. The dialog shows a list of all issues found in the text document. Through a quick access button, it is possible to access the critical element. The issue is highlighted. These checks are currently implemented:

  • Check if the document title is set
  • Check if the document language is set, or all styles in use, have the language set
  • Check all images, graphics, OLE objects for the alt (or title in some objects) text
  • Check for heading order. Order of the headings must increase incrementally with no skips
  • Check, if text conveys additional meaning with (direct) formatting
  • Check if tables do not include split or merged cells, which could be disorienting for users with visual impairments
  • Check for fake/manual numbering (not using integrated numbering)
  • Check that hyperlink text is not a hyperlink itself – hyperlink should be described
  • Check for the contrast between text and the background
  • Check for blinking text, which can be problematic for people with cognitive disabilities or photosensitive epilepsy
  • Check for footnotes and end notes, which should be avoided

Faster Rotation of Bitmap Graphics

Fast image rotation in Collabora Online 21.11.2.4

The rotation of bitmap graphics has undergone a significant speed improvement. When rotating graphics via the button (the slightly off-set filled circle above a selected graphic), the movement is now much smoother and easier to position. This improvement makes manipulating bitmap graphics much more comfortable. Here’s how you can try it for yourself. Select a bitmap graphic by clicking on it. Move the cursor to the grey circle above the graphic. The cursor now changes into a palm. Now move the palm cursor to the right and left as you wish while holding down the left mouse button.

Goodbye, Hamburger Menu 👋 The User Interface Experiences Many Improvements

Home Tab in Collabora Online 21.11.2.4
View Tab in Collabora Online 21.11.2.4

The Collabora Online 21.11.2.4 update brings some clearly visible changes to the user interface. The tabs have been streamlined in favour of a more floating style. The appearance of Collabora Online on iPads has been harmonised with the appearance on desktops and notebooks. By clicking the current tab, you can collapse the menu or display it again. Additionally, we are waving the hamburger menu goodbye. Many of the functions contained therein were already available via buttons in other tabs. Now the remaining functions have also found a new home, in places that are less generic. For instance, Select All can be found inside the Layout tab, the Full Screen icon now lives in the View tab, and so does the possibility to toggle the ruler. At the same time, the Undo & Redo buttons have been moved to the Home tab. And there are even more small UI enhancements to be discovered. All dialogs experienced visual improvements, and so did many elements in the Sidebar and the formatting icons. Thanks to the community, that contributed a lot to this specific area.

 

 

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.

 

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.