tdf#155876 UI cmds Calc-Sheet menu (30)

+ Sheet menu for Calc: clear cells, references, fill
+ refactoring

Change-Id: I0c0c10af4a9983e893907aa5c0a491b5814dae22
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160657
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
(cherry picked from commit 4953ea62c3603c2c3f66faf67dac67ba987476c9)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160638

7 files changed, 162 insertions, 108 deletions

diff --git a/source/text/scalc/00/00000402.xhp b/source/text/scalc/00/00000402.xhp
index 3c71881376..f587341b42 100644
--- a/source/text/scalc/00/00000402.xhp
+++ b/source/text/scalc/00/00000402.xhp
@@ -161,7 +161,11 @@
   <paragraph role="paragraph" id="par_id131697569897269" localize="false"><keycode>F2</keycode></paragraph>
 </section>
 
-<paragraph id="par_id3150443" role="paragraph"><variable id="bausfullen">Choose <emph>Sheet - Fill Cells</emph>.</variable></paragraph>
+<section id="fill_cells">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph id="par_id3150443" role="paragraph"><variable id="bausfullen">Choose <emph>Sheet - Fill Cells</emph>.</variable></paragraph>
+</section>
+
 <paragraph id="par_id3143267" role="paragraph"><variable id="bausunten">Choose <emph>Sheet - Fill Cells - Down</emph>.</variable></paragraph>
 <paragraph id="par_id3153880" role="paragraph"><variable id="bausrechts">Choose <emph>Sheet - Fill Cells - Right</emph>.</variable></paragraph>
 <paragraph id="par_id3151245" role="paragraph"><variable id="bausoben">Choose <emph>Sheet - Fill Cells - Up</emph>.</variable></paragraph>
@@ -170,8 +174,23 @@
 <paragraph id="par_id3154910" role="paragraph"><variable id="bausreihe">Choose <emph>Sheet - Fill Cells - Series</emph>.</variable></paragraph>
 
 <section id="clear_cells">
-<paragraph id="par_id3154123" role="paragraph">Choose <emph>Sheet - Clear Cells</emph>.</paragraph>
-<paragraph id="par_id3145785" role="paragraph">Backspace</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph id="par_id3154123" role="paragraph">Choose <emph>Sheet - Clear Cells</emph>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_context"/>
+  <paragraph role="paragraph" id="par_id281702417873169">Choose <menuitem>Clear Contents</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+  <table id="tab_id291702417761204">
+    <tablerow>
+      <tablecell>
+        <paragraph id="par_id461702417761205" role="paragraph"><image src="cmd/lc_delete.svg" id="img_id371702417761206" width="1cm"  height="1cm"><alt id="alt_id181702417761207">Icon Clear Cells</alt></image></paragraph>
+      </tablecell>
+      <tablecell>
+        <paragraph id="par_id831702417761209" role="paragraph">Clear Cells</paragraph>
+      </tablecell>
+    </tablerow>
+  </table>
+  <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+  <paragraph id="par_id3145785" role="paragraph"><keycode>Backspace</keycode></paragraph>
 </section>
 
 <section id="delete_cells">
diff --git a/source/text/scalc/00/sheet_menu.xhp b/source/text/scalc/00/sheet_menu.xhp
index 7c3f16c683..ca278f7fbf 100644
--- a/source/text/scalc/00/sheet_menu.xhp
+++ b/source/text/scalc/00/sheet_menu.xhp
@@ -33,6 +33,12 @@
   <paragraph role="paragraph" id="par_id491702125833846">Choose <menuitem>Sheet</menuitem>.</paragraph>
 </section>
 
+<section id="cyclereftype">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph role="paragraph" id="par_id981702420507898">Choose <menuitem>Sheet - Cycle Cell Reference Types</menuitem>.</paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+  <paragraph role="paragraph" id="par_id411702420563569" localize="false"><keycode>F4</keycode></paragraph>
+</section>
 <comment>Hide sheet</comment>
 <section id="hidesheet">
   <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
