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

Collabora Online Community Roundup #8

On October 1st, Collabora Online moved to its new home on GitHub, and started settling in the new infrastructure, expanding its fantastic community, and continuing the work to deliver the latest and greatest developments in productivity and collaboration together. Check our new community website for all the details! 😉

Collabora developers also keep fixing and improving our lovely mother project LibreOffice. As all the good work requires some appreciation, let’s take a look at what the seasoned developers of the Collabora team and the volunteer contributors from our community have been doing during the last week.

Week in Numbers

On the Collabora Online code repository in the last week, 19 authors have pushed 77 commits to master and 156 commits to all branches. On master, 164 files have changed and there have been 15,979 additions and 12,825 deletions.

Screenshot of GitHub Pulse for Collabora Online
Development Activity on Collabora Online GitHub Repository from November 27, 2020 to December 04, 2020

New Contributors

Congratulations to Lawrence D’Anna, Triopsi, baffclan, Jairo Llopis for reporting their first issues and improvement requests on our GitHub repository!

  • Thanks to Lawrence D’Anna for letting us know about an issue with zoom levels on macOS Big Sur.
  • Thanks to Triopsi for reporting an issue about permissions in the COOL docker image.
  • Thanks to baffclan for opening an enhancement request for the iOS app to enhance the UX by adding an about dialog to the main menu.
  • Thanks to Jairo Llopis for letting us know about the lack of mouse support on tablets with DeX mode.

Thank you all, and welcome aboard! 🙂

Join the fun!

You can also join the fun, and be part of our next list of new contributors! 🙂

Just go to our GitHub repo, fork it, build it (on Linux or on any platform), grab one of our newcomer-friendly easy hacks, and send your first pull request. And if you get stuck at any point, just drop by one of our communication channels. 😉

Highlights

Collabora Online Weekly Meeting #4

COOL Weekly Meeting #4 has taken place on Thursday, December 03, 2020 at 11:00:00 am (UTC) with participants both from the community contributors and the Collabora team. We have got a quick update on what’s going on and discussed matters raised by the contributors, as well as having the chance to say hi to fellow members of the community. Topics discussed in the meeting include:

  • During the quick update part by Muhammet Kara, it’s been reported that COOL has got 41 new contributors (20+ code contributors) since the move to GitHub.
  • Toolbar changes (by Andreas Kainz) now has a new issue opened for UI changes which is waiting for review from Pedro Silva. Then new pieces of change will be pushed to master based on feedback.

    Ellipsis button proposed to provide a way of opening related dialogs directly from toolbars
  • Contextual toolbars (by Andreas Kainz) also got a new issue for communication and tracking the progress. It has been reported that JavaScript file looks more complicated than the file for the menu bar, and it is proposed to be chopped into smaller pieces to reduce complexity.
  • On the topic of Dynamic Changes of Toolbar Type (by Gabriel Masei), the results of the initial experimentation has been shared, and further options such as making use of a per-user option on the core side for toolbar preference have been discussed. Gabriel Masei will continue working on the topic with the help of Szymon Szymon Kłos, and discussing certain options with Jan Holesovsky. Miklos Vajna has also shared a nice blog post on effective code review and backporting for Collabora Online.
  • Gökay Şatır shared an update on his work of CanvasTileLayer which means a better look with crisp pixels at every zoom level. It’s been reported that Writer and Impress are the latest winners who got some improvements on this. It will also be backported to the 6.4.x series.
  • Pedro Silva and Andreas Kainz shared updates and discussed the next steps regarding the CSS class names step of the icon theming topic. It’s been decided that details will be discussed on a separate call involving the related parties.
  • It’s been reported that Impress got some recent speedup improvements by Mert Tümer (Impress tile rendering and watermarks) and Tomaž Vajngerl (PDF rendering).
  • Szymon Kłos has shared updates on his work around auto-filters and pivot table dialogs, which are still work in progress.
  • Andreas Kainz proposed a coherent approach to maintain user interfaces of COOL, and it has been discussed from different angles. Details of the discussion can be found in the minutes of the meeting.
  • Nicolas Christener shared an update on his work to prepare a blog post about the iOS app upgrade and provided a link to preview the draft.
  • It’s been mentioned that now everything -PC, Online, mobile, etc.- are all on the same 6.4.x base, which makes it easier to coherently maintain all for the developers, and easier to follow for the deployers and the users alike.

Check out the meeting minutes for the details of the meeting, make your own suggestions for the next meeting, and join us on Thursday, December 10, 2020, at 11:00 am (UTC) to stay in touch with the rest of the community. We’re looking forward to hearing from you live. 😉

