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!

Updated Collabora Online – version 4.2.1 – available now

First update of major release Collabora Online 4.2

After a lot of encouraging feedback we received on the major 4.2.0 Online release, we’re happy to now announce the first update!

New Features

  • Context menu option to put a shape or image to the background of text on Writer. (Wrap → Wrap Through + In Background, Arrange → To Background and To Foreground)

Shape moved to the background of a Writer document. Click on the image to start animation!
  • Writer documents can be exported to EPUB format. Use File > Download as > EPUB (.epub)
    This uses the default similar to File > Export As > Export Directly As EPUB in LibreOffice / Collabora Office.

Export as EPUB in Collabora Online!

Improved features

  • Consistent Calc formula bar focusing in all cases

  • Possibility to easily navigate across wide merged cells in Calc

  • You can use Table of Contents links in Writer document

  • Updated translations

Fixes

  • In some cases the font dropdown contained only 2 fonts instead of all fonts installed. This has been fixed

  • Search bar did not accept letter ‘r’. This has been fixed

  • Fixed slide reordering by drag-and-drop in Impress

  • Fixed printing in Internet Explorer 11

  • Collabora Online never supported opening .oxt files (LibreOffice extensions) and .odb files (LibreOffice database files). We removed these file types from WOPI discovery.xml

  • Fixed the z-index of some pop-up dialogs, e.g. the warning to exceeded document/connection limit dialog is visible again

  • Fixed download action when server is running with no capabilities

  • On CentOS 8, Ubuntu 18.04, and Debian 10, which have OpenSSL 1.1.1, now we link loolwsd with Poco 1.10.1. That solves SSL connection issues, e.g. connecting to sites that have certificates made with elliptic curve key
  • On some systems the “child-root” jails were not cleaned up after use. This has been fixed

 

4.2.0 information

Since this version is an update. you may be interested in the information on the major release 4.2.0.

 

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 @CollaboraOffice on Twitter.

Collabora Online 4.2.0

A perfect combination of functionality and privacy

Cambridge, United Kingdom, March 5, 2020Collabora Productivity, the driving force behind bringing LibreOffice to the cloud, is excited to announce a major new release of the enterprise-ready online suite Collabora Online 4.2.0. This release includes a fresh look, mobile improvements and better interoperability alongside new dialogs and functionality. Collabora Online enables users and enterprises to work on rich documents in the cloud and to collaborate effectively hosting their own services on-premise. Collabora Online is the perfect online document solution for organizations and services that want to choose digital sovereignty, respect for their users privacy and want to stay in control of their own documents and data.

 

 

A fresh clean look, feature rich side-bar, and much much more

This major update of Collabora Online comes with a fresh new user interface and is built on top of the stability and performance of our LTS version of LibreOffice: Collabora Office 6.2. This new Collabora Online includes many improvements in functionality and user-friendliness as well as a raft of bug fixes and polish. The most obvious new feature is the powerful sidebar, which allows users to easily change settings for text, tables, colours, charts and other objects in the documents. It gives Collabora Online almost the same feature- richness available in Collabora Office on the desktop. Furthermore there is a redesigned status bar, much-improved toolbars and a powerful function wizard now available in Calc online. Copy and paste of rich text and content is added for online functions, and our responsive user interface adapts attractively to smaller and mobile screen sizes.

Extending our great interoperability

Among the all improvements, there is also much improved interoperability with Microsoft Office files. Smart art, rotated and left-right text in tables, pivot tables, special sections and headers in text files, math and gradients in Powerpoint files and much more.

 

Collabora Online Logo

Rich chart functions from the sidebar

The sidebar now gives you access to a wide range of features for charts. Select the chart and it is easy to choose from chart types such as bars, lines and points, pies and more, and also whether the diagram should be displayed in 3D. The sidebar also provides other elements and details, for example titles and legends, colours, transparency, axes and grids. All you need for rich chart editing, is available in Collabora Online.

Collabora Online charts
Editing Charts in Collabora Online

Click to see it in action:

