tdf#141766 Update cell protection Help page

Add new options available since LO 5.4

Change-Id: I1b283d5f4b6d43ed4167cbbbee969406935913bd
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/114668
Tested-by: Jenkins
Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>

3 files changed, 72 insertions, 19 deletions

diff --git a/source/text/scalc/00/00000402.xhp b/source/text/scalc/00/00000402.xhp
index bf8ddefe98..ecea06ff02 100644
--- a/source/text/scalc/00/00000402.xhp
+++ b/source/text/scalc/00/00000402.xhp
@@ -51,5 +51,8 @@
 <paragraph id="par_id3146119" role="paragraph" xml-lang="en-US">Choose <emph>Sheet - Move or Copy Sheet</emph>.</paragraph>
 <paragraph id="par_id3148645" role="paragraph" xml-lang="en-US">Open context menu for a sheet tab.</paragraph>
 </section>
+<section id="cellprotection">
+    <paragraph role="paragraph" id="par_id831619443265443">Choose <menuitem>Edit - Cell Protection</menuitem> to activate sheet protection with current cell protection settings.</paragraph>
+</section>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/06060100.xhp b/source/text/scalc/01/06060100.xhp
index 50222fbb20..5ed52eec56 100644
--- a/source/text/scalc/01/06060100.xhp
+++ b/source/text/scalc/01/06060100.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,7 +16,6 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-
 <helpdocument version="1.0">
 <meta>
 <topic id="textscalc0106060100xml" indexer="include" status="PUBLISH">
@@ -30,12 +27,55 @@
 <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/protectsheetdlg/ProtectSheetDialog" id="bm_id3148919" localize="false"/>
 <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/protectsheetdlg/@@nowidget@@" id="bm_id3148919" localize="false"/>
 <bookmark xml-lang="en-US" branch="hid/.uno:Protect" id="bm_id3156326" localize="false"/>
-<paragraph role="heading" id="hd_id3153087" xml-lang="en-US" level="1">Protecting Sheet</paragraph>
-<paragraph role="paragraph" id="par_id3148664" xml-lang="en-US"><variable id="tabelletext"><ahelp hid=".uno:Protect">Protects the cells in the current sheet from being modified.</ahelp></variable> Choose <emph>Tools - Protect Sheet</emph> to open the <emph>Protect Sheet</emph> dialog in which you then specify sheet protection with or without a password.</paragraph>
+<bookmark xml-lang="en-US" branch="index" id="bm_id141619439455954">
+<bookmark_value>insert rows;protected sheet</bookmark_value>
+<bookmark_value>insert columns;protected sheet</bookmark_value>
+<bookmark_value>delete columns;protected sheet</bookmark_value>
+<bookmark_value>delete rows;protected sheet</bookmark_value>
+<bookmark_value>protected sheet;insert columns</bookmark_value>
+<bookmark_value>protected sheet;insert rows</bookmark_value>
+<bookmark_value>protected sheet;delete rows</bookmark_value>
+<bookmark_value>protected sheet;delete columns</bookmark_value>
+<bookmark_value>protect;sheet</bookmark_value>
+<bookmark_value>selection;in protected cells</bookmark_value>
+</bookmark>
+<h1 id="hd_id3153087"><variable id="ProtectingSheeth1"><link href="text/scalc/01/06060100.xhp" name="Protecting Sheet">Protecting Sheet</link></variable></h1>
+<paragraph role="paragraph" id="par_id3148664" xml-lang="en-US"><variable id="tabelletext"><ahelp hid=".uno:Protect">Protects the cells in the current sheet from being modified.</ahelp></variable></paragraph>
+<paragraph role="paragraph" id="par_id701619429750616">Choose <emph>Tools - Protect Sheet</emph> to open the <emph>Protect Sheet</emph> dialog in which you then specify sheet protection with or without a password, and select the elements of the sheet to protect.</paragraph>
 <section id="howtoget">
   <embed href="text/scalc/00/00000406.xhp#protect_sheet"/>
+  <embed href="text/scalc/00/00000402.xhp#cellprotection"/>
 </section>