Collabora Online (COOL)

  • Thanks to Henry Castro for fixing[0][1] an issue which caused a Writer document to partially fall outside the visible area after certain operations like zoom in and zoom out, and also for doing some under-the-hood improvements on our build system.
  • Thanks to Szymon Kłos for various improvements and fixes on the notebookbar and various dialogs such as the pivot table dialog, turning them into native widgets for COOL, thus allowing a more natural look & feel along with less clutter and possibly better user experience.
  • Thanks to Jan Holesovsky for improving the performance of change tracking by removing some unnecessary checks and iterations, and also for making sure the correct document is used while copying and moving around Calc’s sheet tabs.
  • Thanks to Ashod Nakashian for various fixes and improvements towards increasing general stability of COOL and maintainability of the code-base along with tests to make our code-base future-proof, and also for reviewing pull requests of other contributors, and for mentoring them through tough issues.
  • Thanks to Tamás Zolnai for a lot of fixes and improvements around cypress (testing framework), and the testing facilities for certain integrations, thus helping COOL have an even better automated quality assurance process, and also for mentoring other contributors while writing new cypress tests.
  • Thanks to Thaís Vieira for adding cypress tests to ensure the quality of Collabora Online on various toolbar items of Impress, such as font color and highlight color.
  • Thanks to Pedro Silva for various fixes and improvements around the user interface of COOL to make it have a better and consistent look and feel across different platforms.
  • Thanks to Andras Timar for various fixes and improvements around our docker images and documentation as well as for cleaning up the code-base by removing some unnecessary bits and updating localizations.

    With the Collabora Online Development Edition (CODE) Docker Image you can host your own online Office Suite at home!
  • Thanks to Pranam Lashkari for various user interface and user experience fixes and improvements such as making sure menu entries are not overlapped by the menu bar, and adding new easy ways to arrange Calc sheets through commands move sheet left and move sheet right as well as the move/copy dialog on the desktop browsers.
  • Thanks to Michael Meeks for helping COOL have a less-cluttered code-base and potentially perform better by removing obsolete locking and conditions around MessageQueue.
  • Thanks to Mert Tümer for various performance fixes and improvements especially around watermarks and PDF handling.
  • Thanks to Miklos Vajna for improving the performance and stability of COOL by fixing an issue that caused certain text documents with tables to trigger a continuous loop of tile requests, as well as various other fixes and improvements such as adding a subcommand to our g script to easily backport all commits of a pull request, thus making lives of contributors a bit easier.
  • Thanks to Rashesh Padia for adding a message box to the admin console to indicate when the server is shut down, thus improving UX for the administrators.

Collabora Office on Android & iOS

  • Thanks to Tor Lillqvist for various fixes and improvements on the iOS app such as making sure emojis work properly.

    Using the Emoji keyboard on the Collabora Office iOS app
  • Thanks to Yunusemre Şentürk for updating the target SDK version for Android app from 28 to 29, thus helping it keep up with the current technology.

Collabora Online Integrations

  • Thanks to Julius Härtl for improving domain configuration and handling of Collabora Online’s Nextcloud integration, along with various other improvements under-the-hood.
  • Thanks to Szymon Kłos for improving the user experience of built-in CODE support of Collabora Online’s Nextcloud integration by making sure the timeout is long enough for the server to start and proper checks are in place for it.
  • Thanks to Jan Ackermann for helping Collabora Online’s ownCloud integration provide a better user experience and be future-proof by updating the context menu entry “Edit” as “Open with Collabora”, and replacing a deprecated function call with its modern alternative.
  • Thanks to Thomas Müller for updating translations of Collabora Online’s ownCloud integration thus helping it to have better support for different languages.
  • Thanks to Andreas Grabs for improving the user interface and experience of Collabora Online’s Moodle integration by fixing iframe height to make sure COOL status bar is shown properly.

Honorable Mentions

  • Thanks to Cor Nouws for leading the marketing team, and not stopping there but continuing with testing & reporting bugs, attending to community events, and keeping us all informed about what’s going on. He also attends LibreOffice Design meetings from time to time to help COOL’s mother project LibreOffice have a better UI & UX.
  • Thanks to Eloy Crespo for his efforts to help the project well-funded as always.
  • Thanks to Marc Rodrigues for continuing to keep us updated on various news around Collabora Online and related FOSS projects, and creating a lot of yummy content to read!
  • Thanks to Pedro Silva for improving various points around the COOL Community Page, and also for helping other contributors by providing instructions on their pull requests as well as reviewing them.
  • Thanks to Andras Timar for keeping us organized, maintaining our translation project on Weblate, and delivering hot new releases of our software!
  • Thanks to Yunusemre Şentürk for various tasks towards keeping our CI chains healthy.
  • Thanks to Jan Holesovsky for doing a lot of research on different topics, and providing mentoring/patch-reviewing/hand-holding/wisdom within the team, in our communication channels, and also on various channels of our lovely mother project LibreOffice.
  • Your friendly community mentor, Muhammet Kara, is also creating & improving easy hacks, running workshops, helping new contributors solving their setup & build issues and reviewing their pull requests, working on easing the build procedure, improving our GitHub presence bit by bit based on its community guidelines, compiling/composing these community updates…