diff --git a/source/text/scalc/01/02140000.xhp b/source/text/scalc/01/02140000.xhp
index b34f0e9a08..2c93bcc03c 100644
--- a/source/text/scalc/01/02140000.xhp
+++ b/source/text/scalc/01/02140000.xhp
@@ -1,66 +1,63 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <helpdocument version="1.0">
-	
-<!--
- * This file is part of the LibreOffice project.
- *
- * This Source Code Form is subject to the terms of the Mozilla Public
- * License, v. 2.0. If a copy of the MPL was not distributed with this
- * file, You can obtain one at http://mozilla.org/MPL/2.0/.
- *
- * This file incorporates work covered by the following license notice:
- *
- *   Licensed to the Apache Software Foundation (ASF) under one or more
- *   contributor license agreements. See the NOTICE file distributed
- *   with this work for additional information regarding copyright
- *   ownership. The ASF licenses this file to you under the Apache
- *   License, Version 2.0 (the "License"); you may not use this file
- *   except in compliance with the License. You may obtain a copy of
- *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
- -->
- 
-	
-<meta>
+
+   <!--
+   * This file is part of the LibreOffice project.
+   *
+   * This Source Code Form is subject to the terms of the Mozilla Public
+   * License, v. 2.0. If a copy of the MPL was not distributed with this
+   * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+   *
+   * This file incorporates work covered by the following license notice:
+   *
+   *   Licensed to the Apache Software Foundation (ASF) under one or more
+   *   contributor license agreements. See the NOTICE file distributed
+   *   with this work for additional information regarding copyright
+   *   ownership. The ASF licenses this file to you under the Apache
+   *   License, Version 2.0 (the "License"); you may not use this file
+   *   except in compliance with the License. You may obtain a copy of
+   *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
+   -->
+   <meta>
       <topic id="textscalc0102140000xml" indexer="include" status="PUBLISH">
-         <title xml-lang="en-US" id="tit">Fill</title>
+         <title id="tit">Fill</title>
          <filename>/text/scalc/01/02140000.xhp</filename>
       </topic>
    </meta>
    <body>
