Cambridge, United Kingdom – Bangalore, India – 01 November 2022
Collabora, the developers behind Collabora Online, and Exzatech Consulting, an IT and software solution provider focusing on security and enhanced business performance, are happy to announce a partnership integrating Collabora Online and Exzatech’s ‘Ndryve’ collaborative workspace.
“We are pleased to be Partnering with Exzatech and increasing our offering in Asia.” said Michael Meeks, General Manager of Collabora Productivity. “We love to work with Partners who place value in providing businesses with data privacy and have a great vision for their technology.”
Collabora Online now available in Ndryve
Exzatech provides Ndryve, an enterprise-ready, remote-friendly, “Content Collaboration Workspace” with a focus on data protection and security. Providing a range of benefits for all types of businesses including Government and Healthcare, Ndryve also hosts unique features for research and academic institutions.
Ndryve offers traditional on-premises, hybrid managed or fully cloud-hosted content collaboration workspaces. Their technology combines the ease of consumer-grade solutions like Dropbox and Google Drive, with the security, privacy and control of individual business’ needs.
Collabora Online is a powerful online office suite that supports all major document, spreadsheet and presentation file formats which can be easily integrated in many infrastructures and solutions. Key features are collaborative editing and excellent office file format support.
Collabora Online is excellent for enterprises that need a powerful office suite in the cloud, or on-premises, that protects their privacy and allows them to keep full control of their sensitive corporate data. Collabora Online enables Hosting and Cloud businesses to include document viewing and collaborative editing functionality into their service offerings.
“We are happy to now be offering Collabora Online as an integration in Ndryve, giving our customers the ability to integrate a full-featured, flexible, collaborative workspace across desktop and mobile.” says Anantha Raghava, Chief Executive Officer of Exzatech Consulting.
About Exzatech Consulting
Exzatech combines flexibility and creativity to provide strategic guidance and innovative solutions to their clients. Their vendor-agnostic approach gives them the ability to provide the most suitable analysis, advice, and solutions for each business. Over the years, they have deployed adaptable and innovative solutions for a number of leading BFSI, government, and enterprise clients that have improved operations, secured networks, saved costs, and enhanced business performance.
“As individuals, we are just like anyone else. But as a team, we are a powerhouse of knowledge, skills, and ideas. With decades’ worth of business and technology experience under our wings, we have built a formidable presence as a much sought after IT and software solution provider in India and abroad.” says Exzatech.
Collabora Productivity created Collabora Online, an online office suite based on LibreOffice Technology. Collabora provides a wide range of products, as well as consulting services for enterprises and governments. Powered by the largest team of certified LibreOffice engineers in the world, Collabora is a leading contributor to the LibreOffice codebase and community. Collabora Office for Desktop and Collabora Online provide a business-hardened office suite with long-term support.
Collabora’s multi-platform policy is completed with Collabora Office for iOS and Android. Collabora Productivity is a division of Collabora, the global software consultancy dedicated to providing 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 @CollaboraOffice on Twitter.
Cambridge, October 26, 2022. Collabora Productivity announces the availability of Collabora Online in the OpenPOWER architecture. Accessing this architecture makes our collaborative online office available on another group of powerful data centres and is the result of the young partnership with independent IT service provider 21unity, based in Dieburg, Germany.
Collabora Online Available on OpenPOWER
Starting with the release of the enterprise version 22.05.6, Collabora Online now supports the ppc64le architecture. The abbreviation describes the little-endian architecture provided by the OpenPOWER Foundation, which is based on the Power ISA instruction set. Power ISA is a successor to the PowerPC ISA developed by IBM for the microprocessor architecture of the corresponding name. The architecture is super-scalable and belongs to the family of Reduced Instruction Set Computers (RISC).
“We are pleased to bring our product to the Power platform”, says Michael Meeks, General Manager, Collabora Productivity. “We love to work with like-minded partners who build their business around open technologies.”
Benefits of the OpenPOWER Architecture
Unlocking the OpenPOWER architecture is a consistent step in our strategy to make Collabora Online available on all modern architectures and platforms while bearing the best possible performance in mind. It enables us to deliver our collaborative online office on an additional family of servers and data centres. The OpenPOWER architecture combines performance with high reliability. The openness of the technology is the key to the recent innovations in performance and energy efficiency. For the ppc64le platform, Collabora currently provides Ubuntu 20.04 packages and Docker images to customers and Partners.
21unity and Collabora Productivity Forge a Partnership
The availability of Collabora Online on the OpenPOWER architecture is the result of the fruitful partnership between the Dieburg-based IT service provider 21unity and Collabora Productivity, and was facilitated by the openness of the technology used. The OpenPower Foundation follows an open collaboration model for its technology, in which participating companies share technological innovations with each other – comparable to Collabora’s open-source software development. Collabora Online is based on LibreOffice technology – new features and enhancements that our developers create for our desktop suite are incorporated into the LibreOffice core alongside Collabora Online. 21unity offers the digitally sovereign online collaboration solution 21unity CLOUD as a new product on the OpenPOWER architecture. The offering consists of Nextcloud Enterprise for sharing files, writing email, and conducting chats and video conferences, and includes Collabora Online as a feature-rich, professional online office with outstanding interoperability.
“We are very pleased to be offering Collabora Online in our 21unity Cloud running on OpenPOWER”, says Yogi M. Schneider, CTO/CDO at 21unity. “It’s great to be able to offer the excellent features and interoperability to a wider user base.”
21unity operates the 21unity CLOUD from its own data centre with enterprise-class POWERServers in Dieburg, Germany.
About 21unity
21unity, based in Dieburg, specializes in customized IT solutions for companies. They are a cloud service provider and offer an “out-of-the-box” Nextcloud Enterprise with 21unity Collaboration Cloud and also created their own ERP system, which give the customers a full-fledged digital office experience. Their mission is to create easy-to-use, browser-based solutions for uncomplicated digital collaboration. In the area of system integration, they consider themselves not just a solution finder or developer, but an accelerator and trusted partner for digital transformation. The cloud offering provides a comprehensive collaboration office with the security of a German server location. The link with 21pro – a proprietary ERP – professionalizes the workflow in the process. Learn more at 21unitycloud.de
About Collabora Productivity
Collabora Productivity created Collabora Online, an online office suite based on LibreOffice Technology. Collabora provides a wide range of products, as well as consulting services for enterprises and governments. Powered by the largest team of certified LibreOffice engineers in the world, Collabora is a leading contributor to the LibreOffice codebase and community. Collabora Office for Desktop and Collabora Online provide a business-hardened office suite with long-term support. For more information, visit www.collaboraoffice.com or follow @CollaboraOffice on Twitter.
This New Major Release Brings Grammar Checking, Giant Spreadsheets and Performance Wins
Cambridge, August 4, 2022 – Collabora announces the availability of a new major release of Collabora Online 22.05. The latest major release targets three key areas: ease of use, performance, and interoperability. It demonstrates the company’s mission of being the technology leader in collaborative editing. Collabora Online provides businesses the most effective and secure document creation environment with dedicated support backed by deep experience.
Collabora Online is the collaboration suite that offers business and professionals the best features, interoperability, LTS, and custom support in open source, while respecting user privacy and corporate data security. We highlight some of the latest functionality added to Collabora Online below:
Grammar checking in a Writer Document in Collabora Online 22.05
Starting with version 22.05 we have introduced the support for external grammar checkers. You can now benefit from the great style and grammar checker by LanguageTool in your browser. To make use of this feature, you have to enable this inside Collabora Online’s configuration file. Depending on whether you are using a free or a premium account, both the quality and amount of the suggestions may vary. We would like to express our gratitude to Nicolas Christener and his wonderful team at Adfinis for making this great feature a reality. And of course to the team for their great work creating, maintaining and improving LanguageTool. You can support their open-source work by buying their premium service. Find more details on how to benefit from this feature in our dedicated blogpost on LanguageTool in Collabora Online.
“Jumbo Spreadsheets” with 16k Columns in Calc
Collabora Online 22.05 increases the maximum number of columns available in Calc to 16384
Collabora Online now supports up to 16384 columns in spreadsheets. This is a sixteenfold increase in the maximum number of columns compared to previous versions. Previously, and annoyingly, Calc would display an error message on opening large sheets that exceeded 1024 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. 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 Now Available for Calc
Create beautiful single cell graphs in Calc with Sparklines in Collabora Online 22.05
Sparklines are mini-charts found in Microsoft’s XLSX format. The support for them premiered 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: as lines, bar charts or stacked as win-loss charts. The Sparklines feature can be accessed through the right-click dialog. The source data for a Sparkline is defined in an associated data range.
Collabora Online 22.05 supports the WebP format across all modules
WebP is a graphics format for lossy or lossless image compression. It can be used for both static and animated images, and is also supported by the vast majority of modern browsers. The current version of Collabora Online now allows for importing images in WebP format. The graphic format can also be used in all document types, i.e., in text documents, spreadsheets, presentations as well as Draw files.
Content Controls in Writer: Dropdown, Picture and Date Types
Content Controls menu in Collabora Online Writer 22.05
Writer now has content control: a new way to set properties on a piece of text, primarily for form filling purposes. This feature improves compatibility with the DOCX format around forms. There are now five types of inline Content Controls that can be imported and added to Collabora Online. Writer had already included form controls and fieldmarks, providing similar features. However, there are some differences in their behaviour – among other differences, Content Controls can contain rich text and a set of properties. However, unlike fieldmarks, they can’t span over different paragraphs. Here is a small summary of the capabilities of the new Content Controls.
Rich Text Content Controls simply show an indicator when you’re inside the content
Checkbox Content Controls contain a single character, but you can interact with them: clicking on the content control toggles the checked state of the checkbox
Dropdown Content Controls have a list of dropdown items. Each item is a display-text and value pair, allowing to differentiate between a human-readable string and a machine-readable value.
Picture Content Controls allow the author of a form to pre-format the image before the filler of the form inserts the actual image.
Date Content Controls were emulated with Writer fieldmarks in the past, which created trouble during export, since Word itself doesn’t have a date form-field.
Date Content Control in Collabora Online 22.05Date Content Control Properties in Collabora Online 22.05
Faster native rendering of the input of formulae in Calc
We continue working in the conversion of various UI components in Collabora Online to “native” HTML widgets. This helps us to get better user experience, especially on touch and mobile devices. This time we have converted the formula bar which is used to edit data in cells inside a spreadsheet.
Previous “tunnelled” approaches had some disadvantages, such as a blurry look under some conditions and unexpected cursor position behaviour. Now the edit field is rendered by the browser, ensuring a crisp display of text under all circumstances and resolutions with improved caret positioning. It has now become much easier to type into the formula bar, especially on touch devices.
The formula input bar on touch
Bandwidth wins and improved performance with Deltas
Previous versions of Collabora Online have managed documents as a series of tiles, when a tile is invalidated by its contents changing, new tiles have been compressed and sent. Interestingly, this cost usually outweighed all other rendering and managing of document content. In this version, we adopt a simple time-based compression – whereby for actively changing tiles, we send the user a small set of changes since the last tile. Thus, if you type a ‘period’ we can generate a tiny compressed change for just those pixels. This gives up to a 75% bandwidth saving depending on your workload – as well as saving CPU time. We also have laid the foundation for switching to a far faster zstd compression library in the 22.05 lifetime to save yet more CPU cycles and serve more users from the same server hardware.
Accessibility Check Helps to Create Documents According to the PDF/UA Standard
Accessibility Checker
The current version of Collabora Online includes a new Accessibility Checker. This 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 easily create documents that are friendly to the impaired, without expert assistance, and to make that easier to do. This is accomplished by making it easier to set standardized content annotations within the document so that they can be made available to the end user, including PDF readers via assistive technologies (AT).
The Accessibility Check is a useful step in our 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. See this article for more details on the already implemented checks.
Faster Rotation of Bitmap Graphics
Fast image rotation in Collabora Online 22.05
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.
Dynamic Configuration of Multiple Hosts
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. It is also 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 hosting companies. We have summarized the technical background information on Multihost Configuration inside our SDK documentation.
LibreOffice Technology
CODE and Collabora Online are built with LibreOffice Technology by the LibreOffice community in which we love to participate. We cannot thank everyone involved enough for their passionate work.
LibreOffice – a great technology base
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.
Collabora Online 22.05 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.
This New Major Release Brings Grammar Checking, Giant Spreadsheets and Performance Wins
Cambridge, June 29, 2022 – Collabora announces the availability of Collabora Online Developer Edition (CODE) 22.05. The latest major release targets three key areas: ease of use, performance, and interoperability. It demonstrates the company’s mission of being the technology leader in collaborative editing. Collabora Online businesses the most effective and secure document creation environment with dedicated support and depth of development horsepower. CODE 22.05 is preceding the next major release of our long-term supported business suite Collabora Online. This free developer version includes all features and enhancements that will be available in our enterprise version, expected later in July. The CODE releases allow every interested user to learn and test new features on an early stage. As always, your feedback on possible issues is much appreciated! CODE is the collaboration suite offering home users and early adopters the best features, interoperability in open source, while respecting user privacy and data security. In this announcement, we are showcasing some of the latest functionalities added to Collabora Online.
Grammar checking in a Writer Document in CODE 22.05
Starting with version 22.05 we introduced the support for external grammar checkers. You can now benefit from the style and grammar checker by LanguageTool in your browser. To make use of this feature, you have to enable this inside Collabora Online’s configuration file. Depending on whether you are using a free or a premium account, both the quality and amount of the suggestions may vary. We would like to express our gratitude to Nicolas Christener and his wonderful team at Adfinis for making this great feature a reality.
“Jumbo Spreadsheets” with 16k Columns in Calc
CODE 22.05 increases the maximum number of columns available in Calc to 16384
Collabora Online does now support up to 16384 columns in spreadsheets. This is a sixteenfold increase in the maximum number of columns compared to previous versions. Previously, Calc would display an error message on opening large sheets that exceeded 1024 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. 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 Now Available for Calc
Sparklines for Calc have arrived in CODE 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.
CODE 22.05 supports the WebP format across all modules
WebP is a graphics format for lossy or lossless image compression. It can be used for both static and animated images and is also supported by the vast majority of modern browsers. The current version of CODE now allows for importing images in WebP format. The graphic format can now be used in all document types, i.e. in text documents, spreadsheets, presentations as well as Draw files.
Content Controls in Writer: Dropdown, Picture and Date Types
Content Controls menu in Collabora Online Writer 22.05
Writer now has content controls functionality, a new way to set properties on a piece of text, primarily for form filling purposes. This feature improves compatibility with the DOCX format. There are now five types of inline Content Controls that can be imported and added to Collabora Online. Writer had already included form controls and fieldmarks, providing similar features. However, there are some differences in their behaviour. Among other differences, Content Controls can contain rich text and a set of properties. Instead of fieldmarks, they can’t span over different paragraphs. Here is a small summary of the capabilities of the new Content Controls.
Rich Text Content Controls simply show an indicator when you’re inside the content
Checkbox Content Controls contain a single character, but you can interact with them: clicking on the content control toggles the checked state of the checkbox
Dropdown Content Controls have a list of dropdown items. Each item is a display-text and value pair, allowing to differentiate between a human-readable string and a machine-readable value.
Picture Content Controls allow the author of a form to pre-format the image before the filler of the form inserts the actual image.
Date Content Controls were emulated with Writer fieldmarks in the past, which created trouble during export, since Word itself doesn’t have a date form-field.
Date Content Control in Collabora Online 22.05Date Content Control Properties in Collabora Online 22.05
Faster native rendering of the input of formulae in Calc
We continue working in the conversion of various UI components in Collabora Online to “native” HTML widgets. This helps to get better user experience, especially on touch and mobile devices. This time we have converted the formula bar which is used to edit data in cells inside a spreadsheet.
Previous “tunnelled” approaches had some disadvantages like a blurry look under some conditions and a cursor position setup depending on pixel-based coordinates. Now the edit field is rendered by the browser, ensuring a crisp display of text under all circumstances and resolutions. The position of the caret is represented as a logical value and also handled by the browser. This adds a lot of benefits to the user experience. It has now become much easier to type into the formula bar, especially on touch devices.
New formula input bar in CODE 22.05 using a touch device
Bandwidth wins and improved performance with Deltas
Previous versions of Collabora Online have managed documents as a series of tiles, when a tile is invalidated by its contents changing, new tiles have been compressed and sent. Interestingly this cost usually outweighed all other rendering and managing of document content. In this version we adopt a simple time-based compression – whereby for actively changing tiles we send the user a small set of changes since the last tile. Thus if you type a ‘period’ we can generate a tiny compressed change for just those pixels. This gives up to a 75% bandwidth saving depending on your workload – as well as saving CPU time. We also have laid the foundation for switching to a far faster zstd compression library in the 22.05 lifetime to save yet more CPU cycles and serve more users from the same server hardware.
Accessibility Check Helps to Create Documents According to the PDF/UA Standard
Accessibility Check in CODE 22.05
The current version of CODE includes a new Accessibility Checker. This 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 standardization 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. See this article for more details on the already implemented checks.
Faster Rotation of Bitmap Graphics
Fast image rotation in Collabora Online 22.05
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.
Dynamic Configuration of Multiple Hosts
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. It is also 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 hosting companies. We have summarized the technical background information on Multihost Configuration inside our SDK documentation.
LibreOffice Technology
CODE and Collabora Online are built with LibreOffice Technology by the LibreOffice community in which we love to participate. We cannot thank everyone involved enough for their passionate work.
About CODE
CODE is the Collabora Online Development Edition. It contains the latest developments and is perfect for home users. It enables them to regain control of their own online documents and to host them themselves in a secure and private environment. For tech-enthusiasts, it is a low-threshold way to get involved and familiar with our online office solution. CODE will be improved continuously and our next supported and maintained Collabora Online product will be built from it. The code is available on GitHub.
Before we conclude with some final improvements and news, we really want to let you know about all the people that did the hard work. Thanks to the community that made this release possible! Collabora has invested significantly in bringing a host of new features and functionality to this latest release, and accounts for the overwhelming volume of contributions. However, we want to acknowledge all of our friends and colleagues who helped to contribute not only to this, but also to the underlying LibreOffice technology. All of our code is open source, and available to the public on GitHub. Would you like to be part of the Collabora Online success story? Check the new website for Online with information, easy hacks and a forum for Online, report issues, and participate today!
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
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!
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.