Translators

Last but not least, we can’t thank enough to our translators who constantly help COOL and its friends talk many languages on this earth. Collabora Online speaks many languages, thanks to all of our translators in our translation project, and all of those who previously contributed and keeps contributing to our mother project, LibreOffice.

We’re continuing to work to find good ways to credit translators’ hard work in the product. Please see a list of those involved, and please get in touch if you’re not listed. Many thanks to all those who have worked on translating Online, you rock!

If you would like to help COOL speak your language, you can just go to our translation project on weblate, and start contributing! 😉

Collabora Online translation project on Weblate
Collabora Online translation project on Weblate

Collabora loves LibreOffice!

We’re still contributing to LibreOffice and encourage you too to do so because LibreOffice rocks. 😉

  • Thanks to Gülşah Köse for making sure dotted lines in PPTX files don’t disappear during presentations, thus improving interoperability with other office suites.
  • Thanks to Tor Lillqvist for fixing the Firebird build on macOS on arm64, thus ensuring macOS users on certain platforms will be able to get better support for using databases with LibreOffice.
  • Thanks to Tomaž Vajngerl for fixing an issue that caused certain PDF files with a lot of graphics to use an excessive amount of disk space for caching, thus improving overall stability and performance of LibreOffice while working with PDF files.
  • Thanks to Noel Grandin for doing various code-quality improvements and modernization all around the LibreOffice code-base.
  • Thanks to Miklos Vajna for his work towards better handling of cached field results in Writer, thus potentially improving the performance and user experience of LibreOffice. Check out his blog post for the whole story!
    Old, broken render result in Writer

    New render result in Writer

Read More

Collabora Online Community Roundup #7

On October 1st, Collabora Online moved to its new home on GitHub, and started settling in the new infrastructure, expanding its fantastic community, and continuing the work to deliver the latest and greatest developments in productivity and collaboration together. Check our new community website for all the details! 😉

Collabora developers also keep fixing and improving our lovely mother project LibreOffice. As all the good work requires some appreciation, let’s take a look at what the seasoned developers of the Collabora team and the volunteer contributors from our community have been doing during the last week.

Week in Numbers

On the Collabora Online code repository in the last week, 29 authors have pushed 102 commits to master and 193 commits to all branches. On master, 150 files have changed and there have been 2,357 additions and 1,480 deletions.

Screenshot of GitHub Pulse for Collabora Online
Development Activity on Collabora Online GitHub Repository from November 13, 2020 to November 20, 2020

New Contributors

Congratulations to SaschaT667, JensTheCoder, BernhardGehl, accolon and Gabriel Filion for reporting their first issues and improvement requests on our GitHub repository!

  • Thanks to SaschaT667 for opening an enhancement request for adding editable and dynamically-calculated formulas support to Writer documents.
  • Thanks to JensTheCoder for reporting an issue about frozen lines in Calc documents.
  • Thanks to BernhardGehl for letting us know about some unexpected log messages from COOL, integrated with Nextcloud.
  • Thanks to accolon for reporting an issue about zoom factors of spreadsheets on macOS Big Sur.
  • Thanks to Gabriel Filion for reporting a bug which caused COOL packages for some distros to fail to start, and thanks to Andras Timar for fixing it quickly.

Thank you all, and welcome aboard! 🙂

Join the fun!

You can also join the fun, and be part of our next list of new contributors! 🙂

Just go to our GitHub repo, fork it, build it (on Linux or on any platform), grab one of our newcomer-friendly easy hacks, and send your first pull request. And if you get stuck at any point, just drop by one of our communication channels. 😉

Highlights

Collabora Online Weekly Meeting #3