Click to see the chart sidebar in action

Magic in Calc online with a powerful function wizard for your formulae

If you work on formulae, especially  more complex formulae with many parameters, the function wizard in Calc is extremely helpful. It makes handling complex formulae as simple as possible by offering access to all elements of the structure and showing detailed explanation for the different arguments. This makes using the full set of hundreds of interoperable formulae easy!

Collabora Online function wizard
Powerful function wizard in Collabora Online spreadsheets

 

In excellent condition: Calc brings full conditional formatting

Conditional formatting is a very effective way to understand and visualize your data: you can choose what formatting or icons your cells will receive for certain values.
Collabora Online already offered a limited palette of conditional formats in the tool bar, but the new version of Collabora Online now gives you access to the full set of possibilities by displaying the dialogs for the feature. All you need for creating and adapting conditional formatting is now available in Collabora Online.

Collabora Online conditional formatting
Collabora Online offers full conditional formatting features

Smooth zooming in Calc: scaling of spreadsheets improves significantly

The scaling of spreadsheets sees a major improvement in Collabora Online 4.2.0. While previously  (as in other products) the choice was 100% or 200%, now you can select a zoom level that best suits you. This improvement is accessible with a comfortable quick selector in the lower right corner.

 

Proudly presenting the cool and handy Impress sidebar

Collabora Online now brings you lots of new functionality via the new sidebar in Impress. You can adjust character settings, font-types, objects, sizes, colours, spacing and more from the sidebar. In addition changing the slide layout and even choosing and editing Master Slides is also possible. This provides unprecedented functionality for online editing and is very convenient! All you need to use and edit presentations is available in Collabora Online.

 

The sidebar in Collabora Online offers users great control for presentations

A fantastic image: working with pictures is easier and more precise

Images are fun, and working with them across all types of documents has been massively improved in Collabora Online 4.2.0. Rotating is easy with the clear handles and the new sidebar allows you to adjust colours, brightness, contrast and transparency.  You can also use the sidebar module to arrange the foreground or background positioning of your images.

 

Paste how you like: rich copy/paste features between different documents

When doing work online, you frequently have multiple documents open that need to be combined via copy and paste. In the browser, however, rich copy and paste features are far from trivial. Now the great news is that Collabora Online introduces copying and pasting of rich formatted content like images, charts, and other complex elements across different types of document. Almost all you can wish for working in multiple documents, is now available in Collabora Online.

Rich copy and paste in calc

Enhanced online colour picker

Selecting your desired colour for an object is much more convenient in Collabora Online 4.2.0. In addition to the usual colour selector offering a palette, a new colour picker to choose any custom colour is now available. Use it with text and background in presentations, lines in spreadsheets and presentations, text and background for floating frames in text documents.

Improved collaborative editing with clear links in text documents

Launching links in previous versions required a control-click, which was hard to discover. In Collabora Online 4.2.0, when you collaborate on a document and you want to know the destination of a link, then our new release shows it at a glance. If the mouse cursor is over a link, you will see a pop-up displaying the links target. The pop-up also allows you to see and access the destination with a single click.

Redesigned and clear new icons and a attractive theme

The new design of the icons embellishes the upper toolbar. The new theme is tidier, generally clearer and has more generous spacing, with more distinct highlighting of selected buttons. All of this increases productivity and reduces friction.

New buttons and theming make things more attractive and easier to work with

The status bar benefits from our visual redesign too. Not only does it look cleaner, it also improves quick access to more functions. For example, the language in documents can now also be set via a pop-up.

Table editing: faster with the sidebar and in-document handles

In Collabora Online Writer it is now possible to manipulate tables extensively from the sidebar and we have also added easy-to-use in-document selection handles that make adjusting row height and column width very user-friendly. These features are a convenient extension of the table dialogue, that still also offer access to the tiniest details.

Collabora Online tables
Collabora Online Tables in text documents

You want to insert rows or columns from here? Of course! Or delete some or all of them? A click! Furthermore, the sidebar also allows you to set the background colour, to fine-tune the sizes of rows and columns, as well as merging cells or distributing them evenly. Really all you would wish for if you are working with tables, is available in Collabora Online.

