source/text/scalc/01/04060106.xhp | 185 +++++++++++++++++++++++++++++++-------
1 file changed, 155 insertions(+), 30 deletions(-)
New commits:
commit 12f5fcacd219532e748c24b96c3be143e1fec99f
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
Date: Sun Aug 20 08:23:59 2017 -0300
tdf#107040 Calc: help for SUBTOTAL indexes 101-111
Change-Id: I90ad83a574748597553bb58c5436343b84947395
Reviewed-on: https://gerrit.libreoffice.org/41359
Reviewed-by: Olivier Hallot <olivier.hal...@edx.srv.br>
Tested-by: Olivier Hallot <olivier.hal...@edx.srv.br>
diff --git a/source/text/scalc/01/04060106.xhp
b/source/text/scalc/01/04060106.xhp
index 8c30ead07..f89d93a11 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -495,7 +495,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_GCD" id="bm_id3147578"
localize="false"/>
<paragraph id="hd_id3151221" role="heading" level="2"
xml-lang="en-US">GCD_EXCEL2003</paragraph>
-<paragraph id="par_id3153257" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_GCD"> The result is the greatest common divisor of a list of
numbers.</ahelp></paragraph>
+<paragraph id="par_id3153257" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_GCD">The result is the greatest common divisor of a list of
numbers.</ahelp></paragraph>
<embed href="text/scalc/01/04060102.xhp#ADD_note"/>
<paragraph id="hd_id3147548" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
@@ -534,7 +534,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_LCM" id="bm_id3147222"
localize="false"/>
<paragraph id="hd_id3154230" role="heading" level="2"
xml-lang="en-US">LCM_EXCEL2003</paragraph>
-<paragraph id="par_id3149036" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_LCM"> The result is the lowest common multiple of a list of
numbers.</ahelp></paragraph>
+<paragraph id="par_id3149036" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_LCM">The result is the lowest common multiple of a list of
numbers.</ahelp></paragraph>
<embed href="text/scalc/01/04060102.xhp#ADD_note"/>
<paragraph id="hd_id3153132" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
@@ -551,8 +551,8 @@
<bookmark_value>number of combinations</bookmark_value>
</bookmark>
<comment>mw added one entry</comment>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KOMBINATIONEN"
id="bm_id3155077" localize="false"/>
-<comment>should be statistical-->add a link there</comment>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KOMBINATIONEN"
id="bm_id3155077" localize="false"/><comment>should be statistical-->add a
link there</comment>
+
<paragraph id="hd_id3155802" role="heading" level="2"
xml-lang="en-US">COMBIN</paragraph>
<paragraph id="par_id3156172" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_KOMBINATIONEN">Returns the number of combinations for elements
without repetition.</ahelp></paragraph>
@@ -573,8 +573,8 @@
<bookmark_value>number of combinations with repetitions</bookmark_value>
</bookmark>
<comment>mw added one entry</comment>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KOMBINATIONEN2"
id="bm_id3150295" localize="false"/>
-<comment>should be statistical-->add a link there</comment>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KOMBINATIONEN2"
id="bm_id3150295" localize="false"/><comment>should be statistical-->add a
link there</comment>
+
<paragraph id="hd_id3150284" role="heading" level="2"
xml-lang="en-US">COMBINA</paragraph>
<paragraph id="par_id3157894" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_KOMBINATIONEN2">Returns the number of combinations of a subset of
items including repetitions.</ahelp></paragraph>
@@ -604,7 +604,7 @@
<paragraph id="par_id3148511" role="code" xml-lang="en-US">TRUNC(Number;
Count)</paragraph>
<paragraph id="par_id3150796" role="paragraph" xml-lang="en-US">Returns
<emph>Number</emph> with at most <emph>Count</emph> decimal places. Excess
decimal places are simply removed, irrespective of sign.</paragraph>
<paragraph id="par_id3150816" role="paragraph" xml-lang="en-US"><item
type="literal">TRUNC(Number; 0)</item> behaves as <item
type="literal">INT(Number)</item> for positive numbers, but effectively rounds
towards zero for negative numbers.</paragraph>
-<paragraph id="par_id3148548" role="warning" xml-lang="en-US">The
<emph>visible</emph> decimal places of the result are specified in
<switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences
+<paragraph id="par_id3148548" role="warning" xml-lang="en-US">The
<emph>visible</emph> decimal places of the result are specified in
<switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences
</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> -
<link href="text/shared/optionen/01060500.xhp">%PRODUCTNAME Calc -
Calculate</link>.</paragraph>
<paragraph id="hd_id3152555" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
@@ -761,7 +761,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_MULTINOMIAL"
id="bm_id3152429" localize="false"/>
<paragraph id="hd_id3152418" role="heading" level="2"
xml-lang="en-US">MULTINOMIAL</paragraph>
-<paragraph id="par_id3152454" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_MULTINOMIAL"> Returns the factorial of the sum of the
arguments divided by the product of the factorials of the
arguments.</ahelp></paragraph>
+<paragraph id="par_id3152454" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_MULTINOMIAL">Returns the factorial of the sum of the
arguments divided by the product of the factorials of the
arguments.</ahelp></paragraph>
<paragraph id="hd_id3155646" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
<paragraph id="par_id3155660" role="code"
xml-lang="en-US">MULTINOMIAL(Number(s))</paragraph>
@@ -913,8 +913,9 @@
</section>
<section id="Section67">
- <embed href="text/scalc/01/func_rawsubtract.xhp#func_rawsubtract"/>
+<embed href="text/scalc/01/func_rawsubtract.xhp#func_rawsubtract"/>
</section>
+
<section id="Section21">
<bookmark xml-lang="en-US" branch="index" id="bm_id3158121">
<bookmark_value>ROUND function</bookmark_value>
@@ -1081,7 +1082,8 @@
<paragraph id="par_id3151774" role="paragraph" xml-lang="en-US">Example
assumption: You have entered invoices into a table. Column A contains the date
value of the invoice, column B the amounts. You want to find a formula that you
can use to return the total of all amounts only for a specific month, e.g. only
the amount for the period >=2008-01-01 to <2008-02-01. The range with the
date values covers A1:A40, the range containing the amounts to be totaled is
B1:B40. C1 contains the start date, 2008<item type="input">-01-01</item>, of
the invoices to be included and C2 the date, 2008<item
type="input">-02-01</item>, that is no longer included.</paragraph>
<paragraph id="par_id3151799" role="paragraph" xml-lang="en-US">Enter the
following formula as an array formula:</paragraph>
<paragraph id="par_id3151813" role="paragraph" xml-lang="en-US"><item
type="input">=SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40)</item></paragraph>
-<paragraph id="par_id3151828" role="paragraph" xml-lang="en-US">In order to
enter this as an array formula, you must press the Shift<switchinline
select="sys"><caseinline select="MAC">+Command</caseinline><defaultinline>+
Ctrl</defaultinline></switchinline>+ Enter keys instead of simply pressing the
Enter key to close the formula. The formula will then be shown in the
<emph>Formula</emph> bar enclosed in braces.</paragraph>
+<paragraph id="par_id3151828" role="paragraph" xml-lang="en-US">In order to
enter this as an array formula, you must press the Shift<switchinline
select="sys"><caseinline select="MAC">+Command
+</caseinline><defaultinline>+ Ctrl</defaultinline></switchinline>+ Enter keys
instead of simply pressing the Enter key to close the formula. The formula will
then be shown in the <emph>Formula</emph> bar enclosed in braces.</paragraph>
<paragraph id="par_id3151869" role="paragraph"
xml-lang="en-US">{=SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40)}</paragraph>
<paragraph id="par_id3151884" role="paragraph" xml-lang="en-US">The formula is
based on the fact that the result of a comparison is 1 if the criterion is met
and 0 if it is not met. The individual comparison results will be treated as an
array and used in matrix multiplication, and at the end the individual values
will be totaled to give the result matrix.</paragraph>
</section>
@@ -1112,12 +1114,13 @@
</section>
<section id="color">
- <embed href="text/scalc/01/func_color.xhp#func_color"/>
+<embed href="text/scalc/01/func_color.xhp#func_color"/>
</section>
<section id="sumifs">
- <paragraph id="hd_id72921259523046" role="heading" level="2"
localize="false" xml-lang="en-US"><embedvar
href="text/scalc/01/func_sumifs.xhp#sumifs_head"/></paragraph>
- <paragraph id="par_id131512822630259" role="paragraph" localize="false"
xml-lang="en-US"><embedvar
href="text/scalc/01/func_sumifs.xhp#sumifs_des"/></paragraph>
+
+<paragraph id="hd_id72921259523046" role="heading" level="2" localize="false"
xml-lang="en-US"><embedvar
href="text/scalc/01/func_sumifs.xhp#sumifs_head"/></paragraph>
+<paragraph id="par_id131512822630259" role="paragraph" localize="false"
xml-lang="en-US"><embedvar
href="text/scalc/01/func_sumifs.xhp#sumifs_des"/></paragraph>
</section>
<section id="Section14">
@@ -1178,15 +1181,23 @@
<table id="tbl_id3165752">
<tablerow>
<tablecell>
- <paragraph id="par_id3165782" role="paragraph" xml-lang="en-US">Function
index</paragraph>
+ <paragraph id="par_id3165782" role="tablehead" xml-lang="en-US">Function
index</paragraph>
+ <paragraph id="par_id20082017081856189" role="tablehead"
xml-lang="en-US">(includes hidden values)</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820170716337755" role="tablehead"
xml-lang="en-US">Function index</paragraph>
+ <paragraph id="par_id200820170818568679" role="tablehead"
xml-lang="en-US">(ignores hidden values)</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3165806" role="paragraph"
xml-lang="en-US">Function</paragraph>
+ <paragraph id="par_id3165806" role="tablehead"
xml-lang="en-US">Function</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3165833" role="paragraph"
xml-lang="en-US">1</paragraph>
+ <paragraph id="par_id3165833" role="paragraph" localize="false"
xml-lang="en-US">1</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id20082017071634481" role="paragraph"
localize="false" xml-lang="en-US">101</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id3165856" role="paragraph"
xml-lang="en-US">AVERAGE</paragraph>
@@ -1194,7 +1205,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3165883" role="paragraph"
xml-lang="en-US">2</paragraph>
+ <paragraph id="par_id3165883" role="paragraph" localize="false"
xml-lang="en-US">2</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820170716349348" role="paragraph"
localize="false" xml-lang="en-US">102</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id3165906" role="paragraph"
xml-lang="en-US">COUNT</paragraph>
@@ -1202,7 +1216,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3165933" role="paragraph"
xml-lang="en-US">3</paragraph>
+ <paragraph id="par_id3165933" role="paragraph" localize="false"
xml-lang="en-US">3</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820170716342109" role="paragraph"
localize="false" xml-lang="en-US">103</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id3165956" role="paragraph"
xml-lang="en-US">COUNTA</paragraph>
@@ -1210,7 +1227,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3165983" role="paragraph"
xml-lang="en-US">4</paragraph>
+ <paragraph id="par_id3165983" role="paragraph" localize="false"
xml-lang="en-US">4</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820170716348854" role="paragraph"
localize="false" xml-lang="en-US">104</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id3166006" role="paragraph"
xml-lang="en-US">MAX</paragraph>
@@ -1218,7 +1238,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3166033" role="paragraph"
xml-lang="en-US">5</paragraph>
+ <paragraph id="par_id3166033" role="paragraph" localize="false"
xml-lang="en-US">5</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id20082017071634799" role="paragraph"
localize="false" xml-lang="en-US">105</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id3166056" role="paragraph"
xml-lang="en-US">MIN</paragraph>
@@ -1226,7 +1249,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3143316" role="paragraph"
xml-lang="en-US">6</paragraph>
+ <paragraph id="par_id3143316" role="paragraph" localize="false"
xml-lang="en-US">6</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820170716342762" role="paragraph"
localize="false" xml-lang="en-US">106</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id3143339" role="paragraph"
xml-lang="en-US">PRODUCT</paragraph>
@@ -1234,7 +1260,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3143366" role="paragraph"
xml-lang="en-US">7</paragraph>
+ <paragraph id="par_id3143366" role="paragraph" localize="false"
xml-lang="en-US">7</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820170716348779" role="paragraph"
localize="false" xml-lang="en-US">107</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id3143389" role="paragraph"
xml-lang="en-US">STDEV</paragraph>
@@ -1242,7 +1271,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3143416" role="paragraph"
xml-lang="en-US">8</paragraph>
+ <paragraph id="par_id3143416" role="paragraph" localize="false"
xml-lang="en-US">8</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820170716355943" role="paragraph"
localize="false" xml-lang="en-US">108</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id3143439" role="paragraph"
xml-lang="en-US">STDEVP</paragraph>
@@ -1250,7 +1282,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3143466" role="paragraph"
xml-lang="en-US">9</paragraph>
+ <paragraph id="par_id3143466" role="paragraph" localize="false"
xml-lang="en-US">9</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820170716355993" role="paragraph"
localize="false" xml-lang="en-US">109</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id3143489" role="paragraph"
xml-lang="en-US">SUM</paragraph>
@@ -1258,7 +1293,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3143516" role="paragraph"
xml-lang="en-US">10</paragraph>
+ <paragraph id="par_id3143516" role="paragraph" localize="false"
xml-lang="en-US">10</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820170716351843" role="paragraph"
localize="false" xml-lang="en-US">110</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id3143539" role="paragraph"
xml-lang="en-US">VAR</paragraph>
@@ -1266,7 +1304,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3143566" role="paragraph"
xml-lang="en-US">11</paragraph>
+ <paragraph id="par_id3143566" role="paragraph" localize="false"
xml-lang="en-US">11</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820170716353789" role="paragraph"
localize="false" xml-lang="en-US">111</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id3143589" role="paragraph"
xml-lang="en-US">VARP</paragraph>
@@ -1274,11 +1315,94 @@
</tablerow>
</table>
+<paragraph id="par_id20082017075115609" role="paragraph" xml-lang="en-US">Use
numbers 1-11 to include manually hidden rows or 101-111 to exclude them;
filtered-out cells are always excluded.</paragraph>
<paragraph id="par_id3143606" role="paragraph"
xml-lang="en-US"><emph>Range</emph> is the range whose cells are
included.</paragraph>
<paragraph id="hd_id3143625" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
-<paragraph id="par_id3143638" role="paragraph" xml-lang="en-US">You have a
table in the cell range A1:B5 containing cities in column A and accompanying
figures in column B. You have used an AutoFilter so that you only see rows
containing the city Hamburg. You want to see the sum of the figures that are
displayed; that is, just the subtotal for the filtered rows. In this case the
correct formula would be:</paragraph>
-<paragraph id="par_id3143658" role="paragraph" xml-lang="en-US"><item
type="input">=SUBTOTAL(9;B2:B5)</item></paragraph>
+<paragraph id="par_id3143638" role="paragraph" xml-lang="en-US">You have a
table in the cell range A1:B6 containing a bill of material for 10 students.
Row 2 (Pen) is manually hidden. You want to see the sum of the figures that are
displayed; that is, just the subtotal for the filtered rows. In this case the
correct formula would be:</paragraph>
+
+<table id="tbl_200820170737188127">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id200820170806057438" role="tablehead"
localize="false" xml-lang="en-US"/>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820170751186827" role="tablehead"
localize="false" xml-lang="en-US">A</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820170751186410" role="tablehead"
localize="false" xml-lang="en-US">B</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id200820170751189874" role="tablehead"
localize="false" xml-lang="en-US">1</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820170751186696" role="tablecontent"
xml-lang="en-US"><emph>ITEM</emph></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id20082017075118422" role="tablecontent"
xml-lang="en-US"><emph>QUANTITY</emph></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id200820170751187332" role="tablehead"
localize="false" xml-lang="en-US">2</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820170751195726" role="tablecontent"
xml-lang="en-US">Pen</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820170751199921" role="tablecontent"
localize="false" xml-lang="en-US">10</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id200820170751197796" role="tablehead"
localize="false" xml-lang="en-US">3</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820170751195912" role="tablecontent"
xml-lang="en-US">Pencil</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820170751195191" role="tablecontent"
localize="false" xml-lang="en-US">10</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id200820170751193908" role="tablehead"
localize="false" xml-lang="en-US">4</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820170751199399" role="tablecontent"
xml-lang="en-US">Notebook</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820170751204129" role="tablecontent"
localize="false" xml-lang="en-US">10</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id200820170751201815" role="tablehead"
localize="false" xml-lang="en-US">5</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820170751201323" role="tablecontent"
xml-lang="en-US">Rubber</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id20082017075120380" role="tablecontent"
localize="false" xml-lang="en-US">10</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id20082017075120914" role="tablehead"
localize="false" xml-lang="en-US">6</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820170751204884" role="tablecontent"
xml-lang="en-US">Sharpener</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id200820170751204938" role="tablecontent"
localize="false" xml-lang="en-US">10</paragraph>
+ </tablecell>
+ </tablerow>
+</table>
+
+<paragraph id="par_id3143658" role="paragraph" xml-lang="en-US"><item
type="input">=SUBTOTAL(9;B2:B6) returns 50.</item></paragraph>
+<paragraph id="par_id200820170751218092" role="paragraph"
xml-lang="en-US"><item type="input">=SUBTOTAL(109;B2:B6) returns
40.</item></paragraph>
</section>
<section id="Section11">
@@ -1486,7 +1610,8 @@
<paragraph id="hd_id3164745" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
<paragraph id="par_id3164758" role="code" xml-lang="en-US">RANDBETWEEN(Bottom;
Top)</paragraph>
<paragraph id="par_id7112338" role="paragraph" xml-lang="en-US">Returns an
integer random number between integers <emph>Bottom</emph> and <emph>Top</emph>
(both inclusive).</paragraph>
-<paragraph id="par_id2855616" role="paragraph" xml-lang="en-US">This function
produces a new random number each time Calc recalculates. To force Calc to
recalculate manually press Shift+<switchinline select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9.</paragraph>
+<paragraph id="par_id2855616" role="paragraph" xml-lang="en-US">This function
produces a new random number each time Calc recalculates. To force Calc to
recalculate manually press Shift+<switchinline select="sys"><caseinline
select="MAC">Command
+</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9.</paragraph>
<paragraph id="par_id2091433" role="paragraph" xml-lang="en-US">To generate
random numbers which never recalculate, copy cells containing this function,
and use <item type="menuitem">Edit - Paste Special</item> (with <item
type="menuitem">Paste All</item> and <item type="menuitem">Formulas</item> not
marked and <item type="menuitem">Numbers</item> marked).</paragraph>
<paragraph id="hd_id3164772" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
@@ -1519,4 +1644,4 @@
</section>
</body>
-</helpdocument>
+</helpdocument>
\ No newline at end of file
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
