[Libreoffice-commits] help.git: source/text
Olivier Hallot (via logerrit)
logerrit at kemper.freedesktop.org
Thu Oct 1 15:38:23 UTC 2020
source/text/scalc/00/avail_release.xhp | 3 +++
source/text/scalc/01/04060104.xhp | 4 ++--
source/text/scalc/01/04060106.xhp | 4 ++--
source/text/scalc/01/04060109.xhp | 2 ++
source/text/scalc/01/ful_func.xhp | 3 +++
source/text/scalc/01/func_now.xhp | 1 +
source/text/scalc/01/func_today.xhp | 1 +
7 files changed, 14 insertions(+), 4 deletions(-)
New commits:
commit d818260b9a4f4546cd5b5a5dbd825bb4ad0ed679
Author: Olivier Hallot <olivier.hallot at libreoffice.org>
AuthorDate: Tue Sep 29 15:00:00 2020 -0300
Commit: Olivier Hallot <olivier.hallot at libreoffice.org>
CommitDate: Thu Oct 1 17:38:04 2020 +0200
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 at libreoffice.org>
diff --git a/source/text/scalc/00/avail_release.xhp b/source/text/scalc/00/avail_release.xhp
index 52e5e790c..13cace8af 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 f79ff3163..c6bf427ff 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 ee630c619..a1318fe48 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 ef5006005..cd7809cd7 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 d53e5fd81..812471972 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 fbb84d2ed..45227d288 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 ac5fee6e8..e4214238d 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>
More information about the Libreoffice-commits
mailing list