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

+ Sheet menu for Calc: fill cells
+ refactoring

Change-Id: If6aa8c42896f67b58e41b6454785a78dfaa344d1
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160658
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
(cherry picked from commit 4ceaee12caa0e8d6caf4fc7fc3adb155898f6a44)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160639

9 files changed, 264 insertions, 201 deletions

diff --git a/source/text/scalc/00/00000402.xhp b/source/text/scalc/00/00000402.xhp
index f587341b42..c6c862fa8b 100644
--- a/source/text/scalc/00/00000402.xhp
+++ b/source/text/scalc/00/00000402.xhp
@@ -166,12 +166,86 @@
   <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>
-<paragraph id="par_id3145068" role="paragraph"><variable id="bauslinks">Choose <emph>Sheet - Fill Cells - Left</emph>.</variable></paragraph>
-<paragraph id="par_id3150400" role="paragraph"><variable id="baustab">Choose <emph>Sheet - Fill Cells - Sheets</emph>.</variable></paragraph>
-<paragraph id="par_id3154910" role="paragraph"><variable id="bausreihe">Choose <emph>Sheet - Fill Cells - Series</emph>.</variable></paragraph>
+<section id="fill_down">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph id="par_id3143267" role="paragraph"><variable id="bausunten">Choose <menuitem>Sheet - Fill Cells - Fill Down</menuitem>.</variable></paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+  <table id="tab_id51702423479153">
+    <tablerow>
+      <tablecell>
+        <paragraph id="par_id381702423479154" role="paragraph"><image src="cmd/lc_filldown.svg" id="img_id231702423479155" width="1cm"  height="1cm"><alt id="alt_id61702423479156">Icon Fill Down</alt></image></paragraph>
+      </tablecell>
+      <tablecell>
+        <paragraph id="par_id681702423479158" role="paragraph">Fill Down</paragraph>
+      </tablecell>
+    </tablerow>
+  </table>
+  <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+  <paragraph role="paragraph" id="par_id101702423551507"><switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode> + D</keycode></paragraph>
+</section>
+
+<section id="fill_right">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph id="par_id3153880" role="paragraph"><variable id="bausrechts">Choose <menuitem>Sheet - Fill Cells - Fill Right</menuitem>.</variable></paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+  <table id="tab_id921702423952473">
+    <tablerow>
+      <tablecell>
+        <paragraph id="par_id701702423952474" role="paragraph"><image src="cmd/lc_fillright.svg" id="img_id401702423952475" width="1cm"  height="1cm"><alt id="alt_id141702423952476">Icon Fill Right</alt></image></paragraph>
+      </tablecell>
+      <tablecell>
+        <paragraph id="par_id731702423952478" role="paragraph">Fill Right</paragraph>
+      </tablecell>
+    </tablerow>
+  </table>
+</section>
+
+<section id="fill_up">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph id="par_id3151245" role="paragraph"><variable id="bausoben">Choose <menuitem>Sheet - Fill Cells - Fill Up</menuitem>.</variable></paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+  <table id="tab_id731702424038216">
+    <tablerow>
+      <tablecell>
+        <paragraph id="par_id931702424038217" role="paragraph"><image src="cmd/lc_fillup.svg" id="img_id681702424038218" width="1cm" height="1cm"><alt id="alt_id861702424038219">Icon Fill Up</alt></image></paragraph>
+      </tablecell>
+      <tablecell>
+        <paragraph id="par_id601702424038221" role="paragraph">Fill Up</paragraph>
+      </tablecell>
+    </tablerow>
+  </table>
+</section>
+
+<section id="fill_left">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph id="par_id3145068" role="paragraph"><variable id="bauslinks">Choose <menuitem>Sheet - Fill Cells - Fill  Left</menuitem>.</variable></paragraph>
+  <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+  <table id="tab_id831702424217650">
+    <tablerow>
+      <tablecell>
+        <paragraph id="par_id601702424217651" role="paragraph"><image src="cmd/lc_fillleft.svg" id="img_id691702424217653" width="1cm"  height="1cm"><alt id="alt_id311702424217654">Icon Fill Left</alt></image></paragraph>
+      </tablecell>
+      <tablecell>
+        <paragraph id="par_id321702424217655" role="paragraph">Fill Left</paragraph>
+      </tablecell>
+    </tablerow>
+  </table>
+</section>
+
+<section id="fill_sheet">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph id="par_id3150400" role="paragraph"><variable id="baustab">Choose <menuitem>Sheet - Fill Cells - Fill Sheets</menuitem>.</variable></paragraph>
+</section>
+
+<section id="fill_series">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph id="par_id3154910" role="paragraph"><variable id="bausreihe">Choose <menuitem>Sheet - Fill Cells - Fill Series</menuitem>.</variable></paragraph>
+</section>
+
+<section id="fill_random">
+  <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+  <paragraph id="par_id2308201415500176457" role="paragraph">Choose <menuitem>Sheet - Fill Cells - Fill Random Number</menuitem></paragraph>
+</section>
 
 <section id="clear_cells">
   <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 2c93bcc03c..8b4a5f2284 100644
--- a/source/text/scalc/01/02140000.xhp
+++ b/source/text/scalc/01/02140000.xhp
@@ -40,13 +40,12 @@
    <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>
+   <embed href="text/scalc/01/02140500.xhp#fill_sheet"/>
+   <embed href="text/scalc/01/02140600.xhp#fill_series"/>
+   <embed href="text/scalc/01/02140700.xhp#fill_random_numbers"/>
+
+   <h2 id="hd_id601702426898284">Filling cells using context menus</h2>
+   <paragraph role="paragraph" id="par_id341702426995235">You can reuse the values in the current column to fill the cell.</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>
diff --git a/source/text/scalc/01/02140100.xhp b/source/text/scalc/01/02140100.xhp
index 87d7aabfb5..044f608b6e 100644
--- a/source/text/scalc/01/02140100.xhp
+++ b/source/text/scalc/01/02140100.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,11 +16,10 @@
  *   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="textscalc0102140100xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Down</title>
+<title id="tit">Fill Down</title>
 <filename>/text/scalc/01/02140100.xhp</filename>
 </topic>
 <history>
@@ -30,16 +27,15 @@
 </history>
 </meta>
 <body>