-      <section id="fill">
-<bookmark xml-lang="en-US" branch="hid/.uno:FillCellsMenu" id="bm_id2939237" localize="false"/>
-<bookmark xml-lang="en-US" branch="index" id="bm_id8473769"><bookmark_value>filling;selection lists</bookmark_value>
-         <bookmark_value>selection lists;filling cells</bookmark_value>
-</bookmark><comment>MW inserted 2 index entries</comment>
-<h1 id="hd_id3153876"><link href="text/scalc/01/02140000.xhp">Fill</link></h1>
-         <paragraph xml-lang="en-US" id="par_id3156285" role="paragraph"><ahelp hid=".">Automatically fills cells with content.</ahelp></paragraph>
-      </section>
-      <section id="howtoget">
-         <embed href="text/scalc/00/00000402.xhp#bausfullen"/>
-      </section>
-      <paragraph xml-lang="en-US" id="par_id3147343" role="note">The $[officename] Calc context menus have <link href="text/scalc/01/02140000.xhp">additional options</link> for filling the cells.</paragraph>
-      <embed href="text/scalc/01/02140100.xhp#down"/>
-      <embed href="text/scalc/01/02140200.xhp#right"/>
-      <embed href="text/scalc/01/02140300.xhp#up"/>
-      <embed href="text/scalc/01/02140400.xhp#left"/>
-      <h2 id="hd_id3149207"><link href="text/scalc/01/02140500.xhp">Sheet</link></h2>
-      <embed href="text/scalc/01/02140500.xhp#tabellenfuellentext"/>
-      <h2 id="hd_id3155111"><link href="text/scalc/01/02140600.xhp">Series</link></h2>
-      <embed href="text/scalc/01/02140600.xhp#reihenfuellentext"/>
-      <paragraph xml-lang="en-US" id="par_id3152994" role="paragraph">
-<emph>Filling cells using context menus:</emph>
-</paragraph>
-      <list type="unordered">
-         <listitem>
-            <paragraph xml-lang="en-US" id="par_id3145384" role="listitem">Call the <link href="text/shared/00/00000005.xhp#contextmenu">context menu</link> when positioned in a cell and choose <emph>Selection List</emph>.</paragraph>
-         </listitem>
-         <listitem>
-<bookmark xml-lang="en-US" branch="hid/.uno:DataSelect" id="bm_id4369249" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id3156450" role="listitem"><ahelp hid=".uno:DataSelect">A list box containing all text found in the current column is displayed.</ahelp> The text is sorted alphabetically and multiple entries are listed only once.</paragraph>
-         </listitem>
-         <listitem>
-            <paragraph xml-lang="en-US" id="par_id3148699" role="listitem">Click one of the listed entries to copy it to the cell.</paragraph>
-         </listitem>
-      </list>
-   </body>
+   <bookmark branch="hid/.uno:FillCellsMenu" id="bm_id2939237" localize="false"/>
+   <bookmark branch="index" id="bm_id8473769"><bookmark_value>filling;selection lists</bookmark_value>
+      <bookmark_value>selection lists;filling cells</bookmark_value>
+      </bookmark><comment>MW inserted 2 index entries</comment>
+   <section id="fill">
+      <h1 id="hd_id3153876"><link href="text/scalc/01/02140000.xhp">Fill Cells</link></h1>
+      <paragraph id="par_id3156285" role="paragraph"><ahelp hid=".">Automatically fills cells with content.</ahelp></paragraph>
+   </section>
+   <section id="howtoget">
+      <embed href="text/scalc/00/00000402.xhp#fill_cells"/>
+   </section>
+   <embed href="text/scalc/01/02140100.xhp#down"/>
+   <embed href="text/scalc/01/02140200.xhp#right"/>
+   <embed href="text/scalc/01/02140300.xhp#up"/>
+   <embed href="text/scalc/01/02140400.xhp#left"/>
+   <h2 id="hd_id3149207"><link href="text/scalc/01/02140500.xhp">Sheet</link></h2>
+   <embed href="text/scalc/01/02140500.xhp#tabellenfuellentext"/>
+   <h2 id="hd_id3155111"><link href="text/scalc/01/02140600.xhp">Series</link></h2>
+   <embed href="text/scalc/01/02140600.xhp#reihenfuellentext"/>
+   <paragraph id="par_id3152994" role="paragraph">
+      <emph>Filling cells using context menus:</emph>
+   </paragraph>
+   <list type="unordered">
+      <listitem>
+         <paragraph id="par_id3145384" role="listitem">Call the <link href="text/shared/00/00000005.xhp#contextmenu">context menu</link> when positioned in a cell and choose <emph>Selection List</emph>.</paragraph>
+      </listitem>
+      <listitem>
+         <bookmark branch="hid/.uno:DataSelect" id="bm_id4369249" localize="false"/>
+         <paragraph id="par_id3156450" role="listitem"><ahelp hid=".uno:DataSelect">A list box containing all text found in the current column is displayed.</ahelp> The text is sorted alphabetically and multiple entries are listed only once.</paragraph>
+      </listitem>
+      <listitem>
+         <paragraph id="par_id3148699" role="listitem">Click one of the listed entries to copy it to the cell.</paragraph>
+      </listitem>
+   </list>
+</body>
 </helpdocument>
diff --git a/source/text/scalc/01/02150000.xhp b/source/text/scalc/01/02150000.xhp
index 7123a47657..4274401607 100644
--- a/source/text/scalc/01/02150000.xhp
+++ b/source/text/scalc/01/02150000.xhp
@@ -1,7 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -19,52 +16,49 @@
  *   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">