Table of contents

Collabora Online now allows you to configure the full table of contents in text documents, thanks to the new Table of Contents dialog. So even online, you can customize your complex table of contents in a few clicks according to your wishes. For example, you can edit the entries and change style, background or columns. In the same way you can update indices of figures, tables and so forth. This brings the full power of rich table of contents and index creation to Collabora Online.

Collabora Online table of contents
Collabora Online offers rich table of contents for text document

Get Collabora Online 4.2

Collabora Online 4.2.0 is our first release of our next development series, 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.
(Customers can find the URL for the repository in the customer portal.)
Collabora Online integrates flawlessly into Nextcloud, ownCloud, Seafile, and many of the major file sync & share, groupware and hosting solutions. It is ideal for organizations that want to collaborate on documents without losing control over them or compromising on privacy. With the ability to host it on your own hardware or to integrate it into a trusted environment, Collabora Online is the ideal online office suite for digital sovereignty. Enterprises interested in using Collabora Online can check out our home page for more information on partner integrations and online demos. Hosting and Cloud businesses that wish to add Collabora Online to their product portfolio can become a partner. For any questions or tailored solutions, do not hesitate to contact sales@collaboraoffice.com.

Get access to the online demo of Collabora Online 4.2.0 and discover its potential!

 

 

 


Thanks to the community!

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 document technology, you can checkout LibreOffice community credits. We cannot thank everyone involved enough for their passionate work. All of our code is contributed to LibreOffice, and can be expected in LibreOffice 7, although we have our own branding and theme. Would you like to be part of the story ? Get involved today!

 

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 @CollaboraOffice on Twitter.

CODE 4.2.0 Released with fresh User Interface

Clean look, feature rich Side Bar, and much more

Cambridge, United Kingdom, December 16, 2019Collabora Productivity, the driving force behind bringing LibreOffice to the cloud, is excited to announce a new, major release of our product CODE (Collabora Online Development Edition) 4.2.0 This release includes a fresh look, mobile improvements, improved inter-operability, new dialogs and functionality as well as a raft of bug fixes and polish. The release gives you an insight into our soon-to-be released enterprise version Collabora Online 4.2.0. CODE and Collabora Online offer privacy as well as the only truly open-source solution for working with and collaborating on rich documents in the cloud.

CODE logo

What’s new?

This major update of Collabora Online Development Edition (CODE) comes with a rich new user interface and is built onto of the stability and performance of our LTS version of LibreOffice: Collabora Office 6.2. It includes many improvements in functionality and user-friendliness. The most obvious new feature is the powerful sidebar on the right. Many settings for text and all kind of properties of objects in the documents can be easily updated here. The sidebar makes it much easier to change tables, colour settings and charts elements in the browser, with close to the same feature richness that is available in Collabora Office on the desktop. The status bar has been redesigned and our powerful function wizard is now available in Calc online. Copy and paste of rich text and content is added for online, and our responsive user interface adapts nicely to mobile phones and tablets.

Rich chart functions from the side bar

When charts are selected, the sidebar now gives access to a wide range of features. For example, you can easily choose chart types from bars, lines and points, pies and more, or whether the diagram should be displayed in 3D.

Other elements of charts can now also be adjusted from the sidebar. You can now determine how and where titles and legends are displayed. Furthermore, many of the visual elements of the diagram can be adjusted here. The sidebar also allows you to define the surface colour, transparency, line types and grid lines.

Click to see that in action:

Click to see the chart sidebar in action

Online function wizard: a powerful tool for formulas

Working with formulas is important and especially for the more complex types, having help with the tenth optional parameter is good. The new function wizard does that and it is new available in Calc from now on. The function wizard grants easy access to all elements of also the most complex formulas. It shows the structure and meaning of different parts of a formula, and more.

Conditions apply: Enhanced formatting options in Calc