-<paragraph role="warning" id="par_id3149664" xml-lang="en-US">To protect cells from further editing, the <emph>Protected</emph> check box must be checked on the <link href="text/scalc/01/05020600.xhp" name="Format - Cells - Cell Protection"><emph>Format - Cells - Cell Protection</emph></link> tab page or on the <emph>Format Cells</emph> context menu.</paragraph>
+<warning id="par_id3149664">To protect cells from further editing, the <emph>Protected</emph> check box must be checked on the <link href="text/scalc/01/05020600.xhp" name="Format - Cells - Cell Protection"><emph>Format - Cells - Cell Protection</emph></link> tab page or on the <emph>Format Cells</emph> context menu.</warning>
+
+<h2 id="hd_id901619431276995">Protect this sheet and contents of the protected cells</h2>
+<paragraph role="paragraph" id="par_id381619431285815">Mark this checkbox to activate protection of sheet and cell contents.</paragraph>
+<h2 id="hd_id31619431291108">Password / Confirm</h2>
+<paragraph role="paragraph" id="par_id851619431300487">Allows you to enter a password to protect the sheet from unauthorized changes. Confirm the password entered in the first box.</paragraph>
+<h2 id="hd_id711619431316966">Allow users of this sheet to</h2>
+<paragraph role="paragraph" id="par_id41619431361278">Select the elements to protect from user actions:</paragraph>
+<list type="unordered">
+    <listitem>
+        <paragraph id="par_id661619430257262"  role="listitem"><emph>Select protected cells</emph>: mark this checkbox to allow you to select protected cells. When the checkbox is unmarked, you cannot select protected cells, the cursor cannot enter in a protected range.</paragraph>
+    </listitem>
+    <listitem>
+        <paragraph id="par_id921619430295947"  role="listitem"><emph>Select unprotected cells</emph>: mark this checkbox to allow user to select unprotected cells. When the checkbox is unmarked, user cannot select unprotected cells, the cursor cannot enter in a unprotected cell or range.</paragraph>
+    </listitem>
+    <listitem>
+        <paragraph id="par_id101619430333784"  role="listitem"><emph>Insert columns</emph>: Allow column insertions even when the sheet is protected. Note that when column insertions is enabled, you can insert columns even when the range to insert the new columns into contains protected cells which will get shifted after the insertion. Cells of the newly inserted columns inherit the Protection property of the range it belongs: when the new cell is inside a protected range, the cell is protected, and when it is in an unprotected range, the cell is unprotected.</paragraph>
+    </listitem>
+    <listitem>
+        <paragraph id="par_id891619430338809"  role="listitem"><emph>Insert rows</emph>: Allow row insertions even when the sheet is protected. Note that when row insertions is enabled, you can insert rows even when the range to insert the new rows into contains protected cells which will get shifted after the insertion. Cells of the newly inserted rows inherit the Protection property of the range it belongs: when the new cell is inside a protected range it is protected, and when it is in an unprotected range, the cell is unprotected.</paragraph>
+    </listitem>
+    <listitem>
+        <paragraph id="par_id311619430374686"  role="listitem"><emph>Delete columns</emph>: Allow column deletions. Note that column deletions are only allowed on unprotected cells.
+            </paragraph>
+    </listitem>
+    <listitem>
+        <paragraph id="par_id561619430376854"  role="listitem"><emph>Delete rows</emph>: Allow row deletions. Note that row deletions are only allowed on unprotected cells.
+            </paragraph>
+    </listitem>
+</list>
 <paragraph role="paragraph" id="par_id3154490">Unprotected cells or cell ranges can be set up on a protected sheet by using the <emph>Tools - Protect Sheet</emph> and <emph>Format - Cells - Cell Protection</emph> menus: </paragraph>
 <list type="ordered">
 <listitem>
@@ -45,16 +85,25 @@
 <paragraph role="paragraph" id="par_id3150329" xml-lang="en-US">Select <emph>Format - Cells - Cell Protection</emph>. Unmark the <emph>Protected</emph> box and click <emph>OK</emph>.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="paragraph" id="par_id3156384" xml-lang="en-US">On the <emph>Tools - Protect Sheet</emph> menu, activate protection for the sheet. Effective immediately, only the cell range you selected in step 1 can be edited.</paragraph>