-  
-  
+
+<bookmark branch="hid/.uno:FillDown" id="bm_id3145173" localize="false"/>
   <section id="down">
-<bookmark branch="hid/.uno:FillDown" xml-lang="en-US" id="bm_id3145173" localize="false"/>
-<h1 id="hd_id3150792"><link href="text/scalc/01/02140100.xhp">Down</link></h1>
-  <paragraph role="paragraph" id="par_id3153969" xml-lang="en-US"><ahelp hid=".uno:FillDown" visibility="visible">Fills a selected range of at least two rows with the contents of the top cell of the range.</ahelp></paragraph>
+<h1 id="hd_id3150792"><link href="text/scalc/01/02140100.xhp">Fill Down</link></h1>
+  <paragraph role="paragraph" id="par_id3153969"><ahelp hid=".uno:FillDown" visibility="visible">Fills a selected range of at least two rows with the contents of the top cell of the range.</ahelp></paragraph>
   </section>
   <section id="howtoget">
-  <embed href="text/scalc/00/00000402.xhp#bausunten"/>
+  <embed href="text/scalc/00/00000402.xhp#fill_down"/>
 </section>
-  <paragraph role="paragraph" id="par_id3145787" xml-lang="en-US">If a selected range has only one column, the contents of the top cell are copied to all others. If several columns are selected, the contents of the corresponding top cell will be copied down.</paragraph>
+  <paragraph role="paragraph" id="par_id3145787">If a selected range has only one column, the contents of the top cell are copied to all others. If several columns are selected, the contents of the corresponding top cell will be copied down.</paragraph>
  </body>
 </helpdocument>
diff --git a/source/text/scalc/01/02140200.xhp b/source/text/scalc/01/02140200.xhp
index 032a93d93c..22ef3e1821 100644
--- a/source/text/scalc/01/02140200.xhp
+++ b/source/text/scalc/01/02140200.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,11 +16,10 @@
  *   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="textscalc0102140200xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Right</title>
+<title id="tit">Right</title>
 <filename>/text/scalc/01/02140200.xhp</filename>
 </topic>
 <history>
@@ -30,16 +27,14 @@
 </history>
 </meta>
 <body>
-  
-  
+<bookmark branch="hid/.uno:FillRight" id="bm_id3149456" localize="false"/>
   <section id="right">
-<bookmark branch="hid/.uno:FillRight" xml-lang="en-US" id="bm_id3149456" localize="false"/>
-<h1 id="hd_id3153896"><link href="text/scalc/01/02140200.xhp">Right</link></h1>
-  <paragraph role="paragraph" id="par_id3153361" xml-lang="en-US"><ahelp hid=".uno:FillRight" visibility="visible">Fills a selected range of at least two columns with the contents of the left most cell.</ahelp></paragraph>
+<h1 id="hd_id3153896"><link href="text/scalc/01/02140200.xhp"> Fill Right</link></h1>
+  <paragraph role="paragraph" id="par_id3153361"><ahelp hid=".uno:FillRight" visibility="visible">Fills a selected range of at least two columns with the contents of the left most cell.</ahelp></paragraph>
   </section>
   <section id="howtoget">
-  <embed href="text/scalc/00/00000402.xhp#bausrechts"/>
+  <embed href="text/scalc/00/00000402.xhp#fill_right"/>
 </section>
-  <paragraph role="paragraph" id="par_id3154684" xml-lang="en-US">If a range of only one row is selected, the contents of the far left cell are copied to all the other selected cells. If you have selected several rows, each of the far left cells is copied into those cells to the right.</paragraph>
+  <paragraph role="paragraph" id="par_id3154684">If a range of only one row is selected, the contents of the far left cell are copied to all the other selected cells. If you have selected several rows, each of the far left cells is copied into those cells to the right.</paragraph>
  </body>
 </helpdocument>
diff --git a/source/text/scalc/01/02140300.xhp b/source/text/scalc/01/02140300.xhp
index e9757cc929..deba5fca6b 100644
--- a/source/text/scalc/01/02140300.xhp
+++ b/source/text/scalc/01/02140300.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,28 +16,26 @@
  *   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="textscalc0102140300xml" indexer="include" status="PUBLISH">
+       <title id="tit">Up</title>
+       <filename>/text/scalc/01/02140300.xhp</filename>
+     </topic>
+     <history>
+       <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+     </history>
+   </meta>
+   <body>
 
-<helpdocument version="1.0">
-<meta>
-<topic id="textscalc0102140300xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Up</title>
-<filename>/text/scalc/01/02140300.xhp</filename>
-</topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-</history>
-</meta>
-<body>
-  
-  
-  <section id="up">
-<bookmark branch="hid/.uno:FillUp" xml-lang="en-US" id="bm_id3149456" localize="false"/>
-<h1 id="hd_id3147264"><link href="text/scalc/01/02140300.xhp">Up</link></h1>
-  <paragraph role="paragraph" id="par_id3150793" xml-lang="en-US"><ahelp hid=".uno:FillUp" visibility="visible">Fills a selected range of at least two rows with the contents of the bottom most cell.</ahelp></paragraph>
-  </section>
-  <section id="howtoget">
-  <embed href="text/scalc/00/00000402.xhp#bausoben"/>
-</section>
-  <paragraph role="paragraph" id="par_id3150447" xml-lang="en-US">If a selected range has only one column, the content of the bottom most cell is copied into the selected cells. If several columns are selected, the contents of the bottom most cells are copied into those selected above.</paragraph>
+   <bookmark branch="hid/.uno:FillUp" id="bm_id3149456" localize="false"/>
+   <section id="up">
+     <h1 id="hd_id3147264"><link href="text/scalc/01/02140300.xhp">Fill Up</link></h1>
+     <paragraph role="paragraph" id="par_id3150793"><ahelp hid=".uno:FillUp" visibility="visible">Fills a selected range of at least two rows with the contents of the bottom most cell.</ahelp></paragraph>
+   </section>
+   <section id="howtoget">
+     <embed href="text/scalc/00/00000402.xhp#fill_up"/>
+   </section>
+   <paragraph role="paragraph" id="par_id3150447">If a selected range has only one column, the content of the bottom most cell is copied into the selected cells. If several columns are selected, the contents of the bottom most cells are copied into those selected above.</paragraph>
  </body>
 </helpdocument>
