Empowering Education with Collabora Online: A Case Study

During the global pandemic, the Friedrich-List-Gemeinschaftsschule in Mössingen, Germany, seamlessly embraced the challenge of transitioning to online learning. Throughout this process, privacy, reliability, and accessibility were held up, with an open-source strategy leveraging Collabora Online as a vital component of their educational toolkit.

“It simply works. And it is reliable. That is crucial for us. In combination with Nextcloud, it works wonderfully and is very performant.”
– David Binder, teacher and IT officer

Embracing Open Source for Education

The Friedrich-List-Gemeinschaftsschule has long been an advocate for open-source solutions, fostering an environment where students are prepared not only for academic challenges but also for the demands of a rapidly evolving digital world. With a robust IT infrastructure based on free software, including Linux clients and LibreOffice, the school was well-positioned to address the sudden shift to online education triggered by the global pandemic.

Reliability and Security as Key Factors

What sets Collabora Online apart for the Friedrich-List-Gemeinschaftsschule is its reliability and security. With approximately 70 teachers and 600 students actively using the platform, Collabora Online has seamlessly become part of the school’s everyday workflow. The software’s integration into the existing infrastructure, coupled with its commitment to data and document security, has provided the school with a reliable and privacy-conscious solution for online collaboration.

Collabora Online for Educational Empowerment

In an educational landscape where flexibility, reliability, and privacy are paramount, Collabora Online stands out as a tool that empowers both educators and students. Its usage at Friedrich-List-Gemeinschaftsschule showcases the adaptability of Collabora Online in addressing the unique challenges of modern education. As institutions continue to navigate the complexities of online learning, Collabora Online proves to be a reliable and secure solution, contributing to the evolution of education in the digital age.

Download the Full White Paper

Explore the full details of how Collabora Online enhances secure collaboration within educational institutions. Dive into the full white paper to uncover the benefits and insights.

 

Case Study

“Open Source helps students learn from home during lockdown”

Why the German Staatendokumentation (State Documentation) Chooses Collabora Online

Discover how the Bundesamt für Fremdenwesen und Asyl (Federal Office for Immigration and Asylum) leverages Collabora Online, a secure and GDPR-compliant cloud office solution, to streamline operations and protect sensitive data.

“Collabora Online is the solution for uncomplicated use of documents in a public authority environment, which fits seamlessly into the existing environment and can be flexibly extended with required extras, such as the Duden Korrektor.”
– Thomas Schrott, Head of Dept for BFA Staatendokumentation

The State Documentation Challenge

The State Documentation team handles a vast amount of sensitive information, making data security and privacy paramount. With governments dealing with an increasing volume of data daily, it is crucial to maintain effective control over the processing of personal data to protect against unauthorized access, theft, and breaches, while also adhering to data protection laws such as GDPR.

Privacy, Security, Compliance

Collabora Online, hosted locally and GDPR compliant, emerges as the ultimate SaaS cloud-based solution. This choice not only ensures control over data location but also guarantees adherence to the stringent data protection laws governing government institutions.

Integration with Nextcloud: Collabora Online seamlessly integrates with Nextcloud, providing a collaborative environment that ensures data privacy and security. This is particularly vital for international exchanges where privacy concerns are heightened.

Open Source Advantage: By leveraging open-source software, BFA retains full control over sensitive data within the EU. This choice aligns with the growing trend among government institutions to opt for open solutions, reducing dependency on proprietary platforms.

The Duden Korrektor Integration

One of the distinctive features of the BFA’s implementation is the integration of Duden Korrektor. This widely used software tool aids in correcting written German and ensures consistency in spelling across all documents produced by the department. Especially with technical terms or names, Duden Korrektor helps standardize company-wide terms. The implementation of the Duden Korrektor into Collabora Online has been co-financed by the EU’s Asylum, Migration and Integration Fund (AMIF).

Download the Full White Paper

Explore the full details of how Collabora Online enhances secure collaboration within government institutions. Dive into the full white paper to uncover the benefits and insights.

 

Case Study

“Collabora Productivity Ltd provides Duden Korrektor functionality for BFA Staatendokumentation”

Thank you for a great 2023!

Thank You for Everything We Achieved Together in 2023 🤝