+<helpdocument version="1.0">
 <meta>
 <topic id="textscalc0102150000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Deleting Contents</title>
+<title id="tit">Deleting Contents</title>
 <filename>/text/scalc/01/02150000.xhp</filename>
 </topic>
 </meta>
 <body>
-<section id="del_contents">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3143284"><bookmark_value>deleting; cell contents</bookmark_value>
+<bookmark branch="index" id="bm_id3143284"><bookmark_value>deleting; cell contents</bookmark_value>
 <bookmark_value>cells; deleting contents</bookmark_value>
 <bookmark_value>spreadsheets; deleting cell contents</bookmark_value>
 <bookmark_value>cell contents; deleting</bookmark_value>
 </bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:Delete" id="bm_id5511579" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/DeleteContentsDialog" id="bm_id3145382" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/@@nowidget@@" id="bm_id3145382" localize="false"/>
-<h1 id="hd_id3143284">Deleting Contents</h1>
-<paragraph role="paragraph" id="par_id3149456" xml-lang="en-US"><variable id="inhalteloeschentext"><ahelp hid=".uno:Delete">Specifies the contents to be deleted from the active cell or from a selected cell range.</ahelp>
-</variable> If several sheets are selected, all selected sheets will be affected.</paragraph>
+<bookmark branch="hid/.uno:Delete" id="bm_id5511579" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/deletecontents/DeleteContentsDialog" id="bm_id3145382" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/deletecontents/@@nowidget@@" id="bm_id3145382" localize="false"/>
+<section id="del_contents">
+<h1 id="hd_id3143284">Clear Cells</h1>
+<paragraph role="paragraph" id="par_id3149456"><variable id="inhalteloeschentext"><ahelp hid=".uno:Delete">Specifies the contents to be deleted from the active cell or from a selected cell range.</ahelp></variable> If several sheets are selected, all selected sheets will be affected.</paragraph>
 </section>
 <section id="howtoget">
   <embed href="text/scalc/00/00000402.xhp#clear_cells"/>
 </section>
-<paragraph role="tip" id="par_id3159154" xml-lang="en-US">This dialog is also called by pressing Backspace after the cell cursor has been activated on the sheet.</paragraph>
-<paragraph role="tip" id="par_id3145367" xml-lang="en-US">Pressing Delete deletes content without calling the dialog or changing formats.</paragraph>
-<paragraph role="tip" id="par_id3153951" xml-lang="en-US">Use <emph>Cut</emph> on the Standard bar to delete contents and formats without the dialog.</paragraph>
+<tip id="par_id3159154">This dialog is also called by pressing Backspace after the cell cursor has been activated on the sheet.</tip>
+<tip id="par_id3145367">Pressing Delete deletes content without calling the dialog or changing formats.</tip>
+<tip id="par_id3153951">Use <emph>Cut</emph> on the Standard bar to delete contents and formats without the dialog.</tip>
 <h2 id="hd_id3148575">Selection</h2>
