https://neowiki.neooffice.org/index.php?title=Protecting_a_Document%2C_a_Sheet_or_Cells_in_Calc&action=history&feed=atom
Protecting a Document, a Sheet or Cells in Calc - Revision history
2024-03-29T15:16:44Z
Revision history for this page on the wiki
MediaWiki 1.10.1
https://neowiki.neooffice.org/index.php?title=Protecting_a_Document%2C_a_Sheet_or_Cells_in_Calc&diff=15927&oldid=prev
Sardisson: clarify this is about protecting contents from modification, not requiring password for opening
2010-02-23T20:14:39Z
<p>clarify this is about protecting contents from modification, not requiring password for opening</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 20:14, 23 February 2010</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">'''Please note that this article is about protecting the contents of a Calc document from being modified.''' If you want to require a password in order to ''open'' a document (e.g., Writer, Calc, or Impress), choose {{menu|Save As…}} from the {{menu|File}} menu and check the {{prefName|Save with password}} checkbox.</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">NeoOffice allows you to protect a document, a sheet, or individual cells in a Calc document. These three types of protection are different<br></td><td> </td><td style="background: #eee; font-size: smaller;">NeoOffice allows you to protect a document, a sheet, or individual cells in a Calc document. These three types of protection are different<br></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Whatever type of protection you need, you have to enter a password to activate and deactivate it.</td><td> </td><td style="background: #eee; font-size: smaller;">Whatever type of protection you need, you have to enter a password to activate and deactivate it.</td></tr>
<tr><td colspan="2" align="left"><strong>Line 6:</strong></td>
<td colspan="2" align="left"><strong>Line 9:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*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.</td><td> </td><td style="background: #eee; font-size: smaller;">*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.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*The protection of a '''sheet''' prevents <del style="color: red; font-weight: bold; text-decoration: none;">modifiication </del>of the contents and the format of ''all the cells'' of that sheet.<br></td><td>+</td><td style="background: #cfc; font-size: smaller;">*The protection of a '''sheet''' prevents <ins style="color: red; font-weight: bold; text-decoration: none;">modification </ins>of the contents and the format of ''all the cells'' of that sheet.<br></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*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.</td><td> </td><td style="background: #eee; font-size: smaller;">*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.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">**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}}.</td><td> </td><td style="background: #eee; font-size: smaller;">**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}}.</td></tr>
</table>
Sardisson
https://neowiki.neooffice.org/index.php?title=Protecting_a_Document%2C_a_Sheet_or_Cells_in_Calc&diff=12727&oldid=prev
Valterb: botlangbar -> IT
2007-11-18T22:11:59Z
<p>botlangbar -> IT</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 22:11, 18 November 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 28:</strong></td>
<td colspan="2" align="left"><strong>Line 28:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">* 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}}.</td><td> </td><td style="background: #eee; font-size: smaller;">* 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}}.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">{{botlangbarEN|[[Fr:Protéger un Document, une Feuille ou des Cellules dans Calc|Français]]}}</td><td>+</td><td style="background: #cfc; font-size: smaller;">{{botlangbarEN|[[Fr:Protéger un Document, une Feuille ou des Cellules dans Calc|Français<ins style="color: red; font-weight: bold; text-decoration: none;">]] [[It:Proteggere_un_documento._un_foglio_o_una_cella_in_Calc|Italiano</ins>]]}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]]</td><td> </td><td style="background: #eee; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]]</td></tr>
</table>
Valterb
https://neowiki.neooffice.org/index.php?title=Protecting_a_Document%2C_a_Sheet_or_Cells_in_Calc&diff=12719&oldid=prev
Lorinda: some polish; remove fixme
2007-11-17T15:58:03Z
<p>some polish; remove fixme</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 15:58, 17 November 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">{{fixme}}</del></td><td>+</td><td style="background: #cfc; font-size: smaller;">NeoOffice allows you to protect a document, a sheet<ins style="color: red; font-weight: bold; text-decoration: none;">, </ins>or individual cells in a Calc document. These three types of protection are different<br></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">NeoOffice allows you to protect a document, a sheet or individual cells in a Calc document. These three types of protection are different<br></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Whatever type of protection you need, you have to enter a password to activate and deactivate it.</td><td> </td><td style="background: #eee; font-size: smaller;">Whatever type of protection you need, you have to enter a password to activate and deactivate it.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:'''If you forget your password, you will not be able to deactivate that protection.'''</td><td> </td><td style="background: #eee; font-size: smaller;">:'''If you forget your password, you will not be able to deactivate that protection.'''</td></tr>
<tr><td colspan="2" align="left"><strong>Line 6:</strong></td>
<td colspan="2" align="left"><strong>Line 5:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Protecting a Document or a Sheet==</td><td> </td><td style="background: #eee; font-size: smaller;">==Protecting a Document or a Sheet==</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*The protection of the document prevents the <del style="color: red; font-weight: bold; text-decoration: none;">sheet '</del>''structure<del style="color: red; font-weight: bold; text-decoration: none;">'</del>'' of the document from modifications. For example, it is impossible to move, delete, insert or rename the sheets. But you can edit them.</td><td>+</td><td style="background: #cfc; font-size: smaller;">*The protection of the <ins style="color: red; font-weight: bold; text-decoration: none;">'''</ins>document<ins style="color: red; font-weight: bold; text-decoration: none;">''' </ins>prevents the ''<ins style="color: red; font-weight: bold; text-decoration: none;">sheet </ins>structure'' of the document from modifications. For example, it is impossible to move, delete, insert or rename the sheets. But you can edit them.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*The protection of a sheet prevents the contents and the format of <del style="color: red; font-weight: bold; text-decoration: none;">'</del>''all the cells<del style="color: red; font-weight: bold; text-decoration: none;">'</del>'' of that sheet <del style="color: red; font-weight: bold; text-decoration: none;">from being modified</del>.<br></td><td>+</td><td style="background: #cfc; font-size: smaller;">*The protection of a <ins style="color: red; font-weight: bold; text-decoration: none;">'''</ins>sheet<ins style="color: red; font-weight: bold; text-decoration: none;">''' </ins>prevents <ins style="color: red; font-weight: bold; text-decoration: none;">modifiication of </ins>the contents and the format of ''all the cells'' of that sheet.<br></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*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.</td><td> </td><td style="background: #eee; font-size: smaller;">*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.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">**To protect the document, choose the {{menu|Tools}} menu, then the {{menu|Protect Document}} submenu and select {{menu|Document…}}. </td><td>+</td><td style="background: #cfc; font-size: smaller;">**To protect the document, choose the {{menu|Tools}} menu, then the {{menu|Protect Document}} submenu and select {{menu|Document…<ins style="color: red; font-weight: bold; text-decoration: none;">}}. In the window that appears, enter a password and confirm it. Click {{button|OK</ins>}}.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">**To activate the protection of a sheet, choose the {{menu|Tools}} menu, then the {{menu|Protect Document}} submenu and select {{menu|Sheet…}}. </td><td>+</td><td style="background: #cfc; font-size: smaller;">**To activate the protection of a sheet, choose the {{menu|Tools}} menu, then the {{menu|Protect Document}} submenu and select {{menu|Sheet…<ins style="color: red; font-weight: bold; text-decoration: none;">}}. In the window that appears, enter a password and confirm it. Click {{button|OK</ins>}}.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Protecting Individual Cells==</td><td> </td><td style="background: #eee; font-size: smaller;">==Protecting Individual Cells==</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">Sometimes, you want to protect only <del style="color: red; font-weight: bold; text-decoration: none;">some </del>cells in a sheet while <del style="color: red; font-weight: bold; text-decoration: none;">being able </del>to <del style="color: red; font-weight: bold; text-decoration: none;">keep on modifying the others</del>. In this case, the method is a bit more complex.</td><td>+</td><td style="background: #cfc; font-size: smaller;">Sometimes, you want to protect only <ins style="color: red; font-weight: bold; text-decoration: none;">certain </ins>cells in a sheet while <ins style="color: red; font-weight: bold; text-decoration: none;">allowing others </ins>to <ins style="color: red; font-weight: bold; text-decoration: none;">be modified</ins>. In this case, the method is a bit more complex.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*Select the whole sheet <del style="color: red; font-weight: bold; text-decoration: none;">which contains </del>the cells to be protected, by pressing {{key|Command-A}}.</td><td>+</td><td style="background: #cfc; font-size: smaller;">*Select the whole sheet <ins style="color: red; font-weight: bold; text-decoration: none;">containing </ins>the cells to be protected, by pressing {{key|Command-A}}.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Go to the {{menu|Format}} menu, and click on {{menu|Cells…}}.</td><td> </td><td style="background: #eee; font-size: smaller;">*Go to the {{menu|Format}} menu, and click on {{menu|Cells…}}.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*In the{{section|Cell Protection}} tab of the {{window|Format Cells}} window which opens, uncheck {{prefName|Protected}}.</td><td>+</td><td style="background: #cfc; font-size: smaller;">*In the {{section|Cell Protection}} tab of the {{window|Format Cells}} window which opens, uncheck {{prefName|Protected}}.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Click {{button|OK}}.</td><td> </td><td style="background: #eee; font-size: smaller;">*Click {{button|OK}}.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Come back into the sheet which contains the cells you want to protect, select them. They don't need to be adjacent.</td><td> </td><td style="background: #eee; font-size: smaller;">*Come back into the sheet which contains the cells you want to protect, select them. They don't need to be adjacent.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">* Go to the {{menu|Tools}} menu, choose the {{menu|Protect Document}} sub-menu and click on {{menu|Sheet…}}.</td><td> </td><td style="background: #eee; font-size: smaller;">* Go to the {{menu|Tools}} menu, choose the {{menu|Protect Document}} sub-menu and click on {{menu|Sheet…}}.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*Enter a password and <del style="color: red; font-weight: bold; text-decoration: none;"> </del>confirm it. Click {{button|OK}}.</td><td>+</td><td style="background: #cfc; font-size: smaller;">*Enter a password and confirm it. Click {{button|OK}}.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Go to the {{menu|Format}} menu, then click on {{menu|Cells…}}.</td><td> </td><td style="background: #eee; font-size: smaller;">*Go to the {{menu|Format}} menu, then click on {{menu|Cells…}}.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*In the {{section|Cell Protection}} tab, in the {{window|Format Cells}} window, check {{prefName|Protected}}.</td><td> </td><td style="background: #eee; font-size: smaller;">*In the {{section|Cell Protection}} tab, in the {{window|Format Cells}} window, check {{prefName|Protected}}.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*:'''Note''' : you can protect both document and sheets or document and individual cells.</td><td>+</td><td style="background: #cfc; font-size: smaller;">*:'''Note''' : you can protect both <ins style="color: red; font-weight: bold; text-decoration: none;">the </ins>document and <ins style="color: red; font-weight: bold; text-decoration: none;">one or more </ins>sheets or <ins style="color: red; font-weight: bold; text-decoration: none;">the </ins>document and individual cells.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Unprotecting document or cells==</td><td> </td><td style="background: #eee; font-size: smaller;">==Unprotecting document or cells==</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*To cancel the protection of the document, go to the {{menu|Tools}} menu. Then in the {{menu|Protect Document}} sub-menu, <del style="color: red; font-weight: bold; text-decoration: none;">remove the check mark of </del>the {{menu|Document…}} item.</td><td>+</td><td style="background: #cfc; font-size: smaller;">*To cancel the protection of the document, go to the {{menu|Tools}} menu. Then in the {{menu|Protect Document}} sub-menu, <ins style="color: red; font-weight: bold; text-decoration: none;">select </ins>the {{menu|Document…}} item<ins style="color: red; font-weight: bold; text-decoration: none;">. A window will appear asking for the password in order to unprotect the document. Enter the password and click {{Button|OK}}</ins>.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">* 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.</td><td>+</td><td style="background: #cfc; font-size: smaller;">* 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<ins style="color: red; font-weight: bold; text-decoration: none;">. A window will appear asking for the password in order to unprotect the sheet. Enter the password and click {{Button|OK}}</ins>.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Protéger un Document, une Feuille ou des Cellules dans Calc|Français]]}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Protéger un Document, une Feuille ou des Cellules dans Calc|Français]]}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]]</td><td> </td><td style="background: #eee; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]]</td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Protecting_a_Document%2C_a_Sheet_or_Cells_in_Calc&diff=12711&oldid=prev
Jgd: translation of the French page Fr:Protéger un Document, une Feuille ou des Cellules dans Calc|
2007-11-17T09:22:34Z
<p>translation of the French page Fr:Protéger un Document, une Feuille ou des Cellules dans Calc|</p>
<p><b>New page</b></p><div>{{fixme}}<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><br />
Whatever type of protection you need, you have to enter a password to activate and deactivate it.<br />
:'''If you forget your password, you will not be able to deactivate that protection.'''<br />
<br />
==Protecting a Document or a Sheet==<br />
<br />
*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.<br />
*The protection of a sheet prevents the contents and the format of '''all the cells''' of that sheet from being modified.<br><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.<br />
**To protect the document, choose the {{menu|Tools}} menu, then the {{menu|Protect Document}} submenu and select {{menu|Document…}}. <br />
**To activate the protection of a sheet, choose the {{menu|Tools}} menu, then the {{menu|Protect Document}} submenu and select {{menu|Sheet…}}. <br />
<br />
==Protecting Individual Cells==<br />
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.<br />
*Select the whole sheet which contains the cells to be protected, by pressing {{key|Command-A}}.<br />
*Go to the {{menu|Format}} menu, and click on {{menu|Cells…}}.<br />
*In the{{section|Cell Protection}} tab of the {{window|Format Cells}} window which opens, uncheck {{prefName|Protected}}.<br />
*Click {{button|OK}}.<br />
*Come back into the sheet which contains the cells you want to protect, select them. They don't need to be adjacent.<br />
* Go to the {{menu|Tools}} menu, choose the {{menu|Protect Document}} sub-menu and click on {{menu|Sheet…}}.<br />
*Enter a password and confirm it. Click {{button|OK}}.<br />
*Go to the {{menu|Format}} menu, then click on {{menu|Cells…}}.<br />
*In the {{section|Cell Protection}} tab, in the {{window|Format Cells}} window, check {{prefName|Protected}}.<br />
*:'''Note''' : you can protect both document and sheets or document and individual cells.<br />
<br />
==Unprotecting document or cells==<br />
*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.<br />
* 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.<br />
<br />
{{botlangbarEN|[[Fr:Protéger un Document, une Feuille ou des Cellules dans Calc|Français]]}}<br />
[[Category:Tips and Hints]][[Category:NeoOffice]]</div>
Jgd