tdf#132586 Add RAND.NV() and RANDBETWEEN.NV()

Change-Id: I181d4f7ce0ccca38339568c034754c40ef345026
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/94724
Tested-by: Jenkins
Reviewed-by: Eike Rathke <erack@redhat.com>
(cherry picked from commit 7e39048579d0049c19299c1e31a2878e21e218ec)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/94967
Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>

1 files changed, 47 insertions, 8 deletions

diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp
index 36bde5f4d1..a226f36372 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -413,14 +413,14 @@
 <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_EXP" id="bm_id3154625" localize="false"/>
 
 <h2 id="hd_id3148698">EXP</h2>
-<paragraph id="par_id3150592" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_EXP">Returns e raised to the power of a number.</ahelp> The constant e has a value of approximately 2.71828182845904.</paragraph>
+<paragraph id="par_id3150592" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_EXP">Returns <literal>e</literal> raised to the power of a number.</ahelp> The constant <literal>e</literal> has a value of approximately 2.71828182845904.</paragraph>
 
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
 <paragraph id="par_id3146786" role="code" xml-lang="en-US">EXP(Number)</paragraph>
 <paragraph id="par_id3155608" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the power to which e is to be raised.</paragraph>
 
 <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3156340" role="paragraph" xml-lang="en-US"><item type="input">=EXP(1)</item> returns 2.71828182845904, the mathematical constant e to Calc's accuracy.</paragraph><comment>see also POWER, LN</comment>
+<paragraph id="par_id3156340" role="paragraph" xml-lang="en-US"><item type="input">=EXP(1)</item> returns 2.71828182845904, the mathematical constant <literal>e</literal> to Calc's accuracy.</paragraph><comment>see also POWER, LN</comment>
 </section>
 
 <section id="Section46">
@@ -1504,8 +1504,8 @@
 
 <section id="Section4">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3164669">
-  <bookmark_value>random numbers; between limits</bookmark_value>
-  <bookmark_value>RANDBETWEEN function</bookmark_value>
+<bookmark_value>random numbers; between limits</bookmark_value>
+<bookmark_value>RANDBETWEEN function</bookmark_value>
 </bookmark>
 <comment>mw changed "random numbers;"</comment>
 <bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_RANDBETWEEN" id="bm_id3164680" localize="false"/>
@@ -1521,12 +1521,27 @@
 
 <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
 <paragraph id="par_id3164785" role="paragraph" xml-lang="en-US"><item type="input">=RANDBETWEEN(20;30)</item> returns an integer of between 20 and 30.</paragraph><comment>see also RAND</comment>
+
+<bookmark xml-lang="en-US" branch="index" id="bm_id461590241346526">
+<bookmark_value>random numbers non-volatile; between limits</bookmark_value>
+<bookmark_value>RANDBETWEEN.NV function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RANDBETWEEN_NV" id="bm_id601590240409484" localize="false"/>
+<h2 id="hd_id171590240366277">RANDBETWEEN.NV</h2>
+<paragraph role="paragraph" id="par_id391590240473510"><ahelp hid="HID_FUNC_RANDBETWEEN_NV">Returns an non-volatile integer random number in a specified range.</ahelp></paragraph>
+<embed href="text/scalc/00/avail_release.xhp#7.0"/>
+<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
+<paragraph role="code" id="par_id181590240522012">RANDBETWEEN.NV(Bottom; Top)</paragraph>
+<paragraph role="paragraph" id="par_id91590242400917">Returns an non-volatile integer random number between integers <emph>Bottom</emph> and <emph>Top</emph> (both inclusive). A non-volatile function is not recalculated at new input events or pressing <keycode>F9</keycode>. However, the function is recalculated when pressing <keycode>F9</keycode> with the cursor on the cell containing the function, when opening the file, and when <emph>Top</emph> or <emph>Bottom</emph> are recalculated.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+<paragraph role="paragraph" id="par_id151590240999839"><input>=RANDBETWEEN.NV(20;30)</input> returns a non-volatile integer between 20 and 30.</paragraph>
+<paragraph role="paragraph" id="par_id1001590241005601"><input>=RANDBETWEEN.NV(A1;30)</input> returns a non-volatile integer between the value of cell A1 and 30. The function is recalculated when the contents of cell A1 change.</paragraph>
 </section>
 
 <section id="Section3">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3164800">
-  <bookmark_value>RAND function</bookmark_value>
-  <bookmark_value>random numbers;between 0 and 1</bookmark_value>
+<bookmark_value>RAND function</bookmark_value>
+<bookmark_value>random numbers;between 0 and 1</bookmark_value>
 </bookmark>
 <comment>mw added one entry</comment>
 <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZUFALLSZAHL" id="bm_id3164812" localize="false"/>
@@ -1537,10 +1552,34 @@
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
 <paragraph id="par_id3164884" role="code" xml-lang="en-US">RAND()</paragraph>
 <paragraph id="par_id5092318" role="paragraph" xml-lang="en-US">This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press F9.</paragraph>
-<paragraph id="par_id9312417" role="paragraph" xml-lang="en-US">To generate random numbers which never recalculate, copy cells each containing =RAND(), 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="par_id9312417" role="paragraph" xml-lang="en-US">To generate random numbers which never recalculate, either:</paragraph>
+<list type="unordered">
+<listitem>
+    <paragraph id="par_id451590242105253"  role="listitem">Copy cells each containing =RAND(), and use <menuitem>Edit - Paste Special</menuitem> (with <emph>Paste All</emph> and <emph>Formulas</emph> not marked and <emph>Numbers</emph> marked).</paragraph>
+</listitem>
+<listitem>
+    <paragraph id="par_id801590242114296"  role="listitem">Use the Fill Cell command with random numbers (<menuitem>Sheet - Fill Cells - Fill Random Numbers</menuitem>).</paragraph>
+</listitem>
+<listitem>
+    <paragraph id="par_id41590242118383"  role="listitem">Use the RAND.NV() function for non-volatile random numbers.</paragraph>
+    </listitem>
+</list>
 <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
 <paragraph id="par_id9569078" role="paragraph" xml-lang="en-US"><item type="input">=RAND()</item> returns a random number between 0 and 1.</paragraph><comment>see also RANDBETWEEN</comment>
+
+<bookmark xml-lang="en-US" branch="index" id="bm_id341590241488944">
+<bookmark_value>random numbers non-volatile;between 0 and 1</bookmark_value>
+<bookmark_value>RAND.NV function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RAND_NV" id="bm_id111590240232198" localize="false"/>
+<h2 id="hd_id71590238179170">RAND.NV</h2>
+<paragraph role="paragraph" id="par_id101590238875834"><ahelp hid="HID_FUNC_RAND_NV">Returns a non-volatile random number between 0 and 1.</ahelp></paragraph>
+<embed href="text/scalc/00/avail_release.xhp#7.0"/>
+<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
+<paragraph role="code" id="par_id391590238945182">RAND.NV()</paragraph>
+<paragraph role="paragraph" id="par_id271590239748534">This function produces a non-volatile random number on input. A non-volatile function is not recalculated at new input events. The function does not recalculate when pressing <keycode>F9</keycode>, except when the cursor is on the cell containing the function. The function is recalculated when opening the file.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+<paragraph role="paragraph" id="par_id191590241215013"><input>=RAND.NV()</input> returns a non-volatile random number between 0 and 1.</paragraph>
 </section>
 </sort>