[Libreoffice-commits] help.git: source/text

[Libreoffice Gerrit user]

 source/text/scalc/00/00000406.xhp |    2 +-
 source/text/scalc/01/06080000.xhp |   17 +++++++++++------
 2 files changed, 12 insertions(+), 7 deletions(-)

New commits:
commit 328abcbac6eba3c0bcfcd9fc82c5afd79d6e8d05
Author:     Mark <mark_r80 at hotmail.com>
AuthorDate: Thu Feb 7 11:21:57 2019 -0800
Commit:     Adolfo Jayme Barrientos <fitojb at ubuntu.com>
CommitDate: Thu Feb 7 23:41:49 2019 +0100

    tdf#107930 - Help needs to be corrected and amended for Recalculation
    
    changed test in 06080000.xhp
    
    Change-Id: I4cc8a0a04517306e5196aa79c607e624b488a56f
    Reviewed-on: https://gerrit.libreoffice.org/67518
    Tested-by: Jenkins
    Reviewed-by: Adolfo Jayme Barrientos <fitojb at ubuntu.com>

diff --git a/source/text/scalc/00/00000406.xhp b/source/text/scalc/00/00000406.xhp
index 40b1a51fe..9800a5977 100644
--- a/source/text/scalc/00/00000406.xhp
+++ b/source/text/scalc/00/00000406.xhp
@@ -58,7 +58,7 @@
 <paragraph id="par_id3149257" role="paragraph" xml-lang="en-US">F9</paragraph>
 </section>
 <section id="exnbr">
-<paragraph id="par_id3146944" role="paragraph" xml-lang="en-US">Choose <emph>Tools - Options - %PRODUCTNAME Calc - Formula</emph>.</paragraph>
+<paragraph id="par_id3146919" role="paragraph" xml-lang="en-US">Choose <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - Formula</emph>.</paragraph>
 </section>
 <paragraph id="par_id3150941" role="paragraph" xml-lang="en-US"><variable id="exatmb">Choose <emph>Data - Calculate - AutoCalculate</emph>.</variable></paragraph>
 <paragraph id="par_id3151276" role="paragraph" xml-lang="en-US"><variable id="autoeingabe">Choose <emph>Tools - AutoInput</emph>.</variable></paragraph>
diff --git a/source/text/scalc/01/06080000.xhp b/source/text/scalc/01/06080000.xhp
index b704a3c29..456aadf32 100644
--- a/source/text/scalc/01/06080000.xhp
+++ b/source/text/scalc/01/06080000.xhp
@@ -36,16 +36,21 @@
 <bookmark xml-lang="en-US" branch="hid/.uno:Calculate" id="bm_id2661876" localize="false"/>
 <bookmark xml-lang="en-US" branch="hid/.uno:Calculate" id="bm_id3156329" localize="false"/>
 <paragraph role="heading" id="hd_id3157909" xml-lang="en-US" level="1"><link href="text/scalc/01/06080000.xhp" name="Recalculate">Recalculate</link></paragraph>
-<paragraph role="paragraph" id="par_id3154758" xml-lang="en-US"><ahelp hid=".uno:Calculate">Recalculates all changed formulas. If AutoCalculate is enabled, the Recalculate command applies only to formulas like RAND or NOW.</ahelp></paragraph>
-</section>
 <section id="howtoget">
 <embed href="text/scalc/00/00000406.xhp#exnb"/>
 </section>
+<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>
+</section>
+<section id="howtoget">
+<embed href="text/scalc/00/00000406.xhp#exnbr"/>
+</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_id3150793" xml-lang="en-US">After the document has been recalculated, the display is refreshed. All charts are also refreshed.</paragraph>
-
-<paragraph role="paragraph" id="par_id315475855" xml-lang="en-US">Volatile (delivering different results on each call) Add-In functions currently cannot respond to the Recalculate command or F9. Press Shift+<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9 to recalculate all formulas, including the Add-In functions.</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>