Unlocking Protection with Locked Cells in Collabora Online

Our road map and new feature development is driven by our users, and we’re excited to announce a new feature inspired by a number of our customers, including a French government ministry – the ability to lock and protect individual cells within spreadsheets. This exciting new feature empowers users to exert greater control over their data and collaborate more effectively than ever before.

Why is this feature useful?

Locking individual cells, rows, columns or entire sheets in Calc offers a multitude of benefits, including:

  • Data Integrity: By locking specific cells, users can prevent their own accidental modifications to critical data or formulas, ensuring data integrity and accuracy.
  • Collaborative Workflows: In collaborative environments, locking cells allows multiple users to work on a spreadsheet simultaneously without the risk of accidental or deliberate attempts to change important information. Junior and senior staff may therefore collaborate together.
  • Security: Locking cells adds an extra layer of security to sensitive data, restricting access to authorised users and minimising the risk of unauthorised changes. In addition to locking editing, ‘selection’ of protected cells can be toggled on or off, either allowing or preventing copy/paste functionality.
  • Template Creation: Users can create templates with predefined values or formulas, locking certain cells to preserve the template structure while allowing customisation in other areas.

How does it work?

Locking individual cells in Collabora Online is intuitive and user-friendly. Simply select the cells you wish to lock, right-click, and choose the “Format Cells” option from the menu. Cells can then be toggled as protected or not. To then apply the protection, right click on the sheet, choose “Protect Sheet”, and you may set a password and choose whichever permissions you intend to give to the protected/unprotected cells.


Unlocking the Full Potential of Your Spreadsheets

With the new feature of protecting cells, Collabora Online empowers users to take control of their data and optimise their collaborative workflows. Whether you’re working on financial models, project plans, or data analysis, locking cells provides you with peace of mind and confidence in your spreadsheet creations.

Empowering Finance: The Safest Bet with Collabora Online

Welcome back to our series looking at how Collabora Online matches the document-editing needs of different sectors. Today, we will dive into the world of finance, where information and data means money, and security is key. Collabora Online stands tall as the guardian of your document vault, keeping your information more secure than a Swiss bank.

Building Your Document Fort Knox

In finance, information security is paramount. At Collabora Online, we get it. So unlike other cloud-based document editors, Collabora Online will keep your files secure on your server, in your premise, under your jurisdiction, all the time. Rather than duplicating and posting copies to every file editor or reader’s browser, Collabora Online retains your files centrally, and operates more like a hyper-efficient remote desktop than a browser-based document editor, yet still allows end users to view or edit documents depending on their permissions.

For users without editing privileges, there can be no unauthorised stripping of permissions, and download or copy/paste access is controlled in a way that other document editors can only dream of – fully enforced from the server, with no reliance on client-side access controls.

Documents can also be further watermarked with user IDs, burnt into the document pixels at the server, reducing any remaining likelihood of leaking screenshots or photos, and ensuring the source of any information loss is immediately identifiable.

Dictum Meum Pactum – ‘My Word is My Bond’ might be the motto of the London Stock Exchange, but we’d rather not risk it…

Your on-premise cloud

You might be wondering, “Does this ultra-secure, on-premise document editor mean sacrificing remote accessibility and collaborative efficiency?” Fear not – Collabora Online not only ensures top-level security, but also unleashes the power of remote access and seamless collaboration.

Collaborate on your financial reports, spreadsheets, and documents from anywhere with an internet connection. Our platform is designed to maximise security, whilst still retaining accessibility, giving you the freedom to work without compromise. You can think of it as giving each user their own unique and trackable pen to write on the same document concurrently, but you are holding the document centrally throughout the process. This methodology is different to most other browser-based document editors that essentially function by making copies of documents, distributing copies to every editor to work on individually, before collating all the changes made centrally.

With Collabora Online your files don’t venture into the unknown, they stay within the confines of your server or trusted local hosting partner. No unauthorised sharing, no uninvited guests, just your documents and your users.

A safe bet with Collabora Online

Choosing Collabora Online is a smart investment, Standard & Poor’s and Moody’s don’t do document editor ratings, but if they did, we’d be AAA. With all the functionality you know and expect, real security, a familiar interface, robust version history, redlining, tracked changes and more, your financial documents will have everything they need.

Smart money collaborates with Collabora Online.

Keep your data secure with Collabora Online.

Try the Online Demo