diff --git a/source/text/scalc/01/02140400.xhp b/source/text/scalc/01/02140400.xhp
index 36a8c51445..dd4cf14ac8 100644
--- a/source/text/scalc/01/02140400.xhp
+++ b/source/text/scalc/01/02140400.xhp
@@ -1,6 +1,4 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,28 +16,25 @@
  *   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="textscalc0102140400xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Left</title>
-<filename>/text/scalc/01/02140400.xhp</filename>
-</topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-</history>
-</meta>
-<body>
-  
-  
-  <section id="left">
-<bookmark branch="hid/.uno:FillLeft" xml-lang="en-US" id="bm_id3149456" localize="false"/>
-<h1 id="hd_id3153896"><link href="text/scalc/01/02140400.xhp">Left</link></h1>
-  <paragraph role="paragraph" id="par_id3150793" xml-lang="en-US"><ahelp hid=".uno:FillLeft" visibility="visible">Fills a selected range of at least two columns with the contents of the far right cell.</ahelp></paragraph>
-  </section>
-  <section id="howtoget">
-  <embed href="text/scalc/00/00000402.xhp#bauslinks"/>
-</section>
-  <paragraph role="paragraph" id="par_id3156280" xml-lang="en-US">If a selected range has only one row, the content of the far right cell is copied into all other cells of the range. If several rows are selected, the far right cells are copied into the cells to the left.</paragraph>
+ <helpdocument version="1.0">
+   <meta>
+     <topic id="textscalc0102140400xml" indexer="include" status="PUBLISH">
+       <title id="tit">Left</title>
+       <filename>/text/scalc/01/02140400.xhp</filename>
+     </topic>
+     <history>
+       <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+     </history>
+   </meta>
+   <body>
+     <bookmark branch="hid/.uno:FillLeft" id="bm_id3149456" localize="false"/>
+      <section id="left">
+     <h1 id="hd_id3153896"><link href="text/scalc/01/02140400.xhp">Fill Left</link></h1>
+     <paragraph role="paragraph" id="par_id3150793"><ahelp hid=".uno:FillLeft" visibility="visible">Fills a selected range of at least two columns with the contents of the far right cell.</ahelp></paragraph>
+   </section>
+   <section id="howtoget">
+     <embed href="text/scalc/00/00000402.xhp#fill_left"/>
+   </section>
+   <paragraph role="paragraph" id="par_id3156280">If a selected range has only one row, the content of the far right cell is copied into all other cells of the range. If several rows are selected, the far right cells are copied into the cells to the left.</paragraph>
  </body>
 </helpdocument>
diff --git a/source/text/scalc/01/02140500.xhp b/source/text/scalc/01/02140500.xhp
index f63102b898..d6fae339b4 100644
--- a/source/text/scalc/01/02140500.xhp
+++ b/source/text/scalc/01/02140500.xhp
@@ -19,35 +19,37 @@
  -->
 <meta>
 <topic id="textscalc0102140500xml" indexer="include" status="PUBLISH">
-  <title xml-lang="en-US" id="tit">Fill Sheets</title>
+  <title id="tit">Fill Sheets</title>
   <filename>/text/scalc/01/02140500.xhp</filename>
 </topic>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="hid/.uno:FillTable" id="bm_id3912388" localize="false"/>
-<h1 id="hd_id3153897">Fill Sheets</h1>
-<paragraph role="paragraph" id="par_id3150791" xml-lang="en-US"><variable id="tabellenfuellentext"><ahelp hid=".uno:FillTable">Specifies the options for transferring sheets or ranges of a certain sheet to the same cells on other selected sheets.</ahelp></variable></paragraph>
+<bookmark branch="hid/.uno:FillTable" id="bm_id3912388" localize="false"/>
+<section id="fill_sheet">
+  <h1 id="hd_id3153897"><link href="text/scalc/01/02140500.xhp#fill sheets">Fill Sheets</link></h1>
+  <paragraph role="paragraph" id="par_id3150791"><variable id="tabellenfuellentext"><ahelp hid=".uno:FillTable">Specifies the options for transferring sheets or ranges of a certain sheet to the same cells on other selected sheets.</ahelp></variable></paragraph>
+</section>
 <section id="howtoget">
-  <embed href="text/scalc/00/00000402.xhp#baustab"/>
+  <embed href="text/scalc/00/00000402.xhp#fill_sheet"/>
 </section>
-<paragraph xml-lang="en-US" role="warning" id="par_id3150768">This menu command is only active if you have selected at least two sheets in the document.</paragraph>
-<paragraph xml-lang="en-US" role="paragraph" id="par_id3150769">To select multiple sheets, click each sheet tab while pressing <switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline> or <keycode>Shift</keycode>.</paragraph>
-<paragraph xml-lang="en-US" role="paragraph" id="par_id3150767">In contrast to copying an area to the clipboard, you can filter certain information and calculate values.</paragraph>
+<warning id="par_id3150768">This menu command is only active if you have selected at least two sheets in the document.</warning>
+<paragraph role="paragraph" id="par_id3150769">To select multiple sheets, click each sheet tab while pressing <switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline> or <keycode>Shift</keycode>.</paragraph>
+<paragraph role="paragraph" id="par_id3150767">In contrast to copying an area to the clipboard, you can filter certain information and calculate values.</paragraph>
 <h2 id="hd_id3155131">Filling a Sheet</h2>
