Protecting Cell Ranges in OpenOffice.org Calc

In OpenOffice.org Calc you can protect sheets and the document as a whole. You can choose whether the cells are protected against accidental changes, whether the formulas can be viewed from within Calc, whether the cells are visible or whether the cells can be printed.

Protection can be provided by means of a password, but it does not have to be. If you have assigned a password, protection can only be removed once the correct password has been entered.

 

Turning on protection

For the current sheet: Choose Tools -> Protect Document -> Sheet.

For spreadsheet documents: Choose Tools -> Protect Document -> Document.

Enter and confirm a password of at least 5 characters.

Turning off protection

For the current sheet: Choose Tools -> Protect Document -> Sheet.

For spreadsheet documents: Choose Tools -> Protect Document -> Document.

Where a password has been assigned, enter the correct password.

 

OpenOffice Password Recovery immediately removes this protection and allows you to set a new password.

OpenOffice Password Recovery Help. (c) 2007 Intelore.