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 the LibreOffice Technology-based suite 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.

Read More

Collabora Online Powers Diagrams in ownCloud 10.9

New Frontend and Diagrams in ownCloud 10.9

The latest version of ownCloud Server brings various performance improvements, including significantly speeding up how ownCloud clients examine the contents of user accounts. This is especially beneficial for those users with a lot of files and large directory structures. The update has also introduced a new frontend. The “richdocuments” extension of Collabora Online supports both the old and new frontend and integrates flawlessly into either of them. At the same time, a new document type has been introduced. The ownCloud Server can now open and edit Diagrams.

Using Diagrams with ownCloud & Collabora Online

The use of the new Diagram file type is very straightforward. Below we are describing how to create a Diagram from scratch inside the new and the old interface and how to edit exiting Diagrams through the ownCloud server web interface.

Accessing documents with Collabora Online from ownCloud’s new frontend

Create or Open a Diagram in the Old Frontend

To create a new diagram inside the old web frontend, simply click the plus icon within the folder navigation above the file list. In addition to the familiar document types (word processing, spreadsheet & presentation), you will now also notice an orange Diagram option. Select this to open an empty diagram document. Diagrams are displayed in a light orange icon and include the extension .odg in their file name. Existing Diagrams will be opened through a click on the file.

Create or Open a Diagram in the New Frontend

The handling within the new frontend is very similar. The new web interface includes an updated new button over the file listing. Click it and choose the new Diagram option to start a Diagram from scratch inside the current folder. Diagrams are also displayed in a light orange icon and include the extension .odg in their file name. Existing Diagrams will be opened through a click on the file or through a context menu that opens with a right-click.

A Diagram opened in Collabora Online 21.11

Edit Diagrams with Collabora Online and ownCloud

Diagrams can also be created outside ownCloud and Collabora Online using Collabora Office Draw or LibreOffice Draw. Diagrams offer a variety of options to edit documents with (vectorized) graphics, shapes, text, FontArt and the smart connector tool that has been introduced in Collabora Online 6.4.8. Furthermore, it is of course possible to work with tables and charts. Diagrams is suitable for creating print products such as flyers or posters, but also organigrams, flow charts or technical drawings. Working within the Diagrams module is very intuitive as it is similar to the approach of creating a presentation in Impress. Further information on the range of functions can be found in the Draw online help.

Discover Collabora Online and ownCloud

Collabora and ownCloud are proud to offer a combined commercial solution including Collabora Online. Based on the LibreOffice technology core, we continue to develop this functionality in response to the evolving needs of our customers. Find out more and request your free demo.

 

 

About ownCloud

ownCloud develops and provides open-source software for content collaboration, allowing teams to easily share and work on files seamlessly regardless of device or location. Hundreds of millions of users worldwide already use ownCloud as an alternative to public clouds – and thereby opt for more digital sovereignty, security and data protection. Find more information online at owncloud.com or follow @ownCloud on Twitter.

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. Keep up to date on all latest developments by following us on Twitter, LinkedIn, YouTube or Mastodon.

Read More