Conditional formatting is a powerful feature in Calc. It is enables you to quickly visualize data in a spreadsheet by setting various useful rules on your sheet to adapt the cells formatting, colour, or even add icons when certain criteria are met. While a simplified set of conditional formats was previously available via an icon in the toolbar, you can now also make use of the full dialogs, to be found in the Format menu, to define and manage conditions fully.

Better display in Calc: smooth scaling of spreadsheets

The scaling of spreadsheets has been significantly improved in CODE 4.2.0. While in Calc you could previously only choose between two zoom factors of 100% and 200%, now fine adjustment is are possible to suit. Using the convenient (and redesigned) quick selector in the lower right corner, you can now choose your favourite zoom percentage between 33% and 200%.

More presentation functions in the sidebar

The new sidebar adds many useful functions to Impress. For shapes and outlines, the size, position, colours, transparency, wrapping and so on are easy to change.

The possibilities to alter the slide master and lay out, from the sidebar, are also completely new in CODE 4.2. You can now access extensive layout functionality for slides such selecting masters, layouts and even editing your own master pages. Needless to say, that character settings, fonts types, sizes, colours and spacing can also be easily adjusted from the sidebar.

Handier working with images

Working with images in all document types is easier, more convenient and more precise. The sidebar allows to adjust colour options, such as brightness, contrast or transparency or the red, blue and green portion of the image. Another handy feature is the adjustment of the layer settings of the images. Bring them to the foreground or arrange them in the background – all via the sidebar.

Rich copy and paste between docx and xlsx documents and more… in the browser

People that work online, often have many documents open simultaneously, and want to mash them together into bigger, better documents. So you’ll be glad to learn the CODE 4.2.0 introduces copying of rich formatted content along with images, charts, and other complex elements, between your online spreadsheets, documents and presentations.

New online colour picker

For certain elements there is not only the usual colour selector, offering a palette, but also the colour picker to chose any custom colours needed. Use it with text and background in presentations, lines in spreadsheets and presentations, text and background for floating frames in text documents.

Handling links in Writer has just become more pleasant

CODE 4.2.0 brings very nice enhancements when working with hyperlinks. Whenever the mouse cursor is located next to a link or on it, you will be kindly notified by a pop-up dialogue allowing the real target to be inspected and launched conveniently with a single click.

Beautiful new icons and a redesigned theme

The new design of the icons embellishes the upper toolbar. The new theme is tidier has more generous spacing, and is clearer in general. It should increase productivity and reduce friction. Buttons that are selected have a clearer and more distinct highlight too.

The status bar also benefits from our visual redesign. Not only does it look cleaner, it also improves quick access to the functions located there. The language of documents can now also be set via a popup.

Table editing in the side bar and table handles

In Writer it is now possible to manipulate tables extensively from the sidebar and we also added easy to use in-document selection handles, choose either or both. Previously the table dialog had to be used, which was far less convenient. These handles make adjusting row height and column width very user-friendly.

You want to insert rows or columns from here? Of course! Or delete some or all of them? a click! Furthermore, the sidebar also allows you to set the background colour of the cells or to fine-tune their height and width of rows and columns. It becomes even more interesting if you select several cells. Then you can also merge them from the sidebar or distribute them evenly.

 

Table of contents

In text documents, the full table of contents can now be configured with the new dialogs. So even online, you can customize your complex table of contents in a few clicks according to your wishes. For example edit the entries and change style, background or columns.

About CODE

CODE is the Collabora Online Development Edition. It contains the latest developments and is perfect for home users that want to start to run their own online office suite. It enables them to regain control of their own online documents and host them themselves in their own controlled and private environment. For them and also for tech-enthusiast, it is a low-threshold way to get involved and familiar with our online office solution. CODE gives the possibility to be the first to use new features. It will be improved continuously and our next enterprise Collabora Online product will be built from it. Note that we recommend our supported and maintained enterprise release: Collabora Online for business and production environments. CODE warns users that they might want support after 10 concurrent documents or 20 concurrent users. Find out how about the different ways to install CODE on our product page.

Get CODE 4.2.0!