source/text/scalc/00/00000406.xhp | 61 +++++++++++-------------------
source/text/scalc/00/00000412.xhp | 40 +++++++++++++++++++
source/text/scalc/01/06070000.xhp | 17 ++++----
source/text/scalc/01/06080000.xhp | 20 +++++----
source/text/scalc/01/calculate.xhp | 12 ++---
source/text/scalc/01/formula2value.xhp | 13 +++---
source/text/scalc/01/recalculate_hard.xhp | 13 +++---
7 files changed, 105 insertions(+), 71 deletions(-)
New commits:
commit d9747fbaf0a8011c106c85fefb7eb9e6f571b505
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Wed Jan 3 13:02:21 2024 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Jan 3 20:23:03 2024 +0100
tdf#155876 UI cmds Calc-Sheet menu (39)
+ Data menu for Calc, Calculate commands
+ refactoring
Change-Id: I068b4c240b0a3192ddcb6f77fd6a2a52ac374437
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/161594
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/00/00000406.xhp
b/source/text/scalc/00/00000406.xhp
index 64239b361e..5a05db44d1 100644
--- a/source/text/scalc/00/00000406.xhp
+++ b/source/text/scalc/00/00000406.xhp
@@ -20,63 +20,48 @@
<meta>
<topic id="textscalc0000000406xml" indexer="exclude" status="PUBLISH">
- <title id="tit" xml-lang="en-US">Tools Menu</title>
+ <title id="tit">Tools Menu</title>
<filename>/text/scalc/00/00000406.xhp</filename>
</topic>
</meta>
<body>
<h1 id="hd_id3147264">Tools Menu</h1>
-<paragraph id="par_id3150541" role="paragraph" xml-lang="en-US"><variable
id="exdektv">Choose <emph>Tools - Detective</emph>.</variable></paragraph>
+<paragraph id="par_id3150541" role="paragraph"><variable id="exdektv">Choose
<emph>Tools - Detective</emph>.</variable></paragraph>
<section id="trace_precedents">
-<paragraph id="par_id3153194" role="paragraph" xml-lang="en-US">Choose
<emph>Tools - Detective - Trace Precedents</emph>.</paragraph>
-<paragraph id="par_id3150447" role="paragraph"
xml-lang="en-US">Shift+F9</paragraph>
+<paragraph id="par_id3153194" role="paragraph">Choose <emph>Tools - Detective
- Trace Precedents</emph>.</paragraph>
+<paragraph id="par_id3150447" role="paragraph">Shift+F9</paragraph>
</section>
-<paragraph id="par_id3154123" role="paragraph" xml-lang="en-US"><variable
id="silbentrennungc">Menu <emph>Tools - Language -
Hyphenation</emph>.</variable></paragraph>
-<paragraph id="par_id3145785" role="paragraph" xml-lang="en-US"><variable
id="exdvore">Choose <emph>Tools - Detective - Remove
Precedents</emph>.</variable></paragraph>
+<paragraph id="par_id3154123" role="paragraph"><variable
id="silbentrennungc">Menu <emph>Tools - Language -
Hyphenation</emph>.</variable></paragraph>
+<paragraph id="par_id3145785" role="paragraph"><variable id="exdvore">Choose
<emph>Tools - Detective - Remove Precedents</emph>.</variable></paragraph>
<section id="trace_dependents">
-<paragraph id="par_id3155411" role="paragraph" xml-lang="en-US">Choose
<emph>Tools - Detective - Trace Dependents</emph>.</paragraph>
-<paragraph id="par_id3153363" role="paragraph"
xml-lang="en-US">Shift+F5</paragraph>
+<paragraph id="par_id3155411" role="paragraph">Choose <emph>Tools - Detective
- Trace Dependents</emph>.</paragraph>
+<paragraph id="par_id3153363" role="paragraph">Shift+F5</paragraph>
</section>
-<paragraph id="par_id3146984" role="paragraph" xml-lang="en-US"><variable
id="exdszne">Choose <emph>Tools - Detective - Remove
Dependents</emph>.</variable></paragraph>
-<paragraph id="par_id3154014" role="paragraph" xml-lang="en-US"><variable
id="exdase">Choose <emph>Tools - Detective - Remove All
Traces</emph>.</variable></paragraph>
-<paragraph id="par_id3153188" role="paragraph" xml-lang="en-US"><variable
id="exdszfe">Choose <emph>Tools - Detective - Trace
Error</emph>.</variable></paragraph>
-<paragraph id="par_id3149410" role="paragraph" xml-lang="en-US"><variable
id="fuellmodus">Choose <emph>Tools - Detective - Fill
Mode</emph>.</variable></paragraph>
-<paragraph id="par_id3156284" role="paragraph" xml-lang="en-US"><variable
id="dateneinkreisen">Choose <emph>Tools - Detective - Mark Invalid
Data</emph>.</variable></paragraph>
-<paragraph id="par_id3153159" role="paragraph" xml-lang="en-US"><variable
id="spurenaktualisieren">Choose <emph>Tools - Detective - Refresh
Traces</emph>.</variable></paragraph>
-<paragraph id="par_id3147397" role="paragraph" xml-lang="en-US"><variable
id="automatisch">Choose <emph>Tools - Detective -
AutoRefresh</emph>.</variable></paragraph>
-<paragraph id="par_id3154018" role="paragraph" xml-lang="en-US"><variable
id="exzws">Choose <emph>Tools - Goal Seek</emph>.</variable></paragraph>
-<paragraph id="par_id3269142" role="paragraph" xml-lang="en-US"><variable
id="solver">Choose <emph>Tools - Solver</emph>.</variable></paragraph>
-<paragraph id="par_id8554338" role="paragraph" xml-lang="en-US"><variable
id="solver_options">Choose <emph>Tools - Solver</emph>, click
<emph>Options</emph> button.</variable></paragraph>
-<paragraph id="par_id3156277" role="paragraph" xml-lang="en-US"><variable
id="exsze">Choose <emph>Tools - Scenarios</emph>.</variable></paragraph>
+<paragraph id="par_id3146984" role="paragraph"><variable id="exdszne">Choose
<emph>Tools - Detective - Remove Dependents</emph>.</variable></paragraph>
+<paragraph id="par_id3154014" role="paragraph"><variable id="exdase">Choose
<emph>Tools - Detective - Remove All Traces</emph>.</variable></paragraph>
+<paragraph id="par_id3153188" role="paragraph"><variable id="exdszfe">Choose
<emph>Tools - Detective - Trace Error</emph>.</variable></paragraph>
+<paragraph id="par_id3149410" role="paragraph"><variable
id="fuellmodus">Choose <emph>Tools - Detective - Fill
Mode</emph>.</variable></paragraph>
+<paragraph id="par_id3156284" role="paragraph"><variable
id="dateneinkreisen">Choose <emph>Tools - Detective - Mark Invalid
Data</emph>.</variable></paragraph>
+<paragraph id="par_id3153159" role="paragraph"><variable
id="spurenaktualisieren">Choose <emph>Tools - Detective - Refresh
Traces</emph>.</variable></paragraph>
+<paragraph id="par_id3147397" role="paragraph"><variable
id="automatisch">Choose <emph>Tools - Detective -
AutoRefresh</emph>.</variable></paragraph>
+<paragraph id="par_id3154018" role="paragraph"><variable id="exzws">Choose
<emph>Tools - Goal Seek</emph>.</variable></paragraph>
+<paragraph id="par_id3269142" role="paragraph"><variable id="solver">Choose
<emph>Tools - Solver</emph>.</variable></paragraph>
+<paragraph id="par_id8554338" role="paragraph"><variable
id="solver_options">Choose <emph>Tools - Solver</emph>, click
<emph>Options</emph> button.</variable></paragraph>
+<paragraph id="par_id3156277" role="paragraph"><variable id="exsze">Choose
<emph>Tools - Scenarios</emph>.</variable></paragraph>
<paragraph role="paragraph" id="par_id971647297529392"><variable
id="tools_forms">Choose <emph>Tools - Forms</emph>.</variable></paragraph>
<paragraph role="paragraph" id="par_id371647273694433"><variable
id="share_spreadsheet">Choose <menuitem>Tools - Share
Spreadsheet</menuitem></variable></paragraph>
-<paragraph id="par_id3149020" role="paragraph" xml-lang="en-US"><variable
id="protect_sheet">Choose <emph>Tools - Protect
Sheet</emph>.</variable></paragraph>
-<paragraph id="par_id3154256" role="paragraph" xml-lang="en-US"><variable
id="protect_spreadsheet">Choose <emph>Tools - Protect Spreadsheet
Structure</emph>.</variable></paragraph>
-
-<section id="recalculate">
-<paragraph id="par_id3146919" role="paragraph" xml-lang="en-US">Choose
<emph>Data - Calculate - Recalculate</emph>.</paragraph>
-<paragraph id="par_id3149257" role="paragraph" xml-lang="en-US">Press
<keycode>F9</keycode></paragraph>
-</section>
+<paragraph id="par_id3149020" role="paragraph"><variable
id="protect_sheet">Choose <emph>Tools - Protect
Sheet</emph>.</variable></paragraph>
+<paragraph id="par_id3154256" role="paragraph"><variable
id="protect_spreadsheet">Choose <emph>Tools - Protect Spreadsheet
Structure</emph>.</variable></paragraph>
<section id="formula_options">
-<paragraph id="par_id3146919a" 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>
-
-<section id="recalculate_hard">
- <paragraph role="paragraph" id="par_id891645217179561">Choose
<menuitem>Data - Calculate - Recalculate hard</menuitem>.</paragraph>
- <paragraph role="paragraph" id="par_id21645217233263">Press
<keycode>Shift</keycode>+<switchinline select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline>+<keycode>F9</keycode></paragraph>
-</section>
-
-<section id="formula2value">
- <paragraph role="paragraph" id="par_id31645223233125">Select a formula
cell or a formula cell range and choose <menuitem>Data - Calculate - Formula to
values</menuitem></paragraph>
+<paragraph id="par_id3146919a" role="paragraph">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>
+<paragraph id="par_id3151276" role="paragraph"><variable
id="autoeingabe">Choose <emph>Tools - AutoInput</emph>.</variable></paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/00/00000412.xhp
b/source/text/scalc/00/00000412.xhp
index 488bafc7e9..fa03249942 100644
--- a/source/text/scalc/00/00000412.xhp
+++ b/source/text/scalc/00/00000412.xhp
@@ -382,7 +382,45 @@
</tablerow>
</table>
</section>
-
<paragraph role="paragraph" id="par_idN10B8F"><variable
id="grouping">Choose <emph>Data - Group and Outline -
Group</emph>.</variable></paragraph>
+
+ <section id="recalculate_hard">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id891645217179561">Choose
<menuitem>Data - Calculate - Recalculate hard</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph role="paragraph" id="par_id21645217233263"><switchinline
select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>
+ Shift + F9</keycode></paragraph>
+ </section>
+ <section id="recalculate">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id3146919" role="paragraph">Choose <menuitem>Data -
Calculate - Recalculate</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id941704291900381">Choose
<menuitem>Data - Recalculate</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id91704291937592">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Recalculate</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id871704291971183">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id891704291971184"
role="paragraph"><image src="cmd/lc_calculate.svg" id="img_id11704291971185"
width="1cm" height="1cm"><alt id="alt_id421704291971186">Icon
Recalculate</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id981704291971188"
role="paragraph">Recalculate</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph id="par_id3149257"
role="paragraph"><keycode>F9</keycode></paragraph>
+ </section>
+ <section id="formula2value">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id31645223233125">Choose
<menuitem>Data - Calculate - Formula to Value</menuitem>.</paragraph>
+ </section>
+ <section id="autocalculate">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id3150941" role="paragraph"><variable
id="exatmb">Choose <menuitem>Data - Calculate -
AutoCalculate</menuitem>.</variable></paragraph>
+ </section>
+ <section id="calculate">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id251645222672072">Choose
<menuitem>Data - Calculate</menuitem></paragraph>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/06070000.xhp
b/source/text/scalc/01/06070000.xhp
index 08c1be799e..0a9fe6d702 100644
--- a/source/text/scalc/01/06070000.xhp
+++ b/source/text/scalc/01/06070000.xhp
@@ -19,13 +19,12 @@
<helpdocument version="1.0">
<meta>
<topic id="textscalc0106070000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">AutoCalculate</title>
+<title id="tit">AutoCalculate</title>
<filename>/text/scalc/01/06070000.xhp</filename>
</topic>
</meta>
<body>
-<section id="autocalculate">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3145673"><bookmark_value>calculating; auto calculating
sheets</bookmark_value>
+<bookmark branch="index" id="bm_id3145673"><bookmark_value>calculating; auto
calculating sheets</bookmark_value>
<bookmark_value>recalculate;auto calculating sheets</bookmark_value>
<bookmark_value>recalculating;auto calculating sheets</bookmark_value>
<bookmark_value>AutoCalculate function in sheets</bookmark_value>
@@ -33,13 +32,17 @@
<bookmark_value>formulas;AutoCalculate function</bookmark_value>
<bookmark_value>cell contents;AutoCalculate function</bookmark_value>
</bookmark><comment>mw added "recalculating;..." </comment>
-<bookmark xml-lang="en-US" branch="hid/.uno:AutomaticCalculation"
id="bm_id6626340" localize="false"/>
+<section id="autocalculate">
+<bookmark branch="hid/.uno:AutomaticCalculation" id="bm_id6626340"
localize="false"/>
<h1 id="hd_id3145673"><link
href="text/scalc/01/06070000.xhp">AutoCalculate</link></h1>
-<paragraph role="paragraph" id="par_id3148798" xml-lang="en-US"><ahelp
hid=".uno:AutomaticCalculation">Automatically recalculates all formulas in the
document.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3148798"><ahelp
hid=".uno:AutomaticCalculation">Automatically recalculates all formulas in the
document.</ahelp></paragraph>
</section>
-<paragraph role="paragraph" id="par_id3145173" xml-lang="en-US">All cells are
recalculated after a sheet cell has been modified. Any charts in the sheet will
also be refreshed.</paragraph>
+<paragraph role="paragraph" id="par_id3145173">All cells are recalculated
after a sheet cell has been modified. Any charts in the sheet will also be
refreshed.</paragraph>
<section id="howtoget">
- <embed href="text/scalc/00/00000406.xhp#exatmb"/>
+ <embed href="text/scalc/00/00000412.xhp#autocalculate"/>
</section>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id341704295996382"
localize="false"><embedvar href="text/scalc/01/calculate.xhp#h1"
markup="ignore"/></paragraph>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/06080000.xhp
b/source/text/scalc/01/06080000.xhp
index 6d837ff1d8..2cfa1b3487 100644
--- a/source/text/scalc/01/06080000.xhp
+++ b/source/text/scalc/01/06080000.xhp
@@ -21,33 +21,35 @@
<meta>
<topic id="textscalc0106080000xml" indexer="include">
-<title id="tit" xml-lang="en-US">Recalculate</title>
+<title id="tit">Recalculate</title>
<filename>/text/scalc/01/06080000.xhp</filename>
</topic>
</meta>
<body>
<section id="recalculate">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3157909"><bookmark_value>recalculating;all formulas in
sheets</bookmark_value>
+<bookmark branch="index" id="bm_id3157909"><bookmark_value>recalculating;all
formulas in sheets</bookmark_value>
<bookmark_value>recalculate;all formulas in sheets</bookmark_value>
<bookmark_value>formulas; recalculating manually</bookmark_value>
<bookmark_value>cell contents; recalculating</bookmark_value>
</bookmark><comment>mw changed "recalculating;...", "formulas;..." and
"cell..." entries and deleted "recalculating formulas"</comment>
-<bookmark xml-lang="en-US" branch="hid/.uno:Calculate" id="bm_id2661876"
localize="false"/>
+<bookmark branch="hid/.uno:Calculate" id="bm_id2661876" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuData-Calculate"
id="bm_id601704292831432" localize="false"/>
<section id="recalculateheader">
<h1 id="hd_id3157909"><link
href="text/scalc/01/06080000.xhp">Recalculate</link></h1>
<paragraph role="paragraph" id="par_id951584669541929">Recalculates formula
cells.</paragraph>
</section>
<section id="howtoget">
-<embed href="text/scalc/00/00000406.xhp#recalculate"/>
+<embed href="text/scalc/00/00000412.xhp#recalculate"/>
</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
<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>
+<paragraph role="paragraph" id="par_id3154758"><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"><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"><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">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">After the document has been
recalculated, the display is refreshed. All charts are also
refreshed.</paragraph>
</section>
<section id="relatedtopics">
<paragraph role="paragraph" id="par_id641645233417894"><link
href="text/shared/optionen/01060900.xhp">Recalculation
options</link></paragraph>
+ <paragraph role="paragraph" id="par_id341704295996382"
localize="false"><embedvar href="text/scalc/01/calculate.xhp#h1"
markup="ignore"/></paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/calculate.xhp
b/source/text/scalc/01/calculate.xhp
index e5dc5d2b02..b6f6f258eb 100644
--- a/source/text/scalc/01/calculate.xhp
+++ b/source/text/scalc/01/calculate.xhp
@@ -11,18 +11,18 @@
<meta>
<topic id="menudatacalculate" indexer="include" status="PUBLISH">
- <title id="tit" xml-lang="en-US">Calculate</title>
+ <title id="tit">Calculate</title>
<filename>/text/scalc/01/calculate.xhp</filename>
</topic>
</meta>
- <body>
+<body>
+<bookmark id="bm_id931584668179315" branch="hid/uno:CellContentsMenu"
localize="false"/>
<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">Calculate</link></h1>
- <paragraph id="par_id241584668179318" role="paragraph"
xml-lang="en-US">Commands to calculate formula cells.</paragraph>
+ <h1 id="hd_id621584668179317"><variable id="h1"><link
href="text/scalc/01/calculate.xhp">Calculate</link></variable></h1>
+ <paragraph id="par_id241584668179318" role="paragraph">Commands to
calculate formula cells.</paragraph>
</section>
<section id="howtoget">
- <paragraph role="paragraph" id="par_id251645222672072">Choose
<menuitem>Data - Calculate</menuitem></paragraph>
+ <embed href="text/scalc/00/00000412.xhp#calculate"/>
</section>
<embed href="text/scalc/01/06080000.xhp#recalculateheader"/>
<embed href="text/scalc/01/recalculate_hard.xhp#recalculate_hard_head"/>
diff --git a/source/text/scalc/01/formula2value.xhp
b/source/text/scalc/01/formula2value.xhp
index abcb62ac3e..e340e68057 100644
--- a/source/text/scalc/01/formula2value.xhp
+++ b/source/text/scalc/01/formula2value.xhp
@@ -11,13 +11,13 @@
<meta>
<topic id="formulatovalues" indexer="include" status="PUBLISH">
- <title id="tit" xml-lang="en-US">Formula to values</title>
+ <title id="tit">Formula to Value</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 id="bm_id851645222861111"
branch="hid/.uno:ConvertFormulaToValue" localize="false"/>
+ <bookmark 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>
@@ -26,11 +26,14 @@
</bookmark>
<section id="formula2value">
<h1 id="hd_id701645222861113"><variable id="formula2valueh1"><link
href="text/scalc/01/formula2value.xhp">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>
+ <paragraph id="par_id501645222861116" role="paragraph">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"/>
+ <embed href="text/scalc/00/00000412.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>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id341704295996382"
localize="false"><embedvar href="text/scalc/01/calculate.xhp#h1"
markup="ignore"/></paragraph>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/recalculate_hard.xhp
b/source/text/scalc/01/recalculate_hard.xhp
index 628164d409..160525ad05 100644
--- a/source/text/scalc/01/recalculate_hard.xhp
+++ b/source/text/scalc/01/recalculate_hard.xhp
@@ -11,13 +11,13 @@
<meta>
<topic id="recalculate hard" indexer="include" status="PUBLISH">
- <title id="tit" xml-lang="en-US">Recalculate hard</title>
+ <title id="tit">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 id="bm_id581645217532281" branch="hid/.uno:CalculateHard"
localize="false"/>
+<bookmark 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>
@@ -27,11 +27,14 @@
</bookmark>
<section id="recalculate_hard_head">
<h1 id="hd_id611645217532285"><variable id="recalculatehardh1"><link
href="text/scalc/01/recalculate_hard.xhp">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>
+ <paragraph id="par_id631645217532291" role="paragraph">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"/>
+ <embed href="text/scalc/00/00000412.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">RAND.NV</link>
and <link
href="text/scalc/01/04060106.xhp#randbetween_nv">RANDBETWEEN.NV</link>.</paragraph>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id341704295996382"
localize="false"><embedvar href="text/scalc/01/calculate.xhp#h1"
markup="ignore"/></paragraph>
+</section>
</body>
</helpdocument>