COOL Weekly Meeting #3 has taken place on Thursday, November 26, 2020 at 11:00:00 am (UTC) with participants both from the community contributors and the Collabora team. We have got a quick update on what’s going on and discussed matters raised by the contributors, as well as having the chance to say hi to fellow members of the community. Topics discussed in the meeting include:

  • Contextual toolbars for COOL (suggested by Andreas Kainz) got a new patch merged to master with some initial bits of implementation. Andreas Kainz will test it and give feedback.
  • Icon theming for COOL leveraging SVG files (suggested by Andreas Kainz) has been decided to be turned into an issue on GitHub to keep track of the initial work of defining the class names. Below is a proof of concept screenshot by Andreas Kainz demonstrating how two different sets of icons can be obtained just by using two different SVG classes.

    A proof of concept screenshot by Andreas Kainz demonstrating two different sets of icons with two different SVG classes
  • The blog post about iOS app upgrade (suggested by Nicolas Christener) is planned to be written/published when the new upgrade is out. It was also mentioned that new beta testers should ask Kendy for access to the testing versions.
  • Regarding Mobile / iOS versions, Pedro Silva has reported that the Notebookbar for iPad has been improved, and many fixes and improvements have already been included in 6.4 for a more clutter-free notebookbar with better user experience for iOS users. He has also touched up the community website to add a prominent link to the forum.
  • Gökay Şatır has shared some update about his work on CanvasTileLayer
  • Gabriel Masei asked about the ways to avoid duplicated effort, and was suggested to keep in touch with the team in the #cool-dev channel on Freenode, and also participate in the following sessions of the COOL Weekly Meeting. He is interested in contributing to COOL to make it possible to dynamically change between the classic toolbar and the new notebookbar views.

Check out the meeting minutes for the details of the meeting, make your own suggestions for the next meeting, and join us on Thursday, December 03, 2020, at 11:00 am (UTC) to stay in touch with the rest of the community. We’re looking forward to hearing from you live. 😉

Collabora Online (COOL)

Collabora Office on Android & iOS

  • Thanks to Tor Lillqvist for fixing an issue which caused the on-screen keyboard not coming back after being dismissed once in a session in the iOS app. He has also made sure that no auto-scrolling of a page on a Writer document happens if user is making a selection by dragging the selection handles in the iOS app.
  • Thanks to Jan Holesovsky for making sure that plain text content copied from browser is properly pasted without additional characters in the Android app.

Collabora Online Integrations

  • Thanks to Roeland Jago Douma for improving performance of Collabora Online’s Nextcloud integration by making sure extra queries and steps are avoided by obtaining the appdata folder in one go. He has also improved handling of empty files to avoid possible issues.
  • Thanks to Julius Härtl and Andras Timar for reviewing and merging pull requests on Collabora Online’s Nextcloud integration.
  • Thanks to Phil Davis for upgrading phan version on Collabora Online’s ownCloud integration, thus helping to maintain a high PHP code-quality for the project.
  • Thanks to Semih Serhat Karakaya for making Collabora Online’s ownCloud integration future-proof by changing the code to use the path from the appManager instead of a static one.
  • Thanks to Jan Ackermann for helping Collabora Online’s ownCloud integration stay up-to-date by replacing some deprecated functions with current ones, as well as making sure the integration app has the correct default name.

Honorable Mentions

  • Thanks to Marc Rodrigues for continuing to keep us updated on various news around Collabora Online and related FOSS projects, and creating a lot of yummy content to read!
  • Thanks to Andras Timar for keeping us organized, maintaining our translation project on Weblate, and delivering hot new releases of our software!
  • Thanks to Cor Nouws for leading the marketing team, and not stopping there but continuing with testing & reporting bugs, attending to community events, and keeping us all informed about what’s going on. He also attends LibreOffice Design meetings from time to time to help COOL’s mother project LibreOffice have a better UI & UX.
  • Thanks to Jan Holesovsky for doing a lot of research on different topics, and providing mentoring/patch-reviewing/hand-holding/wisdom within the team, in our communication channels, and also on various channels of our lovely mother project LibreOffice.
  • Thanks to Eloy Crespo for his efforts to help the project well-funded as always.
  • Your friendly community mentor, Muhammet Kara, is also creating & improving easy hacks, running workshops, helping new contributors solving their setup & build issues and reviewing their pull requests, working on easing the build procedure, improving our GitHub presence bit by bit based on its community guidelines, compiling/composing these community updates…

Translators

Last but not least, we can’t thank enough to our translators who constantly help COOL and its friends talk many languages on this earth. Collabora Online speaks many languages, thanks to all of our translators in our translation project, and all of those who previously contributed and keeps contributing to our mother project, LibreOffice.

We’re continuing to work to find good ways to credit translators’ hard work in the product. Please see a list of those involved, and please get in touch if you’re not listed. Many thanks to all those who have worked on translating Online, you rock!

If you would like to help COOL speak your language, you can just go to our translation project on weblate, and start contributing! 😉

Collabora Online translation project on Weblate
Collabora Online translation project on Weblate

Collabora loves LibreOffice!

