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_...@hotmail.com>
AuthorDate: Thu Feb 7 11:21:57 2019 -0800
Commit: Adolfo Jayme Barrientos <fit...@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 <fit...@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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