-  <list type="unordered">
-   <listitem>
-    <paragraph role="listitem" id="par_id3146119" xml-lang="en-US">Select the entire sheet by clicking the empty gray box in the upper left of the sheet. You can also select an area of the sheet to be copied.</paragraph>
-   </listitem>
-   <listitem>
-    <paragraph xml-lang="en-US" role="listitem" id="par_id3153726">Press <switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline> and click the tab of the sheet where you want to insert the contents.</paragraph>
-   </listitem>
-   <listitem>
-    <paragraph xml-lang="en-US" role="listitem" id="par_id3147436">Select the command <menuitem>Sheet - Fill Cells - Sheets</menuitem>. In the dialog which appears, the check box <emph>Numbers</emph> must be selected (or <emph>Paste All</emph>) if you want to combine operations with the values. You can also choose the desired operation here.</paragraph>
-   </listitem>
-   <listitem>
-    <paragraph xml-lang="en-US" role="listitem" id="par_id3154942">Click <emph>OK</emph>.</paragraph>
-   </listitem>
-  </list>
-  <paragraph xml-lang="en-US" role="paragraph" id="par_id3156283">This dialog is similar to the <link href="text/shared/01/02070000.xhp"><emph>Paste Special</emph></link> dialog, where you can find additional tips.</paragraph>
+<list type="unordered">
+  <listitem>
+    <paragraph role="listitem" id="par_id3146119">Select the entire sheet by clicking the empty gray box in the upper left of the sheet. You can also select an area of the sheet to be copied.</paragraph>
+  </listitem>
+  <listitem>
+    <paragraph role="listitem" id="par_id3153726">Press <switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline> and click the tab of the sheet where you want to insert the contents.</paragraph>
+  </listitem>
+  <listitem>
+    <paragraph role="listitem" id="par_id3147436">Select the command <menuitem>Sheet - Fill Cells - Sheets</menuitem>. In the dialog which appears, the check box <emph>Numbers</emph> must be selected (or <emph>Paste All</emph>) if you want to combine operations with the values. You can also choose the desired operation here.</paragraph>
+  </listitem>
+  <listitem>
+    <paragraph role="listitem" id="par_id3154942">Click <emph>OK</emph>.</paragraph>
+  </listitem>
+</list>
+<paragraph role="paragraph" id="par_id3156283">This dialog is similar to the <link href="text/shared/01/02070000.xhp"><emph>Paste Special</emph></link> dialog, where you can find additional tips.</paragraph>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/02140600.xhp b/source/text/scalc/01/02140600.xhp
index 3ee6a542da..15584eeb39 100644
--- a/source/text/scalc/01/02140600.xhp
+++ b/source/text/scalc/01/02140600.xhp
@@ -20,96 +20,99 @@
 
 <meta>
   <topic id="textscalc0102140600xml" indexer="include" status="PUBLISH">
-    <title id="tit" xml-lang="en-US">Fill Series</title>
+    <title id="tit">Fill Series</title>
     <filename>/text/scalc/01/02140600.xhp</filename>
   </topic>
 </meta>
 
 <body>
 
-<bookmark xml-lang="en-US" branch="hid/.uno:FillSeries" id="bm_id709198" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/FillSeriesDialog" id="bm_id3150791" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/@@nowidget@@" id="bm_id3150791" localize="false"/>
+<bookmark branch="hid/.uno:FillSeries" id="bm_id709198" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/filldlg/FillSeriesDialog" id="bm_id3150791" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/filldlg/@@nowidget@@" id="bm_id3150791" localize="false"/>
 
-<h1 id="hd_id3148664">Fill Series</h1>
-<paragraph id="par_id3148797" role="paragraph" xml-lang="en-US"><variable id="reihenfuellentext"><ahelp hid=".uno:FillSeries">Automatically generate series with the options in this dialog. Determine direction, increment, time unit and series type.</ahelp></variable></paragraph>
-<paragraph id="par_id3146976" role="note" xml-lang="en-US">Before filling a series, first select the cell range.</paragraph>
+<section id="fill_series">
+  <h1 id="hd_id3148664"><link href="text/scalc/01/02140600.xhp#fill series">Fill Series</link></h1>
+<paragraph id="par_id3148797" role="paragraph"><variable id="reihenfuellentext"><ahelp hid=".uno:FillSeries">Automatically generate series with the options in this dialog. Determine direction, increment, time unit and series type.</ahelp></variable></paragraph>
+</section>
+
+<note id="par_id3146976">Before filling a series, first select the cell range.</note>
 
 <section id="howtoget">
-<embed href="text/scalc/00/00000402.xhp#bausreihe"/>
+<embed href="text/scalc/00/00000402.xhp#fill_series"/>
 </section>
-<paragraph id="par_id3145748" role="paragraph" xml-lang="en-US">To automatically continue a series using the assumed completion rules, choose the <emph>AutoFill</emph> option after opening the <emph>Fill Series</emph> dialog.</paragraph>
+<paragraph id="par_id3145748" role="paragraph">To automatically continue a series using the assumed completion rules, choose the <emph>AutoFill</emph> option after opening the <emph>Fill Series</emph> dialog.</paragraph>
 
 <h2 id="hd_id3147435">Direction</h2>
-<paragraph id="par_id3154729" role="paragraph" xml-lang="en-US">Determines the direction of series creation.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/down" id="bm_id3147124" localize="false"/>
+<paragraph id="par_id3154729" role="paragraph">Determines the direction of series creation.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/filldlg/down" id="bm_id3147124" localize="false"/>
 
 <h3 id="hd_id3145253">Down</h3>
-<paragraph id="par_id3155418" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/down">Creates a downward series in the selected cell range for the column using the defined increment to the end value.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/right" id="bm_id3153415" localize="false"/>
+<paragraph id="par_id3155418" role="paragraph"><ahelp hid="modules/scalc/ui/filldlg/down">Creates a downward series in the selected cell range for the column using the defined increment to the end value.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/filldlg/right" id="bm_id3153415" localize="false"/>
 
 <h3 id="hd_id3155738">Right</h3>
-<paragraph id="par_id3149402" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/right">Creates a series running from left to right within the selected cell range using the defined increment to the end value.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/up" id="bm_id3155067" localize="false"/>
+<paragraph id="par_id3149402" role="paragraph"><ahelp hid="modules/scalc/ui/filldlg/right">Creates a series running from left to right within the selected cell range using the defined increment to the end value.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/filldlg/up" id="bm_id3155067" localize="false"/>
 
 <h3 id="hd_id3146972">Up</h3>
-<paragraph id="par_id3153711" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/up">Creates an upward series in the cell range of the column using the defined increment to the end value.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/left" id="bm_id3147341" localize="false"/>
+<paragraph id="par_id3153711" role="paragraph"><ahelp hid="modules/scalc/ui/filldlg/up">Creates an upward series in the cell range of the column using the defined increment to the end value.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/filldlg/left" id="bm_id3147341" localize="false"/>
 
 <h3 id="hd_id3153764">Left</h3>