+    <paragraph role="paragraph" id="par_id3156384" xml-lang="en-US">On the <emph>Tools - Protect Sheet</emph> menu, activate protection for the sheet. Effective immediately, only the cell range you selected in step 1 can be edited.</paragraph>
 </listitem>
 </list>
-<paragraph role="paragraph" id="par_id3149566" xml-lang="en-US">To later change an unprotected area to a protected area, select the range. Next, on the <emph>Format - Cells - Cell Protection</emph> tab page, check the <emph>Protected</emph> box. Finally, choose the <emph>Tools - Protect Sheet</emph> menu. The previously editable range is now protected.</paragraph>
+<paragraph role="paragraph" id="par_id3149566" xml-lang="en-US">To later change an unprotected area to a protected area:</paragraph>
+    <list type="ordered">
+        <listitem>
+            <paragraph id="par_id101619439013221"  role="listitem">Select the range of cells that will be protected.</paragraph>
+        </listitem>
+        <listitem>
+            <paragraph id="par_id601619439028536"  role="listitem">On the <menuitem>Format - Cells - Cell Protection</menuitem> tab page, check the <emph>Protected</emph> box. </paragraph>
+        </listitem>
+        <listitem>
+            <paragraph id="par_id641619439061892"  role="listitem">Choose the <menuitem>Tools - Protect Sheet</menuitem> menu. The previously editable range is now protected.</paragraph>
+        </listitem>
+    </list>
 <paragraph role="paragraph" id="par_id3153964" xml-lang="en-US">Sheet protection also affects the context menu of the sheet tabs at the bottom of the screen. The <emph>Delete</emph> and <emph>Rename</emph> commands cannot be selected.</paragraph>
 <paragraph role="paragraph" id="par_id3150301" xml-lang="en-US">If a sheet is protected, you will not be able to modify or delete any Cell Styles.</paragraph>
-<paragraph role="paragraph" id="par_id3154656" xml-lang="en-US">A protected sheet or cell range can no longer be modified until this protection is disabled. To disable the protection, choose the <emph>Tools - Protect Sheet</emph> command. If no password was set, the sheet protection is immediately disabled. If the sheet was password protected, the <emph>Remove Protection</emph> dialog opens, where you must enter the password.</paragraph>
+<paragraph role="paragraph" id="par_id3154656" xml-lang="en-US">A protected sheet or cell range can no longer be modified until this protection is disabled, with the exceptions of the settings for columns and row of the <menuitem>Tools - Protect Sheet</menuitem> dialog. To disable the protection, choose the <menuitem>Tools - Protect Sheet</menuitem> command. If no password was set, the sheet protection is immediately disabled. If the sheet was password protected, the <emph>Remove Protection</emph> dialog opens, where you must enter the password.</paragraph>
 <paragraph role="paragraph" id="par_id3149815" xml-lang="en-US">Once saved, protected sheets can only be saved again by using the <emph>File - Save As</emph> command.</paragraph>
-<paragraph role="heading" id="hd_id3150206" xml-lang="en-US" level="2"><link href="text/shared/01/password_dlg.xhp" name="Password">Password (optional)</link></paragraph>
-<paragraph role="paragraph" id="par_id3152990" xml-lang="en-US"><ahelp hid="modules/scalc/ui/protectsheetdlg/password1">Allows you to enter a password to protect the sheet from unauthorized changes.</ahelp></paragraph>
-<paragraph role="note" id="par_id3148700" xml-lang="en-US">Complete protection of your work can be achieved by combining the options <emph>Tools - Protect Sheet</emph> and <emph>Tools - Protect Spreadsheet Structure</emph>, including password protection. To prohibit opening the document altogether, in the <emph>Save</emph> dialog mark the <emph>Save with password</emph> box before you click the <emph>Save</emph> button.</paragraph>
+<note id="par_id3148700">Complete protection of your work can be achieved by combining the options <emph>Tools - Protect Sheet</emph> and <emph>Tools - Protect Spreadsheet Structure</emph>, including password protection. To prohibit opening the document altogether, in the <emph>Save</emph> dialog mark the <emph>Save with password</emph> box before you click the <emph>Save</emph> button.</note>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/guide/cell_protect.xhp b/source/text/scalc/guide/cell_protect.xhp
index eefb72d581..6cb10c7223 100644
--- a/source/text/scalc/guide/cell_protect.xhp
+++ b/source/text/scalc/guide/cell_protect.xhp
@@ -38,12 +38,12 @@
       <bookmark_value>formulas;hiding</bookmark_value>
 </bookmark>
 
