summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSteve Fanning <stevemfanning@yahoo.co.uk>2021-10-26 20:37:57 +0200
committerOlivier Hallot <olivier.hallot@libreoffice.org>2021-11-02 08:05:33 +0100
commit5f532332487c5c57eecb949d0d83fdf2c5f4e7ac (patch)
tree45ffa08877967d299389527301723634bf48ccb0
parent95f006af3ffbe256ebf095db8be2ebd1321e673e (diff)
Update help to explain that CONVERT_OOO
Change-Id: I6f981b70f98c95cef510a60f4791336446db8648 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/124193 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
-rw-r--r--source/text/scalc/01/04060106.xhp7
1 files changed, 4 insertions, 3 deletions
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp
index 389cf9d237..acd376eae9 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -627,7 +627,7 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3152569" role="paragraph" xml-lang="en-US"><item type="input">=TRUNC(1.239;2)</item> returns 1.23. The 9 is lost.</paragraph>
<paragraph id="par_id7050080" role="paragraph" xml-lang="en-US"><item type="input">=TRUNC(-1.234999;3)</item> returns -1.234. All the 9s are lost.</paragraph><comment>see also INT, ROUND, ROUNDDOWN, ROUNDUP, CEILING, FLOOR, EVEN, ODD, MROUND</comment>
-<paragraph role="paragraph" id="par_id441635243969504"><input>=TRUNC(-45.67)</input> returns -45. The default value for <emph>Count</emph> is 0.</paragraph>
+<paragraph role="paragraph" id="par_id441635243969504"><input>=TRUNC(-45.67)</input> returns -45. The default value for <emph>Count</emph> is 0.</paragraph>
<tip id="par_id151635245092041">Refer to the <link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/TRUNC" name="TRUNC_Wiki">TRUNC</link> wiki page for more details about this function.</tip>
</section>
@@ -763,7 +763,7 @@
<paragraph id="par_id3144357" role="paragraph" xml-lang="en-US"><emph>M</emph> is the increment to increase N</paragraph>
<paragraph id="par_id3144370" role="paragraph" xml-lang="en-US"><emph>Coefficients</emph> is a series of coefficients. For each coefficient the series sum is extended by one section.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph role="paragraph" id="par_id431635251540138"><input>=SERIESSUM(A1; 0; 1; {1; 2; 3})</input> calculates the value of 1+2x+3x<sup>2</sup>, where x is the value in cell A1. If A1 contains 1, the formula returns 6; if A1 contains 2, the formula returns 17; if A1 contains 3, the formula returns 34; and so on.</paragraph>
+<paragraph role="paragraph" id="par_id431635251540138"><input>=SERIESSUM(A1; 0; 1; {1; 2; 3})</input> calculates the value of 1+2x+3x<sup>2</sup>, where x is the value in cell A1. If A1 contains 1, the formula returns 6; if A1 contains 2, the formula returns 17; if A1 contains 3, the formula returns 34; and so on.</paragraph>
<tip id="par_id881635251427220">Refer to the <link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/SERIESSUM" name="SERIESSUM_Wiki">SERIESSUM</link> wiki page for more details about this function.</tip>
</section>
@@ -1396,7 +1396,8 @@
<h2 id="hd_id0908200902074836">CONVERT_OOO</h2>
<paragraph id="par_id0908200902131122" role="paragraph" xml-lang="en-US"><ahelp hid=".">Converts to euros a currency value expressed in one of the legacy currencies of 19 member states of the European Union, and vice versa.</ahelp> The conversion uses the fixed exchange rates at which the legacy currencies entered the euro.</paragraph>
-<tip id="par_id581631900947319">We recommend using the more flexible EUROCONVERT function for converting between these currencies. For converting between many different units of measure, use the CONVERT function.</tip>
+
+<tip id="par_id581631900947319">We recommend using the more flexible EUROCONVERT function for converting between these currencies. CONVERT_OOO is not a standardized function and is not portable.</tip>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id0908200902131191" role="code" xml-lang="en-US">CONVERT_OOO(Value; "Text1"; "Text2")</paragraph>