-<paragraph id="par_id3156382" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/left">Creates a series running from right to left in the selected cell range using the defined increment to the end value.</ahelp></paragraph>
+<paragraph id="par_id3156382" role="paragraph"><ahelp hid="modules/scalc/ui/filldlg/left">Creates a series running from right to left in the selected cell range using the defined increment to the end value.</ahelp></paragraph>
 
 <h2 id="hd_id3147344">Series Type</h2>
-<paragraph id="par_id3149257" role="paragraph" xml-lang="en-US">Defines the series type. Choose between <emph>Linear</emph>, <emph>Growth</emph>, <emph>Date</emph> and <emph>AutoFill</emph>.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/linear" id="bm_id3150298" localize="false"/>
+<paragraph id="par_id3149257" role="paragraph">Defines the series type. Choose between <emph>Linear</emph>, <emph>Growth</emph>, <emph>Date</emph> and <emph>AutoFill</emph>.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/filldlg/linear" id="bm_id3150298" localize="false"/>
 
 <h3 id="hd_id3148488">Linear</h3>
-<paragraph id="par_id3159238" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/linear">Creates a linear number series using the defined increment and end value.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/growth" id="bm_id3150784" localize="false"/>
+<paragraph id="par_id3159238" role="paragraph"><ahelp hid="modules/scalc/ui/filldlg/linear">Creates a linear number series using the defined increment and end value.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/filldlg/growth" id="bm_id3150784" localize="false"/>
 
 <h3 id="hd_id3149210">Growth</h3>
-<paragraph id="par_id3150364" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/growth">Creates a growth series using the defined increment and end value.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/date" id="bm_id3155378" localize="false"/>
+<paragraph id="par_id3150364" role="paragraph"><ahelp hid="modules/scalc/ui/filldlg/growth">Creates a growth series using the defined increment and end value.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/filldlg/date" id="bm_id3155378" localize="false"/>
 
 <h3 id="hd_id3149528">Date</h3>
-<paragraph id="par_id3150887" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/date">Creates a date series using the defined increment and end date.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/autofill" id="bm_id3152985" localize="false"/>
+<paragraph id="par_id3150887" role="paragraph"><ahelp hid="modules/scalc/ui/filldlg/date">Creates a date series using the defined increment and end date.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/filldlg/autofill" id="bm_id3152985" localize="false"/>
 
 <h3 id="hd_id3150202">AutoFill</h3>
-<paragraph id="par_id3156288" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/autofill">Forms a series directly in the sheet.</ahelp> The <emph>AutoFill</emph> function takes account of customized lists. For example, by entering <emph>January</emph> in the first cell, the series is completed using the list defined under <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph>
+<paragraph id="par_id3156288" role="paragraph"><ahelp hid="modules/scalc/ui/filldlg/autofill">Forms a series directly in the sheet.</ahelp> The <emph>AutoFill</emph> function takes account of customized lists. For example, by entering <emph>January</emph> in the first cell, the series is completed using the list defined under <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph>
 </caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - Sort Lists</emph>.</paragraph>
-<paragraph id="par_id3155811" role="paragraph" xml-lang="en-US">AutoFill tries to complete a value series by using a defined pattern. The series 1,3,5 is automatically completed with 7,9,11,13, and so on. Date and time series are completed accordingly; for example, after 01.01.99 and 15.01.99, an interval of 14 days is used.</paragraph>
-<paragraph id="par_id2956483" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/guide/calc_series.xhp#calc_series"/></paragraph>
+<paragraph id="par_id3155811" role="paragraph">AutoFill tries to complete a value series by using a defined pattern. The series 1,3,5 is automatically completed with 7,9,11,13, and so on. Date and time series are completed accordingly; for example, after 01.01.99 and 15.01.99, an interval of 14 days is used.</paragraph>
+<paragraph id="par_id2956483" role="paragraph" localize="false"><embedvar href="text/scalc/guide/calc_series.xhp#calc_series"/></paragraph>
 
 <h2 id="hd_id3148700">Unit of Time</h2>
-<paragraph id="par_id3153308" role="paragraph" xml-lang="en-US">In this area you can specify the desired unit of time. This area is only active if the <emph>Date</emph> option has been chosen in the <emph>Series type</emph> area.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/day" id="bm_id3153913" localize="false"/>
+<paragraph id="par_id3153308" role="paragraph">In this area you can specify the desired unit of time. This area is only active if the <emph>Date</emph> option has been chosen in the <emph>Series type</emph> area.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/filldlg/day" id="bm_id3153913" localize="false"/>
 
 <h3 id="hd_id3148868">Day</h3>
-<paragraph id="par_id3148605" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/day">Use the <emph>Date</emph> series type and this option to create a series using all seven days of the week. Unit of <emph>Increment</emph> is day.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/week" id="bm_id3145074" localize="false"/>
+<paragraph id="par_id3148605" role="paragraph"><ahelp hid="modules/scalc/ui/filldlg/day">Use the <emph>Date</emph> series type and this option to create a series using all seven days of the week. Unit of <emph>Increment</emph> is day.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/filldlg/week" id="bm_id3145074" localize="false"/>
 
 <h3 id="hd_id3144771">Weekday</h3>
-<paragraph id="par_id3150108" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/week">Use the <emph>Date</emph> series type and this option to create a series only using the five weekdays. Unit of <emph>Increment</emph> is day.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/month" id="bm_id3159204" localize="false"/>
+<paragraph id="par_id3150108" role="paragraph"><ahelp hid="modules/scalc/ui/filldlg/week">Use the <emph>Date</emph> series type and this option to create a series only using the five weekdays. Unit of <emph>Increment</emph> is day.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/filldlg/month" id="bm_id3159204" localize="false"/>
 
 <h3 id="hd_id3154957">Month</h3>
-<paragraph id="par_id3149126" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/month">Use the <emph>Date</emph> series type and this option to form a series which unit of <emph>Increment</emph> is month.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/year" id="bm_id3146777" localize="false"/>
+<paragraph id="par_id3149126" role="paragraph"><ahelp hid="modules/scalc/ui/filldlg/month">Use the <emph>Date</emph> series type and this option to form a series which unit of <emph>Increment</emph> is month.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/filldlg/year" id="bm_id3146777" localize="false"/>
 
 <h3 id="hd_id3152870">Year</h3>
