Powerful spreadsheet features arrive for tablets

 

Pivot Tables, Managing Names and Statistical Tools and more available for tablets in Collabora Office 6.4.3

Version 6.4.3 brings features for working with spreadsheets on Android tablets of iPads. You can now insert or edit Pivot Tables, Define and Manage Names and use and use the powerful Collabora Office Statistical Tools. Writer gains the ability to Insert Bookmarks and Reference Fields. Please be aware, that these new features can currently not be accessed through the UI on phones. However, many UI and UX improvements have been implemented in this version, making the apps both easier to use and fun to work with. Find a description of the new Calc features in our earlier released Collabora Online 6.4.3 announcement.

 

Staged releases on Android devices

Since the upgrade to the new major branch Collabora Office 6.4 for mobile, we moved to a staggered release schedule. This means that new versions are made available to users gradually. Version updates will be rolled-out to users in sequential waves, so some will see version 6.4.3 sooner than others.

 

Available on Chromebooks

Together with the update of our mobile apps version 6.4.3 of Collabora Office is now also available for Chrome OS. Users of Chromebooks are entitled to all the above mentioned features. Since Collabora Office for Chrome OS is distributed via the Play Store, it is also available as a staged release.

 

Download Collabora Office 6.4.3

Collabora Office is available through the Play Store and App Store. We also provide the latest .apk for Android! Collabora Office is also available on F-Droid via a third-party repository to add.

 

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 .

 

Read More

Important new spreadsheet features and many other improvements in Collabora Online 6.4.3

Pivot Tables, Managing Names and Statistical Tools – new in Collabora Online 6.4.3

Version 6.4.3 brings powerful features to Calc online. You can now insert or edit Pivot Tables, and can now Define and Manage Names and use new Statistical Tools in spreadsheets. AutoFilter works more smoothly as well. Writer gains the ability to Insert Bookmarks and Reference Fields and there are many improvements to make Collabora Online better looking, easier to use and to offer more functionality. The full overview is in the release notes page.

Using Pivot Tables in Collabora Online

Pivot Tables are a flexible and powerful analysis tool for mixed data sets. The Pivot Table icon on the Data tab starts the wizard to create a Pivot Table in three steps. Editing the lay out of an existing Pivot Table, can be started with the same button. To create a new Pivot Table, do the following:

    1. Select the source (use the current selection or define one)
    2. Define the layout by dragging the available fields to the desired part of the Pivot Table
    3. Make final adjustments like defining the destination (new tab, or a position on the current one) of the Pivot Table and other options.

 

Select the data source for the Pivot Table
Step 1: Select the data source for the Pivot Table
Defining a Pivot Table layout in Collabora Online
Step 2: Drag and drop the available fields to define the layout of the Pivot Table
Pivot Table wizard in Collabora Online
Step 3: Make final (optinal) adjustments, like e. g. destination of the Pivot Table
Filtering data and adjusting the finest details to get the perfect result, with a rich set of sub-dialogs familiar from the desktop!

 

Defining and managing Range Names in Calc Online

Define Names allows you to specify easy to use names for selected areas. Access this function via the Data tab in Calc. Once one or more ranges are defined, they can be managed through the Manage Names function. While calculation in Online always used these names, the ability to manage them online is very convenient.

Defining range names in Collabora Online
Manage range names in Collabora Online
Mind that via the Options in Define Names, you can also define a Print Range. Print ranges are essential to configure and print useful PDF documents from a spreadsheet focused on the areas of greatest interest. Another great win in this new Collabora Online version!

 

 New look of AutoFilter in Collabora Online

The AutoFilter feature has been redesigned and is now using natively themed dialogs. It generates a rich combo box on the data columns of a range, that allows you select the data to be displayed and as well start the dialog for the even more flexible Standard Filter dialog.

 

Statistical tools for data analysis

Calc offers more than a dozen powerful statistical tools. Those are now available in Collabora Online via tab Data, tab. For statistical analysis you can access:

  • Sampling
  • Descriptive Statistics
  • Analysis of Variance (ANOVA)
  • Correlation
  • Covariance
  • Exponential Smoothing
  • Moving Average
  • Regression
  • Paired t-test
  • F-test
  • Z-test
  • Chi-square Test

A more detailed description about the statistical tools is available in the Collabora Online documentation. The Fourier Analysis can also be found inside the Statistics menu.

 

Improved document jail performance

Then there is an important improvement in performance for some users in Collabora Online 6.4.3. The details are rather technical. Collabora Online isolates each document into a secure jail. This is done by falling back through a series of options to ensure performance and security. The fastest approach (tried first) is bind-mounting, after which Collabora Online tries to use capabilities like cap_fowner to hard-link system files in. Unfortunately, in the 6.4.x series an intersection with systemd namespaces crippled this hard-linking optimization. In 6.4.3 this is now solved by copying files out of the system to a place that can safely and quickly hard-linked so then they can be shared. This is far faster than the ultimate fallback: raw copying of the data. The developers further accelerated the raw copying case by avoiding copying dictionaries too. For some systems this should give a significant performance win for document thumbnailing and load times, we also warn when hitting this slowest code-path too.

 

More new features in Collabora Online 6.4.3

Collabora Online is in permanent development, steadily introducing safe new features into our stable releases and constantly improving interoperability and user experience. Please check-out our release notes to find out about the latest features and improvements. Would you like to test the latest version with all new features? Then simply request a free demo!

 

 

How to access the new features in the classic UI

The new icons are only available in the new NotebookBar UI. However, if you are using the classic UI you will also be able to access the Pivot Table, AutoFilter, Define Name & Manage Names via the Data tab. On mouseover, a dropdown menu will give you access to the features.

All features available in a single menu in the classic UI

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 .

 

Read More

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!

Read More