We’re still contributing to LibreOffice and encourage you too to do so because LibreOffice rocks. 😉

  • Thanks to Gülşah Köse for making sure documents with text camera z rotation are properly opened and saved for PPTX files, thus improving interoperability with other office suites.
  • Thanks to Miklos Vajna for fixing a bug that caused LibreOffice to not update all preview images on an ODT file after issuing the UpdateAll command, as well as various other fixes for issues encountered while opening certain DOCX files,[0][1] and also for improving PPT support by resolving an issue which caused some images being lost after opening a PPTX file and saving it as PPT.
  • Thanks to Noel Grandin for doing various code-quality improvements and modernization all around the LibreOffice code-base.

Read More

Collabora Online Community Roundup #6

On October 1st, Collabora Online moved to its new home on GitHub, and started settling in the new infrastructure, expanding its fantastic community, and continuing the work to deliver the latest and greatest developments in productivity and collaboration together. Check our new community website for all the details! 😉

Collabora developers also keep fixing and improving our lovely mother project LibreOffice. As all the good work requires some appreciation, let’s take a look at what the seasoned developers of the Collabora team and the volunteer contributors from our community have been doing during the last week.

Week in Numbers

On the Collabora Online code repository in the last week, 29 authors have pushed 102 commits to master and 193 commits to all branches. On master, 150 files have changed and there have been 2,357 additions and 1,480 deletions.

Screenshot of GitHub Pulse for Collabora Online
Development Activity on Collabora Online GitHub Repository from November 13, 2020 to November 20, 2020

New Contributors

Congratulations to Marco Bierbach and gohrner for reporting their first issues and improvement requests on our GitHub repository!

  • Thanks to Marco Bierbach for reporting an issue happening on macOS with a 4K monitor.
  • Thanks to gohrner for letting us know about a bug that affects the formula bar while using notebookbar interface.

Thank you all, and welcome aboard! 🙂

Join the fun!

You can also join the fun, and be part of our next list of new contributors! 🙂

Just go to our GitHub repo, fork it, build it (on Linux or on any platform), grab one of our newcomer-friendly easy hacks, and send your first pull request. And if you get stuck at any point, just drop by one of our communication channels. 😉

Highlights

Collabora Online Weekly Meeting #2

COOL Weekly Meeting #2 has taken place on Thursday, November 19, 2020 at 11:00:00 am (UTC) with participants both from the community contributors and the Collabora team. We have got a quick update on what’s going on and discussed matters raised by the contributors, as well as having the chance to say hi to fellow members of the community. Topics discussed in the meeting include:

  • Contextual toolbars for COOL (suggested by Andreas Kainz)
  • Icon theming for COOL leveraging SVG files (suggested by Andreas Kainz)
  • The blog post about iOS app upgrade (suggested by Nicolas Christener)
  • Pull requests pending review
  • Help for the new contributors to get started with COOL development on Android

Check out the meeting minutes for the details of the meeting, make your own suggestions for the next meeting, and join us on Thursday, November 26, 2020, at 11:00 am (UTC) to stay in touch with the rest of the community. We’re looking forward to hearing from you live. 😉

Collabora Online (COOL)

  • Thanks to Pedro Silva for various fixes and improvements around the user interface of COOL to make it easier to maintain[0][1][2] and have a better and consistent look and feel[3][4] especially in the case of dialogs[5][6].
  • Thanks to Ayhan Yalçınsoy for upgrading our eslint version to 6.0.0. He has been working on preparing the code-base for the upgrade in the previous weeks. This will bring a bunch of fixes and improvements for one of our depended-on libraries and will ease maintaining code quality.

    ESLint is a pluggable and configurable linter tool for identifying and reporting on patterns in JavaScript.
  • Thanks to Ashod Nakashian for various fixes and improvements around watermark feature[0][1] and general stability of COOL and maintainability of the code-base.[2]
  • Thanks to Pranam Lashkari for fixing a bug which caused cell content selections on Calc documents not being properly updated after tapping on a different cell, and making sure correct author and date info is displayed for comment replies.
  • Thanks to Tamás Zolnai for a lot of fixes and improvements around cypress (testing framework), and the testing facilities for certain integrations, thus helping COOL have an even better automated quality assurance process, and also for mentoring other contributors while writing new cypress tests.
  • Thanks to Szymon Kłos for making bringing notebookbar a bit closer to feature-completion by adding[0][1] conditional formatting submenu and advanced filter dialog, fixing a bug which caused screen-flickering while scrolling through a PDF document, ensuring[0][1] that related context (right-click) menu entries are shown when change-tracking is enabled on a Writer document, making sure comments are properly displayed after returning to an inactive document, as well as various other improvements and fixes.
  • Thanks to Nnamani Ezinne Martina for adding more cypress tests to ensure the quality of Collabora Online on various toolbar items such as Spacing, Italic, Underline, Strikethrough, Highlight Color, Font Color, Clear Direct Formatting, Apply Font Style, Apply Font Size, Add Decimal Places, Delete Decimal places, Format as Currency and Format as Percent.
  • Thanks to Jan Holesovsky for improving the user experience of COOL by disabling the Freeze panes menu and notebookbar entries on tablets which were confusing users because the related feature is not available there, and for making sure add and save options for comments are not shown when a user doesn’t have permission to edit the document.
  • Thanks to Michael Meeks for various fixes and improvements under-the-hood towards increased stability and reliability.[0][1]
  • Thanks to Mert Tümer for fixing a bug that was causing watermark text to be distorted in certain cases.

    Screenshot of a sample watermark text before and after the fix.

