source/text/scalc/01/04060106.xhp | 55 ++++++++++++++++++++++++++++++++------ 1 file changed, 47 insertions(+), 8 deletions(-)
New commits: commit 7e39048579d0049c19299c1e31a2878e21e218ec Author: Olivier Hallot <[email protected]> AuthorDate: Sat May 23 11:34:25 2020 -0300 Commit: Eike Rathke <[email protected]> CommitDate: Wed May 27 14:30:25 2020 +0200 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 <[email protected]> diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index 36bde5f4d..a226f3637 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> _______________________________________________ Libreoffice-commits mailing list [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