At the end of the year, we like to look back at what we have achieved as a team alongside our worldwide network of partners and the community. 2023 was a particularly significant year for us as we celebrated ten years of Collabora Productivity, adding another productive decade to our mission of bringing document editing and trillions of existing documents into the free world!

 

 

In March we held another successful COOL Days conference, this time in Cambridge, which brought together our team, partners and the community. We are looking forward to another great event in April 2024 – join us!

As well as our own events, our team also attended over ten locations to present talks, meet partners and share Collabora Online with the wider community. You can keep up to date with our adventures on our events page.

2023 saw many organisations and users throwing off their proprietary shackles, and embracing the freedom open-source solutions bring. In particular, we saw many educational institutions reconsidering their relationship with Microsoft 365 and Google Workspace amid privacy concerns, great strides being taken by local and national governments such as the openDesk project in Germany, and increasing numbers of private companies taking back control of their document storage and editing needs.

Collabora Online, Collabora Office and our mobile apps have all seen performance improvements and increased functionality. In July, we released the new major release of our flagship product Collabora Online 23.05, which included increased interoperability, performance boosts and a whole range of new features and accessibility improvements. Thank you for your support! Let’s take a deeper dive into what we have achieved together this year. 💜

 

Collabora Online 22.05 → 23.05

Our flagship product, Collabora Online saw marked improvements in 2023, introducing many exciting new features and a big focus on accessibility, working to bring the best digital experience we can to all our users, regardless of their abilities or challenges.

  • February 2023: Zotero plug in, PDF and EPUB export options, insert page number dialog, Duden Corrector plugin, easy hyperlink pop up editor
  • March 2023: linking API, improved conditional formatting from XLSX files.
  • April 2023: interoperability improvements.
  • July 2023: major release 23.05 introducing dark mode, expanded keyboard shortcuts, initial screen reading support, document themes, multi-page floating tables and accessibility improvements.
  • August 2023: further updates to keyboard shortcuts and more performance improvements.
  • September 2023: new font previews and barcode/QR code functionality.
  • October & November 2023: a focus on polishing and bug fixing with over 70 improvements.
  • December 2023: STYLEREF, floating tables properties, re-designed PostMessage for integrators and developers.

See the full release notes for Collabora Online 23.05 and COOL 22.05.

 

CODE: Developing a Rock-Solid Enterprise Version 💪

The latest major release of the Collabora Online Development Edition (CODE) 23.05 was released in June. CODE always appears in advance of the corresponding version of Collabora Online – the Development Edition contains all new features which are extensively tested before becoming available in the Enterprise version (COOL). An overview of CODE releases for 2023 can be found in the release notes but will mostly mirror those of Collabora Online. You can find the conversations about CODE on social media, by searching for the hashtag #cool_dev on Mastodon or Twitter.

 

Powerful New Features for Collabora Office on the Desktop 🖥️

August 2023 saw the latest major release of Collabora Office, our long term supported desktop Office Suite for Windows, macOS, and Linux. This release brought a number of powerful productivity features focusing on accessibility and improving user experience. The new features contain code that was contributed to LibreOffice 7.4, 7.5 and 7.6. Collabora Office for Windows is available through the Microsoft Store. The latest version for macOS can be bought from the App Store. We also appreciate those who help us test the latest features inside our unstable snapshots.

  • August 2023: major release of Collabora Office 23.05 including dark mode, interoperability features, document themes, 64-bit zip support, advanced editing features for tables and forms and so much more!
  • September 2023: MS Office interoperability improvements including further support of document themes, floating tables and pivot tables.
  • December 2023: Collabora Office 23.05.6 – STYLEREF, floating tables properties and advanced header and footer functionality.

Many new Features for Collabora Office for Android, iOS & Chrome OS📱

Our major release for mobile and tablet devices in September 2023 brought more of the functionality from Collabora Online into the pockets of our users, as well as improving the current user experience and making navigating on smaller screens easier. Now you can use dark mode, improved form controls in Writer, Sparklines, consistent dialogs and a better UX for users on smaller screened devices.

 

Events 🗓️