-<paragraph id="par_id3151300" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/year">Use the <emph>Date</emph> series type and this option to create a series which unit of <emph>Increment</emph> is year.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/startValue" id="bm_id3145357" localize="false"/>
+<paragraph id="par_id3151300" role="paragraph"><ahelp hid="modules/scalc/ui/filldlg/year">Use the <emph>Date</emph> series type and this option to create a series which unit of <emph>Increment</emph> is year.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/filldlg/startValue" id="bm_id3145357" localize="false"/>
 
 <h2 id="hd_id3154762">Start Value</h2>
-<paragraph id="par_id3149381" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/startValue">Determines the start value for the series.</ahelp> Use numbers, dates or times.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/endValue" id="bm_id3153557" localize="false"/>
+<paragraph id="par_id3149381" role="paragraph"><ahelp hid="modules/scalc/ui/filldlg/startValue">Determines the start value for the series.</ahelp> Use numbers, dates or times.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/filldlg/endValue" id="bm_id3153557" localize="false"/>
 
 <h2 id="hd_id3153013">End Value</h2>
-<paragraph id="par_id3153487" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/endValue">Determines the end value for the series.</ahelp> Use numbers, dates or times.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/increment" id="bm_id3151196" localize="false"/>
+<paragraph id="par_id3153487" role="paragraph"><ahelp hid="modules/scalc/ui/filldlg/endValue">Determines the end value for the series.</ahelp> Use numbers, dates or times.</paragraph>
+<bookmark branch="hid/modules/scalc/ui/filldlg/increment" id="bm_id3151196" localize="false"/>
 
 <h2 id="hd_id3149312">Increment</h2>
-<paragraph id="par_id3154739" role="paragraph" xml-lang="en-US">The term "increment" denotes the amount by which a given value increases.<ahelp hid="modules/scalc/ui/filldlg/increment"> Determines the value by which the series of the selected type increases by each step.</ahelp> Entries can only be made if the linear, growth or date series types have been selected.</paragraph>
+<paragraph id="par_id3154739" role="paragraph">The term "increment" denotes the amount by which a given value increases.<ahelp hid="modules/scalc/ui/filldlg/increment"> Determines the value by which the series of the selected type increases by each step.</ahelp> Entries can only be made if the linear, growth or date series types have been selected.</paragraph>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/02140700.xhp b/source/text/scalc/01/02140700.xhp
index e3d66a88ad..982aa25fa9 100644
--- a/source/text/scalc/01/02140700.xhp
+++ b/source/text/scalc/01/02140700.xhp
@@ -20,186 +20,189 @@
 
 <meta>
 <topic id="ID" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Fill Random Numbers</title>
+<title id="tit">Fill Random Numbers</title>
 <filename>/text/scalc/01/02140700.xhp</filename>
 </topic>
 </meta>
 <body>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/RandomNumberGeneratorDialog" id="bm_id3150791" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/@@nowidget@@" id="bm_id3150791" localize="false"/>
-<h1 id="hd_id2308201415431520596">Fill Random Numbers</h1>
-<paragraph id="par_id2308201415431525817" role="paragraph" xml-lang="en-US"><ahelp hid=".">Populate a cell range with automatically generated pseudo random numbers with the selected distribution function and its parameters.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="index" id="bm_id2308201416102526759">
+<bookmark branch="hid/modules/scalc/ui/randomnumbergenerator/RandomNumberGeneratorDialog" id="bm_id3150791" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/randomnumbergenerator/@@nowidget@@" id="bm_id3150791" localize="false"/>
+<section id="fill_random_numbers">
+<h1 id="hd_id2308201415431520596"><link href="text/scalc/01/02140700.xhp">Fill Random Numbers</link></h1>
+<paragraph id="par_id2308201415431525817" role="paragraph"><ahelp hid=".">Populate a cell range with automatically generated pseudo random numbers with the selected distribution function and its parameters.</ahelp></paragraph>
+</section>
+<bookmark branch="index" id="bm_id2308201416102526759">
 <bookmark_value>fill range;random numbers</bookmark_value>
 <bookmark_value>random rumbers;fill range</bookmark_value>
 <bookmark_value>random rumbers;distribution</bookmark_value>
 </bookmark>
 <section id="howtoget">
-<paragraph id="par_id2308201415500176457" role="paragraph" xml-lang="en-US">Choose <item type="menuitem">Sheet - Fill Cells - Random Number</item></paragraph>
+<embed href="text/scalc/00/00000402.xhp#fill_random"/>
 </section>
+
 <h2 id="hd_id2308201415431233475">Data</h2>
 <h3 id="hd_id2308201415431883475">Cell Range</h3>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/cell-range-edit" id="bm_id3150792" localize="false"/>
-<paragraph id="par_id2308201415431811111" role="paragraph" xml-lang="en-US"><ahelp hid=".">Define the range of cells to fill with random numbers. If you have previously selected a range, it will be displayed here.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/randomnumbergenerator/cell-range-edit" id="bm_id3150792" localize="false"/>
+<paragraph id="par_id2308201415431811111" role="paragraph"><ahelp hid=".">Define the range of cells to fill with random numbers. If you have previously selected a range, it will be displayed here.</ahelp></paragraph>
 <h2 id="hd_id2308201415431850229">Random number generator</h2>
 <h3 id="hd_id2308201415431880497">Distribution</h3>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/distribution-combo" id="bm_id2308201416384294287" localize="false"/>
-<paragraph id="par_id2308201415431874867" role="paragraph" xml-lang="en-US"><ahelp hid=".">The distribution function for the random number generator.</ahelp></paragraph>
-<paragraph id="par_id2308201416441240058" role="paragraph" xml-lang="en-US">Valid distributions function and their parameters are</paragraph>
+<bookmark branch="hid/modules/scalc/ui/randomnumbergenerator/distribution-combo" id="bm_id2308201416384294287" localize="false"/>
+<paragraph id="par_id2308201415431874867" role="paragraph"><ahelp hid=".">The distribution function for the random number generator.</ahelp></paragraph>
+<paragraph id="par_id2308201416441240058" role="paragraph">Valid distributions function and their parameters are</paragraph>
 
 
 <table id="Tabela1">
 <tablerow>
 <tablecell>