Collabora Office on Android & iOS

  • Thanks to Pedro Silva for improving the user experience on the iOS app by ensuring consistent button styling.
  • Thanks to Tor Lillqvist for fixing typing into tunneled dialogs, the dialogs coming from the LibreOffice core side, on hardware keyboards in the iOS app.

Collabora Online Integrations

  • Thanks to Julius Härtl for a lot of under-the-hood improvements on Collabora Online’s Nextcloud integration, along with various improvements towards mobile apps[0][1], and also for reviewing and merging pull requests by other contributors.
  • Thanks to Roeland Jago Douma for improving configurability of Collabora Online’s Nextcloud integration by making the timeout value configurable.
  • Thanks to Andreas Grabs for doing under-the-hood improvements on the CI facilities of Collabora Online’s Moodle integration.

Honorable Mentions

  • Thanks to Marc Rodrigues for continuing to keep us updated on various news around Collabora Online and related FOSS projects, and creating a lot of yummy content to read!
  • Thanks to Mike Kaganski for mentoring other members of the team, and helping them get started.
  • Thanks to Yunusemre Şentürk for various tasks towards keeping our CI chains healthy.
  • Thanks to Andras Timar for keeping us organized, maintaining our translation project on Weblate, and delivering hot new releases of our software!
  • Thanks to Jan Holesovsky for doing a lot of research on different topics, and providing mentoring/patch-reviewing/hand-holding/wisdom within the team, in our communication channels, and also on various channels of our lovely mother project LibreOffice.
  • Thanks to Eloy Crespo for his efforts to help the project well-funded as always.
  • Thanks to Cor Nouws for leading the marketing team, and not stopping there but continuing with testing & reporting bugs, attending to community events, and keeping us all informed about what’s going on. He also attends LibreOffice Design meetings from time to time to help COOL’s mother project LibreOffice have a better UI & UX.
  • Your friendly community mentor, Muhammet Kara, is also creating & improving easy hacks, running workshops, helping new contributors solving their setup & build issues and reviewing their pull requests, working on easing the build procedure, improving our GitHub presence bit by bit based on its community guidelines, compiling/composing these community updates…

Translators

Last but not least, we can’t thank enough to our translators who constantly help COOL and its friends talk many languages on this earth. Collabora Online speaks many languages, thanks to all of our translators in our translation project, and all of those who previously contributed and keeps contributing to our mother project, LibreOffice.

We’re continuing to work to find good ways to credit translators’ hard work in the product. Please see a list of those involved, and please get in touch if you’re not listed. Many thanks to all those who have worked on translating Online, you rock!

If you would like to help COOL speak your language, you can just go to our translation project on weblate, and start contributing! 😉

Collabora Online translation project on Weblate
Collabora Online translation project on Weblate

Collabora loves LibreOffice!

We’re still contributing to LibreOffice and encourage you too to do so because LibreOffice rocks. 😉

  • Thanks to Tor Lillqvist for releasing LibreOffice Vanilla 7.0.3.1 in the Mac App Store. He has also done various improvements towards LibreOffice support for ARM-Based Macs. Check out the blog post for details.
  • Thanks to Tomaž Vajngerl for doing various improvements[0][1][2] towards better PDF handling of Draw.
  • Thanks to Miklos Vajna for improving DOCX compatibility by fixing a bug that caused LibreOffice to crash while opening a DOCX file with tracked changes, as well as various other fixes for issues encountered while opening certain DOCX files.[0][1][2][3]
  • Thanks to Noel Grandin for doing various code-quality improvements and modernization all around the LibreOffice code-base.

Read More

Collabora Online Community Roundup #5

On October 1st, Collabora Online moved to its new home on GitHub, and started settling in the new infrastructure, expanding its fantastic community, and continuing the work to deliver the latest and greatest developments in productivity and collaboration together. Check our new community website for all the details! 😉

