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@ubuntu.com>

2 files changed, 12 insertions, 7 deletions

diff --git a/source/text/scalc/00/00000406.xhp b/source/text/scalc/00/00000406.xhp
index 40b1a51fee..9800a59777 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 b704a3c294..456aadf329 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>