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.
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 .
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.
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.
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.
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.
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.
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
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.
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.
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!
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.
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 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.
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.
Three full days dedicated to LibreOffice technology
The LibreOffice Conference 2020, this year also known as oSLO 2020, took place from 15 to 17 October 2020 as a joint online event with openSUSE. The number of participants at the online conference was roughly the same as at an on-site event. A total of over 320 participants had registered on the conference platform. Individual talks were attended by up to 150 people simultaneously. The LibreOffice community in Latin America had organized an additional track in Spanish and Portuguese. Our team contributed 16 talks (find the complete list here). Enjoy some recorded recordings, download the slides and feel free to ask further questions in our forum.
Collabora & the LibreOffice Ecosystem
Some much-acclaimed topics were the lectures by Michael Meeks, which highlighted the exciting and long-standing history of LibreOffice, and those that dealt with the relationship between profit-oriented companies and the voluntary community—and pointed out possible perspectives.
This year’s talks on Collabora Online had a strong focus on improving the user experience. Ashod Nakashian talked about the challenges of integrating Sidebars into Online, while Szymon Kłos explained the path to the NotebookBar, the new optional user interface. Tomaž Vajngerl showed the great new features for PDF files. Pedro Silva held a presentation on visual consistency, user experience, as well as possibilities for customization. He also showed how to join the project. Slides of his talk are also available in Portuguese (as part of the Latin-American Track). Muhammet Kara‘s presentation highlighted the new one-click option, that makes installing Collabora Online by home users much easier.
LibreOffice & Collabora Office
These talks dealt with new functions added to LibreOffice by the Collabora team. This includes the extensive work with the SKIA graphics library, presented by Luboš Luňák, and the digital signing of files in PDF and OOXML, showcased by Miklos Vanja. Collabora Office is now also available on Chrome OS. Jan Holesovsky outlined what it took to port the Android app to Chromebooks.
Collabora Office on Android & iOS
Our mobile apps are a lot of attention. Their huge success recently added 500K users to the LibreOffice user base. Szymon Kłos presented technical details how the LibreOffice Sidebar get re-used on phones. Tor Lillqvist focused, on the latest developments for Collabora Office on iOS, while Jan Holesovsky presented the history of online and mobile.
Living on video?
Missed the conference? Would you like to watch or re-watch some talks? The sessions at the openSUSE & LibreOffice Conference have been recorded and are going to be published. We have a playlist collecting all the talks held by our developers. Find it here on YouTube. We are continuously adding the all published oSLO2020 talks there. In the meantime, please subscribe to our YouTube channel to not miss any updates from us.
The updated release of Collabora Office for Android and iOS now supports opening password protected documents and is available for F-Droid. Thus the open source app running on your mobile devices – mind that ChromeOS is supported too – is again gaining in both features and user support.
Opening password protected documents
Just click on the document you’d like to open. In case it is a password-protected document Collabora Office will display the field for the password entry. Needless to say that this naturally works for text documents, spreadsheets and presentations alike, be it DOCX, XLSX, PPTX, ODT, ODS, ODP,or ..
Now available for F-Droid!
Regularly users have asked us about the availability of Collabora Office for F-Droid, the community driven platform focusing on free and open source apps for Android. And now it’s here! Currently we provide two versions: the 4.2.x release – already longer existing, and the snapshot of the unstable 6.4 line. With the latter you can help us test the latest and greatest features! Something we really appreciate, so do contact us 🙂 !
However.. searching in the F-Droid site app list, you will not find it; first you will have to add the repo. Of course the F-Droid community provides a simple and clear HowTo.
In short: you need to add the following third party repository: https://www.collaboraoffice.com/downloads/fdroid/repo/ (see the QR-code below).
Collabora Office is the first fully functional mobile document editor for F-Droid. Thanks to the F-Droid community for helping to make this possible. Shortly we’ll publish a post adding more details to the story and possibly addressing some questions too.
Where to get the new Collabora Office for mobile?
Just install or update your Collabora Office app from the Play Store or App Store. And for F-Droid, see the info just above here!
From Thursday, 15th to Saturday 18th 2020 the openSUSE & LibreOffice Conference takes place as a virtual and joint event. We are glad to be one of the sponsors and to be able to contribute no less than 14 talks from our team members. To make it easier for you to keep track of all the topics, we have prepared a little overview of our talks. See you in the livestream!
Accelerating the adoption of Open Source! How does Collabora do that together with their partners and customers? About another year of investment into LibreOffice alongside the community, the ecosystem and our choices. #Collabora #EcosystemRead more!
Bringing the Sidebars Online
12:30 UTC, Ashod Nakashian
Adding the Sidebars, with the rich and advanced editing features, to Online was challenging. Learn, how we succeeded! #OnlineUIRead more!
Bringing the NotebookBar to Online
13:30 UTC, Szymon Kłos
The story behind introducing new (optional) user interface for Online. Learn about the milestones of this new feature sponsored by Collabora. #OnlineUIRead more!
Implementing Vulkan-capable drawing using the Skia library
14:00 UTC, Luboš Luňák
Skia is a unified modern drawing across all platforms, so this is about the nice visual performance of LibreOffice and Collabora products. How is the implementation going? #LibreOfficeDevRead more!
Making Online trivial to setup
15:30 UTC, Muhammet Kara
We have recently released a big step in improving Collabora (thus LibreOffice) Online and lowered the barrier to liberating the documents of home-users. This is a quick presentation shows how the one-click installation app for Online works, and where we are at now. #OnlineInstallationRead more!
Day 2, Friday 16th 2020
Faster Jail Creation with Bind-Mount
11:00 UTC, Ashod Nakashian
A jail is an essential part of the secure work and collaborating in Collabora Online. Learn about the design and challenges of setting up jails… fast! #OnlineDevRead more!
OOXML / PDF Digital Signing in Draw and elsewhere
11:30 UTC, Miklos Vajna
LibreOffice did have support for digital signing for ODF files. Collabora extended this to OOXML files and to signing existing PDF files. Come and see where we are, what still needs to be done, and how you can help. #DigitalSigningRead more!
Come and hear some of the stories of the beginning, and before the beginning. Hear a developer’s perspective on the first ten years of the project and how companies had to do with this, alongside amazing volunteers. #LibreOfficeRead more!
Chrome OS as a new platform
16:00 UTC, Jan Holesovsky
Hear about the Chrome OS and the work we have made to enable the Collabora Office Android app for easy consumption on Chromebooks. #MobileRead more!
Improvements to PDF support in Collabora Online
18:00 UTC, Tomaž Vajngerl
Recently we added possibility to open PDFs with Collabora Online, which opens the PDF in Draw as a series of embedded PDF graphics (each one in its own page). In this talk, hear about additional improvements to the PDF functionality – like searching and handling of PDF annotations. #PDFRead more!
Day 3, Saturday 17th 2020
History of Online & Mobile
12:00 UTC, Jan Holesovsky
Come and hear about the history of Collabora Online, LibreOfficeKit, Leaflet and other building bits that led to the Online as we know today. #MobileRead more!
Re-using the Sidebar on phones
12:30 UTC, Szymon Kłos
The talk about work done by Collabora Productivity for improving UX on mobile phones. Editing on smartphones has never been easier. Hear some technical details in this talk. #Mobile #OnlineUIRead more!
in PT/ES. For users it is most important that UI elements are easy to recognize. Hear about improvements that have been made on that front in Collabora Online. #OnlineUI #CSSLeia mais!
How to become a part of this
Very easily. The attendance openSUSE and LibreOffice conference 2020 is free of charge. Just subscribe to the conference website, meet the community and join three days of discussion about the latest developments with regard to LibreOffice and openSUSE. The complete schedule of the virtual conference is here at your disposal.