Collabora developers also keep fixing and improving our lovely mother project LibreOffice. As all the good work requires some appreciation, let’s take a look at what the seasoned developers of the Collabora team and the volunteer contributors from our community have been doing during the last week.

Week in Numbers

On the Collabora Online code repository in the last week, 24 authors have pushed 72 commits to master and 146 commits to all branches. On master, 100 files have changed and there have been 1,051 additions and 535 deletions.

Screenshot of GitHub Pulse for Collabora Online
Development Activity on Collabora Online GitHub Repository from November 06, 2020 to November 13, 2020

New Contributors

Congratulations to Irihapeti, avatar1024, kadarpik, zubanst and sidey for reporting their first issues and improvement requests on our GitHub repository!

  • Thanks to Irihapeti for reporting a bug regarding default fonts on our Android app.
  • Thanks to avatar1024 for letting us know about a missing menu item on Collabora Online 6.4 by creating an issue.
  • Thanks to kadarpik for reporting an issue about Calc formula bar which causes unexpected cursor behaviour on certain cells.
  • Thanks to zubanst for letting us know about a potential issue with a specific integration.
  • Thanks to sidey for reporting an issue about using system fonts with CODE, and then also providing the relevant solution when it turned out to be a configuration issue.

Thank you all, and welcome aboard! 🙂

Join the fun!

You can also join the fun, and be part of our next list of new contributors! 🙂

Just go to our GitHub repo, fork it, build it (on Linux or on any platform), grab one of our newcomer-friendly easy hacks, and send your first pull request. And if you get stuck at any point, just drop by one of our communication channels. 😉

Highlights

New categories on COOL Community Forum

Our community forum now has more categories in which you can ask your questions and help other users and contributors by answering their questions. If you get stuck at some point setting up your very specific development environment or COOL installation, or if you have achieved something nice, feel free to jump into the forum to ask your questions or share your knowledge!

Collabora Online Community Forum
Collabora Online Community Forum

Live Interactions in COOL Weekly Meetings

The first of Collabora Online Weekly Meetings has taken place on Thursday, November 12, 2020 at 11:00:00 am (UTC) with participants both from the community contributors and the Collabora team. We have got a quick update on what’s going on and discussed matters raised by the contributors, as well as having the chance to say hi to fellow members of the community. Check out the meeting minutes for the details of the first meeting, make your own suggestions for the next meeting, and join us on Thursday, November 19, 2020, at 11:00 am (UTC) to stay in touch with the rest of the community. We’re looking forward to hearing from you live. 😉

Collabora Online (COOL)

  • Thanks to Pedro Silva for making sure menu bar buttons are properly middle aligned, and fixing various issues around notebookbar and tooltips, thus letting us have a better UX over-all.
  • Thanks to Ashod Nakashian for adding support for new-line breaks in watermark texts, thus letting users to be able to add multi-line watermark text to documents, and for improving stability. He has also done some clean-up to keep the code-base tidy and more maintainable.
  • Thanks to Pranam Lashkari for improving stability of Collabora Online through some fixes around jquery and DOM, and for enhancing the user experience by removing context menu options with tunnelled dialogs which don’t work well while working on documents collaboratively.
  • Thanks to Nnamani Ezinne Martina for adding more cypress tests to ensure the quality of Collabora Online on various toolbar items such as Insert Chart, Insert Shape, Align Center, Align Right, Justified, Toggle Numbered List, Toggle Bulleted List, Increase Indent and Decrease Indent.
  • Thanks to Thaís Vieira for ensuring the quality of various mobile view menus through testing.
  • Thanks to Andreas Kainz for improving visual consistency and helping COOL look more beautiful through verious fixes and improvements such as updating the shape icon, updating the Tools and the Insert menus on Writer, adding some missed commands to the View and the Insert menus of Calc, along with other similar improvemnts.[0][1][2]
  • Thanks to Tamás Zolnai for making sure form fields are now properly activated while multiple users are collaboratively working on a document, and also for mentoring other contributors while writing new cypress tests.
  • Thanks to Andras Timar for adding support for Visio (.vsdx) files.
  • Thanks to Miklos Vajna for improving the developer experience by adding commit hooks for DCO towards having potentially less CI failures and less need for amending submitted pull requests.

Collabora Office on Android & iOS

  • Thanks to Pedro Silva for imroving user experience on the iOS app by fixing an issue which caused the Impress sidebar buttons to appear in read-only mode, causing confusion. He has also fixed a bug causing the hamburger menu on the iOS app to be shown below the notebookbar, thus improving the UI and UX even further.
  • Thanks to Tor Lillqvist for improving font handling of the iOS app, by fixing an issue that caused the app not to see the registered system fonts, and for various under-the-hood improvements.[0][1][2]
  • Thanks to Mert Tümer for a lot of improvements and fixes on ChromeOS, such as making sure scrolling on trackpad with two fingers works again properly, newly created documents are editable right-away without additional double-touch, copy-paste via shortcuts are working functional, and using arrow keys doesn’t cause losing focus on text boxes. Users on Chromebook can be more productive with their office documents now! 😉

