diff options
| author | Kurt Zenker <kz@openoffice.org> | 2008-03-07 11:13:07 +0000 |
|---|---|---|
| committer | Kurt Zenker <kz@openoffice.org> | 2008-03-07 11:13:07 +0000 |
| commit | ac14e9f39638b04aacc288c7b83e1df7388c35e4 (patch) | |
| tree | bc51938a235a5a37e3175ba1fc4c0e36be7e7c56 /helpcontent2 | |
| parent | bf19695afdf7b9dcf541a024fc22ea627f4798d6 (diff) | |
INTEGRATION: CWS hcshared17_DEV300 (1.7.92); FILE MERGED
2008/03/04 15:23:58 ufi 1.7.92.1: vor build
Diffstat (limited to 'helpcontent2')
| -rwxr-xr-x | helpcontent2/source/text/scalc/guide/cell_protect.xhp | 110 |
1 files changed, 55 insertions, 55 deletions
diff --git a/helpcontent2/source/text/scalc/guide/cell_protect.xhp b/helpcontent2/source/text/scalc/guide/cell_protect.xhp index 719c5e5775..1000642173 100755 --- a/helpcontent2/source/text/scalc/guide/cell_protect.xhp +++ b/helpcontent2/source/text/scalc/guide/cell_protect.xhp @@ -1,14 +1,15 @@ <?xml version="1.0" encoding="UTF-8"?> + <!-- *********************************************************************** * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: cell_protect.xhp,v $ + * $RCSfile: cell_protect.xhp,v $fileonly,v $ * - * $Revision: 1.7 $ + * $Revision: 1.8 $ * - * last change: $Author: vg $ $Date: 2007-02-07 11:29:53 $ + * last change: $Author: kz $ $Date: 2008-03-07 12:13:07 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. @@ -35,19 +36,19 @@ * ************************************************************************ --> - -<helpdocument version="1.0"> + + + <helpdocument version="1.0"> <meta> <topic id="textscalcguidecell_protectxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Protecting Cells from Changes</title> +<title xml-lang="en-US" id="tit">Protecting Cells from Changes</title> <filename>/text/scalc/guide/cell_protect.xhp</filename> </topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2006-12-04T11:33:31">FPE: Changed table to numbered list, cleanup deleted screenshot; dedr: reviewed</lastedited> -</history> </meta> <body> + + + <bookmark xml-lang="en-US" branch="index" id="bm_id3146119"><bookmark_value>protecting;cells and sheets</bookmark_value> <bookmark_value>cells; protecting</bookmark_value> <bookmark_value>cell protection; enabling</bookmark_value> @@ -57,50 +58,49 @@ <bookmark_value>changing; sheet protection</bookmark_value> <bookmark_value>hiding;formulas</bookmark_value> <bookmark_value>formulas;hiding</bookmark_value> -</bookmark><comment>MW transferred "modifying;..." and "changing;..." into one index entry</comment> -<paragraph role="heading" id="hd_id3146119" xml-lang="en-US" level="1" l10n="U" oldref="5"><variable id="cell_protect"><link href="text/scalc/guide/cell_protect.xhp" name="Protecting Cells from Changes">Protecting Cells from Changes</link> +</bookmark> + <comment>MW transferred "modifying;..." and "changing;..." into one index entry</comment> + <paragraph xml-lang="en-US" id="hd_id3146119" role="heading" level="1" l10n="U" oldref="5"><variable id="cell_protect"><link href="text/scalc/guide/cell_protect.xhp" name="Protecting Cells from Changes">Protecting Cells from Changes</link> </variable></paragraph> -<paragraph role="paragraph" id="par_id3154013" xml-lang="en-US" l10n="CHG" oldref="19">%PRODUCTNAME provides several options to protect the data in a spreadsheet.</paragraph> -<list type="unordered"> -<listitem> -<paragraph role="paragraph" id="par_idN1070B" xml-lang="en-US" l10n="NEW">You can protect the cell contents and formats from changes. </paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_idN1070F" xml-lang="en-US" l10n="NEW">You can protect the spreadsheet structure from changes, for example the count, names, and order of the sheets.</paragraph> -</listitem> -</list> -<list type="ordered"> -<listitem> -<paragraph role="paragraph" id="par_idN1066B" xml-lang="en-US" l10n="NEW">Select the cells that you want to specify the cell protection options for.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id3149019" xml-lang="en-US" l10n="U" oldref="7">Choose <item type="menuitem">Format - Cells</item> and click the <emph>Cell Protection</emph> tab.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id3152985" xml-lang="en-US" l10n="U" oldref="9">Select the protection options that you want.</paragraph> -<paragraph role="paragraph" id="par_id3152898" xml-lang="en-US" l10n="U" oldref="10">Select <emph>Protected</emph> to prevent changes to the contents and the format of a cell. </paragraph> -<paragraph role="paragraph" id="par_idN1069A" xml-lang="en-US" l10n="NEW">Select <emph>Hide formula</emph> to hide and to protect formulas from changes.</paragraph> -<paragraph role="paragraph" id="par_idN106A1" xml-lang="en-US" l10n="NEW">Select <emph>Hide when printing</emph> to hide protected cells in the printed document. The cells are not hidden onscreen.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id3152872" xml-lang="en-US" l10n="U" oldref="11">Click <emph>OK</emph>.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id3145362" xml-lang="en-US" l10n="U" oldref="12">Apply the protection options.</paragraph> -<paragraph role="paragraph" id="par_idN106C0" xml-lang="en-US" l10n="NEW">To protect the cells from being changed / viewed / printed according to your settings in the <emph>Format - Cells</emph> dialog, choose <item type="menuitem">Tools - Protect Document - Sheet</item>.</paragraph> -<paragraph role="paragraph" id="par_idN106C7" xml-lang="en-US" l10n="CHG">To protect the structure of the document, for example the count, <link href="text/scalc/guide/rename_table.xhp">names</link>, and order of the sheets, from being changed, choose <item type="menuitem">Tools - Protect Document - Document</item>.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_idN106CF" xml-lang="en-US" l10n="NEW">(Optional) Enter a password.</paragraph> -<paragraph role="warning" id="par_idN106D2" xml-lang="en-US" l10n="NEW">If you forget your password, you cannot deactivate the protection. If you only want to protect cells from accidental changes, set the sheet protection, but do not enter a password.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id3153810" xml-lang="en-US" l10n="U" oldref="13">Click <emph>OK</emph>. </paragraph> -</listitem> -</list> -<section id="relatedtopics"> -<embed href="text/scalc/guide/cell_unprotect.xhp#cell_unprotect"/> -<embed href="text/shared/guide/protection.xhp#protection"/> -</section> -</body> + <paragraph xml-lang="en-US" id="par_id3153368" role="paragraph" l10n="U" oldref="17">In <item type="productname">%PRODUCTNAME</item> 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.</paragraph> + <paragraph xml-lang="en-US" id="par_id3145261" role="paragraph" l10n="U" oldref="18">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.</paragraph> + <paragraph xml-lang="en-US" id="par_id3148576" role="paragraph" l10n="U" oldref="19">Note that the cell protection for cells with the <emph>Protected</emph> attribute is only effective when you protect the whole table. In the default condition, every cell has the <emph>Protected</emph> attribute. Therefore you must remove the attribute selectively for those cells where the user may make changes. You then protect the whole table and save the document.</paragraph> + <paragraph xml-lang="en-US" id="par_id5974303" role="warning" l10n="NEW">These protection features are just switches to prevent accidental action. The features are not intended to provide any secure protection. For example, by exporting a sheet to another file format, a user may be able to surpass the protection features. There is only one secure protection: the password that you can apply when saving an OpenDocument file. A file that has been saved with a password can be opened only with the same password.</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_idN1066B" role="paragraph" l10n="NEW">Select the cells that you want to specify the cell protection options for.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3149019" role="paragraph" l10n="U" oldref="7">Choose <item type="menuitem">Format - Cells</item> and click the <emph>Cell Protection</emph> tab.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3152985" role="paragraph" l10n="U" oldref="9">Select the protection options that you want.</paragraph> + <paragraph xml-lang="en-US" id="par_id3152898" role="paragraph" l10n="U" oldref="10">Select <emph>Protected</emph> to prevent changes to the contents and the format of a cell. </paragraph> + <paragraph xml-lang="en-US" id="par_idN1069A" role="paragraph" l10n="NEW">Select <emph>Hide formula</emph> to hide and to protect formulas from changes.</paragraph> + <paragraph xml-lang="en-US" id="par_idN106A1" role="paragraph" l10n="NEW">Select <emph>Hide when printing</emph> to hide protected cells in the printed document. The cells are not hidden onscreen.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3152872" role="paragraph" l10n="U" oldref="11">Click <emph>OK</emph>.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3145362" role="paragraph" l10n="U" oldref="12">Apply the protection options.</paragraph> + <paragraph xml-lang="en-US" id="par_idN106C0" role="paragraph" l10n="NEW">To protect the cells from being changed / viewed / printed according to your settings in the <emph>Format - Cells</emph> dialog, choose <item type="menuitem">Tools - Protect Document - Sheet</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_idN106C7" role="paragraph" l10n="CHG">To protect the structure of the document, for example the count, <link href="text/scalc/guide/rename_table.xhp">names</link>, and order of the sheets, from being changed, choose <item type="menuitem">Tools - Protect Document - Document</item>.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_idN106CF" role="paragraph" l10n="NEW">(Optional) Enter a password of at least 5 characters.</paragraph> + <paragraph xml-lang="en-US" id="par_idN106D2" role="warning" l10n="NEW">If you forget your password, you cannot deactivate the protection. If you only want to protect cells from accidental changes, set the sheet protection, but do not enter a password.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3153810" role="paragraph" l10n="U" oldref="13">Click <emph>OK</emph>. </paragraph> + </listitem> + </list> + <section id="relatedtopics"> + + <embed href="text/scalc/guide/cell_unprotect.xhp#cell_unprotect"/> + <embed href="text/shared/guide/protection.xhp#protection"/> + <paragraph xml-lang="en-US" id="par_idN10B8C" role="paragraph" l10n="NEW"> <embedvar href="text/shared/guide/digital_signatures.xhp#digital_signatures"/> </paragraph> + + </section> + </body> </helpdocument> |