-<paragraph role="paragraph" id="par_id3149665" xml-lang="en-US">This area lists the options for deleting contents.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/deleteall" id="bm_id3144766" localize="false"/><h3 id="hd_id3146975">Delete All</h3>
-<paragraph role="paragraph" id="par_id3154729" xml-lang="en-US"><ahelp hid="modules/scalc/ui/deletecontents/deleteall">Deletes all content from the selected cell range.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/text" id="bm_id3147394" localize="false"/><h3 id="hd_id3156286">Text<comment>i50439</comment></h3>
-<paragraph role="paragraph" id="par_id3154015" xml-lang="en-US"><ahelp hid="modules/scalc/ui/deletecontents/text">Deletes text only. Formats, formulas, numbers and dates are not affected.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/numbers" id="bm_id3156276" localize="false"/><h3 id="hd_id3153840">Numbers</h3>
-<paragraph role="paragraph" id="par_id3148405" xml-lang="en-US"><ahelp hid="modules/scalc/ui/deletecontents/numbers">Deletes numbers only. Formats and formulas remain unchanged.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/datetime" id="bm_id3154757" localize="false"/><h3 id="hd_id3155764">Date &amp; time</h3>
-<paragraph role="paragraph" id="par_id3149567" xml-lang="en-US"><ahelp hid="modules/scalc/ui/deletecontents/datetime">Deletes date and time values. Formats, text, numbers and formulas remain unchanged.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/formulas" id="bm_id3149256" localize="false"/><h3 id="hd_id3154703">Formulas</h3>
-<paragraph role="paragraph" id="par_id3148485" xml-lang="en-US"><ahelp hid="modules/scalc/ui/deletecontents/formulas">Deletes formulas. Text, numbers, formats, dates and times remain unchanged.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/comments" id="bm_id3152775" localize="false"/><h3 id="hd_id3150300">Comments</h3>
-<paragraph role="paragraph" id="par_id3154658" xml-lang="en-US"><ahelp hid="modules/scalc/ui/deletecontents/comments">Deletes comments added to cells. All other elements remain unchanged.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/formats" id="bm_id3145258" localize="false"/><h3 id="hd_id3155112">Formats</h3>
-<paragraph role="paragraph" id="par_id3146134" xml-lang="en-US"><ahelp hid="modules/scalc/ui/deletecontents/formats">Deletes format attributes applied to cells. All cell content remains unchanged.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/objects" id="bm_id3152582" localize="false"/><h3 id="hd_id3150088">Objects</h3>
-<paragraph role="paragraph" id="par_id3152990" xml-lang="en-US"><ahelp hid="modules/scalc/ui/deletecontents/objects">Deletes objects. All cell content remains unchanged.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3149665">This area lists the options for deleting contents.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/deletecontents/deleteall" id="bm_id3144766" localize="false"/><h3 id="hd_id3146975">Delete All</h3>
+<paragraph role="paragraph" id="par_id3154729"><ahelp hid="modules/scalc/ui/deletecontents/deleteall">Deletes all content from the selected cell range.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/deletecontents/text" id="bm_id3147394" localize="false"/><h3 id="hd_id3156286">Text<comment>i50439</comment></h3>
+<paragraph role="paragraph" id="par_id3154015"><ahelp hid="modules/scalc/ui/deletecontents/text">Deletes text only. Formats, formulas, numbers and dates are not affected.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/deletecontents/numbers" id="bm_id3156276" localize="false"/><h3 id="hd_id3153840">Numbers</h3>
+<paragraph role="paragraph" id="par_id3148405"><ahelp hid="modules/scalc/ui/deletecontents/numbers">Deletes numbers only. Formats and formulas remain unchanged.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/deletecontents/datetime" id="bm_id3154757" localize="false"/><h3 id="hd_id3155764">Date &amp; time</h3>
+<paragraph role="paragraph" id="par_id3149567"><ahelp hid="modules/scalc/ui/deletecontents/datetime">Deletes date and time values. Formats, text, numbers and formulas remain unchanged.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/deletecontents/formulas" id="bm_id3149256" localize="false"/><h3 id="hd_id3154703">Formulas</h3>
+<paragraph role="paragraph" id="par_id3148485"><ahelp hid="modules/scalc/ui/deletecontents/formulas">Deletes formulas. Text, numbers, formats, dates and times remain unchanged.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/deletecontents/comments" id="bm_id3152775" localize="false"/><h3 id="hd_id3150300">Comments</h3>
+<paragraph role="paragraph" id="par_id3154658"><ahelp hid="modules/scalc/ui/deletecontents/comments">Deletes comments added to cells. All other elements remain unchanged.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/deletecontents/formats" id="bm_id3145258" localize="false"/><h3 id="hd_id3155112">Formats</h3>
+<paragraph role="paragraph" id="par_id3146134"><ahelp hid="modules/scalc/ui/deletecontents/formats">Deletes format attributes applied to cells. All cell content remains unchanged.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/deletecontents/objects" id="bm_id3152582" localize="false"/><h3 id="hd_id3150088">Objects</h3>
+<paragraph role="paragraph" id="par_id3152990"><ahelp hid="modules/scalc/ui/deletecontents/objects">Deletes objects. All cell content remains unchanged.</ahelp></paragraph>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/ToggleRelative.xhp b/source/text/scalc/01/ToggleRelative.xhp
new file mode 100644
index 0000000000..dd07a043a1
--- /dev/null
+++ b/source/text/scalc/01/ToggleRelative.xhp
@@ -0,0 +1,32 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+    <!--
+    * This file is part of the LibreOffice project.
+    *
+    * This Source Code Form is subject to the terms of the Mozilla Public
+    * License, v. 2.0. If a copy of the MPL was not distributed with this
+    * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+    *
+    -->
+
+    <meta>
+        <topic id="textscalc01ToggleRelativexhp" indexer="include" status="PUBLISH">
+            <title id="tit">Toggle Relative Adressing</title>
+            <filename>/text/scalc/01/ToggleRelative.xhp</filename>
+        </topic>
+    </meta>
+<body>
+<bookmark branch="hid/.uno:ToggleRelative" id="bm_id991702418291729" localize="false"/>
+<section id="cycle_types">
+    <h1 id="hd_id81702418438740"><variable id="h1"><link href="text/scalc/01/ToggleRelative.xhp">Cycle Cell Reference Types</link></variable></h1>
+    <paragraph id="par_id361702418438742" role="paragraph">Cycles between absolute and relative addressing of cell reference in the formula.</paragraph>
+</section>
+<section id="howtoget">
+    <embed href="text/scalc/00/sheet_menu.xhp#cyclereftype"/>
+</section>
+<embed href="text/scalc/guide/relativ_absolut_ref.xhp#abs_rel_types"/>
+<section id="relatedtopics">
+    <paragraph role="paragraph" id="par_id301702418791608" localize="false"><embedvar href="text/scalc/guide/relativ_absolut_ref.xhp#relativ_absolut_ref" markup="ignore"/></paragraph>
+</section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/guide/relativ_absolut_ref.xhp b/source/text/scalc/guide/relativ_absolut_ref.xhp
index fd14ade9e5..e302c97141 100644
--- a/source/text/scalc/guide/relativ_absolut_ref.xhp
+++ b/source/text/scalc/guide/relativ_absolut_ref.xhp
@@ -19,7 +19,7 @@
 <helpdocument version="1.0">
 <meta>
 <topic id="textscalcguiderelativ_absolut_refxml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Addresses and References, Absolute and Relative</title>
