tdf#145898 Formula to Value and Recalculate Hard

Review of the Data - Calculate submenu - Added Recalculate Hard page - Added Formula to value page - Links and embed for navigation - Some precisions regarding non-volatile functions Change-Id: Ic39b61feb851b9cc7c8cb2ae6907651a64a81a6e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/130180 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com>
author: Olivier Hallot <olivier.hallot@libreoffice.org> 2022-02-18 22:09:31 -0300
committer: Eike Rathke <erack@redhat.com> 2022-02-23 22:48:58 +0100
commit: 4ac52bffa0d4055a8c18d1a25d15a68eae00adee (patch)
tree: 05dec84c4cccb546d54fe5eb42ebded06a0c6f41
parent: 046e5b4b6101edcc1614dd2dc392d8feab9eb891 (diff)
9 files changed, 113 insertions, 29 deletions
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index fd7d20600d..de4304d996 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -187,6 +187,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
     helpcontent2/source/text/scalc/01/databar_more_options \
     helpcontent2/source/text/scalc/01/ex_data_stat_func \
     helpcontent2/source/text/scalc/01/format_graphic \
+    helpcontent2/source/text/scalc/01/formula2value \
     helpcontent2/source/text/scalc/01/ful_func \
     helpcontent2/source/text/scalc/01/func_aggregate \
     helpcontent2/source/text/scalc/01/func_arabic \
@@ -275,6 +276,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
     helpcontent2/source/text/scalc/01/func_year \
     helpcontent2/source/text/scalc/01/func_yearfrac \
     helpcontent2/source/text/scalc/01/live_data_stream \
+    helpcontent2/source/text/scalc/01/recalculate_hard \
     helpcontent2/source/text/scalc/01/solver \
     helpcontent2/source/text/scalc/01/solver_options \
     helpcontent2/source/text/scalc/01/solver_options_algo \
diff --git a/source/text/scalc/00/00000406.xhp b/source/text/scalc/00/00000406.xhp
index 045c12d528..7c90749a11 100644
--- a/source/text/scalc/00/00000406.xhp
+++ b/source/text/scalc/00/00000406.xhp
@@ -25,7 +25,7 @@
   </topic>
 </meta>
 <body>
-<paragraph id="hd_id3147264" role="heading" level="1" xml-lang="en-US">Tools Menu</paragraph>
+<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>
 
 <section id="trace_precedents">
@@ -55,11 +55,22 @@
 
 <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">F9</paragraph>
+<paragraph id="par_id3149257" role="paragraph" xml-lang="en-US">Press <keycode>F9</keycode></paragraph>
 </section>
+
 <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>
+</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>
 </body>
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>
diff --git a/source/text/shared/optionen/01060900.xhp b/source/text/shared/optionen/01060900.xhp
index c6c8e5f526..790c3851a1 100644
--- a/source/text/shared/optionen/01060900.xhp
+++ b/source/text/shared/optionen/01060900.xhp
@@ -43,14 +43,14 @@
         </bookmark>
         <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optformula/OptFormula" id="bm_id3149095" localize="false"/>
         <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optformula/@@nowidget@@" id="@@nowidget@@" localize="false"/>
-        <paragraph id="hd_id3145071" role="heading" level="1" xml-lang="en-US"><link href="text/shared/optionen/01060900.xhp" name="Formula">Formula</link></paragraph>
+        <h1 id="hd_id3145071"><link href="text/shared/optionen/01060900.xhp" name="Formula">Formula</link></h1>
         <paragraph id="par_id3147576" role="paragraph" xml-lang="en-US"><ahelp hid=".">Defines formula syntax options and loading options for %PRODUCTNAME Calc.</ahelp></paragraph>
     </section>
     <section id="howtoget">
         <embed href="text/shared/00/00000406.xhp#exopfo"/>
     </section>
-    <paragraph id="hd_id3149399" role="heading" level="2" xml-lang="en-US">Formula options</paragraph>
-    <paragraph id="hd_id31493991" role="heading" level="3" xml-lang="en-US">Formula syntax</paragraph>
+    <h2 id="hd_id3149399">Formula options</h2>
+    <h3 id="hd_id31493991">Formula syntax</h3>
     <paragraph id="par_id3155419" role="paragraph" xml-lang="en-US">There are three options. Let's see it by example. In a sample spreadsheet there are two worksheets, Sheet1 and Sheet2. In A1 cell of Sheet1 there is a reference to C4 cell of Sheet2.</paragraph>
 
     <list type="unordered">
@@ -63,10 +63,10 @@
         <listitem>
             <paragraph id="par_id3153061" role="listitem" xml-lang="en-US"><emph>Excel R1C1</emph> - This is the relative row/column addressing, known from Microsoft Excel. The reference will be <item type="input">=Sheet2!R[3]C[2]</item></paragraph>
             </listitem></list>
-    <paragraph id="hd_id31493992" role="heading" level="3" xml-lang="en-US">Use English function names</paragraph>
+    <h3 id="hd_id31493992">Use English function names</h3>
     <paragraph id="par_id4155419" role="paragraph" xml-lang="en-US">In %PRODUCTNAME Calc function names can be localized. By default, the check box is off, which means the localized function names are used. Checking this check box will swap localized function names with the English ones. This change takes effect in all of the following areas: formula input and display, function wizard, and formula tips. You can of course uncheck it to go back to the localized function names.</paragraph>
 
