[gnumeric] Doc fixes.
- From: Morten Welinder <mortenw src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [gnumeric] Doc fixes.
- Date: Wed, 17 Jan 2018 14:21:39 +0000 (UTC)
commit 3b9ee71cd9691ae9b061d2ba010c83498a9dfe3f
Author: Morten Welinder <terra gnome org>
Date: Wed Jan 17 09:21:14 2018 -0500
Doc fixes.
NEWS | 3 ++
doc/C/func.defs | 48 +++++++++++++++++++-------------------
doc/C/functions.xml | 48 +++++++++++++++++++-------------------
plugins/fn-complex/functions.c | 2 +-
plugins/fn-date/functions.c | 2 +-
plugins/fn-eng/functions.c | 4 +-
plugins/fn-financial/functions.c | 2 +-
plugins/fn-info/functions.c | 2 +-
plugins/fn-logical/functions.c | 10 ++++----
plugins/fn-lookup/functions.c | 2 +-
plugins/fn-math/functions.c | 2 +-
plugins/fn-random/functions.c | 4 +-
plugins/fn-stat/functions.c | 32 ++++++++++++------------
plugins/fn-string/functions.c | 6 ++--
plugins/fn-tsa/functions.c | 2 +-
15 files changed, 86 insertions(+), 83 deletions(-)
---
diff --git a/NEWS b/NEWS
index 75ed6d5..ff76d1a 100644
--- a/NEWS
+++ b/NEWS
@@ -7,6 +7,9 @@ Morten:
* Fix problem with stopping a glpk solver.
* Improve workaround for gtk+ scrollbar bug. [#792417]
+Rafael Fontenelle:
+ * Doc fixes. [#792556] [#792592]
+
--------------------------------------------------------------------------
Gnumeric 1.12.38
diff --git a/doc/C/func.defs b/doc/C/func.defs
index 54167ee..2d4f144 100644
--- a/doc/C/func.defs
+++ b/doc/C/func.defs
@@ -286,7 +286,7 @@
@{z}: a complex number
@{lower}: if true (the default), the lower incomplete gamma function, otherwise the upper incomplete gamma
function
@{regularize}: if true (the default), the regularized version of the incomplete gamma function
-@NOTE=The regularized incomplete gamma function is the unregularized incomplete gamma function divided by
gamma(@{a}).
+@NOTE=The regularized incomplete gamma function is the unregularized incomplete gamma function divided by
GAMMA(@{a}).
@SEEALSO=GAMMA,IMIGAMMA
@CATEGORY=Complex
@@ -933,7 +933,7 @@ The natural logarithm is not uniquely defined on complex numbers. You may need t
@SYNTAX=WEEKDAY(date,method)
@ARGUMENTDESCRIPTION=@{date}: date serial value
@{method}: numbering system, defaults to 1
-@DESCRIPTION=The WEEKDAY function returns the day-of-week of @{date}. The value of @{method} determines how
days are numbered; it defaults to 1.
+@DESCRIPTION=The WEEKDAY function returns the day-of-week of @{date}. The value of @{method} determines how
days are numbered; it defaults to 1.
@NOTE=If @{method} is 1, then Sunday is 1, Monday is 2, etc. If @{method} is 2, then Monday is 1, Tuesday is
2, etc. If @{method} is 3, then Monday is 0, Tuesday is 1, etc. If @{method} is 11, then Monday is 1, Tuesday
is 2, etc. If @{method} is 12, then Tuesday is 1, Wednesday is 2, etc. If @{method} is 13, then Wednesday is
1, Thursday is 2, etc. If @{method} is 14, then Thursday is 1, Friday is 2, etc. If @{method} is 15, then
Friday is 1, Saturday is 2, etc. If @{method} is 16, then Saturday is 1, Sunday is 2, etc. If @{method} is
17, then Sunday is 1, Monday is 2, etc.
@EXCEL=This function is Excel compatible.
@SEEALSO=DATE,ISOWEEKNUM
@@ -1527,7 +1527,7 @@ The depreciation coefficient used is:
@{period}: subject period
@{rate}: depreciation rate
@{basis}: calendar basis
-@DESCRIPTION=AMORLINC calculates the depreciation of an asset using French accounting conventions. Assets
purchased in the middle of a period take prorated depreciation into account.
+@DESCRIPTION=AMORLINC calculates the depreciation of an asset using French accounting conventions. Assets
purchased in the middle of a period take prorated depreciation into account.
@NOTE=Named for AMORtissement LINeaire Comptabilite. If @{basis} is 0, then the US 30/360 method is used. If
@{basis} is 1, then actual number of days is used. If @{basis} is 2, then actual number of days is used
within a month, but years are considered only 360 days. If @{basis} is 3, then actual number of days is used
within a month, but years are always considered 365 days. If @{basis} is 4, then the European 30/360 method
is used.
@SEEALSO=AMORDEGRC
@@ -2730,7 +2730,7 @@ The depreciation coefficient used is:
@SHORTDESC=the value of execution environment variable @{name}
@SYNTAX=GETENV(name)
@ARGUMENTDESCRIPTION=@{name}: the name of the environment variable
-@NOTE=If a variable called @{name} does not exist, #N/A! will be returned. Variable names are case sensitive.
+@NOTE=If a variable called @{name} does not exist, #N/A will be returned. Variable names are case sensitive.
@CATEGORY=Information
@FUNCTION=INFO
@@ -2913,11 +2913,11 @@ The depreciation coefficient used is:
@CATEGORY=Logic
@FUNCTION=IFNA
-@SHORTDESC=test for #NA! error
+@SHORTDESC=test for #N/A error
@SYNTAX=IFNA(x,y)
-@ARGUMENTDESCRIPTION=@{x}: value to test for #NA! error
+@ARGUMENTDESCRIPTION=@{x}: value to test for #N/A error
@{y}: alternate value
-@DESCRIPTION=This function returns the first value, unless that is #NA!, in which case it returns the second.
+@DESCRIPTION=This function returns the first value, unless that is #N/A, in which case it returns the second.
@SEEALSO=IF,ISERROR
@CATEGORY=Logic
@@ -2928,7 +2928,7 @@ The depreciation coefficient used is:
@{value1}: value if @{condition1} is true
@{cond2}: condition
@{value2}: value if @{condition2} is true
-@DESCRIPTION=This function returns the value after the first true contional. If no conditional is true,
#VALUE! is returned.
+@DESCRIPTION=This function returns the value after the first true conditional. If no conditional is true,
#VALUE! is returned.
@SEEALSO=IF
@CATEGORY=Logic
@@ -2961,7 +2961,7 @@ The depreciation coefficient used is:
@{value1}: first result value
@{choice2}: second choice value
@{value2}: second result value
-@DESCRIPTION=This function compares the reference value, @{ref}, against the choice values, @{choice1} etc.,
and returns the corresponding result value when it finds a match. The choices may be followed by a default
value to use. If there are no choices that match and no default value, #NA! is return.
+@DESCRIPTION=This function compares the reference value, @{ref}, against the choice values, @{choice1} etc.,
and returns the corresponding result value when it finds a match. The choices may be followed by a default
value to use. If there are no choices that match and no default value, #N/A is return.
@SEEALSO=IF,IFS
@CATEGORY=Logic
@@ -3110,9 +3110,9 @@ The depreciation coefficient used is:
@SYNTAX=MATCH(seek,vector,type)
@ARGUMENTDESCRIPTION=@{seek}: value to find
@{vector}: n by 1 or 1 by n range to be searched
-@{type}: +1 (the default) to find the largest value ≤ @{seek}, 0 to find the first value = @{seek}, or-1 to
find the smallest value ≥ @{seek}
+@{type}: +1 (the default) to find the largest value ≤ @{seek}, 0 to find the first value = @{seek}, or -1 to
find the smallest value ≥ @{seek}
@DESCRIPTION=MATCH searches @{vector} for @{seek} and returns the 1-based index.
-@NOTE= For @{type} = -1 the data must be sorted in descending order; for @{type} = +1 the data must be
sorted in ascending order. If @{seek} could not be found, #N/A is returned. If @{vector} is neither n by 1
nor 1 by n, #N/A is returned.
+@NOTE=For @{type} = -1 the data must be sorted in descending order; for @{type} = +1 the data must be sorted
in ascending order. If @{seek} could not be found, #N/A is returned. If @{vector} is neither n by 1 nor 1 by
n, #N/A is returned.
@SEEALSO=LOOKUP
@CATEGORY=Lookup
@@ -3603,7 +3603,7 @@ The depreciation coefficient used is:
@{lower}: if true (the default), the lower incomplete gamma function, otherwise the upper incomplete gamma
function
@{regularize}: if true (the default), the regularized version of the incomplete gamma function
@{real}: if true (the default), the real part of the result, otherwise the imaginary part
-@NOTE=The regularized incomplete gamma function is the unregularized incomplete gamma function divided by
gamma(@{a}) This is a real valued function as long as neither @{a} nor @{z} are negative.
+@NOTE=The regularized incomplete gamma function is the unregularized incomplete gamma function divided by
GAMMA(@{a}) This is a real valued function as long as neither @{a} nor @{z} are negative.
@SEEALSO=GAMMA,IMIGAMMA
@CATEGORY=Mathematics
@@ -4467,7 +4467,7 @@ For @{α} = 2, @{β}=0, the Lévy distribution reduces to the normal distributio
@ARGUMENTDESCRIPTION=@{d1}: first value
@{d2}: second value
@DESCRIPTION=SIMTABLE returns one of the values in the given argument list depending on the round number of
the simulation tool. When the simulation tool is not activated, SIMTABLE returns @{d1}.
-With the simulation tool and the SIMTABLE function you can test given decision variables. Each SIMTABLE
function contains the possible values of a simulation variable. In most valid simulation models you should
have the same number of values @{dN} for all decision variables. If the simulation is run more rounds than
there are values defined, SIMTABLE returns #N/A! error (e.g. if A1 contains `=SIMTABLE(1)' and A2
`=SIMTABLE(1,2)', A1 yields #N/A! error on the second round).
+With the simulation tool and the SIMTABLE function you can test given decision variables. Each SIMTABLE
function contains the possible values of a simulation variable. In most valid simulation models you should
have the same number of values @{dN} for all decision variables. If the simulation is run more rounds than
there are values defined, SIMTABLE returns #N/A error (e.g. if A1 contains `=SIMTABLE(1)' and A2
`=SIMTABLE(1,2)', A1 yields #N/A error on the second round).
The successive use of the simulation tool also requires that you give to the tool at least one input
variable having RAND() or any other RAND<distribution name>() function in it. On each round, the simulation
tool iterates for the given number of rounds over all the input variables to reevaluate them. On each
iteration, the values of the output variables are stored, and when the round is completed, descriptive
statistical information is created according to the values.
@CATEGORY=Statistics
@@ -4740,7 +4740,7 @@ The successive use of the simulation tool also requires that you give to the too
@ARGUMENTDESCRIPTION=@{x}: number
@{y}: scale parameter
@{cumulative}: whether to evaluate the density function or the cumulative distribution function
-@DESCRIPTION=If @{cumulative} is false it will return: @{y} * exp (-@{y}*@{x}),otherwise it will return
1 - exp (-@{y}*@{x}).
+@DESCRIPTION=If @{cumulative} is false it will return: @{y} * exp (-@{y}*@{x}), otherwise it will return
1 - exp (-@{y}*@{x}).
@NOTE=If @{x} < 0 or @{y} <= 0 this will return an error.
@EXCEL=This function is Excel compatible.
@SEEALSO=POISSON
@@ -4982,7 +4982,7 @@ GROWTH returns an array having one column and a row for each data point in @{new
@{affine}: if true, the model contains a constant term, defaults to true
@{stats}: if true, some additional statistics are provided, defaults to false
@DESCRIPTION=This function returns an array with the first row giving the regression coefficients for the
independent variables x_m, x_(m-1),…,x_2, x_1 followed by the y-intercept if @{affine} is true.
-If @{stats} is true, the second row contains the corresponding standard errors of the regression
coefficients.In this case, the third row contains the R^2 value and the standard error for the predicted
value. The fourth row contains the observed F value and its degrees of freedom. Finally, the fifth row
contains the regression sum of squares and the residual sum of squares.
+If @{stats} is true, the second row contains the corresponding standard errors of the regression
coefficients. In this case, the third row contains the R^2 value and the standard error for the predicted
value. The fourth row contains the observed F value and its degrees of freedom. Finally, the fifth row
contains the regression sum of squares and the residual sum of squares.
If @{affine} is false, R^2 is the uncentered version of the coefficient of determination; that is the
proportion of the sum of squares explained by the model.
@NOTE=If the length of @{known_ys} does not match the corresponding length of @{known_xs}, this function
returns a #NUM! error.
@SEEALSO=LOGEST,TREND
@@ -5058,8 +5058,8 @@ LOGFIT returns an array having five columns and one row. `Sign' is given in the
@{known_xs}: known x-values; defaults to the array {1, 2, 3, …}
@{affine}: if true, the model contains a constant term, defaults to true
@{stat}: if true, extra statistical information will be returned; defaults to FALSE
-@DESCRIPTION=LOGREG function transforms your x's to z=ln(x) and applies the “least squares” method to fit
the linear equation y = m * z + b to your y's and z's --- equivalent to fitting the equation y = m * ln(x) +
b to y's and x's. LOGREG returns an array having two columns and one row. m is given in the first column and
b in the second.
-Any extra statistical information is written below m and b in the result array. This extra statistical
information consists of four rows of data: In the first row the standard error values for the coefficients
m, b are given. The second row contains the square of R and the standard error for the y estimate. The third
row contains the F-observed value and the degrees of freedom. The last row contains the regression sum of
squares and the residual sum of squares.The default of @{stat} is FALSE.
+@DESCRIPTION=LOGREG function transforms your x's to z=ln(x) and applies the “least squares” method to fit
the linear equation y = m * z + b to your y's and z's --- equivalent to fitting the equation y = m * ln(x) +
b to y's and x's. LOGREG returns an array having two columns and one row. m is given in the first column and
b in the second.
+Any extra statistical information is written below m and b in the result array. This extra statistical
information consists of four rows of data: In the first row the standard error values for the coefficients
m, b are given. The second row contains the square of R and the standard error for the y estimate. The third
row contains the F-observed value and the degrees of freedom. The last row contains the regression sum of
squares and the residual sum of squares. The default of @{stat} is FALSE.
@NOTE=If @{known_ys} and @{known_xs} have unequal number of data points, this function returns a #NUM! error.
@SEEALSO=LOGFIT,LINEST,LOGEST
@@ -5241,7 +5241,7 @@ If the data set does not contain any duplicates this function returns a #N/A err
@ARGUMENTDESCRIPTION=@{array}: range of numeric values
@{x}: data point to be ranked
@{significance}: number of significant digits, defaults to 3
-@NOTE=If @{array} contains no data points, this function returns a #NUM! error. If @{significance} is less
than one, this function returns a #NUM! error. If @{x} exceeds the largest value or is less than the smallest
value in @{array}, this function returns an #N/A! error. If @{x} does not match any of the values in @{array}
or @{x} matches more than once, this function interpolates the returned value.
+@NOTE=If @{array} contains no data points, this function returns a #NUM! error. If @{significance} is less
than one, this function returns a #NUM! error. If @{x} exceeds the largest value or is less than the smallest
value in @{array}, this function returns an #N/A error. If @{x} does not match any of the values in @{array}
or @{x} matches more than once, this function interpolates the returned value.
@SEEALSO=LARGE,MAX,MEDIAN,MIN,PERCENTILE,QUARTILE,SMALL
@CATEGORY=Statistics
@@ -5251,7 +5251,7 @@ If the data set does not contain any duplicates this function returns a #N/A err
@ARGUMENTDESCRIPTION=@{array}: range of numeric values
@{x}: data point to be ranked
@{significance}: number of significant digits, defaults to 3
-@NOTE=If @{array} contains no data points, this function returns a #NUM! error. If @{significance} is less
than one, this function returns a #NUM! error. If @{x} exceeds the largest value or is less than the smallest
value in @{array}, this function returns an #N/A! error. If @{x} does not match any of the values in @{array}
or @{x} matches more than once, this function interpolates the returned value.
+@NOTE=If @{array} contains no data points, this function returns a #NUM! error. If @{significance} is less
than one, this function returns a #NUM! error. If @{x} exceeds the largest value or is less than the smallest
value in @{array}, this function returns an #N/A error. If @{x} does not match any of the values in @{array}
or @{x} matches more than once, this function interpolates the returned value.
@SEEALSO=LARGE,MAX,MEDIAN,MIN,PERCENTILE,PERCENTILE.EXC,QUARTILE,QUARTILE.EXC,SMALL
@CATEGORY=Statistics
@@ -6318,7 +6318,7 @@ Numbers, text and logical values are included in the calculation too. If the cel
@{alpha}: scale parameter
@{beta}: scale parameter
@{cumulative}: whether to evaluate the density function or the cumulative distribution function
-@DESCRIPTION=If the @{cumulative} boolean is true it will return: 1 - exp
(-(@{x}/@{beta})^@{alpha}),otherwise it will return (@{alpha}/@{beta}^@{alpha}) * @{x}^(@{alpha}-1) *
exp(-(@{x}/@{beta}^@{alpha})).
+@DESCRIPTION=If the @{cumulative} boolean is true it will return: 1 - exp (-(@{x}/@{beta})^@{alpha}),
otherwise it will return (@{alpha}/@{beta}^@{alpha}) * @{x}^(@{alpha}-1) * exp(-(@{x}/@{beta}^@{alpha})).
@NOTE=If @{x} < 0 this function returns a #NUM! error. If @{alpha} <= 0 or @{beta} <= 0 this function
returns a #NUM! error.
@EXCEL=This function is Excel compatible.
@SEEALSO=POISSON
@@ -6341,7 +6341,7 @@ Numbers, text and logical values are included in the calculation too. If the cel
@SHORTDESC=text with full-width katakana and ASCII characters converted to half-width
@SYNTAX=ASC(text)
@ARGUMENTDESCRIPTION=@{text}: string
-@DESCRIPTION=ASC converts full-width katakana and ASCII characters to half-width equivalent characters,
copying all others.
+@DESCRIPTION=ASC converts full-width katakana and ASCII characters to half-width equivalent characters,
copying all others.
The distinction between half-width and full-width characters is described in
http://www.unicode.org/reports/tr11/.
@NOTE=While in obsolete encodings ASC used to translate between 2-byte and 1-byte characters, this is not
the case in UTF-8.
@EXCEL=For most strings, this function has the same effect as in Excel.
@@ -6456,7 +6456,7 @@ This function is Excel compatible.
@SHORTDESC=text with half-width katakana and ASCII characters converted to full-width
@SYNTAX=JIS(text)
@ARGUMENTDESCRIPTION=@{text}: original text
-@DESCRIPTION=JIS converts half-width katakana and ASCII characters to full-width equivalent characters,
copying all others.
+@DESCRIPTION=JIS converts half-width katakana and ASCII characters to full-width equivalent characters,
copying all others.
The distinction between half-width and full-width characters is described in
http://www.unicode.org/reports/tr11/.
@NOTE=While in obsolete encodings JIS used to translate between 1-byte and 2-byte characters, this is not
the case in UTF-8.
@EXCEL=For most strings, this function has the same effect as in Excel.
@@ -6476,7 +6476,7 @@ The distinction between half-width and full-width characters is described in htt
@CATEGORY=String
@FUNCTION=LEFTB
-@SHORTDESC=the first characters of the string @{s} comprising at most @{num_bytes} bytes
+@SHORTDESC=the first characters of the string @{s} comprising at most @{num_bytes} bytes
@SYNTAX=LEFTB(s,num_bytes)
@ARGUMENTDESCRIPTION=@{s}: the string
@{num_bytes}: the maximum number of bytes to return (defaults to 1)
@@ -6754,7 +6754,7 @@ Possible interpolation methods are:
@SHORTDESC=periodogram of the given data
@SYNTAX=PERIODOGRAM(ordinates,filter,abscissae,interpolation,number)
@ARGUMENTDESCRIPTION=@{ordinates}: ordinates of the given data
-@{filter}: windowing function to be used, defaults to no filter
+@{filter}: windowing function to be used, defaults to no filter
@{abscissae}: abscissae of the given data, defaults to regularly spaced abscissae
@{interpolation}: method of interpolation, defaults to none
@{number}: number of interpolated data points
diff --git a/doc/C/functions.xml b/doc/C/functions.xml
index c41de82..72d8292 100644
--- a/doc/C/functions.xml
+++ b/doc/C/functions.xml
@@ -1123,7 +1123,7 @@
</refsect1>
<refsect1>
<title>Note</title>
- <para>The regularized incomplete gamma function is the unregularized incomplete gamma function
divided by gamma(<parameter>a</parameter>).</para>
+ <para>The regularized incomplete gamma function is the unregularized incomplete gamma function
divided by GAMMA(<parameter>a</parameter>).</para>
</refsect1>
<refsect1>
<title>See also</title>
@@ -3439,7 +3439,7 @@
</refsect1>
<refsect1>
<title>Description</title>
- <para>The <function>WEEKDAY</function> function returns the day-of-week of
<parameter>date</parameter>. The value of <parameter>method</parameter> determines how days are numbered; it
defaults to 1. </para>
+ <para>The <function>WEEKDAY</function> function returns the day-of-week of
<parameter>date</parameter>. The value of <parameter>method</parameter> determines how days are numbered; it
defaults to 1.</para>
</refsect1>
<refsect1>
<title>Note</title>
@@ -5046,7 +5046,7 @@
</refsect1>
<refsect1>
<title>Description</title>
- <para><function>AMORLINC</function> calculates the depreciation of an asset using French accounting
conventions. Assets purchased in the middle of a period take prorated depreciation into account. </para>
+ <para><function>AMORLINC</function> calculates the depreciation of an asset using French accounting
conventions. Assets purchased in the middle of a period take prorated depreciation into account.</para>
</refsect1>
<refsect1>
<title>Note</title>
@@ -8612,7 +8612,7 @@
</refsect1>
<refsect1>
<title>Note</title>
- <para>If a variable called <parameter>name</parameter> does not exist, #N/A! will be returned.
Variable names are case sensitive.</para>
+ <para>If a variable called <parameter>name</parameter> does not exist, #N/A will be returned.
Variable names are case sensitive.</para>
</refsect1>
</refentry>
<refentry id="gnumeric-function-INFO">
@@ -9276,7 +9276,7 @@
<function>IFNA</function>
</refname>
<refpurpose>
- test for #NA! error
+ test for #N/A error
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -9284,12 +9284,12 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: value to test for #NA! error</para>
+ <para><parameter>x</parameter>: value to test for #N/A error</para>
<para><parameter>y</parameter>: alternate value</para>
</refsect1>
<refsect1>
<title>Description</title>
- <para>This function returns the first value, unless that is #NA!, in which case it returns the
second.</para>
+ <para>This function returns the first value, unless that is #N/A, in which case it returns the
second.</para>
</refsect1>
<refsect1>
<title>See also</title>
@@ -9324,7 +9324,7 @@
</refsect1>
<refsect1>
<title>Description</title>
- <para>This function returns the value after the first true contional. If no conditional is true,
#VALUE! is returned.</para>
+ <para>This function returns the value after the first true conditional. If no conditional is true,
#VALUE! is returned.</para>
</refsect1>
<refsect1>
<title>See also</title>
@@ -9443,7 +9443,7 @@
</refsect1>
<refsect1>
<title>Description</title>
- <para>This function compares the reference value, <parameter>ref</parameter>, against the choice
values, <parameter>choice1</parameter> etc., and returns the corresponding result value when it finds a
match. The choices may be followed by a default value to use. If there are no choices that match and no
default value, #NA! is return.</para>
+ <para>This function compares the reference value, <parameter>ref</parameter>, against the choice
values, <parameter>choice1</parameter> etc., and returns the corresponding result value when it finds a
match. The choices may be followed by a default value to use. If there are no choices that match and no
default value, #N/A is return.</para>
</refsect1>
<refsect1>
<title>See also</title>
@@ -9975,7 +9975,7 @@
<title>Arguments</title>
<para><parameter>seek</parameter>: value to find</para>
<para><parameter>vector</parameter>: n by 1 or 1 by n range to be searched</para>
- <para><parameter>type</parameter>: +1 (the default) to find the largest value ≤
<parameter>seek</parameter>, 0 to find the first value = <parameter>seek</parameter>, or-1 to find the
smallest value ≥ <parameter>seek</parameter></para>
+ <para><parameter>type</parameter>: +1 (the default) to find the largest value ≤
<parameter>seek</parameter>, 0 to find the first value = <parameter>seek</parameter>, or -1 to find the
smallest value ≥ <parameter>seek</parameter></para>
</refsect1>
<refsect1>
<title>Description</title>
@@ -9983,7 +9983,7 @@
</refsect1>
<refsect1>
<title>Note</title>
- <para> For <parameter>type</parameter> = -1 the data must be sorted in descending order; for
<parameter>type</parameter> = +1 the data must be sorted in ascending order. If <parameter>seek</parameter>
could not be found, #N/A is returned. If <parameter>vector</parameter> is neither n by 1 nor 1 by n, #N/A is
returned.</para>
+ <para>For <parameter>type</parameter> = -1 the data must be sorted in descending order; for
<parameter>type</parameter> = +1 the data must be sorted in ascending order. If <parameter>seek</parameter>
could not be found, #N/A is returned. If <parameter>vector</parameter> is neither n by 1 nor 1 by n, #N/A is
returned.</para>
</refsect1>
<refsect1>
<title>See also</title>
@@ -11894,7 +11894,7 @@
</refsect1>
<refsect1>
<title>Note</title>
- <para>The regularized incomplete gamma function is the unregularized incomplete gamma function
divided by gamma(<parameter>a</parameter>) This is a real valued function as long as neither
<parameter>a</parameter> nor <parameter>z</parameter> are negative.</para>
+ <para>The regularized incomplete gamma function is the unregularized incomplete gamma function
divided by GAMMA(<parameter>a</parameter>) This is a real valued function as long as neither
<parameter>a</parameter> nor <parameter>z</parameter> are negative.</para>
</refsect1>
<refsect1>
<title>See also</title>
@@ -15148,7 +15148,7 @@
<refsect1>
<title>Description</title>
<para><function>SIMTABLE</function> returns one of the values in the given argument list depending
on the round number of the simulation tool. When the simulation tool is not activated,
<function>SIMTABLE</function> returns <parameter>d1</parameter>.</para>
- <para>With the simulation tool and the <function>SIMTABLE</function> function you can test given
decision variables. Each <function>SIMTABLE</function> function contains the possible values of a simulation
variable. In most valid simulation models you should have the same number of values <parameter>dN</parameter>
for all decision variables. If the simulation is run more rounds than there are values defined,
<function>SIMTABLE</function> returns #N/A! error (e.g. if A1 contains `=<function>SIMTABLE</function>(1)'
and A2 `=<function>SIMTABLE</function>(1,2)', A1 yields #N/A! error on the second round).</para>
+ <para>With the simulation tool and the <function>SIMTABLE</function> function you can test given
decision variables. Each <function>SIMTABLE</function> function contains the possible values of a simulation
variable. In most valid simulation models you should have the same number of values <parameter>dN</parameter>
for all decision variables. If the simulation is run more rounds than there are values defined,
<function>SIMTABLE</function> returns #N/A error (e.g. if A1 contains `=<function>SIMTABLE</function>(1)' and
A2 `=<function>SIMTABLE</function>(1,2)', A1 yields #N/A error on the second round).</para>
<para>The successive use of the simulation tool also requires that you give to the tool at least one
input variable having RAND() or any other RAND<distribution name>() function in it. On each round, the
simulation tool iterates for the given number of rounds over all the input variables to reevaluate them. On
each iteration, the values of the output variables are stored, and when the round is completed, descriptive
statistical information is created according to the values.</para>
</refsect1>
</refentry>
@@ -16110,7 +16110,7 @@
</refsect1>
<refsect1>
<title>Description</title>
- <para>If <parameter>cumulative</parameter> is false it will return: <parameter>y</parameter> *
exp (-<parameter>y</parameter>*<parameter>x</parameter>),otherwise it will return 1 - exp
(-<parameter>y</parameter>*<parameter>x</parameter>).</para>
+ <para>If <parameter>cumulative</parameter> is false it will return: <parameter>y</parameter> *
exp (-<parameter>y</parameter>*<parameter>x</parameter>), otherwise it will return 1 - exp
(-<parameter>y</parameter>*<parameter>x</parameter>).</para>
</refsect1>
<refsect1>
<title>Note</title>
@@ -16966,7 +16966,7 @@
<refsect1>
<title>Description</title>
<para>This function returns an array with the first row giving the regression coefficients for the
independent variables x_m, x_(m-1),…,x_2, x_1 followed by the y-intercept if <parameter>affine</parameter> is
true.</para>
- <para>If <parameter>stats</parameter> is true, the second row contains the corresponding standard
errors of the regression coefficients.In this case, the third row contains the R^2 value and the standard
error for the predicted value. The fourth row contains the observed F value and its degrees of freedom.
Finally, the fifth row contains the regression sum of squares and the residual sum of squares.</para>
+ <para>If <parameter>stats</parameter> is true, the second row contains the corresponding standard
errors of the regression coefficients. In this case, the third row contains the R^2 value and the standard
error for the predicted value. The fourth row contains the observed F value and its degrees of freedom.
Finally, the fifth row contains the regression sum of squares and the residual sum of squares.</para>
<para>If <parameter>affine</parameter> is false, R^2 is the uncentered version of the coefficient of
determination; that is the proportion of the sum of squares explained by the model.</para>
</refsect1>
<refsect1>
@@ -17229,8 +17229,8 @@
</refsect1>
<refsect1>
<title>Description</title>
- <para><function>LOGREG</function> function transforms your x's to z=ln(x) and applies the “least
squares” method to fit the linear equation y = m * z + b to your y's and z's --- equivalent to fitting the
equation y = m * ln(x) + b to y's and x's. <function>LOGREG</function> returns an array having two columns
and one row. m is given in the first column and b in the second. </para>
- <para>Any extra statistical information is written below m and b in the result array. This extra
statistical information consists of four rows of data: In the first row the standard error values for the
coefficients m, b are given. The second row contains the square of R and the standard error for the y
estimate. The third row contains the F-observed value and the degrees of freedom. The last row contains the
regression sum of squares and the residual sum of squares.The default of <parameter>stat</parameter> is
FALSE.</para>
+ <para><function>LOGREG</function> function transforms your x's to z=ln(x) and applies the “least
squares” method to fit the linear equation y = m * z + b to your y's and z's --- equivalent to fitting the
equation y = m * ln(x) + b to y's and x's. <function>LOGREG</function> returns an array having two columns
and one row. m is given in the first column and b in the second.</para>
+ <para>Any extra statistical information is written below m and b in the result array. This extra
statistical information consists of four rows of data: In the first row the standard error values for the
coefficients m, b are given. The second row contains the square of R and the standard error for the y
estimate. The third row contains the F-observed value and the degrees of freedom. The last row contains the
regression sum of squares and the residual sum of squares. The default of <parameter>stat</parameter> is
FALSE.</para>
</refsect1>
<refsect1>
<title>Note</title>
@@ -17903,7 +17903,7 @@
</refsect1>
<refsect1>
<title>Note</title>
- <para>If <parameter>array</parameter> contains no data points, this function returns a #NUM! error.
If <parameter>significance</parameter> is less than one, this function returns a #NUM! error. If
<parameter>x</parameter> exceeds the largest value or is less than the smallest value in
<parameter>array</parameter>, this function returns an #N/A! error. If <parameter>x</parameter> does not
match any of the values in <parameter>array</parameter> or <parameter>x</parameter> matches more than once,
this function interpolates the returned value.</para>
+ <para>If <parameter>array</parameter> contains no data points, this function returns a #NUM! error.
If <parameter>significance</parameter> is less than one, this function returns a #NUM! error. If
<parameter>x</parameter> exceeds the largest value or is less than the smallest value in
<parameter>array</parameter>, this function returns an #N/A error. If <parameter>x</parameter> does not match
any of the values in <parameter>array</parameter> or <parameter>x</parameter> matches more than once, this
function interpolates the returned value.</para>
</refsect1>
<refsect1>
<title>See also</title>
@@ -17942,7 +17942,7 @@
</refsect1>
<refsect1>
<title>Note</title>
- <para>If <parameter>array</parameter> contains no data points, this function returns a #NUM! error.
If <parameter>significance</parameter> is less than one, this function returns a #NUM! error. If
<parameter>x</parameter> exceeds the largest value or is less than the smallest value in
<parameter>array</parameter>, this function returns an #N/A! error. If <parameter>x</parameter> does not
match any of the values in <parameter>array</parameter> or <parameter>x</parameter> matches more than once,
this function interpolates the returned value.</para>
+ <para>If <parameter>array</parameter> contains no data points, this function returns a #NUM! error.
If <parameter>significance</parameter> is less than one, this function returns a #NUM! error. If
<parameter>x</parameter> exceeds the largest value or is less than the smallest value in
<parameter>array</parameter>, this function returns an #N/A error. If <parameter>x</parameter> does not match
any of the values in <parameter>array</parameter> or <parameter>x</parameter> matches more than once, this
function interpolates the returned value.</para>
</refsect1>
<refsect1>
<title>See also</title>
@@ -21405,7 +21405,7 @@
</refsect1>
<refsect1>
<title>Description</title>
- <para>If the <parameter>cumulative</parameter> boolean is true it will return: 1 - exp
(-(<parameter>x</parameter>/<parameter>beta</parameter>)^<parameter>alpha</parameter>),otherwise it will
return (<parameter>alpha</parameter>/<parameter>beta</parameter>^<parameter>alpha</parameter>) *
<parameter>x</parameter>^(<parameter>alpha</parameter>-1) *
exp(-(<parameter>x</parameter>/<parameter>beta</parameter>^<parameter>alpha</parameter>)).</para>
+ <para>If the <parameter>cumulative</parameter> boolean is true it will return: 1 - exp
(-(<parameter>x</parameter>/<parameter>beta</parameter>)^<parameter>alpha</parameter>), otherwise it will
return (<parameter>alpha</parameter>/<parameter>beta</parameter>^<parameter>alpha</parameter>) *
<parameter>x</parameter>^(<parameter>alpha</parameter>-1) *
exp(-(<parameter>x</parameter>/<parameter>beta</parameter>^<parameter>alpha</parameter>)).</para>
</refsect1>
<refsect1>
<title>Note</title>
@@ -21497,7 +21497,7 @@
</refsect1>
<refsect1>
<title>Description</title>
- <para><function>ASC</function> converts full-width katakana and ASCII characters to half-width
equivalent characters, copying all others. </para>
+ <para><function>ASC</function> converts full-width katakana and ASCII characters to half-width
equivalent characters, copying all others.</para>
<para>The distinction between half-width and full-width characters is described in
http://www.unicode.org/reports/tr11/.</para>
</refsect1>
<refsect1>
@@ -21909,7 +21909,7 @@
</refsect1>
<refsect1>
<title>Description</title>
- <para><function>JIS</function> converts half-width katakana and ASCII characters to full-width
equivalent characters, copying all others. </para>
+ <para><function>JIS</function> converts half-width katakana and ASCII characters to full-width
equivalent characters, copying all others.</para>
<para>The distinction between half-width and full-width characters is described in
http://www.unicode.org/reports/tr11/.</para>
</refsect1>
<refsect1>
@@ -21986,7 +21986,7 @@
<function>LEFTB</function>
</refname>
<refpurpose>
- the first characters of the string <parameter>s</parameter> comprising at most
<parameter>num_bytes</parameter> bytes
+ the first characters of the string <parameter>s</parameter> comprising at most
<parameter>num_bytes</parameter> bytes
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -22994,7 +22994,7 @@
<refsect1>
<title>Arguments</title>
<para><parameter>ordinates</parameter>: ordinates of the given data</para>
- <para><parameter>filter</parameter>: windowing function to be used, defaults to no filter</para>
+ <para><parameter>filter</parameter>: windowing function to be used, defaults to no filter</para>
<para><parameter>abscissae</parameter>: abscissae of the given data, defaults to regularly spaced
abscissae</para>
<para><parameter>interpolation</parameter>: method of interpolation, defaults to none</para>
<para><parameter>number</parameter>: number of interpolated data points</para>
diff --git a/plugins/fn-complex/functions.c b/plugins/fn-complex/functions.c
index 360ef0e..6119d3c 100644
--- a/plugins/fn-complex/functions.c
+++ b/plugins/fn-complex/functions.c
@@ -1109,7 +1109,7 @@ static GnmFuncHelp const help_imigamma[] = {
{ GNM_FUNC_HELP_ARG, F_("z:a complex number")},
{ GNM_FUNC_HELP_ARG, F_("lower:if true (the default), the lower incomplete gamma function, otherwise
the upper incomplete gamma function")},
{ GNM_FUNC_HELP_ARG, F_("regularize:if true (the default), the regularized version of the incomplete
gamma function")},
- { GNM_FUNC_HELP_NOTE, F_("The regularized incomplete gamma function is the unregularized incomplete
gamma function divided by gamma(@{a}).") },
+ { GNM_FUNC_HELP_NOTE, F_("The regularized incomplete gamma function is the unregularized incomplete
gamma function divided by GAMMA(@{a}).") },
{ GNM_FUNC_HELP_EXAMPLES, "=IMIGAMMA(2.5,-1.8,TRUE,TRUE)" },
{ GNM_FUNC_HELP_EXAMPLES, "=IMIGAMMA(2.5,-1.8,TRUE,TRUE)" },
{ GNM_FUNC_HELP_SEEALSO, "GAMMA,IMIGAMMA"},
diff --git a/plugins/fn-date/functions.c b/plugins/fn-date/functions.c
index eefbd39..2d19ed6 100644
--- a/plugins/fn-date/functions.c
+++ b/plugins/fn-date/functions.c
@@ -647,7 +647,7 @@ static GnmFuncHelp const help_weekday[] = {
{ GNM_FUNC_HELP_NAME, F_("WEEKDAY:day-of-week") },
{ GNM_FUNC_HELP_ARG, F_("date:date serial value")},
{ GNM_FUNC_HELP_ARG, F_("method:numbering system, defaults to 1")},
- { GNM_FUNC_HELP_DESCRIPTION, F_("The WEEKDAY function returns the day-of-week of @{date}. The value
of @{method} determines how days are numbered; it defaults to 1. ") },
+ { GNM_FUNC_HELP_DESCRIPTION, F_("The WEEKDAY function returns the day-of-week of @{date}. The value
of @{method} determines how days are numbered; it defaults to 1.") },
{ GNM_FUNC_HELP_NOTE, F_("If @{method} is 1, then Sunday is 1, Monday is 2, etc.") },
{ GNM_FUNC_HELP_NOTE, F_("If @{method} is 2, then Monday is 1, Tuesday is 2, etc.") },
{ GNM_FUNC_HELP_NOTE, F_("If @{method} is 3, then Monday is 0, Tuesday is 1, etc.") },
diff --git a/plugins/fn-eng/functions.c b/plugins/fn-eng/functions.c
index c6847ef..dcfb986 100644
--- a/plugins/fn-eng/functions.c
+++ b/plugins/fn-eng/functions.c
@@ -207,8 +207,8 @@ static GnmFuncHelp const help_base[] = {
{ GNM_FUNC_HELP_ARG, F_("n:integer") },
{ GNM_FUNC_HELP_ARG, F_("b:base (2 \xe2\x89\xa4 @{b} \xe2\x89\xa4 36)") },
{ GNM_FUNC_HELP_ARG, F_("length:minimum length of the resulting string") },
- { GNM_FUNC_HELP_DESCRIPTION, F_("BASE converts @{n} to its string representation in base @{b}."
- " Leading zeroes will be added to reach the minimum length given by
@{length}.") },
+ { GNM_FUNC_HELP_DESCRIPTION, F_("BASE converts @{n} to its string representation in base @{b}. "
+ "Leading zeroes will be added to reach the minimum length given by
@{length}.") },
{ GNM_FUNC_HELP_ODF, F_("This function is OpenFormula compatible.") },
{ GNM_FUNC_HELP_EXAMPLES, "=BASE(255,16,4)" },
{ GNM_FUNC_HELP_SEEALSO, "DECIMAL" },
diff --git a/plugins/fn-financial/functions.c b/plugins/fn-financial/functions.c
index 04263da..e5b477d 100644
--- a/plugins/fn-financial/functions.c
+++ b/plugins/fn-financial/functions.c
@@ -2963,7 +2963,7 @@ static GnmFuncHelp const help_amorlinc[] = {
{ GNM_FUNC_HELP_ARG, F_("basis:calendar basis")},
{ GNM_FUNC_HELP_DESCRIPTION, F_(
"AMORLINC calculates the depreciation of an asset using French accounting
conventions. "
- "Assets purchased in the middle of a period take prorated depreciation into account.
") },
+ "Assets purchased in the middle of a period take prorated depreciation into
account.") },
{ GNM_FUNC_HELP_NOTE, F_("Named for AMORtissement LINeaire Comptabilite.") },
GNM_DATE_BASIS_HELP
{ GNM_FUNC_HELP_EXAMPLES, "=AMORLINC(2400,DATE(1998,8,19),DATE(1998,12,30),300,1,0.14,1)" },
diff --git a/plugins/fn-info/functions.c b/plugins/fn-info/functions.c
index ebb01b9..0ef6bd5 100644
--- a/plugins/fn-info/functions.c
+++ b/plugins/fn-info/functions.c
@@ -1798,7 +1798,7 @@ gnumeric_type (GnmFuncEvalInfo *ei, GnmValue const * const *argv)
static GnmFuncHelp const help_getenv[] = {
{ GNM_FUNC_HELP_NAME, F_("GETENV:the value of execution environment variable @{name}")},
{ GNM_FUNC_HELP_ARG, F_("name:the name of the environment variable")},
- { GNM_FUNC_HELP_NOTE, F_("If a variable called @{name} does not exist, #N/A! will be returned.") },
+ { GNM_FUNC_HELP_NOTE, F_("If a variable called @{name} does not exist, #N/A will be returned.") },
{ GNM_FUNC_HELP_NOTE, F_("Variable names are case sensitive.") },
{ GNM_FUNC_HELP_EXAMPLES, "=GETENV(\"HOME\")" },
{ GNM_FUNC_HELP_END}
diff --git a/plugins/fn-logical/functions.c b/plugins/fn-logical/functions.c
index 1bf3552..a2e9be0 100644
--- a/plugins/fn-logical/functions.c
+++ b/plugins/fn-logical/functions.c
@@ -243,10 +243,10 @@ gnumeric_iferror (GnmFuncEvalInfo *ei, GnmValue const * const *argv)
/***************************************************************************/
static GnmFuncHelp const help_ifna[] = {
- { GNM_FUNC_HELP_NAME, F_("IFNA:test for #NA! error") },
- { GNM_FUNC_HELP_ARG, F_("x:value to test for #NA! error") },
+ { GNM_FUNC_HELP_NAME, F_("IFNA:test for #N/A error") },
+ { GNM_FUNC_HELP_ARG, F_("x:value to test for #N/A error") },
{ GNM_FUNC_HELP_ARG, F_("y:alternate value") },
- { GNM_FUNC_HELP_DESCRIPTION, F_("This function returns the first value, unless that is #NA!, in which
case it returns the second.") },
+ { GNM_FUNC_HELP_DESCRIPTION, F_("This function returns the first value, unless that is #N/A, in which
case it returns the second.") },
{ GNM_FUNC_HELP_EXAMPLES, "=IFNA(12,14)" },
{ GNM_FUNC_HELP_EXAMPLES, "=IFNA(1/0,14)" },
{ GNM_FUNC_HELP_EXAMPLES, "=IFNA(NA(),14)" },
@@ -268,7 +268,7 @@ static GnmFuncHelp const help_ifs[] = {
{ GNM_FUNC_HELP_ARG, F_("value1:value if @{condition1} is true") },
{ GNM_FUNC_HELP_ARG, F_("cond2:condition") },
{ GNM_FUNC_HELP_ARG, F_("value2:value if @{condition2} is true") },
- { GNM_FUNC_HELP_DESCRIPTION, F_("This function returns the value after the first true contional. If
no conditional is true, #VALUE! is returned.") },
+ { GNM_FUNC_HELP_DESCRIPTION, F_("This function returns the value after the first true conditional.
If no conditional is true, #VALUE! is returned.") },
{ GNM_FUNC_HELP_EXAMPLES, "=IFS(false,1/0,true,42)" },
{ GNM_FUNC_HELP_SEEALSO, "IF" },
{ GNM_FUNC_HELP_END }
@@ -313,7 +313,7 @@ static GnmFuncHelp const help_switch[] = {
{ GNM_FUNC_HELP_ARG, F_("value1:first result value") },
{ GNM_FUNC_HELP_ARG, F_("choice2:second choice value") },
{ GNM_FUNC_HELP_ARG, F_("value2:second result value") },
- { GNM_FUNC_HELP_DESCRIPTION, F_("This function compares the reference value, @{ref}, against the
choice values, @{choice1} etc., and returns the corresponding result value when it finds a match. The
choices may be followed by a default value to use. If there are no choices that match and no default value,
#NA! is return.") },
+ { GNM_FUNC_HELP_DESCRIPTION, F_("This function compares the reference value, @{ref}, against the
choice values, @{choice1} etc., and returns the corresponding result value when it finds a match. The
choices may be followed by a default value to use. If there are no choices that match and no default value,
#N/A is return.") },
{ GNM_FUNC_HELP_EXAMPLES, "=SWITCH(WEEKDAY(TODAY()),0,\"Sunday\",1,\"Saturday\",\"not weekend\")" },
{ GNM_FUNC_HELP_SEEALSO, "IF,IFS" },
{ GNM_FUNC_HELP_END }
diff --git a/plugins/fn-lookup/functions.c b/plugins/fn-lookup/functions.c
index b555f6a..59b27f6 100644
--- a/plugins/fn-lookup/functions.c
+++ b/plugins/fn-lookup/functions.c
@@ -1260,7 +1260,7 @@ static GnmFuncHelp const help_match[] = {
"0 to find the first value = @{seek}, or "
"-1 to find the smallest value \xe2\x89\xa5 @{seek}")},
{ GNM_FUNC_HELP_DESCRIPTION, F_("MATCH searches @{vector} for @{seek} and returns the 1-based
index.")},
- { GNM_FUNC_HELP_NOTE, F_(" For @{type} = -1 the data must be sorted in descending order; "
+ { GNM_FUNC_HELP_NOTE, F_("For @{type} = -1 the data must be sorted in descending order; "
"for @{type} = +1 the data must be sorted in ascending order.")},
{ GNM_FUNC_HELP_NOTE, F_("If @{seek} could not be found, #N/A is returned.")},
{ GNM_FUNC_HELP_NOTE, F_("If @{vector} is neither n by 1 nor 1 by n, #N/A is returned.")},
diff --git a/plugins/fn-math/functions.c b/plugins/fn-math/functions.c
index 7abfc43..0e295c1 100644
--- a/plugins/fn-math/functions.c
+++ b/plugins/fn-math/functions.c
@@ -1066,7 +1066,7 @@ static GnmFuncHelp const help_igamma[] = {
{ GNM_FUNC_HELP_ARG, F_("lower:if true (the default), the lower incomplete gamma function, otherwise
the upper incomplete gamma function")},
{ GNM_FUNC_HELP_ARG, F_("regularize:if true (the default), the regularized version of the incomplete
gamma function")},
{ GNM_FUNC_HELP_ARG, F_("real:if true (the default), the real part of the result, otherwise the
imaginary part")},
- { GNM_FUNC_HELP_NOTE, F_("The regularized incomplete gamma function is the unregularized incomplete
gamma function divided by gamma(@{a})") },
+ { GNM_FUNC_HELP_NOTE, F_("The regularized incomplete gamma function is the unregularized incomplete
gamma function divided by GAMMA(@{a})") },
{ GNM_FUNC_HELP_NOTE, F_("This is a real valued function as long as neither @{a} nor @{z} are
negative.") },
{ GNM_FUNC_HELP_EXAMPLES, "=IGAMMA(2.5,-1.8,TRUE,TRUE,TRUE)" },
{ GNM_FUNC_HELP_EXAMPLES, "=IGAMMA(2.5,-1.8,TRUE,TRUE,FALSE)" },
diff --git a/plugins/fn-random/functions.c b/plugins/fn-random/functions.c
index f247acb..3718c53 100644
--- a/plugins/fn-random/functions.c
+++ b/plugins/fn-random/functions.c
@@ -832,8 +832,8 @@ static GnmFuncHelp const help_simtable[] = {
"valid simulation models you should have the same number of "
"values @{dN} for all decision variables. If the simulation is run "
"more rounds than there are values defined, SIMTABLE returns "
- "#N/A! error (e.g. if A1 contains `=SIMTABLE(1)' and A2 "
- "`=SIMTABLE(1,2)', A1 yields #N/A! error on the second round).\n"
+ "#N/A error (e.g. if A1 contains `=SIMTABLE(1)' and A2 "
+ "`=SIMTABLE(1,2)', A1 yields #N/A error on the second round).\n"
"The successive use of the simulation tool also requires that you "
"give to the tool at least one input variable having RAND() or "
"any other RAND<distribution name>() function in it. "
diff --git a/plugins/fn-stat/functions.c b/plugins/fn-stat/functions.c
index 6cfdb1e..7be0a63 100644
--- a/plugins/fn-stat/functions.c
+++ b/plugins/fn-stat/functions.c
@@ -981,7 +981,7 @@ static GnmFuncHelp const help_expondist[] = {
{ GNM_FUNC_HELP_ARG, F_("y:scale parameter")},
{ GNM_FUNC_HELP_ARG, F_("cumulative:whether to evaluate the density function or the cumulative
distribution function")},
{ GNM_FUNC_HELP_DESCRIPTION, F_("If @{cumulative} is false it will return:\t"
- "@{y} * exp (-@{y}*@{x}),otherwise it will return\t"
+ "@{y} * exp (-@{y}*@{x}), otherwise it will return\t"
"1 - exp (-@{y}*@{x}).")},
{ GNM_FUNC_HELP_NOTE, F_("If @{x} < 0 or @{y} <= 0 this will return an error.")},
{ GNM_FUNC_HELP_EXCEL, F_("This function is Excel compatible.") },
@@ -1935,7 +1935,7 @@ static GnmFuncHelp const help_weibull[] = {
{ GNM_FUNC_HELP_ARG, F_("beta:scale parameter")},
{ GNM_FUNC_HELP_ARG, F_("cumulative:whether to evaluate the density function or the cumulative
distribution function")},
{ GNM_FUNC_HELP_DESCRIPTION, F_("If the @{cumulative} boolean is true it will return: "
- "1 - exp (-(@{x}/@{beta})^@{alpha}),otherwise it will return "
+ "1 - exp (-(@{x}/@{beta})^@{alpha}), otherwise it will return "
"(@{alpha}/@{beta}^@{alpha}) * @{x}^(@{alpha}-1) * exp(-(@{x}/@{beta}^@{alpha})).") },
{ GNM_FUNC_HELP_NOTE, F_("If @{x} < 0 this function returns a #NUM! error.") },
{ GNM_FUNC_HELP_NOTE, F_("If @{alpha} <= 0 or @{beta} <= 0 this function returns a #NUM! error.")},
@@ -2369,7 +2369,7 @@ static GnmFuncHelp const help_large[] = {
{ GNM_FUNC_HELP_EXCEL, F_("This function is Excel compatible.") },
{ GNM_FUNC_HELP_EXAMPLES, F_("Let us assume that the cells A1, A2, ..., A5 contain numbers "
"11.4, 17.3, 21.3, 25.9, and 40.1.") },
- { GNM_FUNC_HELP_EXAMPLES, F_("Then LARGE(A1:A5,2) equals 25.9."
+ { GNM_FUNC_HELP_EXAMPLES, F_("Then LARGE(A1:A5,2) equals 25.9. "
"LARGE(A1:A5,4) equals 17.3.") },
{ GNM_FUNC_HELP_SEEALSO, "PERCENTILE,PERCENTRANK,QUARTILE,SMALL"},
{ GNM_FUNC_HELP_END }
@@ -2412,7 +2412,7 @@ static GnmFuncHelp const help_small[] = {
{ GNM_FUNC_HELP_EXCEL, F_("This function is Excel compatible.") },
{ GNM_FUNC_HELP_EXAMPLES, F_("Let us assume that the cells A1, A2, ..., A5 contain numbers "
"11.4, 17.3, 21.3, 25.9, and 40.1.") },
- { GNM_FUNC_HELP_EXAMPLES, F_("Then SMALL(A1:A5,2) equals 17.3."
+ { GNM_FUNC_HELP_EXAMPLES, F_("Then SMALL(A1:A5,2) equals 17.3. "
"SMALL(A1:A5,4) equals 25.9.") },
{ GNM_FUNC_HELP_SEEALSO, "PERCENTILE,PERCENTRANK,QUARTILE,LARGE"},
{ GNM_FUNC_HELP_END }
@@ -2841,7 +2841,7 @@ static GnmFuncHelp const help_percentrank[] = {
{ GNM_FUNC_HELP_NOTE, F_("If @{significance} is less than one, this function returns a #NUM! "
"error.") },
{ GNM_FUNC_HELP_NOTE, F_("If @{x} exceeds the largest value or is less than the smallest "
- "value in @{array}, this function returns an #N/A! error.") },
+ "value in @{array}, this function returns an #N/A error.") },
{ GNM_FUNC_HELP_NOTE, F_("If @{x} does not match any of the values in @{array} or @{x} matches "
"more than once, this function interpolates the returned value.") },
{ GNM_FUNC_HELP_SEEALSO, "LARGE,MAX,MEDIAN,MIN,PERCENTILE,QUARTILE,SMALL"},
@@ -2945,7 +2945,7 @@ static GnmFuncHelp const help_percentrank_exc[] = {
{ GNM_FUNC_HELP_NOTE, F_("If @{significance} is less than one, this function returns a #NUM! "
"error.") },
{ GNM_FUNC_HELP_NOTE, F_("If @{x} exceeds the largest value or is less than the smallest "
- "value in @{array}, this function returns an #N/A! error.") },
+ "value in @{array}, this function returns an #N/A error.") },
{ GNM_FUNC_HELP_NOTE, F_("If @{x} does not match any of the values in @{array} or @{x} matches "
"more than once, this function interpolates the returned value.") },
{ GNM_FUNC_HELP_SEEALSO,
"LARGE,MAX,MEDIAN,MIN,PERCENTILE,PERCENTILE.EXC,QUARTILE,QUARTILE.EXC,SMALL"},
@@ -3287,9 +3287,9 @@ static GnmFuncHelp const help_ttest[] = {
{ GNM_FUNC_HELP_EXAMPLES, F_("Let us assume that the cells A1, A2, ..., A5 contain numbers "
"11.4, 17.3, 21.3, 25.9, and 40.1, and the cells B1, B2, ... "
"B5 23.2, 25.8, 29.9, 33.5, and 42.7.") },
- { GNM_FUNC_HELP_EXAMPLES, F_("Then TTEST(A1:A5,B1:B5,1,1) equals 0.003127619."
- "TTEST(A1:A5,B1:B5,2,1) equals 0.006255239."
- "TTEST(A1:A5,B1:B5,1,2) equals 0.111804322."
+ { GNM_FUNC_HELP_EXAMPLES, F_("Then TTEST(A1:A5,B1:B5,1,1) equals 0.003127619. "
+ "TTEST(A1:A5,B1:B5,2,1) equals 0.006255239. "
+ "TTEST(A1:A5,B1:B5,1,2) equals 0.111804322. "
"TTEST(A1:A5,B1:B5,1,3) equals 0.113821797.") },
{ GNM_FUNC_HELP_SEEALSO, "FDIST,FINV"},
{ GNM_FUNC_HELP_END }
@@ -3730,7 +3730,7 @@ static GnmFuncHelp const help_linest[] = {
"coefficients for the independent variables "
"x_m, x_(m-1),\xe2\x80\xa6,x_2, x_1 followed by the y-intercept if
@{affine} is true.")},
{ GNM_FUNC_HELP_DESCRIPTION, F_("If @{stats} is true, the second row contains the corresponding
standard "
- "errors of the regression coefficients."
+ "errors of the regression coefficients. "
"In this case, the third row contains the R^2 value and the standard
error "
"for the predicted value. "
"The fourth row contains the observed F value and its degrees of
freedom. "
@@ -3839,7 +3839,7 @@ static GnmFuncHelp const help_logreg[] = {
"y = m * ln(x) + b "
"to y's and x's. "
"LOGREG returns an array having two columns and one row. "
- "m is given in the first column and b in the second. ") },
+ "m is given in the first column and b in the second.") },
{ GNM_FUNC_HELP_DESCRIPTION, F_("Any extra statistical information is written below m and b in the "
"result array. This extra statistical information consists of four "
"rows of data: In the first row the standard error values for the "
@@ -3847,7 +3847,7 @@ static GnmFuncHelp const help_logreg[] = {
"contains the square of R and the standard error for the y "
"estimate. The third row contains the F-observed value and the "
"degrees of freedom. The last row contains the regression sum "
- "of squares and the residual sum of squares."
+ "of squares and the residual sum of squares. "
"The default of @{stat} is FALSE.") },
{ GNM_FUNC_HELP_NOTE, F_("If @{known_ys} and @{known_xs} have unequal number of data points, "
"this function returns a #NUM! error.") },
@@ -4568,10 +4568,10 @@ static GnmFuncHelp const help_subtotal[] = {
{ GNM_FUNC_HELP_ARG, F_("ref2:second value")},
{ GNM_FUNC_HELP_EXCEL, F_("This function is Excel compatible.") },
{ GNM_FUNC_HELP_EXAMPLES, F_("Let us assume that the cells A1, A2, ..., A5 contain numbers 23, 27,
28, 33, and 39.") },
- { GNM_FUNC_HELP_EXAMPLES, F_("Then SUBTOTAL(1,A1:A5) equals 30."
- "SUBTOTAL(6,A1:A5) equals 22378356."
- "SUBTOTAL(7,A1:A5) equals 6.164414003."
- "SUBTOTAL(9,A1:A5) equals 150."
+ { GNM_FUNC_HELP_EXAMPLES, F_("Then SUBTOTAL(1,A1:A5) equals 30. "
+ "SUBTOTAL(6,A1:A5) equals 22378356. "
+ "SUBTOTAL(7,A1:A5) equals 6.164414003. "
+ "SUBTOTAL(9,A1:A5) equals 150. "
"SUBTOTAL(11,A1:A5) equals 30.4.") },
{ GNM_FUNC_HELP_SEEALSO, "COUNT,SUM"},
{ GNM_FUNC_HELP_END }
diff --git a/plugins/fn-string/functions.c b/plugins/fn-string/functions.c
index 7ed0a83..a2c6d3d 100644
--- a/plugins/fn-string/functions.c
+++ b/plugins/fn-string/functions.c
@@ -331,7 +331,7 @@ gnumeric_left (GnmFuncEvalInfo *ei, GnmValue const * const *argv)
/***************************************************************************/
static GnmFuncHelp const help_leftb[] = {
- { GNM_FUNC_HELP_NAME, F_("LEFTB:the first characters of the string @{s} comprising at most
@{num_bytes} bytes")},
+ { GNM_FUNC_HELP_NAME, F_("LEFTB:the first characters of the string @{s} comprising at most
@{num_bytes} bytes")},
{ GNM_FUNC_HELP_ARG, F_("s:the string")},
{ GNM_FUNC_HELP_ARG, F_("num_bytes:the maximum number of bytes to return (defaults to 1)")},
{ GNM_FUNC_HELP_NOTE, F_("The semantics of this function is subject to change as various applications
implement it.")},
@@ -1515,7 +1515,7 @@ gnumeric_searchb (GnmFuncEvalInfo *ei, GnmValue const * const *argv)
static GnmFuncHelp const help_asc[] = {
{ GNM_FUNC_HELP_NAME, F_("ASC:text with full-width katakana and ASCII characters converted to
half-width")},
{ GNM_FUNC_HELP_ARG, F_("text:string")},
- { GNM_FUNC_HELP_DESCRIPTION, F_("ASC converts full-width katakana and ASCII characters to half-width
equivalent characters, copying all others. ")},
+ { GNM_FUNC_HELP_DESCRIPTION, F_("ASC converts full-width katakana and ASCII characters to half-width
equivalent characters, copying all others.")},
{ GNM_FUNC_HELP_DESCRIPTION, F_("The distinction between half-width and full-width characters is
described in http://www.unicode.org/reports/tr11/.";)},
{ GNM_FUNC_HELP_EXCEL, F_("For most strings, this function has the same effect as in Excel.")},
{ GNM_FUNC_HELP_NOTE, F_("While in obsolete encodings ASC used to translate between 2-byte and 1-byte
characters, this is not the case in UTF-8.")},
@@ -1643,7 +1643,7 @@ static GnmFuncHelp const help_jis[] = {
{ GNM_FUNC_HELP_NAME, F_("JIS:text with half-width katakana and ASCII characters converted to
full-width")},
{ GNM_FUNC_HELP_ARG, F_("text:original text")},
{ GNM_FUNC_HELP_DESCRIPTION, F_("JIS converts half-width katakana and ASCII characters "
- "to full-width equivalent characters, copying all others. ")},
+ "to full-width equivalent characters, copying all others.")},
{ GNM_FUNC_HELP_DESCRIPTION, F_("The distinction between half-width and full-width characters "
"is described in http://www.unicode.org/reports/tr11/.";)},
{ GNM_FUNC_HELP_EXCEL, F_("For most strings, this function has the same effect as in Excel.")},
diff --git a/plugins/fn-tsa/functions.c b/plugins/fn-tsa/functions.c
index 8ccc41d..3775625 100644
--- a/plugins/fn-tsa/functions.c
+++ b/plugins/fn-tsa/functions.c
@@ -561,7 +561,7 @@ gnumeric_interpolation (GnmFuncEvalInfo *ei, GnmValue const * const *argv)
static GnmFuncHelp const help_periodogram[] = {
{ GNM_FUNC_HELP_NAME, F_("PERIODOGRAM:periodogram of the given data") },
{ GNM_FUNC_HELP_ARG, F_("ordinates:ordinates of the given data") },
- { GNM_FUNC_HELP_ARG, F_("filter:windowing function to be used, defaults to no filter") },
+ { GNM_FUNC_HELP_ARG, F_("filter:windowing function to be used, defaults to no filter") },
{ GNM_FUNC_HELP_ARG, F_("abscissae:abscissae of the given data, defaults to regularly spaced
abscissae") },
{ GNM_FUNC_HELP_ARG, F_("interpolation:method of interpolation, defaults to none") },
{ GNM_FUNC_HELP_ARG, F_("number:number of interpolated data points") },
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]