+<title id="tit">Addresses and References, Absolute and Relative</title>
 <filename>/text/scalc/guide/relativ_absolut_ref.xhp</filename>
 </topic>
 <history>
@@ -27,7 +27,7 @@
 </history>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id3156423"><bookmark_value>addressing; relative and absolute</bookmark_value>
+<bookmark branch="index" id="bm_id3156423"><bookmark_value>addressing; relative and absolute</bookmark_value>
 <bookmark_value>references; absolute/relative</bookmark_value>
 <bookmark_value>absolute addresses in spreadsheets</bookmark_value>
 <bookmark_value>relative addresses</bookmark_value>
@@ -49,17 +49,21 @@
 <embed href="text/scalc/guide/cellreferences.xhp#otherdocref"/>
 <embed href="text/scalc/01/04060199.xhp#referenceoperators"/>
 <h2 id="hd_id3163712">Relative Addressing</h2>
-<paragraph role="paragraph" id="par_id3146119" xml-lang="en-US">The cell in column A, row 1 is addressed as A1. You can address a range of adjacent cells by first entering the coordinates of the upper left cell of the area, then a colon followed by the coordinates of the lower right cell. For example, the square formed by the first four cells in the upper left corner is addressed as A1:B2.</paragraph>
-<paragraph role="paragraph" id="par_id3154730" xml-lang="en-US">By addressing an area in this way, you are making a relative reference to A1:B2. Relative here means that the reference to this area will be adjusted automatically when you copy the formulas.</paragraph>
+<paragraph role="paragraph" id="par_id3146119">The cell in column A, row 1 is addressed as A1. You can address a range of adjacent cells by first entering the coordinates of the upper left cell of the area, then a colon followed by the coordinates of the lower right cell. For example, the square formed by the first four cells in the upper left corner is addressed as A1:B2.</paragraph>
+<paragraph role="paragraph" id="par_id3154730">By addressing an area in this way, you are making a relative reference to A1:B2. Relative here means that the reference to this area will be adjusted automatically when you copy the formulas.</paragraph>
 <h2 id="hd_id3149377">Absolute Addressing</h2>