COOL Days 2023 took place in Cambridge, with more than 50 participants joining from our team, partners and the community. We presented 45 lightning talks showcasing our talented developers’ work across the year, held workshops and discussions with our partners about the importance of data protection in Europe, shared our development roadmap, and further discussed how to mutually support our sales and marketing efforts as part of our partnership. The community dived into a LibreOffice Hackfest and of course we had a great time socialising and team building around historic Cambridge.

 

 

 

As well as our own annual conference, our team attended events across Europe presenting talks, meeting partners and sharing Collabora Online, as well as presenting a keynote at the LibreOffice Conference for Latin America in Mexico.

2023 Events

 

Date Event Location Links
17th – 18th January 2023 Univention Summit Bremen, Germany Blog
4th – 5th February 2023 FOSDEM Brussels, Belgium Blog & Talks
6th – 8th March 2023 CS3 Barcelona, Spain Talk Recording
28th – 29th March 2023 COOL Days Cambridge, UK Blog, Live Stream
16th – 17th September 2023 Nextcloud Conference Berlin, Germany Blog & Talks
20th – 23rd September 2023 LibreOffice Conference Bucharest, Romania Blog & Talks
28th – 29th September 2023 SeaDays Mainz, Germany Talk
7th – 9th November 2023 Smart Country Convention Berlin, Germany openDesk Blog
9th – 10th November 2023 LibreOffice Congreso Latin America Mexico City, Mexico Keynote
6th – 7th December 2023 Open Source Experience Paris, France Talk Slides

 

LibreOffice Community & Contributions to 7.5 and 7.6

Collabora Productivity is part of the ecosystem developing and advancing LibreOffice technology. We are the largest contributor to the LibreOffice codebase, with our developers contributing many commits to the LibreOffice core.

LibreOffice 7.5 and LibreOffice 7.6 saw many improvements from the team at Collabora – here is just a snapshot of some of the commits this year.

  • Content controls – added plain text type, combo box, PDF export, titles and tags. (Miklos Vajna, Collabora)
  • Impress now supports cropped video for media shapes. blog post (Miklos Vajna, Collabora)
  • Citation handling: added plumbing in Writer to build Zotero-like functionality. blog post (Miklos Vajna, Collabora)
  • Keyboard navigation through forms (Justin Luth, Collabora)
  • Replacing strings with numbers in Calc tdf#126109 (Noel Grandin, Collabora)
  • Find and replace in very large Calc sheets tdf#150749 (Noel Grandin, Collabora)
  • Added page number wizard in Insert menu for easy one-step insertion of the page number in the header/footer tdf#86630 (Paris Oplopoios / Justin Luth, Collabora)
  • Initial machine translation is available, backend by DeepL translate (Mert Tumer, Collabora) core commit e20d2tdf#34058
  • Added pivot table compact layout. core commit 2f8d1 (Dennis Francis, Collabora)
  • Display soft breaks as line breaks at fontwork. tdf#148000 (Attila Szűcs, Collabora)
  • Added support to open multi image tiff files tdf#155444 (Rashesh Padia, Collabora)
  • Auto fitting text scaling algorithm has been changed so it works similar to MS Office. (Tomaž Vajngerl, Collabora)

Of course, we also had many of our developers share their work in the LibreOffice Technology devroom at FOSDEM this year. You can find links to their talks and slides in our blog.

 

Partners

This year we have welcomed 20 new partners from across Europe, Australia and South America including Oodrive, Salesframe, Aridhia and unodata. We are very happy to have a growing partner network allowing more and more users to take control of their data.

Team

This year we have seen our team grow, adding another 17 people to our core team at Collabora Productivity within our Sales, Marketing and Technical teams, with 50% of these coming from the Collabora Online Community. We love to hire smart people who have contributed to the Open Source community. This allows us to provide a richer experience for our partners and customers.

Collabora Online Community Contributions

The Collabora Online Community kept growing and helped to improve the software through their commits, feedback, and translations. You can see from the stats above that our Community is doing great things! You too, can help to make Collabora Online better. Join the discussions in our forum, join our community calls every Thursday at 12pm CET, translate strings on Weblate, file bug reports or feature requests on GitHub and spread the word on Collabora Online!

 

The Collabora Online SDK ⚙️

The Collabora Online SDK describes the main methods that allow you to interact with different Collabora Online components. Find installation guides, frequently asked questions, Post Message API and documentation on exiting integrations and on how to create new ones. This year we continued to add to our information to enable better integrations and clearer guidance.