-<paragraph xml-lang="en-US" id="hd_id3146119" role="heading" level="1"><variable id="cell_protect"><link href="text/scalc/guide/cell_protect.xhp" name="Protecting Cells from Changes">Protecting Cells from Changes</link>
-</variable></paragraph>
+<h1 id="hd_id3146119"><variable id="cell_protect"><link href="text/scalc/guide/cell_protect.xhp" name="Protecting Cells from Changes">Protecting Cells from Changes</link>
+</variable></h1>
       <paragraph xml-lang="en-US" id="par_id3153368" role="paragraph">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">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">Note that the cell protection for cells with the <emph>Protected</emph> attribute is only effective when you protect the whole sheet. 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 sheet and save the document.</paragraph>
-      <paragraph xml-lang="en-US" id="par_id5974303" role="warning">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>
+      <warning id="par_id5974303">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.</warning>
       <list type="ordered">
          <listitem>
             <paragraph xml-lang="en-US" id="par_idN1066B" role="listitem">Select the cells that you want to specify the cell protection options for.</paragraph>
@@ -53,7 +53,7 @@
          </listitem>
          <listitem>
             <paragraph xml-lang="en-US" id="par_id3152985" role="listitem">Select the protection options that you want. All options will be applied only after you protect the sheet from the Tools menu - see below.</paragraph>
-                        <paragraph xml-lang="en-US" id="par_id31529866655" role="listitem">Uncheck <emph>Protected</emph> to allow the user to change the currently selected cells.</paragraph>
+            <paragraph xml-lang="en-US" id="par_id31529866655" role="listitem">Uncheck <emph>Protected</emph> to allow the user to change the currently selected cells.</paragraph>
             <paragraph xml-lang="en-US" id="par_id3152898" role="listitem">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="listitem">Select <emph>Hide formula</emph> to hide and to protect formulas from changes.</paragraph>
             <paragraph xml-lang="en-US" id="par_idN106A1" role="listitem">Select <emph>Hide when printing</emph> to hide protected cells in the printed document. The cells are not hidden onscreen.</paragraph>
@@ -63,18 +63,19 @@
          </listitem>
          <listitem>
             <paragraph xml-lang="en-US" id="par_id3145362" role="listitem">Apply the protection options.</paragraph>
-            <paragraph xml-lang="en-US" id="par_idN106C0" role="listitem">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 Sheet</item>.</paragraph>
+            <paragraph xml-lang="en-US" id="par_idN106C0" role="listitem">To protect the cells from being changed, viewed or printed according to your settings in the <emph>Format - Cells</emph> dialog, choose <link href="text/scalc/01/06060100.xhp" name="Tools protect sheet"><menuitem>Tools - Protect Sheet</menuitem></link>.</paragraph>
             <paragraph xml-lang="en-US" id="par_idN106C7" role="listitem">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 Spreadsheet Structure</item>.</paragraph>
          </listitem>
          <listitem>
             <paragraph xml-lang="en-US" id="par_idN106CF" role="listitem">(Optional) Enter a password.</paragraph>
-            <paragraph xml-lang="en-US" id="par_idN106D2" role="warning">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>
+            <warning id="par_idN106D2">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.</warning>
          </listitem>
          <listitem>
-            <paragraph xml-lang="en-US" id="par_id3153810" role="listitem">Click <emph>OK</emph>. </paragraph>
+            <paragraph xml-lang="en-US" id="par_id3153810" role="listitem">Click <emph>OK</emph>.</paragraph>
          </listitem>
       </list>
       <section id="relatedtopics">
+          <embed href="text/scalc/01/06060100.xhp#ProtectingSheeth1"/>
          <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" localize="false">