Protecting a Document, a Sheet or Cells in Calc

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 09:22, 17 November 2007 (edit)
Jgd (Talk | contribs)
(translation of the French page Fr:Protéger un Document, une Feuille ou des Cellules dans Calc|)
← Previous diff		 Revision as of 15:58, 17 November 2007 (edit) (undo)
Lorinda (Talk | contribs)
(some polish; remove fixme)
Next diff →
Line 1: Line 1:
-{{fixme}}+NeoOffice allows you to protect a document, a sheet, or individual cells in a Calc document. These three types of protection are different<br>
-NeoOffice allows you to protect a document, a sheet or individual cells in a Calc document. These three types of protection are different<br>+
Whatever type of protection you need, you have to enter a password to activate and deactivate it. Whatever type of protection you need, you have to enter a password to activate and deactivate it.
:'''If you forget your password, you will not be able to deactivate that protection.''' :'''If you forget your password, you will not be able to deactivate that protection.'''
Line 6: Line 5:
==Protecting a Document or a Sheet== ==Protecting a Document or a Sheet==
-*The protection of the document prevents the sheet '''structure''' of the document from modifications. For example, it is impossible to move, delete, insert or rename the sheets. But you can edit them.+*The protection of the '''document''' prevents the ''sheet structure'' of the document from modifications. For example, it is impossible to move, delete, insert or rename the sheets. But you can edit them.
-*The protection of a sheet prevents the contents and the format of '''all the cells''' of that sheet from being modified.<br>+*The protection of a '''sheet''' prevents modifiication of the contents and the format of ''all the cells'' of that sheet.<br>
*If you select the {{menu|Format}} menu, then the {{menu|Cells…}} item, and if you click on the {{prefName|Cell Protection}} tab, you notice that the {{prefName|Protected}} box in the {{section|Protection}} section is checked by default. If you want to protect a document or a sheet, don't modify that option. *If you select the {{menu|Format}} menu, then the {{menu|Cells…}} item, and if you click on the {{prefName|Cell Protection}} tab, you notice that the {{prefName|Protected}} box in the {{section|Protection}} section is checked by default. If you want to protect a document or a sheet, don't modify that option.
-**To protect the document, choose the {{menu|Tools}} menu, then the {{menu|Protect Document}} submenu and select {{menu|Document…}}. +**To protect the document, choose the {{menu|Tools}} menu, then the {{menu|Protect Document}} submenu and select {{menu|Document…}}. In the window that appears, enter a password and confirm it. Click {{button|OK}}.
-**To activate the protection of a sheet, choose the {{menu|Tools}} menu, then the {{menu|Protect Document}} submenu and select {{menu|Sheet…}}. +**To activate the protection of a sheet, choose the {{menu|Tools}} menu, then the {{menu|Protect Document}} submenu and select {{menu|Sheet…}}. In the window that appears, enter a password and confirm it. Click {{button|OK}}.
==Protecting Individual Cells== ==Protecting Individual Cells==
-Sometimes, you want to protect only some cells in a sheet while being able to keep on modifying the others. In this case, the method is a bit more complex.+Sometimes, you want to protect only certain cells in a sheet while allowing others to be modified. In this case, the method is a bit more complex.
-*Select the whole sheet which contains the cells to be protected, by pressing {{key|Command-A}}.+*Select the whole sheet containing the cells to be protected, by pressing {{key|Command-A}}.
*Go to the {{menu|Format}} menu, and click on {{menu|Cells…}}. *Go to the {{menu|Format}} menu, and click on {{menu|Cells…}}.
-*In the{{section|Cell Protection}} tab of the {{window|Format Cells}} window which opens, uncheck {{prefName|Protected}}.+*In the {{section|Cell Protection}} tab of the {{window|Format Cells}} window which opens, uncheck {{prefName|Protected}}.
*Click {{button|OK}}. *Click {{button|OK}}.
*Come back into the sheet which contains the cells you want to protect, select them. They don't need to be adjacent. *Come back into the sheet which contains the cells you want to protect, select them. They don't need to be adjacent.
* Go to the {{menu|Tools}} menu, choose the {{menu|Protect Document}} sub-menu and click on {{menu|Sheet…}}. * Go to the {{menu|Tools}} menu, choose the {{menu|Protect Document}} sub-menu and click on {{menu|Sheet…}}.
-*Enter a password and confirm it. Click {{button|OK}}.+*Enter a password and confirm it. Click {{button|OK}}.
*Go to the {{menu|Format}} menu, then click on {{menu|Cells…}}. *Go to the {{menu|Format}} menu, then click on {{menu|Cells…}}.
*In the {{section|Cell Protection}} tab, in the {{window|Format Cells}} window, check {{prefName|Protected}}. *In the {{section|Cell Protection}} tab, in the {{window|Format Cells}} window, check {{prefName|Protected}}.
-*:'''Note''' : you can protect both document and sheets or document and individual cells.+*:'''Note''' : you can protect both the document and one or more sheets or the document and individual cells.
==Unprotecting document or cells== ==Unprotecting document or cells==
-*To cancel the protection of the document, go to the {{menu|Tools}} menu. Then in the {{menu|Protect Document}} sub-menu, remove the check mark of the {{menu|Document…}} item.+*To cancel the protection of the document, go to the {{menu|Tools}} menu. Then in the {{menu|Protect Document}} sub-menu, select the {{menu|Document…}} item. A window will appear asking for the password in order to unprotect the document. Enter the password and click {{Button|OK}}.
-* To cancel the protection of a sheet or of individual cells in a sheet, go to the sheet which contains them, select the {{menu|Tools}} menu, then the {{menu|Protect Document}}, and remove the check mark of the {{menu|Sheet…}} item.+* To cancel the protection of a sheet or of individual cells in a sheet, go to the sheet which contains them, select the {{menu|Tools}} menu, then the {{menu|Protect Document}}, and remove the check mark of the {{menu|Sheet…}} item. A window will appear asking for the password in order to unprotect the sheet. Enter the password and click {{Button|OK}}.
{{botlangbarEN|[[Fr:Protéger un Document, une Feuille ou des Cellules dans Calc|Français]]}} {{botlangbarEN|[[Fr:Protéger un Document, une Feuille ou des Cellules dans Calc|Français]]}}
[[Category:Tips and Hints]][[Category:NeoOffice]] [[Category:Tips and Hints]][[Category:NeoOffice]]