A small sample of some 2023 updates:

 

Thanks to all who helped out!

It has been an exciting year here at Collabora Productivity, and we are so grateful to everyone who has been involved in 2023, and indeed for the past ten years – customers, partners, staff, and the community. We couldn’t have achieved any of these things without everyone working together so well. We have big plans for 2024 and are anticipating an even more exciting year ahead. We look forward to sharing it with you!

Don’t hesitate to get in touch with us, if you’d like to partner with us, or to download Collabora Online. Thank you for the great support this year. We wish you all a Merry Christmas and a Happy New Year!

Thank You!

 

News by Collabora Directly into your Inbox 📨

Keep up to date with our public newsletter. If you would like to receive regular updates with all the news and updates about Collabora Online, Collabora Office and future events, please sign up to our newsletter.

How SURF keeps 66,000 users productive in Dutch universities

 

SURF, the collaborative ICT organization for Dutch education and research institutions, plays a vital role in supporting 14 universities, 36 universities of applied sciences, and 70 research institutions by managing their IT infrastructure. To address the need for secure data exchange within this academic ecosystem, SURF deployed SURFdrive, an ownCloud-based file-sharing platform. However, they also required an online office productivity suite to enable real-time collaborative editing of documents, tables, and presentations.

In response to stringent data security requirements, SURF sought a solution that could be self-hosted, ensuring efficient and secure data exchange while allowing simultaneous real-time collaboration. ownCloud met their file-sharing needs, but they still needed an office productivity suite. Collabora Online emerged as the ideal solution, seamlessly integrating with ownCloud to enable users to access, create, and edit office documents collaboratively. Multiple authorized users could work on the same documents simultaneously, eliminating version conflicts.

 

Find out how the combination of ownCloud and Collabora Online has been highly successful for SurfNet, allowing SURFdrive to connect 59 institutions and serving 66,000 users in the Dutch academic landscape.

Download the Full White Paper

Explore the full details of how Collabora Online is helping in The Netherlands. Dive into the full white paper to uncover the benefits and insights.

 

Case Study

“Together with ownCloud and Collabora Online, we have created an IT infrastructure that meets [and] can keep up with the large enterprises in terms of performance and usability”

£1.2 Million for Office Software? Collabora Office and Healthcare Savings

(First published 2018, SEHSCT went on to become a Collabora Office customer)

The South Eastern Health and Social Care Trust (SEHSCT) provides six hospitals in Northern Ireland with acute hospital services and community health and social services to 345,000 people, with a budget of just under £500 million and a staff of 8,500 with computer accounts. Microsoft Office licenses were due for renewal in 2018, at a cost of £145 per user each year.

For the Trust, these licenses would have cost in excess of £1.2 million a year.

Faced with the high cost of renewing its licenses for Microsoft Office, the SEHSCT began a feasibility study to examine the possibility of using Collabora Office.

“We’re happy with the software. It has been a real pleasure working with Collabora to fix our migration issues”
– Darren Henderson, SEHSCT

Financial Efficiency

The SEHSCT was going through a feasibility study, assessing the shift from Microsoft to Collabora Office. The motivation? Substantial savings on licenses – a vital consideration for institutions grappling with tight budgets. Collabora Productivity offers a highly competitive solution, with licenses costing a fraction of Microsoft Office’s annual license fee (£145 per user at the time).

Functional Parity and Beyond

Despite concerns about compatibility issues due to the vast number of applications used, Collabora Office proved itself by offering a reliable and functional alternative.

Ongoing Support and Adaptability

Collabora Productivity’s team demonstrated a commitment to addressing compatibility concerns promptly. The collaboration between the SEHSCT and Collabora Productivity ensured continuous improvement and adaptation to specific needs. With a modest annual fee, institutions can gain access to an extensive wealth of expertise. Collabora Productivity’s team, with decades of experience, provided unparalleled support to navigate migration challenges successfully.

Download the Full White Paper

Explore the full details of how Collabora Office and Online can enhance secure collaboration within healthcare institutions. Dive into the full white paper to uncover the benefits and insights.

 

Case Study

“Open Source helps students learn from home during lockdown”