-<paragraph role="paragraph" id="par_id3154943" xml-lang="en-US">Absolute referencing is the opposite of relative addressing. A dollar sign is placed before each letter and number in an absolute reference, for example, $A$1:$B$2.</paragraph>
-<tip id="par_id3147338">$[officename] can convert the current reference, in which the cursor is positioned in the input line, from relative to absolute and vice versa by pressing F4. If you start with a relative address such as A1, the first time you press this key combination, both row and column are set to absolute references ($A$1). The second time, only the row (A$1), and the third time, only the column ($A1). If you press the key combination once more, both column and row references are switched back to relative (A1)</tip>
-<paragraph role="paragraph" id="par_id3153963" xml-lang="en-US">$[officename] Calc shows the references to a formula. If, for example, you click the formula =SUM(A1:C5;D15:D24) in a cell, the two referenced areas in the sheet will be highlighted in color. For example, the formula component "A1:C5" may be in blue and the cell range in question bordered in the same shade of blue. The next formula component "D15:D24" can be marked in red in the same way.</paragraph>
+<paragraph role="paragraph" id="par_id3154943">Absolute referencing is the opposite of relative addressing. A dollar sign is placed before each letter and number in an absolute reference, for example, $A$1:$B$2.</paragraph>
+
+<section id="abs_rel_types">
+    <tip id="par_id3147338">$[officename] can convert the current reference, in which the cursor is positioned in the input line, from relative to absolute and vice versa by pressing <keycode>F4</keycode>. If you start with a relative address such as A1, the first time you press this key combination, both row and column are set to absolute references ($A$1). The second time, only the row (A$1), and the third time, only the column ($A1). If you press the key combination once more, both column and row references are switched back to relative (A1)</tip>
+</section>
+
+<paragraph role="paragraph" id="par_id3153963">$[officename] Calc shows the references to a formula. If, for example, you click the formula =SUM(A1:C5;D15:D24) in a cell, the two referenced areas in the sheet will be highlighted in color. For example, the formula component "A1:C5" may be in blue and the cell range in question bordered in the same shade of blue. The next formula component "D15:D24" can be marked in red in the same way.</paragraph>
 <h2 id="hd_id3154704">When to Use Relative and Absolute References</h2>
