source/text/scalc/01/04060107.xhp | 8 ++++----
1 file changed, 4 insertions(+), 4 deletions(-)
New commits:
commit 1a010a1c18a0d992afd907efc201f04f799f9c4a
Author: Steve Fanning <stevemfann...@yahoo.co.uk>
AuthorDate: Wed May 27 17:18:23 2020 +0200
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Fri May 29 17:47:21 2020 +0200
(04060107.xhp) Update syntax section for four functions to include square
brackets, indicating optional parameters.
Change-Id: Ie1b2a487be11c9e6b2ed17eae8e0b067510c8b61
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/94953
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060107.xhp
b/source/text/scalc/01/04060107.xhp
index ec0f868e2..185868bb5 100644
--- a/source/text/scalc/01/04060107.xhp
+++ b/source/text/scalc/01/04060107.xhp
@@ -693,7 +693,7 @@
<h2 id="hd_id3109846">LINEST</h2>
<paragraph id="par_id3144733" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_RGP">Returns a table of statistics for a straight line that best
fits a data set.</ahelp><comment>changed based on
https://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_LINEST_function
(issue 76142)</comment></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph id="par_id3152839" role="code" xml-lang="en-US">LINEST(data_Y;
data_X; linearType; stats)</paragraph>
+ <paragraph id="par_id3152839" role="code" xml-lang="en-US">LINEST(data_Y [;
data_X [; linearType [; stats]]])</paragraph>
<paragraph id="par_id3152853" role="paragraph"
xml-lang="en-US"><emph>data_Y</emph> is a single row or column range specifying
the y coordinates in a set of data points.</paragraph>
<paragraph id="par_id3154428" role="paragraph"
xml-lang="en-US"><emph>data_X</emph> is a corresponding single row or column
range specifying the x coordinates. If <emph>data_X</emph> is omitted it
defaults to <item type="literal">1, 2, 3, ..., n</item>. If there is more than
one set of variables <emph>data_X</emph> may be a range with corresponding
multiple rows or columns.</paragraph>
<paragraph id="par_id0811200804502119" role="paragraph"
xml-lang="en-US">LINEST finds a straight line <item type="literal">y = a +
bx</item> that best fits the data, using linear regression (the "least squares"
method). With more than one set of variables the straight line is of the form
<item type="literal">y = a + b1x1 + b2x2 ... + bnxn</item>.</paragraph>
@@ -965,7 +965,7 @@
<h2 id="hd_id3146009">LOGEST</h2>
<paragraph id="par_id3146037" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_RKP">This function calculates the adjustment of the entered data
as an exponential regression curve (y=b*m^x).</ahelp><comment>UFI: see
http://support.microsoft.com/default.aspx?kbid=828528&product=xl2003 for
bug #i31051#</comment></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph id="par_id3163123" role="code" xml-lang="en-US">LOGEST(DataY;
DataX; FunctionType; Stats)</paragraph>
+ <paragraph id="par_id3163123" role="code" xml-lang="en-US">LOGEST(DataY [;
DataX [; FunctionType [; Stats]]])</paragraph>
<paragraph id="par_id3163137" role="paragraph"
xml-lang="en-US"><emph>DataY</emph> represents the Y Data array.</paragraph>
<paragraph id="par_id3163155" role="paragraph"
xml-lang="en-US"><emph>DataX</emph> (optional) represents the X Data
array.</paragraph>
<paragraph id="par_id3163174" role="paragraph"
xml-lang="en-US"><emph>FunctionType</emph> (optional). If Function_Type = 0,
functions in the form y = m^x will be calculated. Otherwise, y = b*m^x
functions will be calculated.</paragraph>
@@ -1112,7 +1112,7 @@
<h2 id="hd_id3166062">TREND</h2>
<paragraph id="par_id3166091" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_TREND">Returns values along a linear trend.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph id="par_id3166122" role="code" xml-lang="en-US">TREND(DataY;
DataX; NewDataX; LinearType)</paragraph>
+ <paragraph id="par_id3166122" role="code" xml-lang="en-US">TREND(DataY [;
DataX [; NewDataX [; LinearType]]])</paragraph>
<paragraph id="par_id3166137" role="paragraph"
xml-lang="en-US"><emph>DataY</emph> represents the Y Data array.</paragraph>
<paragraph id="par_id3166156" role="paragraph"
xml-lang="en-US"><emph>DataX</emph> (optional) represents the X Data
array.</paragraph>
<paragraph id="par_id3166176" role="paragraph"
xml-lang="en-US"><emph>NewDataX</emph> (optional) represents the array of the X
data, which are used for recalculating values.</paragraph>
@@ -1131,7 +1131,7 @@
<h2 id="hd_id3166317">GROWTH</h2>
<paragraph id="par_id3166346" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_VARIATION">Calculates the points of an exponential trend in an
array.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph id="par_id3166377" role="code" xml-lang="en-US">GROWTH(DataY;
DataX; NewDataX; FunctionType)</paragraph>
+ <paragraph id="par_id3166377" role="code" xml-lang="en-US">GROWTH(DataY [;
DataX [; NewDataX [; FunctionType]]])</paragraph>
<paragraph id="par_id3166392" role="paragraph"
xml-lang="en-US"><emph>DataY</emph> represents the Y Data array.</paragraph>
<paragraph id="par_id3166411" role="paragraph"
xml-lang="en-US"><emph>DataX</emph> (optional) represents the X Data
array.</paragraph>
<paragraph id="par_id3173797" role="paragraph"
xml-lang="en-US"><emph>NewDataX</emph> (optional) represents the X data array,
in which the values are recalculated.</paragraph>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
