source/text/scalc/01/04060106.xhp | 7 ++++---
1 file changed, 4 insertions(+), 3 deletions(-)
New commits:
commit 5f532332487c5c57eecb949d0d83fdf2c5f4e7ac
Author: Steve Fanning <stevemfann...@yahoo.co.uk>
AuthorDate: Tue Oct 26 20:37:57 2021 +0200
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Tue Nov 2 08:05:33 2021 +0100
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.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060106.xhp
b/source/text/scalc/01/04060106.xhp
index 389cf9d23..acd376eae 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>