Revision as of 15:58, 17 November 2007

NeoOffice allows you to protect a document, a sheet, or individual cells in a Calc document. These three types of protection are different
Whatever type of protection you need, you have to enter a password to activate and deactivate it.

If you forget your password, you will not be able to deactivate that protection.

Protecting a Document or a Sheet

  • The protection of the document prevents the sheet structure of the document from modifications. For example, it is impossible to move, delete, insert or rename the sheets. But you can edit them.
  • The protection of a sheet prevents modifiication of the contents and the format of all the cells of that sheet.
  • If you select the Format menu, then the Cells… item, and if you click on the Cell Protection tab, you notice that the Protected box in the Protection section is checked by default. If you want to protect a document or a sheet, don't modify that option.
    • To protect the document, choose the Tools menu, then the Protect Document submenu and select Document…. In the window that appears, enter a password and confirm it. Click OK.
    • To activate the protection of a sheet, choose the Tools menu, then the Protect Document submenu and select Sheet…. In the window that appears, enter a password and confirm it. Click OK.

Protecting Individual Cells

Sometimes, you want to protect only certain cells in a sheet while allowing others to be modified. In this case, the method is a bit more complex.

  • Select the whole sheet containing the cells to be protected, by pressing Command-A.
  • Go to the Format menu, and click on Cells….
  • In the Cell Protection tab of the Format Cells window which opens, uncheck Protected.
  • Click OK.
  • Come back into the sheet which contains the cells you want to protect, select them. They don't need to be adjacent.
  • Go to the Tools menu, choose the Protect Document sub-menu and click on Sheet….
  • Enter a password and confirm it. Click OK.
  • Go to the Format menu, then click on Cells….
  • In the Cell Protection tab, in the Format Cells window, check Protected.
    Note : you can protect both the document and one or more sheets or the document and individual cells.

Unprotecting document or cells

  • To cancel the protection of the document, go to the Tools menu. Then in the Protect Document sub-menu, select the Document… item. A window will appear asking for the password in order to unprotect the document. Enter the password and click OK.
  • To cancel the protection of a sheet or of individual cells in a sheet, go to the sheet which contains them, select the Tools menu, then the Protect Document, and remove the check mark of the Sheet… item. A window will appear asking for the password in order to unprotect the sheet. Enter the password and click OK.


This article in other languages: Français
Retrieved from "https://neowiki.neooffice.org/index.php/Protecting_a_Document%2C_a_Sheet_or_Cells_in_Calc"
Personal tools