diff options
Diffstat (limited to 'source/text/scalc/01')
| -rw-r--r-- | source/text/scalc/01/04060106.xhp | 10 | ||||
| -rw-r--r-- | source/text/scalc/01/06080000.xhp | 12 | ||||
| -rw-r--r-- | source/text/scalc/01/calculate.xhp | 7 | ||||
| -rw-r--r-- | source/text/scalc/01/formula2value.xhp | 36 | ||||
| -rw-r--r-- | source/text/scalc/01/recalculate_hard.xhp | 37 |
5 files changed, 87 insertions, 15 deletions
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index e2f2d18851..753b9f1315 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -1476,7 +1476,8 @@ <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> - +</section> +<section id="randbetween_nv"> <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> @@ -1486,7 +1487,7 @@ <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/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> +<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, when using the <link href="text/scalc/01/recalculate_hard.xhp" name="recalculate hard"><menuitem>Recalculate Hard</menuitem></link> command (<keycode>Shift</keycode>+<switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline>+<keycode>F9</keycode>) 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> @@ -1524,7 +1525,8 @@ </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> - +</section> +<section id="rand_nv"> <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> @@ -1534,7 +1536,7 @@ <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/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> +<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 or using the <link href="text/scalc/01/recalculate_hard.xhp" name="recalculate hard"><menuitem>Recalculate Hard</menuitem></link> command (<keycode>Shift</keycode>+<switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline>+<keycode>F9</keycode>). 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> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> diff --git a/source/text/scalc/01/06080000.xhp b/source/text/scalc/01/06080000.xhp index 08a6e09e16..f689ac46e4 100644 --- a/source/text/scalc/01/06080000.xhp +++ b/source/text/scalc/01/06080000.xhp @@ -43,15 +43,11 @@ <paragraph role="paragraph" id="par_id3154758" xml-lang="en-US"><ahelp hid=".uno:Calculate">If AutoCalculate is disabled, the Recalculate command recalculates all (so-called dirty) formula cells that depend on changed cell content and their dependents, and formula cells containing volatile functions such as RAND() or NOW() and formula cells that depend on them.</ahelp></paragraph> <paragraph role="paragraph" id="par_id3154759" xml-lang="en-US"><ahelp hid=".uno:Calculate">If AutoCalculate is enabled, the Recalculate command applies only to formula cells containing volatile functions like RAND() or NOW() and formula cells that depend on them.</ahelp></paragraph> <paragraph role="paragraph" id="par_id3154753" xml-lang="en-US"><ahelp hid=".uno:Calculate">In either mode, with formula cell(s) selected pressing F9 recalculates the currently selected cells and formula cells that depend on them. This can be useful after reading documents with recalculation disabled and individual cells need recalculation.</ahelp></paragraph> -<paragraph role="paragraph" id="par_id315475899" xml-lang="en-US">Press F9 to recalculate. Press Shift+<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9 to recalculate all formulas in the document.</paragraph> +<paragraph role="paragraph" id="par_id315475899" xml-lang="en-US">Press <keycode>F9</keycode> to recalculate. Press <keycode>Shift</keycode>+<switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline>+<keycode>F9</keycode> to recalculate all formulas in the document, including Add-In functions and non-volatile functions.</paragraph> +<paragraph role="paragraph" id="par_id3150799" xml-lang="en-US">After the document has been recalculated, the display is refreshed. All charts are also refreshed.</paragraph> </section> -<section id="howtoget"> -<embed href="text/scalc/00/00000406.xhp#formula_options"/> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id641645233417894"><link href="text/shared/optionen/01060900.xhp" name="relaculationoptions">Recalculation options</link></paragraph> </section> -<paragraph role="paragraph" id="par_id3150793" xml-lang="en-US">Recalculation options are, Recalculation on File Load, with values:</paragraph> -<paragraph role="paragraph" id="par_id3150795" xml-lang="en-US">Always recalculate, Never recalculate (default option), Prompt user.</paragraph> - -<paragraph role="paragraph" id="par_id315475855" xml-lang="en-US">Press Shift+<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9 to recalculate all formulas in the document, including Add-In functions. The hard recalculation correctly recalculates all formula cells.</paragraph> -<paragraph role="paragraph" id="par_id3150799" xml-lang="en-US">After the document has been recalculated, the display is refreshed. All charts are also refreshed.</paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/calculate.xhp b/source/text/scalc/01/calculate.xhp index 143c123c27..ab06f421b7 100644 --- a/source/text/scalc/01/calculate.xhp +++ b/source/text/scalc/01/calculate.xhp @@ -19,13 +19,14 @@ <section id="calculateheader"> <bookmark id="bm_id931584668179315" xml-lang="en-US" branch="hid/uno:CellContentsMenu" localize="false"/> <h1 id="hd_id621584668179317"><link href="text/scalc/01/calculate.xhp" name="Calculate">Calculate</link></h1> - <paragraph id="par_id241584668179318" role="paragraph" xml-lang="en-US"><ahelp hid=".">Commands to calculate formula cells.</ahelp></paragraph> + <paragraph id="par_id241584668179318" role="paragraph" xml-lang="en-US">Commands to calculate formula cells.</paragraph> </section> <section id="howtoget"> - + <paragraph role="paragraph" id="par_id251645222672072">Choose <menuitem>Data - Calculate</menuitem></paragraph> </section> <embed href="text/scalc/01/06080000.xhp#recalculateheader"/> + <embed href="text/scalc/01/recalculate_hard.xhp#recalculate_hard_head"/> + <embed href="text/scalc/01/formula2value.xhp#formula2value"/> <embed href="text/scalc/01/06070000.xhp#autocalculate"/> - </body> </helpdocument> diff --git a/source/text/scalc/01/formula2value.xhp b/source/text/scalc/01/formula2value.xhp new file mode 100644 index 0000000000..3b06a1c7dd --- /dev/null +++ b/source/text/scalc/01/formula2value.xhp @@ -0,0 +1,36 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + + <meta> + <topic id="formulatovalues" indexer="include" status="PUBLISH"> + <title id="tit" xml-lang="en-US">Formula to values</title> + <filename>/text/scalc/01/formula2value.xhp</filename> + </topic> + </meta> + <body> + <bookmark id="bm_id851645222861111" xml-lang="en-US" branch="hid/.uno:ConvertFormulaToValue" localize="false"/> + <bookmark xml-lang="en-US" branch="index" id="bm_id321645231251889"> +<bookmark_value>convert;formula to values</bookmark_value> +<bookmark_value>replace formula with values</bookmark_value> +<bookmark_value>recalculate;formula to values</bookmark_value> +<bookmark_value>formula to values;convert</bookmark_value> +<bookmark_value>formula to values;recalculate</bookmark_value> + </bookmark> + <section id="formula2value"> + <h1 id="hd_id701645222861113"><variable id="formula2valueh1"><link href="text/scalc/01/formula2value.xhp" name="formula to values">Formula to value</link></variable></h1> + <paragraph id="par_id501645222861116" role="paragraph" xml-lang="en-US">Replaces the formula cell with value calculated by the formula. The formula is lost.</paragraph> + </section> + <section id="howtoget"> + <embed href="text/scalc/00/00000406.xhp#formula2value"/> + </section> + <paragraph role="paragraph" id="par_id51645230882532">Use this command to convert formula cells into data cells. The converted cells contents becomes static and will not be recalculated.</paragraph> +</body> +</helpdocument> diff --git a/source/text/scalc/01/recalculate_hard.xhp b/source/text/scalc/01/recalculate_hard.xhp new file mode 100644 index 0000000000..20abafc278 --- /dev/null +++ b/source/text/scalc/01/recalculate_hard.xhp @@ -0,0 +1,37 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * +--> + +<meta> + <topic id="reclaculate hard" indexer="include" status="PUBLISH"> + <title id="tit" xml-lang="en-US">Recalculate hard</title> + <filename>/text/scalc/01/recalculate_hard.xhp</filename> + </topic> +</meta> +<body> +<bookmark id="bm_id581645217532281" xml-lang="en-US" branch="hid/.uno:CalculateHard" localize="false"/> +<bookmark xml-lang="en-US" branch="index" id="bm_id351645231629404"> + <bookmark_value>calculate;recalculate hard</bookmark_value> + <bookmark_value>formulas;recalculate hard</bookmark_value> + <bookmark_value>calculate;force recalculation</bookmark_value> + <bookmark_value>formulas;force recalculation</bookmark_value> + <bookmark_value>non volatile functions;force recalculation</bookmark_value> + <bookmark_value>cell contents;force recalculation</bookmark_value> +</bookmark> +<section id="recalculate_hard_head"> + <h1 id="hd_id611645217532285"><variable id="recalculatehardh1"><link href="text/scalc/01/recalculate_hard.xhp" name="recalculate hard">Recalculate Hard</link></variable></h1> + <paragraph id="par_id631645217532291" role="paragraph" xml-lang="en-US">Recalculates all formulas in the document, including Add-In functions and non-volatile functions.</paragraph> +</section> +<section id="howtoget"> + <embed href="text/scalc/00/00000406.xhp#recalculate_hard"/> +</section> +<paragraph role="paragraph" id="par_id361645227084327">The <menuitem>Recalculate Hard</menuitem> command forces recalculation of all formula cells of the spreadsheet document, including explicit non-volatile functions, even if no new input event exist. Examples of explicit non-volatile functions are <link href="text/scalc/01/04060106.xhp#rand_nv" name="RAND.NV">RAND.NV</link> and <link href="text/scalc/01/04060106.xhp#randbetween_nv" name="RANDBETWEEN.NV">RANDBETWEEN.NV</link>.</paragraph> +</body> +</helpdocument> |