Collabora Online Integrations

  • Thanks to Gary Kim for fixing special-character-escaping on the “Edit with” menu item for Collabora Online’s Nextcloud integration, and thanks to Julius Härtl for reviewing and merging the related pull request.

    “Edit with” menu item of Collabora Online’s Nextcloud integration
  • Thanks to Julius Härtl for a lot of under-the-hood improvements on Collabora Online’s Nextcloud integration, along with various improvements towards mobile apps[0][1], and also for reviewing and merging pull requests by other contributors.
  • Thanks to Phil Davis for under-the-hood improvement towards PHP dependency on Collabora Online’s ownCloud integration, and thanks to Dipak Acharya for reviewing and merging the related pull request.

Honorable Mentions

  • Thanks to Pedro Silva for doing various improvements on our community page, reviewing pull requests, and sharing his design magic with us, other contributors through participation in discussions in various channels including LibreOffice Design Meetings, issue reports and pull requests on GitHub.
  • Thanks to Marc Rodrigues for continuing to keep us updated on various news around Collabora Online and related FOSS projects, and creating a lot of yummy content to read!
  • Thanks to Mike Kaganski for working on new integrations and also helping with maintaining our forum, handling administrative tasks.
  • Thanks to Yunusemre Şentürk for improving the related release engineering bits to allow us to have more robust snapshot builds for Collabora Online 6.4 series and improving testing infra for integrations, along with various other tasks towards keeping our CI chains healthy.
  • Thanks to Andras Timar for keeping us organized, maintaining our translation project on Weblate, and delivering hot new releases of our software!
  • Thanks to Cor Nouws for leading the marketing team, and not stopping there but continuing with testing & reporting bugs, attending to community events, and keeping us all informed about what’s going on. He also attends LibreOffice Design meetings from time to time to help COOL’s mother project LibreOffice have a better UI & UX.
  • Thanks to Eloy Crespo for his efforts to help the project well-funded as always.
  • Thanks to Jan Holesovsky for doing a lot of research on different topics, and providing mentoring/patch-reviewing/hand-holding/wisdom within the team, in our communication channels, and also on various channels of our lovely mother project LibreOffice.
  • Your friendly community mentor, Muhammet Kara, is also creating & improving easy hacks, running workshops, helping new contributors solving their setup & build issues and reviewing their pull requests, working on easing the build procedure, improving our GitHub presence bit by bit based on its community guidelines, compiling/composing these community updates…

Translators

Last but not least, we can’t thank enough to our translators who constantly help COOL and its friends talk many languages on this earth. Collabora Online speaks many languages, thanks to all of our translators in our translation project, and all of those who previously contributed and keeps contributing to our mother project, LibreOffice.

We’re continuing to work to find good ways to credit translators’ hard work in the product. Please see a list of those involved, and please get in touch if you’re not listed. Many thanks to all those who have worked on translating Online, you rock!

If you would like to help COOL speak your language, you can just go to our translation project on weblate, and start contributing! 😉

Collabora Online translation project on Weblate
Collabora Online translation project on Weblate

Collabora loves LibreOffice!

We’re still contributing to LibreOffice and encourage you too to do so because LibreOffice rocks. 😉

  • Thanks to Gülşah Köse for fixing a bug which caused z-rotated text to produce additional shape rotations after open and save operations on PPTX files, and improving row height handling of certain PPTX documents imported into Impress, thus letting us have a more flawless experience with exchanged presentations with tables. Check out her blog post for details.

    The table on PPTX file before and after the fix
  • Thanks to Ivan Stefanenko for adding accessibility checks for headings and fontworks, thus making LibreOffice a bit more user-friendly.
  • Thanks to Tomaž Vajngerl for doing various improvements[0][1][2] towards better PDF handling of Draw.
  • Thanks to Miklos Vajna for improving DOCX compatibility by fixing a bug that caused some images on documents to be incorrectly positioned when imported to LibreOffice, and fixing a bug which caused a crash while opening a certain DOCX document with change-tracking, along with other improvements towards stability, maintainability and better PDF handling, and also for mentoring other members of the team while fixing various issues.
  • Thanks to Noel Grandin for doing various code-quality improvements and modernization all around the LibreOffice code-base.
  • Thanks to Dennis Francis for multi-threading improvements towards better performance on Calc documents, reducing setup-cost while doing recalculations especially if there are many formula-groups.

Read More