-<paragraph role="paragraph" id="par_id3147346" xml-lang="en-US">What distinguishes a relative reference? Assume you want to calculate in cell E1 the sum of the cells in range A1:B2. The formula to enter into E1 would be: =SUM(A1:B2). If you later decide to insert a new column in front of column A, the elements you want to add would then be in B1:C2 and the formula would be in F1, not in E1. After inserting the new column, you would therefore have to check and correct all formulas in the sheet, and possibly in other sheets.</paragraph>
-<paragraph role="paragraph" id="par_id3155335" xml-lang="en-US">Fortunately, $[officename] does this work for you. After having inserted a new column A, the formula =SUM(A1:B2) will be automatically updated to =SUM(B1:C2). Row numbers will also be automatically adjusted when a new row 1 is inserted. Absolute and relative references are always adjusted in $[officename] Calc whenever the referenced area is moved. But be careful if you are copying a formula since in that case only the relative references will be adjusted, not the absolute references.</paragraph>
-<paragraph role="paragraph" id="par_id3145791" xml-lang="en-US">Absolute references are used when a calculation refers to one specific cell in your sheet. If a formula that refers to exactly this cell is copied relatively to a cell below the original cell, the reference will also be moved down if you did not define the cell coordinates as absolute.</paragraph>
-<paragraph role="paragraph" id="par_id3147005" xml-lang="en-US">Aside from when new rows and columns are inserted, references can also change when an existing formula referring to particular cells is copied to another area of the sheet. Assume you entered the formula =SUM(A1:A9) in row 10. If you want to calculate the sum for the adjacent column to the right, simply copy this formula to the cell to the right. The copy of the formula in column B will be automatically adjusted to =SUM(B1:B9).</paragraph>
+<paragraph role="paragraph" id="par_id3147346">What distinguishes a relative reference? Assume you want to calculate in cell E1 the sum of the cells in range A1:B2. The formula to enter into E1 would be: =SUM(A1:B2). If you later decide to insert a new column in front of column A, the elements you want to add would then be in B1:C2 and the formula would be in F1, not in E1. After inserting the new column, you would therefore have to check and correct all formulas in the sheet, and possibly in other sheets.</paragraph>
+<paragraph role="paragraph" id="par_id3155335">Fortunately, $[officename] does this work for you. After having inserted a new column A, the formula =SUM(A1:B2) will be automatically updated to =SUM(B1:C2). Row numbers will also be automatically adjusted when a new row 1 is inserted. Absolute and relative references are always adjusted in $[officename] Calc whenever the referenced area is moved. But be careful if you are copying a formula since in that case only the relative references will be adjusted, not the absolute references.</paragraph>
+<paragraph role="paragraph" id="par_id3145791">Absolute references are used when a calculation refers to one specific cell in your sheet. If a formula that refers to exactly this cell is copied relatively to a cell below the original cell, the reference will also be moved down if you did not define the cell coordinates as absolute.</paragraph>
+<paragraph role="paragraph" id="par_id3147005">Aside from when new rows and columns are inserted, references can also change when an existing formula referring to particular cells is copied to another area of the sheet. Assume you entered the formula =SUM(A1:A9) in row 10. If you want to calculate the sum for the adjacent column to the right, simply copy this formula to the cell to the right. The copy of the formula in column B will be automatically adjusted to =SUM(B1:B9).</paragraph>
 <section id="relatedtopics">
 <embed href="text/scalc/guide/value_with_name.xhp#value_with_name"/><comment>mw changed link target from "address_byname" to "value_with_name"</comment><embed href="text/scalc/guide/address_auto.xhp#address_auto"/>
 </section>
diff --git a/source/text/scalc/main0116.xhp b/source/text/scalc/main0116.xhp
index e2f9f1815a..9e525c979e 100644
--- a/source/text/scalc/main0116.xhp
+++ b/source/text/scalc/main0116.xhp
@@ -48,8 +48,10 @@
 <embed href="text/scalc/01/Add.xhp#addatend"/>
 <embed href="text/scalc/01/04050100.xhp#sheetfromfile"/>
 <embed href="text/scalc/01/04090000.xhp#extdata"/>
-
+<embed href="text/scalc/01/02170000.xhp#deletesheet"/>
+<embed href="text/scalc/01/ToggleRelative.xhp#cycle_types"/>
 <embed href="text/scalc/01/02140000.xhp#fill"/>
+
 <embed href="text/scalc/01/02150000.xhp#del_contents"/>
 
 <h2 id="hd_id3150792"><link href="text/scalc/01/02180000.xhp">Move or Copy Sheet</link></h2>