Inform user on volatile functions

Change-Id: I31f05cc446ecab2bba698660d31790652298578b
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/103634
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>

7 files changed, 14 insertions, 4 deletions

diff --git a/source/text/scalc/00/avail_release.xhp b/source/text/scalc/00/avail_release.xhp
index 52e5e790c0..13cace8af9 100644
--- a/source/text/scalc/00/avail_release.xhp
+++ b/source/text/scalc/00/avail_release.xhp
@@ -77,5 +77,8 @@
     <section id="7.0">
         <tip id="par_id651551401041665">This function is available since %PRODUCTNAME 7.0.</tip>
     </section>
+    <section id="7.1">
+        <tip id="par_id651551401041666">This function is available since %PRODUCTNAME 7.1.</tip>
+    </section>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/04060104.xhp b/source/text/scalc/01/04060104.xhp
index f79ff3163e..c6bf427ff8 100644
--- a/source/text/scalc/01/04060104.xhp
+++ b/source/text/scalc/01/04060104.xhp
@@ -154,7 +154,7 @@
 
 <paragraph id="hd_id5787224" role="heading" level="2" xml-lang="en-US">INFO</paragraph>
 <paragraph id="par_id1507309" role="paragraph" xml-lang="en-US">Returns specific information about the current working environment. The function receives a single text argument and returns data depending on that parameter.</paragraph>
-
+<embed href="text/scalc/01/ful_func.xhp#func_volatile"/>
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
 <paragraph id="par_id3928952" role="code" xml-lang="en-US">INFO("Type")</paragraph>
 <paragraph id="par_id5206762" role="paragraph" xml-lang="en-US">The following table lists the values for the text parameter <item type="literal">Type</item> and the return values of the INFO function.</paragraph>
@@ -250,7 +250,7 @@
 
 <paragraph id="hd_id3150688" role="heading" level="2" xml-lang="en-US">FORMULA</paragraph>
 <paragraph id="par_id3158417" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FORMEL">Displays the formula of a formula cell as a text string.</ahelp></paragraph>
-
+<embed href="text/scalc/01/ful_func.xhp#func_volatile"/>
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
 <paragraph id="par_id3147535" role="code" xml-lang="en-US">FORMULA(Reference)</paragraph>
 <paragraph id="par_id3014313" role="paragraph" xml-lang="en-US"><emph>Reference</emph> is a reference to a cell containing a formula.</paragraph>
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp
index ee630c6192..a1318fe487 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -1512,7 +1512,7 @@
 
 <h2 id="hd_id3164669">RANDBETWEEN</h2>
 <paragraph id="par_id3164711" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_RANDBETWEEN">Returns an integer random number in a specified range.</ahelp></paragraph>
-
+<embed href="text/scalc/01/ful_func.xhp#func_volatile"/>
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
 <paragraph id="par_id3164758" role="code" xml-lang="en-US">RANDBETWEEN(Bottom; Top)</paragraph>
 <paragraph id="par_id7112338" role="paragraph" xml-lang="en-US">Returns an integer random number between integers <emph>Bottom</emph> and <emph>Top</emph> (both inclusive).</paragraph>
@@ -1548,7 +1548,7 @@
 
 <h2 id="hd_id3164800">RAND</h2>
 <paragraph id="par_id3164829" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ZUFALLSZAHL">Returns a random number between 0 and 1.</ahelp><comment>The value of 0 can be returned, the value of 1 not.</comment><comment>this is really true after issue 53642 will be fixed</comment></paragraph>
-
+<embed href="text/scalc/01/ful_func.xhp#func_volatile"/>
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
 <paragraph id="par_id3164884" role="code" xml-lang="en-US">RAND()</paragraph>
 <paragraph id="par_id5092318" role="paragraph" xml-lang="en-US">This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press F9.</paragraph>
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp
index ef50060056..cd7809cd7e 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -209,6 +209,7 @@
 <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_INDIREKT" id="bm_id3153922" localize="false"/>
 <h2 id="hd_id3153181">INDIRECT</h2>
          <paragraph xml-lang="en-US" id="par_id3147169" role="paragraph"><ahelp hid="HID_FUNC_INDIREKT">Returns the <emph>reference</emph> specified by a text string.</ahelp> This function can also be used to return the area of a corresponding string.</paragraph>