-    <paragraph id="hd_id4149399" role="heading" level="2" xml-lang="en-US">Separators</paragraph>
+    <h2 id="hd_id4149399">Separators</h2>
     <paragraph id="par_id5155419" role="paragraph" xml-lang="en-US">This option group lets you configure separators in your formula expressions. This comes in handy when, for instance, you want to separate your function parameters by commas (,) instead of semicolons (;).</paragraph>
     <paragraph id="par_id6155419" role="paragraph" xml-lang="en-US">For example, instead of <item type="input">=SUM(A1;B1;C1)</item> you can type <item type="input">=SUM(A1,B1,C1)</item>.</paragraph>
     <paragraph id="par_id7155419" role="paragraph" xml-lang="en-US">Likewise, you can also change the column and row separators for in-line arrays. Previously, an in-line array used semicolons (;) as the column separators and the pipe symbols (|) as the row separators, so a typical in-line array expression looked like this for a 5 x 2 matrix array:</paragraph>
@@ -76,16 +76,13 @@
 
     <embed href="text/shared/optionen/detailedcalculation.xhp#detailed_calculation"/>
 
-    <paragraph id="hd_id5149400" role="heading" level="2" xml-lang="en-US">Recalculation on File Load</paragraph>
-	    <section id="howtoget">
-        <embed href="text/scalc/00/00000406.xhp#formula_options"/>
-    </section>
+    <h2 id="hd_id5149400">Recalculation on File Load</h2>
     <paragraph id="par_id2335549" role="paragraph" xml-lang="en-US">Recalculating formulas can take significant time while loading very large files.</paragraph>
 
-    <paragraph id="par_id2115549" role="heading" level="3" xml-lang="en-US">Excel 2007 and newer:</paragraph>
+    <h3 id="par_id2115549">Excel 2007 and newer:</h3>
     <paragraph id="par_id2015549" role="paragraph" xml-lang="en-US">Loading a large spreadsheet file can take a long time. If you don't need to update your large spreadsheet data immediately, you can postpone the recalculation at a better time. %PRODUCTNAME allows you to defer recalculation of Excel 2007 (and above) spreadsheets to speedup loading time. </paragraph>
 
-    <paragraph id="par_id2215549" role="heading" level="3" xml-lang="en-US">ODF Spreadsheet (not saved by %PRODUCTNAME):</paragraph>
+    <h3 id="par_id2215549">ODF Spreadsheet (not saved by %PRODUCTNAME):</h3>
     <paragraph id="par_id2016549" role="paragraph" xml-lang="en-US">Recent versions of %PRODUCTNAME caches spreadsheet formula results into its ODF file. This feature helps %PRODUCTNAME to recalculate a large ODF spreadsheet saved by %PRODUCTNAME faster. </paragraph>
     <paragraph id="par_id2017549" role="paragraph" xml-lang="en-US">For ODF spreadsheets saved by other programs, where such cached formula results may not exist, recalculation can be deferred to speedup file loading as with Excel 2007 files. </paragraph>
     <paragraph id="par_id2315549" role="paragraph" xml-lang="en-US">For the entries above the following choices are possible:</paragraph>
@@ -100,7 +97,7 @@
         <listitem>
             <paragraph id="par_id3253061" role="listitem" xml-lang="en-US"><emph>Prompt user</emph> - Prompt user for action.</paragraph>
             </listitem></list>
-    <paragraph id="par_id2010549" role="tip" xml-lang="en-US">%PRODUCTNAME saved ODF spreadsheets will honor <emph>Never recalculate</emph> and <emph>Always recalculate</emph> options. </paragraph>
+    <tip id="par_id2010549">%PRODUCTNAME saved ODF spreadsheets will honor <emph>Never recalculate</emph> and <emph>Always recalculate</emph> options. </tip>
 
     <section id="relatedtopics">
         <paragraph id="par_id200920171902249043" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060107.xhp">Array formulas</link></paragraph>
diff --git a/source/text/shared/optionen/detailedcalculation.xhp b/source/text/shared/optionen/detailedcalculation.xhp
index 68fc24ac88..b14c0a9b36 100644
--- a/source/text/shared/optionen/detailedcalculation.xhp
+++ b/source/text/shared/optionen/detailedcalculation.xhp
@@ -69,6 +69,8 @@
         <paragraph id="par_id811567770857290" role="listitem"><emph>Calc A1 | Excel A1</emph></paragraph>
       </listitem>
     </list>
+    <h3 id="hd_id71645215179431">Apply those settings to current document only</h3>
+    <paragraph role="paragraph" id="par_id111645215251396">Mark this checkbox to apply the settings to the document only.</paragraph>
     <section id="relatedtopics">
       <paragraph role="paragraph" id="par_id191535211862982"><link href="text/scalc/01/04060102.xhp" name="dateandtime">Date and time functions</link></paragraph>
       <paragraph role="paragraph" id="par_id261535211868627"><link href="text/scalc/01/04060109.xhp#Section6" name="indirect">INDIRECT function</link></paragraph>
author	Olivier Hallot <olivier.hallot@libreoffice.org>	2022-02-18 22:09:31 -0300
committer	Eike Rathke <erack@redhat.com>	2022-02-23 22:48:58 +0100
commit	4ac52bffa0d4055a8c18d1a25d15a68eae00adee (patch)
tree	05dec84c4cccb546d54fe5eb42ebded06a0c6f41
parent	046e5b4b6101edcc1614dd2dc392d8feab9eb891 (diff)