source/text/scalc/00/00000402.xhp | 86 +++++++++++++++++++++++++++++--
source/text/scalc/01/02140000.xhp | 13 ++--
source/text/scalc/01/02140100.xhp | 18 ++----
source/text/scalc/01/02140200.xhp | 17 ++----
source/text/scalc/01/02140300.xhp | 44 +++++++---------
source/text/scalc/01/02140400.xhp | 45 +++++++---------
source/text/scalc/01/02140500.xhp | 48 +++++++++--------
source/text/scalc/01/02140600.xhp | 91 +++++++++++++++++----------------
source/text/scalc/01/02140700.xhp | 103 +++++++++++++++++++-------------------
9 files changed, 264 insertions(+), 201 deletions(-)
New commits:
commit b34d255751b25b1de5b3c680336bd8e9bac31264
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Tue Dec 12 21:26:51 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Dec 13 01:33:14 2023 +0100
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.hal...@libreoffice.org>
(cherry picked from commit 4ceaee12caa0e8d6caf4fc7fc3adb155898f6a44)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160639
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>