+         <embed href="text/scalc/01/ful_func.xhp#func_volatile"/>
          <embed href="text/scalc/01/04060109.xhp#r1c1"/>
          <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
          <paragraph xml-lang="en-US" id="par_id3149824" role="code">INDIRECT(Ref [; A1])</paragraph>
@@ -350,6 +351,7 @@
 <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VERSCHIEBUNG" id="bm_id3148926" localize="false"/>
 <h2 id="hd_id3158430">OFFSET</h2>
          <paragraph xml-lang="en-US" id="par_id3149167" role="paragraph"><ahelp hid="HID_FUNC_VERSCHIEBUNG">Returns the value of a cell offset by a certain number of rows and columns from a given reference point.</ahelp></paragraph>
+         <embed href="text/scalc/01/ful_func.xhp#func_volatile"/>
          <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
          <paragraph xml-lang="en-US" id="par_id3159194" role="code">OFFSET(Reference; Rows; Columns [; Height [; Width]])</paragraph>
          <paragraph xml-lang="en-US" id="par_id3152360" role="paragraph">
diff --git a/source/text/scalc/01/ful_func.xhp b/source/text/scalc/01/ful_func.xhp
index d53e5fd815..8124719722 100644
--- a/source/text/scalc/01/ful_func.xhp
+++ b/source/text/scalc/01/ful_func.xhp
@@ -74,5 +74,8 @@
     <section id="reference255">
         <paragraph role="paragraph" id="par_id431584335947010"><emph>Reference 1, Reference 2, … ,Reference 255</emph> are references to cells.</paragraph>
     </section>
+    <section id="func_volatile">
+        <paragraph role="paragraph" id="par_id1001601332672155">This function is always recalculated whenever a recalculation occurs.</paragraph>
+    </section>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/func_now.xhp b/source/text/scalc/01/func_now.xhp
index fbb84d2ed1..45227d2886 100644
--- a/source/text/scalc/01/func_now.xhp
+++ b/source/text/scalc/01/func_now.xhp
@@ -29,6 +29,7 @@
 <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_JETZT" id="bm_id3150532" localize="false"/><h2 id="hd_id3150521"><variable id="now"><link href="text/scalc/01/func_now.xhp">NOW</link>
 </variable></h2>
 <paragraph role="paragraph" id="par_id3148829" xml-lang="en-US"><ahelp hid="HID_FUNC_JETZT">Returns the computer system date and time.</ahelp> The value is updated when you recalculate the document or each time a cell value is modified.</paragraph>
+<embed href="text/scalc/01/ful_func.xhp#func_volatile"/>
 <embed href="text/scalc/01/ODFF.xhp#odff"/>
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
 <paragraph role="code" id="par_id3154897" xml-lang="en-US">NOW()</paragraph>
diff --git a/source/text/scalc/01/func_today.xhp b/source/text/scalc/01/func_today.xhp
index ac5fee6e82..e4214238d4 100644
--- a/source/text/scalc/01/func_today.xhp
+++ b/source/text/scalc/01/func_today.xhp
@@ -29,6 +29,7 @@
 <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_HEUTE" id="bm_id3147267" localize="false"/><h2 id="hd_id3145659"><variable id="today"><link href="text/scalc/01/func_today.xhp">TODAY</link>
 </variable></h2>
 <paragraph role="paragraph" id="par_id3153759" xml-lang="en-US"><ahelp hid="HID_FUNC_HEUTE">Returns the current computer system date.</ahelp> The value is updated when you reopen the document or modify the values of the document.</paragraph>
+<embed href="text/scalc/01/ful_func.xhp#func_volatile"/>
 <embed href="text/scalc/01/ODFF.xhp#odff"/>
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
 <paragraph role="code" id="par_id3153154" xml-lang="en-US">TODAY()</paragraph>