Collabora Online – Safe, Powerful, Flexible.

Empowering Law: Unleashing Collabora Online for Legal Document Excellence

In our ongoing exploration of how Collabora Online empowers various sectors, we’ve discussed use cases within education, governments, and national defence. Now, let’s turn our attention to the legal world, where accuracy, control, and security are paramount. Collabora Online, our flagship collaborative office suite, continues to prove itself as a versatile and robust solution, aligning seamlessly with the unique needs of the legal profession.

Document Security at Its Core

In the legal realm, confidentiality and document security are non-negotiable. Collabora Online builds a fortress of security around your legal documents. Unlike traditional document editors, where files travel between servers and devices, Collabora Online adopts a server-centric approach. Your documents never leave the secure confines of the server, offering unparalleled control over sensitive legal information. This stands in stark contrast to other document editors such as Microsoft Office, where files are copied in their entirety and sent to users’ browsers for editing, with changes then merged centrally. Collabora Online in effect gives multiple users their own set of unique and trackable pens to work on the same document concurrently, and crucially there isn’t a (metaphorical) photocopier or secretary frantically looking for and merging changes in sight. This all provides legal professionals the assurance they need in an era of increasing data privacy concerns.

Track Every Change, Preserve Every Version

For legal professionals, clarity in document history is indispensable. Collabora Online’s robust version history, redlining, and track changes features are tailored to the meticulous requirements of legal document management. As mentioned above, since the document never leaves the confines of your own on-premise (or trusted hosting partner’s) servers, there is no way for third parties to alter contents without your knowledge. Read-only files stay read only, download permissions are controlled, and any screenshots watermarked with user details to prevent unauthorised sharing – something other browser-based or offline document editing suites struggle to control (as the U.S. Department of Defense recently discovered). Any and all changes can and will be clearly displayed in the document history. Whether it’s scrutinising the evolution of a contract, identifying modifications, or preserving a pristine or unpublished version, Collabora Online offers a comprehensive toolkit for legal practitioners to navigate the complexities of document collaboration with ease.

Genuine Compliance

If you are using Microsoft Office 365 as your document editor, it is becoming increasingly unclear if they are in any way compliant with GDPR regulations, or indeed if they have any intention to comply with the law. This is the conclusion of the latest two-year study carried out by the German privacy regulator DSK (Datenschutzkonferenz). Worryingly, DSK’s accusations are not merely legal nit-picking, but relate to how Microsoft shares data with U.S. authorities. “[Microsoft may] provide disproportionate access rights for U.S. intelligence services and there is no judicial recourse for EU citizens.”1 “To compensate for the fundamental rights inadequacies of [U.S. laws providing extensive access rights to US intelligence services] identified by the European Court of Justice, it would be necessary to take measures to prevent or render ineffective the access of U.S. authorities – and thus Microsoft – to personal data.”2

Whilst the DSK report appears to have public services in mind, and is primarily concerned about schools and other public bodies, for any legal practice these allegations should be sounding serious alarm bells. With a locally hosted Collabora Online deployment, you can be sure your documents will always stay within your local legal jurisdiction, or for maximum control, host your documents on-premise.

Don’t delay

Collabora Online provides a quality solution that meets the rigorous standards legal practice demands. Already in use by government departments, educational institutions, and across the private sector sector, Collabora Online enables legal professionals to focus on their expertise, while handling the legal and security intricacies of document editing and collaborative working.

Keep your data secure with Collabora Online.

Try the Online Demo

Collabora Online – Safe, Powerful, Flexible.

  1. Original German: Für die USA hat der EuGH in ‘Schrems II’ festgestellt, dass FISA 702 und E.O. 12333 unverhältnismäßige Zugriffsrechte für US-Geheimdienste vorsehen und für EU-Bürger kein gerichtlicher Rechtsschutz gegeben ist.
  2. Original German: Um die vom EuGH identifizierten am EU-Maßstab gemessenen grundrechtlichen Unzulänglichkeiten von FISA 702 auszugleichen, wäre es erforderlich, Maßnahmen zu ergreifen, die den Zugriff der US-Behörden – und damit von Microsoft – auf personenbezogene Daten verhindern oder ineffektiv machen.


Collabora Online Empowering Series:

Empowering Education: A Smart Choice with Collabora Online

Empowering Governments: Collabora Online and Sovereignty

Empowering National Defence: The Strongest Solution with Collabora Online

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”