-<paragraph id="par_id230820141543181813" role="tablehead" xml-lang="en-US">Distribution</paragraph>
+<paragraph id="par_id230820141543181813" role="tablehead">Distribution</paragraph>
 </tablecell>
 <tablecell>
-<paragraph id="par_id2308201415431868807" role="tablehead" xml-lang="en-US">Parameters</paragraph>
+<paragraph id="par_id2308201415431868807" role="tablehead">Parameters</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph id="par_id2308201415431869872" role="tablecontent" xml-lang="en-US">Uniform</paragraph>
+<paragraph id="par_id2308201415431869872" role="tablecontent">Uniform</paragraph>
 </tablecell>
 <tablecell>
 <list type="unordered">
 <listitem>
-<paragraph id="par_id2308201415431850857" role="ul_item" xml-lang="en-US"><emph>Minimum:</emph> The minimum value of the sample.</paragraph>
+<paragraph id="par_id2308201415431850857" role="ul_item"><emph>Minimum:</emph> The minimum value of the sample.</paragraph>
 </listitem>
 <listitem>
-<paragraph id="par_id2308201415431859422" role="ul_item" xml-lang="en-US"><emph>Maximum:</emph> The maximum value of the sample.</paragraph>
+<paragraph id="par_id2308201415431859422" role="ul_item"><emph>Maximum:</emph> The maximum value of the sample.</paragraph>
 </listitem></list>
 </tablecell>
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph id="par_id2308201415431848733" role="tablecontent" xml-lang="en-US">Uniform Integer</paragraph>
+<paragraph id="par_id2308201415431848733" role="tablecontent">Uniform Integer</paragraph>
 </tablecell>
 <tablecell>
 <list type="unordered">
 <listitem>
-<paragraph id="par_id2308201415431813421" role="ul_item" xml-lang="en-US"><emph>Minimum:</emph> The minimum value of the sample.</paragraph>
+<paragraph id="par_id2308201415431813421" role="ul_item"><emph>Minimum:</emph> The minimum value of the sample.</paragraph>
 </listitem>
 <listitem>
-<paragraph id="par_id2308201415431821789" role="ul_item" xml-lang="en-US"><emph>Maximum:</emph> The maximum value of the sample.</paragraph>
+<paragraph id="par_id2308201415431821789" role="ul_item"><emph>Maximum:</emph> The maximum value of the sample.</paragraph>
 </listitem></list>
 </tablecell>
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph id="par_id2308201415431870493" role="tablecontent" xml-lang="en-US">Normal</paragraph>
+<paragraph id="par_id2308201415431870493" role="tablecontent">Normal</paragraph>
 </tablecell>
 <tablecell>
 <list type="unordered">
 <listitem>
-<paragraph id="par_id2308201415431973994" role="ul_item" xml-lang="en-US"><emph>Mean:</emph> The mean of the Normal distribution.</paragraph>
+<paragraph id="par_id2308201415431973994" role="ul_item"><emph>Mean:</emph> The mean of the Normal distribution.</paragraph>
 </listitem>
 <listitem>
-<paragraph id="par_id2308201415431951090" role="ul_item" xml-lang="en-US"><emph>Standard Deviation:</emph> The standard deviation of the Normal distribution.</paragraph>
+<paragraph id="par_id2308201415431951090" role="ul_item"><emph>Standard Deviation:</emph> The standard deviation of the Normal distribution.</paragraph>
 </listitem></list>
-<paragraph id="par_id2308201415431990992" role="warning" xml-lang="en-US">The mean and standard deviation of the numbers generated may not equal the Mean and Standard Deviation inserted in the dialog.</paragraph>
+<warning id="par_id2308201415431990992">The mean and standard deviation of the numbers generated may not equal the Mean and Standard Deviation inserted in the dialog.</warning>
 </tablecell>
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph id="par_id2308201415431912748" role="tablecontent" xml-lang="en-US">Cauchy</paragraph>
+<paragraph id="par_id2308201415431912748" role="tablecontent">Cauchy</paragraph>
 </tablecell>
 <tablecell>
 <list type="unordered">
 <listitem>
-<paragraph id="par_id2308201415431923135" role="ul_item" xml-lang="en-US"><emph>Median:</emph> the median of the data or location parameter.</paragraph>
+<paragraph id="par_id2308201415431923135" role="ul_item"><emph>Median:</emph> the median of the data or location parameter.</paragraph>
 </listitem>
 <listitem>
-<paragraph id="par_id2308201415431997296" role="ul_item" xml-lang="en-US"><emph>Sigma:</emph> the scale parameter.</paragraph>
+<paragraph id="par_id2308201415431997296" role="ul_item"><emph>Sigma:</emph> the scale parameter.</paragraph>
 </listitem></list>
-<paragraph id="par_id2308201415431971536" role="warning" xml-lang="en-US">The median and sigma of the generated numbers may not equal the data inserted in the dialog.</paragraph>
+<warning id="par_id2308201415431971536">The median and sigma of the generated numbers may not equal the data inserted in the dialog.</warning>
 </tablecell>
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph id="par_id2308201415431962173" role="tablecontent" xml-lang="en-US">Bernoulli</paragraph>
+<paragraph id="par_id2308201415431962173" role="tablecontent">Bernoulli</paragraph>
 </tablecell>
 <tablecell>
 <list type="unordered">
 <listitem>
-<paragraph id="par_id2308201415431994157" role="ul_item" xml-lang="en-US"><emph>p Value:</emph> The probability of success.</paragraph>
+<paragraph id="par_id2308201415431994157" role="ul_item"><emph>p Value:</emph> The probability of success.</paragraph>
 </listitem></list>
 </tablecell>
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph id="par_id2308201415431979367" role="tablecontent" xml-lang="en-US">Binomial</paragraph>
+<paragraph id="par_id2308201415431979367" role="tablecontent">Binomial</paragraph>
 </tablecell>
 <tablecell>
 <list type="unordered">
 <listitem>
-<paragraph id="par_id2308201415431958372" role="ul_item" xml-lang="en-US"><emph>p Value:</emph> The probability of success of each trial.</paragraph>
+<paragraph id="par_id2308201415431958372" role="ul_item"><emph>p Value:</emph> The probability of success of each trial.</paragraph>
 </listitem>
 <listitem>
