Collabora Office Calc and Collabora Online Calc · Sheet and cell protection · Beginner
Protect Formulas and Leave Input Cells Editable in Collabora Calc
Unlock the input range before protecting the sheet, then verify formula protection and editable inputs after reopening.
Official documentation reviewed; synthetic expectations independently checked; not tested in Collabora; deployment-specific controls require verification. · Editorial standards
Remove the Protected attribute from input cells first, leave it enabled on formula cells, and then protect the sheet. Setting cell attributes alone does not enforce protection. Collabora’s protection help says cells are protected by default and that the sheet-level switch activates those attributes.
Scope and safe starting point
The traditional menu-bar instructions below follow Collabora Office Help labeled 26.04. Collabora Office Classic is the separate traditional desktop product. The Help label 26.04 identifies the documentation version, not a verified Classic runtime. New Collabora Office 26.04 uses an Online-style interface; traditional menu-bar routes below apply only where the installed interface actually exposes them. The Online route follows Collabora’s Online cell-protection guide. The traditional Tools menu is not an Online or new-desktop menu guarantee. Use a disposable ODS copy with editing permission; if it is already protected, obtain authorized access to unprotect it before changing cell attributes.
Reusable practice layout
Enter the table in A1:C3. The practice text file repeats the cell-by-cell setup; it does not contain protection settings.
| Item | Quantity input | Calculated total |
|---|---|---|
| Notebook | 2 | =B2*4.50 |
| Pen | 3 | =B3*1.25 |
C2 should calculate 9 and C3 should calculate 3.75. These formulas use a decimal-point locale; enter the equivalent decimal separator if your installation uses a comma. Optionally use SUM in C4: =SUM(C2:C3) should give 12.75. Keep C4 protected too.
Unlock inputs, then protect the sheet
- Select B2:B3, not the entire worksheet. These are the only cells intended for data entry.
- In an installation exposing the traditional menu-bar route, choose Format → Cells → Cell Protection. In the documented Online tabbed interface, use Format → Format Cells → Cell Protection.
- Clear Protected for B2:B3 and confirm. Inspect C2:C3 separately and ensure Protected remains selected. Do not clear it globally and then assume formulas are still locked.
- Activate sheet protection: in the traditional menu-bar interface, use Tools → Protect Sheet; in the documented Online interface, use Review → Protect Sheet or the sheet tab’s context menu.
- For this disposable exercise, omit a password and confirm the dialog. If selection permissions are offered, permit selecting unprotected cells so people can reach B2:B3. A real sheet-protection password needs an agreed custodian; keep an unprotected source copy somewhere appropriately restricted.
Verify the actual result
- Change B2 from 2 to 4: entry should succeed and C2 should become 18. With C3 unchanged, C4 should be 21.75.
- Try changing C2 to 0: the protected formula should reject the edit. Cancel the attempt; do not remove protection to make the test appear successful.
- Verify B3 is editable and that an unintended cell, such as A2, is still protected.
- Save, close and reopen the spreadsheet. Repeat both the input and formula tests. If you export to XLSX for someone else, repeat in that exact exported file and target application.
The lock icon in Online helps identify active sheet protection, but the edit tests establish whether the intended ranges were configured. A read-only file that blocks every cell has not passed the editable-input test.
Troubleshooting and boundaries
Everything is locked: unprotect the sheet with authorization, select B2:B3, clear their Protected attribute, and protect again. Formulas are still editable: check the attributes of C2:C3 and the sheet-level protection state. Controls are absent: verify editing permission and server build; do not substitute desktop menu paths blindly. The Online 26.04 release notes specifically mention mobile sheet-tab protection improvements, so older mobile interfaces should not be assumed equivalent.
Sheet protection helps prevent accidental changes. It is not file encryption or a replacement for sharing permissions. Hiding formulas is a different setting from preventing their editing. Spreadsheet-structure protection is also separate from this input/formula exercise.
Testing disclosure: The documented protection prerequisites and product-specific menu routes were reviewed; the arithmetic was checked independently. This tutorial has not been tested in Collabora Office or Collabora Online, including save/reopen persistence.