-<paragraph id="par_id2308201415431919718" role="ul_item" xml-lang="en-US"><emph>Number of trials:</emph> the number of trials of the experiment.</paragraph>
+<paragraph id="par_id2308201415431919718" role="ul_item"><emph>Number of trials:</emph> the number of trials of the experiment.</paragraph>
 </listitem></list>
 </tablecell>
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph id="par_id2308201415431985648" role="tablecontent" xml-lang="en-US">Chi Squared</paragraph>
+<paragraph id="par_id2308201415431985648" role="tablecontent">Chi Squared</paragraph>
 </tablecell>
 <tablecell>
 <list type="unordered">
 <listitem>
-<paragraph id="par_id230820141543194944" role="ul_item" xml-lang="en-US"><emph>Nu Value: </emph>a positive integer that specifies the number of degrees of freedom.</paragraph>
+<paragraph id="par_id230820141543194944" role="ul_item"><emph>Nu Value: </emph>a positive integer that specifies the number of degrees of freedom.</paragraph>
 </listitem></list>
 </tablecell>
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph id="par_id2308201415431935636" role="tablecontent" xml-lang="en-US">Geometric</paragraph>
+<paragraph id="par_id2308201415431935636" role="tablecontent">Geometric</paragraph>
 </tablecell>
 <tablecell>
 <list type="unordered">
 <listitem>
-<paragraph id="par_id2308201415431978150" role="ul_item" xml-lang="en-US"><emph>p Value:</emph> The probability of success of each trial.</paragraph>
+<paragraph id="par_id2308201415431978150" role="ul_item"><emph>p Value:</emph> The probability of success of each trial.</paragraph>
 </listitem></list>
 </tablecell>
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph id="par_id230820141543197085" role="tablecontent" xml-lang="en-US">Negative Binomial</paragraph>
+<paragraph id="par_id230820141543197085" role="tablecontent">Negative Binomial</paragraph>
 </tablecell>
 <tablecell>
 <list type="unordered">
 <listitem>
-<paragraph id="par_id2308201415431916718" role="ul_item" xml-lang="en-US"><emph>p Value:</emph> The probability of success of each trial.</paragraph>
+<paragraph id="par_id2308201415431916718" role="ul_item"><emph>p Value:</emph> The probability of success of each trial.</paragraph>
 </listitem>
 <listitem>
-<paragraph id="par_id2308201415431951891" role="ul_item" xml-lang="en-US"><emph>Number of trials:</emph> the number of trials of the experiment.</paragraph>
+<paragraph id="par_id2308201415431951891" role="ul_item"><emph>Number of trials:</emph> the number of trials of the experiment.</paragraph>
 </listitem></list>
 </tablecell>
 </tablerow>
 <tablerow>
 <tablecell>
-<paragraph id="par_id2308201415432870493" role="tablecontent" xml-lang="en-US">Poisson</paragraph>
+<paragraph id="par_id2308201415432870493" role="tablecontent">Poisson</paragraph>
 </tablecell>
 <tablecell>
 <list type="unordered">
 <listitem>
-<paragraph id="par_id2308201415432973994" role="ul_item" xml-lang="en-US"><emph>Mean:</emph> The mean of the Poisson distribution.</paragraph>
+<paragraph id="par_id2308201415432973994" role="ul_item"><emph>Mean:</emph> The mean of the Poisson distribution.</paragraph>
 </listitem></list>
 </tablecell>
 </tablerow>
 </table>
 <h2 id="hd_id2308201415431232932">Options</h2>
 <h3 id="hd_id2308201415431832932">Enable custom seed</h3>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/enable-seed-check" id="bm_id3150793" localize="false"/>
-<paragraph id="par_id2308201415431841782" role="paragraph" xml-lang="en-US"><ahelp hid=".">Set the initial value of the random number generator to a known value <emph>Seed.</emph></ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/randomnumbergenerator/enable-seed-check" id="bm_id3150793" localize="false"/>
+<paragraph id="par_id2308201415431841782" role="paragraph"><ahelp hid=".">Set the initial value of the random number generator to a known value <emph>Seed.</emph></ahelp></paragraph>
 <h3 id="hd_id2308201415431881107">Seed</h3>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/seed-spin" id="bm_id3150794" localize="false"/>
-<paragraph id="par_id2308201415431834837" role="paragraph" xml-lang="en-US"><ahelp hid=".">Value set to initiate the random number generator algorithm. It is used to initialize (seed) the random number generator in order to reproduce the same sequence of pseudorandom numbers. Specify a positive integer number (1, 2, ...) to produce a specific sequence, or leave the field blank if you don't need this particular feature.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/randomnumbergenerator/seed-spin" id="bm_id3150794" localize="false"/>
+<paragraph id="par_id2308201415431834837" role="paragraph"><ahelp hid=".">Value set to initiate the random number generator algorithm. It is used to initialize (seed) the random number generator in order to reproduce the same sequence of pseudorandom numbers. Specify a positive integer number (1, 2, ...) to produce a specific sequence, or leave the field blank if you don't need this particular feature.</ahelp></paragraph>
 <h3 id="hd_id2308201415431875641">Enable rounding</h3>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/enable-rounding-check" id="bm_id3150795" localize="false"/>
-<paragraph id="par_id2308201415431822157" role="paragraph" xml-lang="en-US"><ahelp hid=".">Round the number to a given number of <emph>Decimal Places</emph>.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/randomnumbergenerator/enable-rounding-check" id="bm_id3150795" localize="false"/>
+<paragraph id="par_id2308201415431822157" role="paragraph"><ahelp hid=".">Round the number to a given number of <emph>Decimal Places</emph>.</ahelp></paragraph>
 <h3 id="hd_id2308201415431826506">Decimal places</h3>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/decimal-places-spin" id="bm_id3150796" localize="false"/>
-<paragraph id="par_id2308201415431820502" role="paragraph" xml-lang="en-US"><ahelp hid=".">Number of decimal places of the numbers generated.</ahelp></paragraph>
+<bookmark branch="hid/modules/scalc/ui/randomnumbergenerator/decimal-places-spin" id="bm_id3150796" localize="false"/>
+<paragraph id="par_id2308201415431820502" role="paragraph"><ahelp hid=".">Number of decimal places of the numbers generated.</ahelp></paragraph>
 </body>
 </helpdocument>