[gnumeric] Indicate vararg functions in docs. [#649484]
- From: Andreas J. Guelzow <guelzow src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [gnumeric] Indicate vararg functions in docs. [#649484]
- Date: Fri, 6 May 2011 18:21:44 +0000 (UTC)
commit 8f6302d4a409da89f9830879be3b62f63bfc7297
Author: Andreas J Guelzow <aguelzow pyrshep ca>
Date: Fri May 6 12:20:59 2011 -0600
Indicate vararg functions in docs. [#649484]
2011-05-06 Andreas J. Guelzow <aguelzow pyrshep ca>
* src/func.c (function_dump_defs): write ellipsis in syntax
2011-05-06 Andreas J. Guelzow <aguelzow pyrshep ca>
* func.defs: update
* functions.xml: update
ChangeLog | 6 ++-
NEWS | 2 +-
doc/C/ChangeLog | 5 ++
doc/C/func.defs | 113 +++++++++++++++++++++++++-----------------------
doc/C/functions.xml | 119 +++++++++++++++++++++++++++-----------------------
src/func.c | 11 ++++-
6 files changed, 143 insertions(+), 113 deletions(-)
---
diff --git a/ChangeLog b/ChangeLog
index 370a5a0..affa809 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,7 +1,11 @@
2011-05-06 Andreas J. Guelzow <aguelzow pyrshep ca>
+ * src/func.c (function_dump_defs): write ellipsis in syntax
+
+2011-05-06 Andreas J. Guelzow <aguelzow pyrshep ca>
+
* src/func.c (function_def_count_args): special case INDEX
-
+
2011-05-05 Morten Welinder <terra gnome org>
* src/style.c (gnm_font_override_codepage): New function.
diff --git a/NEWS b/NEWS
index 6094535..0102c4e 100644
--- a/NEWS
+++ b/NEWS
@@ -7,7 +7,7 @@ Andreas:
* Handle NUL characters in cvs import. [#648354]
* Fix some Statistics tool formatting. [#649092]
* Fix undo crash for column widths. [#649139]
- * Indicate vararg functions in function browser. [#649484]
+ * Indicate vararg functions in function browser and docs. [#649484]
Morten:
* Fix problems with localized function docs.
diff --git a/doc/C/ChangeLog b/doc/C/ChangeLog
index c01d9ba..211fbec 100644
--- a/doc/C/ChangeLog
+++ b/doc/C/ChangeLog
@@ -1,3 +1,8 @@
+2011-05-06 Andreas J. Guelzow <aguelzow pyrshep ca>
+
+ * func.defs: update
+ * functions.xml: update
+
2011-04-09 Andreas J. Guelzow <aguelzow pyrshep ca>
* func.defs: update
diff --git a/doc/C/func.defs b/doc/C/func.defs
index a3d1112..7e34465 100644
--- a/doc/C/func.defs
+++ b/doc/C/func.defs
@@ -319,7 +319,7 @@ The natural logarithm is not uniquely defined on complex numbers. You may need t
@CATEGORY=Complex
@FUNCTION=IMPRODUCT
@SHORTDESC=the product of the given complex numbers
- SYNTAX=IMPRODUCT(z1,z2)
+ SYNTAX=IMPRODUCT(z1,z2,â?¦)
@ARGUMENTDESCRIPTION= {z1}: a complex number
@{z2}: a complex number
@NOTE=If any of @{z1}, @{z2},... is not a valid complex number, #VALUE! is returned.
@@ -391,7 +391,7 @@ The natural logarithm is not uniquely defined on complex numbers. You may need t
@CATEGORY=Complex
@FUNCTION=IMSUM
@SHORTDESC=the sum of the given complex numbers
- SYNTAX=IMSUM(z1,z2)
+ SYNTAX=IMSUM(z1,z2,â?¦)
@ARGUMENTDESCRIPTION= {z1}: a complex number
@{z2}: a complex number
@NOTE=If any of @{z1}, @{z2},... is not a valid complex number, #VALUE! is returned.
@@ -1131,10 +1131,13 @@ For metric units any of the following prefixes can be used:
@FUNCTION=DEC2BIN
@SHORTDESC=binary representation of the decimal number @{x}
@SYNTAX=DEC2BIN(x,places)
- ARGUMENTDESCRIPTION=@{x}: integer
+ ARGUMENTDESCRIPTION=@{x}: integer (â?? 513 < @{x} < 512)
@{places}: number of digits
- DESCRIPTION=If @{places} is given, DEC2BIN pads the result with zeros to achieve exactly @{places} digits. If this is not possible, DEC2BIN returns #NUM!
+ DESCRIPTION=If @{places} is given and @{x} is non-negative, DEC2BIN pads the result with zeros to achieve exactly @{places} digits. If this is not possible, DEC2BIN returns #NUM!
+If @{places} is given and @{x} is negative, @{places} is ignored.
+ NOTE=If @{x} < â?? 512 or @{x} > 511, DEC2BIN returns #NUM!
@EXCEL=This function is Excel compatible.
+ ODF=This function is OpenFormula compatible.
@SEEALSO=BIN2DEC,DEC2OCT,DEC2HEX
@CATEGORY=Engineering
@@ -1237,7 +1240,7 @@ For metric units any of the following prefixes can be used:
@CATEGORY=Engineering
@FUNCTION=INVSUMINV
@SHORTDESC=the reciprocal of the sum of reciprocals of the arguments
- SYNTAX=INVSUMINV(x0,x1)
+ SYNTAX=INVSUMINV(x0,x1,â?¦)
@ARGUMENTDESCRIPTION= {x0}: non-negative number
@{x1}: non-negative number
@DESCRIPTION=INVSUMINV sum calculates the reciprocal (the inverse) of the sum of reciprocals (inverses) of all its arguments.
@@ -1730,7 +1733,7 @@ The depreciation coefficient used is:
@CATEGORY=Finance
@FUNCTION=NPV
@SHORTDESC=net present value
- SYNTAX=NPV(rate,value1,value2)
+ SYNTAX=NPV(rate,value1,value2,â?¦)
@ARGUMENTDESCRIPTION= {rate}: effective interest rate per period
@{value1}: cash flow for period 1
@{value2}: cash flow for period 2
@@ -2686,7 +2689,7 @@ The depreciation coefficient used is:
@CATEGORY=Information
@FUNCTION=ISREF
@SHORTDESC=TRUE if @{value} is a reference
- SYNTAX=ISREF(value)
+ SYNTAX=ISREF(value,â?¦)
@ARGUMENTDESCRIPTION= {value}: a value
@DESCRIPTION=This function checks if a value is a cell reference.
@EXCEL=This function is Excel compatible.
@@ -2730,7 +2733,7 @@ The depreciation coefficient used is:
@CATEGORY=Logic
@FUNCTION=AND
@SHORTDESC=logical conjunction
- SYNTAX=AND(b0,b1)
+ SYNTAX=AND(b0,b1,â?¦)
@ARGUMENTDESCRIPTION= {b0}: logical value
@{b1}: logical value
@DESCRIPTION=AND calculates the logical conjunction of its arguments @{b0},@{b1},...
@@ -2787,7 +2790,7 @@ The depreciation coefficient used is:
@CATEGORY=Logic
@FUNCTION=OR
@SHORTDESC=logical disjunction
- SYNTAX=OR(b0,b1)
+ SYNTAX=OR(b0,b1,â?¦)
@ARGUMENTDESCRIPTION= {b0}: logical value
@{b1}: logical value
@DESCRIPTION=OR calculates the logical disjunction of its arguments @{b0},@{b1},...
@@ -2806,7 +2809,7 @@ The depreciation coefficient used is:
@CATEGORY=Logic
@FUNCTION=XOR
@SHORTDESC=logical exclusive disjunction
- SYNTAX=XOR(b0,b1)
+ SYNTAX=XOR(b0,b1,â?¦)
@ARGUMENTDESCRIPTION= {b0}: logical value
@{b1}: logical value
@DESCRIPTION=XOR calculates the logical exclusive disjunction of its arguments @{b0},@{b1},...
@@ -2828,21 +2831,21 @@ The depreciation coefficient used is:
@CATEGORY=Lookup
@FUNCTION=AREAS
@SHORTDESC=number of areas in @{reference}
- SYNTAX=AREAS(reference)
+ SYNTAX=AREAS(reference,â?¦)
@ARGUMENTDESCRIPTION= {reference}: range
@SEEALSO=ADDRESS,INDEX,INDIRECT,OFFSET
@CATEGORY=Lookup
@FUNCTION=ARRAY
@SHORTDESC=vertical array of the arguments
- SYNTAX=ARRAY(v)
+ SYNTAX=ARRAY(v,â?¦)
@ARGUMENTDESCRIPTION= {v}: value
@SEEALSO=TRANSPOSE
@CATEGORY=Lookup
@FUNCTION=CHOOSE
@SHORTDESC=the (@{index}+1)th argument
- SYNTAX=CHOOSE(index,value1,value2)
+ SYNTAX=CHOOSE(index,value1,value2,â?¦)
@ARGUMENTDESCRIPTION= {index}: positive number
@{value1}: first value
@{value2}: second value
@@ -3328,7 +3331,7 @@ The depreciation coefficient used is:
@CATEGORY=Mathematics
@FUNCTION=G_PRODUCT
@SHORTDESC=product of all the values and cells referenced
- SYNTAX=G_PRODUCT(x1,x2)
+ SYNTAX=G_PRODUCT(x1,x2,â?¦)
@ARGUMENTDESCRIPTION= {x1}: number
@{x2}: number
@NOTE=Empty cells are ignored and the empty product is 1.
@@ -3352,7 +3355,7 @@ The depreciation coefficient used is:
@CATEGORY=Mathematics
@FUNCTION=GCD
@SHORTDESC=the greatest common divisor
- SYNTAX=GCD(n0,n1)
+ SYNTAX=GCD(n0,n1,â?¦)
@ARGUMENTDESCRIPTION= {n0}: positive integer
@{n1}: positive integer
@DESCRIPTION=GCD calculates the greatest common divisor of the given numbers @{n0},@{n1},..., the greatest integer that is a divisor of each argument.
@@ -3370,7 +3373,7 @@ The depreciation coefficient used is:
@CATEGORY=Mathematics
@FUNCTION=HYPOT
@SHORTDESC=the square root of the sum of the squares of the arguments
- SYNTAX=HYPOT(n0,n1)
+ SYNTAX=HYPOT(n0,n1,â?¦)
@ARGUMENTDESCRIPTION= {n0}: number
@{n1}: number
@SEEALSO=MIN,MAX
@@ -3386,7 +3389,7 @@ The depreciation coefficient used is:
@CATEGORY=Mathematics
@FUNCTION=LCM
@SHORTDESC=the least common multiple
- SYNTAX=LCM(n0,n1)
+ SYNTAX=LCM(n0,n1,â?¦)
@ARGUMENTDESCRIPTION= {n0}: positive integer
@{n1}: positive integer
@DESCRIPTION=LCM calculates the least common multiple of the given numbers @{n0},@{n1},..., the smallest integer that is a multiple of each argument.
@@ -3489,7 +3492,7 @@ The depreciation coefficient used is:
@CATEGORY=Mathematics
@FUNCTION=MULTINOMIAL
@SHORTDESC=multinomial coefficient (@{x1}+â?¯+ {xn}) choose (@{x1},â?¦,@{xn})
- SYNTAX=MULTINOMIAL(x1,x2,xn)
+ SYNTAX=MULTINOMIAL(x1,x2,xn,â?¦)
@ARGUMENTDESCRIPTION= {x1}: first number
@{x2}: second number
@{xn}: nth number
@@ -3532,7 +3535,7 @@ The depreciation coefficient used is:
@CATEGORY=Mathematics
@FUNCTION=PRODUCT
@SHORTDESC=product of the given values
- SYNTAX=PRODUCT(values)
+ SYNTAX=PRODUCT(values,â?¦)
@ARGUMENTDESCRIPTION= {values}: a list of values to multiply
@DESCRIPTION=PRODUCT computes the product of all the values and cells referenced in the argument list.
@NOTE=If all cells are empty, the result will be 0.
@@ -3680,7 +3683,7 @@ If @{d} is less than zero, @{x} is rounded away from 0 to the left of the decima
@CATEGORY=Mathematics
@FUNCTION=SUM
@SHORTDESC=sum of the given values
- SYNTAX=SUM(values)
+ SYNTAX=SUM(values,â?¦)
@ARGUMENTDESCRIPTION= {values}: a list of values to add
@DESCRIPTION=SUM computes the sum of all the values and cells referenced in the argument list.
@EXCEL=This function is Excel compatible.
@@ -3690,7 +3693,7 @@ If @{d} is less than zero, @{x} is rounded away from 0 to the left of the decima
@CATEGORY=Mathematics
@FUNCTION=SUMA
@SHORTDESC=sum of all values and cells referenced
- SYNTAX=SUMA(area0,area1)
+ SYNTAX=SUMA(area0,area1,â?¦)
@ARGUMENTDESCRIPTION= {area0}: first cell area
@{area1}: second cell area
@DESCRIPTION=Numbers, text and logical values are included in the calculation too. If the cell contains text or the argument evaluates to FALSE, it is counted as value zero (0). If the argument evaluates to TRUE, it is counted as one (1).
@@ -3709,7 +3712,7 @@ If @{d} is less than zero, @{x} is rounded away from 0 to the left of the decima
@CATEGORY=Mathematics
@FUNCTION=SUMPRODUCT
@SHORTDESC=multiplies components and adds the results
- SYNTAX=SUMPRODUCT()
+ SYNTAX=SUMPRODUCT(,â?¦)
@DESCRIPTION=Multiplies corresponding data entries in the given arrays or ranges, and then returns the sum of those products.
@NOTE=If an entry is not numeric, the value zero is used instead. If arrays or range arguments do not have the same dimensions, return #VALUE! error. SUMPRODUCTs arguments are arrays or ranges. Attempting to use A1:A5>0 will not work, implicit intersection will kick in. Instead use --(A1:A5>0)
@SEEALSO=SUM,PRODUCT,G_PRODUCT
@@ -3717,7 +3720,7 @@ If @{d} is less than zero, @{x} is rounded away from 0 to the left of the decima
@CATEGORY=Mathematics
@FUNCTION=SUMSQ
@SHORTDESC=sum of the squares of all values and cells referenced
- SYNTAX=SUMSQ(area0,area1)
+ SYNTAX=SUMSQ(area0,area1,â?¦)
@ARGUMENTDESCRIPTION= {area0}: first cell area
@{area1}: second cell area
@EXCEL=This function is Excel compatible.
@@ -4128,7 +4131,7 @@ For @{α} = 2, @{β}=0, the Lévy distribution reduces to the normal distributio
@CATEGORY=Random Numbers
@FUNCTION=SIMTABLE
@SHORTDESC=one of the values in the given argument list depending on the round number of the simulation tool
- SYNTAX=SIMTABLE(d1,d2)
+ SYNTAX=SIMTABLE(d1,d2,â?¦)
@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}.
@@ -4147,7 +4150,7 @@ The successive use of the simulation tool also requires that you give to the too
@CATEGORY=Statistics
@FUNCTION=AVEDEV
@SHORTDESC=average of the absolute deviations of a data set
- SYNTAX=AVEDEV(number1,number2)
+ SYNTAX=AVEDEV(number1,number2,â?¦)
@ARGUMENTDESCRIPTION= {number1}: first value
@{number2}: second value
@EXCEL=This function is Excel compatible.
@@ -4156,7 +4159,7 @@ The successive use of the simulation tool also requires that you give to the too
@CATEGORY=Statistics
@FUNCTION=AVERAGE
@SHORTDESC=average of all the numeric values and cells
- SYNTAX=AVERAGE(number1,number2)
+ SYNTAX=AVERAGE(number1,number2,â?¦)
@ARGUMENTDESCRIPTION= {number1}: first value
@{number2}: second value
@EXCEL=This function is Excel compatible.
@@ -4165,7 +4168,7 @@ The successive use of the simulation tool also requires that you give to the too
@CATEGORY=Statistics
@FUNCTION=AVERAGEA
@SHORTDESC=average of all the values and cells
- SYNTAX=AVERAGEA(number1,number2)
+ SYNTAX=AVERAGEA(number1,number2,â?¦)
@ARGUMENTDESCRIPTION= {number1}: first value
@{number2}: second value
@DESCRIPTION=Numbers, text and logical values are included in the calculation too. If the cell contains text or the argument evaluates to FALSE, it is counted as value zero (0). If the argument evaluates to TRUE, it is counted as one (1). Note that empty cells are not counted.
@@ -4300,7 +4303,7 @@ The successive use of the simulation tool also requires that you give to the too
@CATEGORY=Statistics
@FUNCTION=COUNT
@SHORTDESC=total number of integer or floating point arguments passed
- SYNTAX=COUNT(number1,number2)
+ SYNTAX=COUNT(number1,number2,â?¦)
@ARGUMENTDESCRIPTION= {number1}: first value
@{number2}: second value
@EXCEL=This function is Excel compatible.
@@ -4309,7 +4312,7 @@ The successive use of the simulation tool also requires that you give to the too
@CATEGORY=Statistics
@FUNCTION=COUNTA
@SHORTDESC=number of arguments passed not including empty cells
- SYNTAX=COUNTA(number1,number2)
+ SYNTAX=COUNTA(number1,number2,â?¦)
@ARGUMENTDESCRIPTION= {number1}: first value
@{number2}: second value
@EXCEL=This function is Excel compatible.
@@ -4339,7 +4342,7 @@ The successive use of the simulation tool also requires that you give to the too
@CATEGORY=Statistics
@FUNCTION=CRONBACH
@SHORTDESC=Cronbach's alpha
- SYNTAX=CRONBACH(ref1,ref2)
+ SYNTAX=CRONBACH(ref1,ref2,â?¦)
@ARGUMENTDESCRIPTION= {ref1}: first data set
@{ref2}: second data set
@SEEALSO=VAR
@@ -4356,7 +4359,7 @@ The successive use of the simulation tool also requires that you give to the too
@CATEGORY=Statistics
@FUNCTION=DEVSQ
@SHORTDESC=sum of squares of deviations of a data set
- SYNTAX=DEVSQ(number1,number2)
+ SYNTAX=DEVSQ(number1,number2,â?¦)
@ARGUMENTDESCRIPTION= {number1}: first value
@{number2}: second value
@DESCRIPTION=Strings and empty cells are simply ignored.
@@ -4496,7 +4499,7 @@ If the @{bins_array} is empty, this function returns the number of data points i
@CATEGORY=Statistics
@FUNCTION=GEOMEAN
@SHORTDESC=geometric mean
- SYNTAX=GEOMEAN(number1,number2)
+ SYNTAX=GEOMEAN(number1,number2,â?¦)
@ARGUMENTDESCRIPTION= {number1}: first value
@{number2}: second value
@DESCRIPTION=The geometric mean is equal to the Nth root of the product of the N values.
@@ -4519,7 +4522,7 @@ GROWTH returns an array having one column and a row for each data point in @{new
@CATEGORY=Statistics
@FUNCTION=HARMEAN
@SHORTDESC=harmonic mean
- SYNTAX=HARMEAN(number1,number2)
+ SYNTAX=HARMEAN(number1,number2,â?¦)
@ARGUMENTDESCRIPTION= {number1}: first value
@{number2}: second value
@DESCRIPTION=The harmonic mean of N data points is N divided by the sum of the reciprocals of the data points).
@@ -4552,7 +4555,7 @@ GROWTH returns an array having one column and a row for each data point in @{new
@CATEGORY=Statistics
@FUNCTION=KURT
@SHORTDESC=unbiased estimate of the kurtosis of a data set
- SYNTAX=KURT(number1,number2)
+ SYNTAX=KURT(number1,number2,â?¦)
@ARGUMENTDESCRIPTION= {number1}: first value
@{number2}: second value
@DESCRIPTION=Strings and empty cells are simply ignored.
@@ -4563,7 +4566,7 @@ GROWTH returns an array having one column and a row for each data point in @{new
@CATEGORY=Statistics
@FUNCTION=KURTP
@SHORTDESC=population kurtosis of a data set
- SYNTAX=KURTP(number1,number2)
+ SYNTAX=KURTP(number1,number2,â?¦)
@ARGUMENTDESCRIPTION= {number1}: first value
@{number2}: second value
@DESCRIPTION=Strings and empty cells are simply ignored.
@@ -4688,7 +4691,7 @@ Any extra statistical information is written below m and b in the result array.
@CATEGORY=Statistics
@FUNCTION=MAX
@SHORTDESC=largest value, with negative numbers considered smaller than positive numbers
- SYNTAX=MAX(number1,number2)
+ SYNTAX=MAX(number1,number2,â?¦)
@ARGUMENTDESCRIPTION= {number1}: first value
@{number2}: second value
@EXCEL=This function is Excel compatible.
@@ -4697,7 +4700,7 @@ Any extra statistical information is written below m and b in the result array.
@CATEGORY=Statistics
@FUNCTION=MAXA
@SHORTDESC=largest value, with negative numbers considered smaller than positive numbers
- SYNTAX=MAXA(number1,number2)
+ SYNTAX=MAXA(number1,number2,â?¦)
@ARGUMENTDESCRIPTION= {number1}: first value
@{number2}: second value
@DESCRIPTION=Numbers, text and logical values are included in the calculation too. If the cell contains text or the argument evaluates to FALSE, it is counted as value zero (0). If the argument evaluates to TRUE, it is counted as one (1). Note that empty cells are not counted.
@@ -4707,7 +4710,7 @@ Any extra statistical information is written below m and b in the result array.
@CATEGORY=Statistics
@FUNCTION=MEDIAN
@SHORTDESC=median of a data set
- SYNTAX=MEDIAN(number1,number2)
+ SYNTAX=MEDIAN(number1,number2,â?¦)
@ARGUMENTDESCRIPTION= {number1}: first value
@{number2}: second value
@DESCRIPTION=Strings and empty cells are simply ignored.
@@ -4718,7 +4721,7 @@ Any extra statistical information is written below m and b in the result array.
@CATEGORY=Statistics
@FUNCTION=MIN
@SHORTDESC=smallest value, with negative numbers considered smaller than positive numbers
- SYNTAX=MIN(number1,number2)
+ SYNTAX=MIN(number1,number2,â?¦)
@ARGUMENTDESCRIPTION= {number1}: first value
@{number2}: second value
@EXCEL=This function is Excel compatible.
@@ -4727,7 +4730,7 @@ Any extra statistical information is written below m and b in the result array.
@CATEGORY=Statistics
@FUNCTION=MINA
@SHORTDESC=smallest value, with negative numbers considered smaller than positive numbers
- SYNTAX=MINA(number1,number2)
+ SYNTAX=MINA(number1,number2,â?¦)
@ARGUMENTDESCRIPTION= {number1}: first value
@{number2}: second value
@DESCRIPTION=Numbers, text and logical values are included in the calculation too. If the cell contains text or the argument evaluates to FALSE, it is counted as value zero (0). If the argument evaluates to TRUE, it is counted as one (1). Note that empty cells are not counted.
@@ -4737,7 +4740,7 @@ Any extra statistical information is written below m and b in the result array.
@CATEGORY=Statistics
@FUNCTION=MODE
@SHORTDESC=first most common number in the dataset
- SYNTAX=MODE(number1,number2)
+ SYNTAX=MODE(number1,number2,â?¦)
@ARGUMENTDESCRIPTION= {number1}: first value
@{number2}: second value
@DESCRIPTION=Strings and empty cells are simply ignored.
@@ -5502,7 +5505,7 @@ If the data set does not contain any duplicates this function returns a #N/A err
@CATEGORY=Statistics
@FUNCTION=SKEW
@SHORTDESC=unbiased estimate for skewness of a distribution
- SYNTAX=SKEW(number1,number2)
+ SYNTAX=SKEW(number1,number2,â?¦)
@ARGUMENTDESCRIPTION= {number1}: first value
@{number2}: second value
@DESCRIPTION=Strings and empty cells are simply ignored.
@@ -5513,7 +5516,7 @@ If the data set does not contain any duplicates this function returns a #N/A err
@CATEGORY=Statistics
@FUNCTION=SKEWP
@SHORTDESC=population skewness of a data set
- SYNTAX=SKEWP(number1,number2)
+ SYNTAX=SKEWP(number1,number2,â?¦)
@ARGUMENTDESCRIPTION= {number1}: first value
@{number2}: second value
@DESCRIPTION=Strings and empty cells are simply ignored.
@@ -5542,11 +5545,11 @@ If the data set does not contain any duplicates this function returns a #N/A err
@CATEGORY=Statistics
@FUNCTION=SSMEDIAN
- SHORTDESC=median for grouped data as commonly determined in the social sciences
+ SHORTDESC=median for grouped data
@SYNTAX=SSMEDIAN(array,interval)
@ARGUMENTDESCRIPTION= {array}: data set
@{interval}: length of each grouping interval, defaults to 1
- DESCRIPTION=The data is assumed to be grouped into intervals of width @{interval}. Each data point in @{array} is the midpoint of the interval containing the true data value. The median is calculated by interpolation within the median interval (the interval containing the median value), assuming that the true values within that interval are distributed uniformly:
+ DESCRIPTION=The data are assumed to be grouped into intervals of width @{interval}. Each data point in @{array} is the midpoint of the interval containing the true value. The median is calculated by interpolation within the median interval (the interval containing the median value), assuming that the true values within that interval are distributed uniformly:
median = L + @{interval}*(N/2 - CF)/F
where:
L = the lower limit of the median interval
@@ -5570,7 +5573,7 @@ F = the number of data points in the median interval
@CATEGORY=Statistics
@FUNCTION=STDEV
@SHORTDESC=sample standard deviation of the given sample
- SYNTAX=STDEV(area1,area2)
+ SYNTAX=STDEV(area1,area2,â?¦)
@ARGUMENTDESCRIPTION= {area1}: first cell area
@{area2}: second cell area
@DESCRIPTION=STDEV is also known as the N-1-standard deviation.
@@ -5581,7 +5584,7 @@ To obtain the population standard deviation of a whole population use STDEVP.
@CATEGORY=Statistics
@FUNCTION=STDEVA
@SHORTDESC=sample standard deviation of the given sample
- SYNTAX=STDEVA(area1,area2)
+ SYNTAX=STDEVA(area1,area2,â?¦)
@ARGUMENTDESCRIPTION= {area1}: first cell area
@{area2}: second cell area
@DESCRIPTION=STDEVA is also known as the N-1-standard deviation.
@@ -5593,7 +5596,7 @@ Numbers, text and logical values are included in the calculation too. If the cel
@CATEGORY=Statistics
@FUNCTION=STDEVP
@SHORTDESC=population standard deviation of the given population
- SYNTAX=STDEVP(area1,area2)
+ SYNTAX=STDEVP(area1,area2,â?¦)
@ARGUMENTDESCRIPTION= {area1}: first cell area
@{area2}: second cell area
@DESCRIPTION=This is also known as the N-standard deviation
@@ -5603,7 +5606,7 @@ Numbers, text and logical values are included in the calculation too. If the cel
@CATEGORY=Statistics
@FUNCTION=STDEVPA
@SHORTDESC=population standard deviation of an entire population
- SYNTAX=STDEVPA(area1,area2)
+ SYNTAX=STDEVPA(area1,area2,â?¦)
@ARGUMENTDESCRIPTION= {area1}: first cell area
@{area2}: second cell area
@DESCRIPTION=This is also known as the N-standard deviation
@@ -5624,7 +5627,7 @@ Numbers, text and logical values are included in the calculation too. If the cel
@CATEGORY=Statistics
@FUNCTION=SUBTOTAL
@SHORTDESC=the subtotal of the given list of arguments
- SYNTAX=SUBTOTAL(function_nbr,ref1,ref2)
+ SYNTAX=SUBTOTAL(function_nbr,ref1,ref2,â?¦)
@ARGUMENTDESCRIPTION= {function_nbr}: determines which function to use according to the following table:
1 AVERAGE
2 COUNT
@@ -5701,7 +5704,7 @@ This function is Excel compatible for non-negative @{x}.
@CATEGORY=Statistics
@FUNCTION=VAR
@SHORTDESC=sample variance of the given sample
- SYNTAX=VAR(area1,area2)
+ SYNTAX=VAR(area1,area2,â?¦)
@ARGUMENTDESCRIPTION= {area1}: first cell area
@{area2}: second cell area
@DESCRIPTION=VAR is also known as the N-1-variance.
@@ -5712,7 +5715,7 @@ This function is Excel compatible for non-negative @{x}.
@CATEGORY=Statistics
@FUNCTION=VARA
@SHORTDESC=sample variance of the given sample
- SYNTAX=VARA(area1,area2)
+ SYNTAX=VARA(area1,area2,â?¦)
@ARGUMENTDESCRIPTION= {area1}: first cell area
@{area2}: second cell area
@DESCRIPTION=VARA is also known as the N-1-variance.
@@ -5725,7 +5728,7 @@ Numbers, text and logical values are included in the calculation too. If the cel
@CATEGORY=Statistics
@FUNCTION=VARP
@SHORTDESC=variance of an entire population
- SYNTAX=VARP(area1,area2)
+ SYNTAX=VARP(area1,area2,â?¦)
@ARGUMENTDESCRIPTION= {area1}: first cell area
@{area2}: second cell area
@DESCRIPTION=VARP is also known as the N-variance.
@@ -5734,7 +5737,7 @@ Numbers, text and logical values are included in the calculation too. If the cel
@CATEGORY=Statistics
@FUNCTION=VARPA
@SHORTDESC=variance of an entire population
- SYNTAX=VARPA(area1,area2)
+ SYNTAX=VARPA(area1,area2,â?¦)
@ARGUMENTDESCRIPTION= {area1}: first cell area
@{area2}: second cell area
@DESCRIPTION=VARPA is also known as the N-variance.
@@ -5816,7 +5819,7 @@ This function is Excel compatible.
@CATEGORY=String
@FUNCTION=CONCATENATE
@SHORTDESC=the concatenation of the strings @{s1}, @{s2},â?¦
- SYNTAX=CONCATENATE(s1,s2)
+ SYNTAX=CONCATENATE(s1,s2,â?¦)
@ARGUMENTDESCRIPTION= {s1}: first string
@{s2}: second string
@EXCEL=This function is Excel compatible.
diff --git a/doc/C/functions.xml b/doc/C/functions.xml
index a3743af..dd5ebd2 100644
--- a/doc/C/functions.xml
+++ b/doc/C/functions.xml
@@ -1256,7 +1256,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>IMPRODUCT</function>(<parameter>z1</parameter>,<parameter>z2</parameter>)</synopsis>
+ <synopsis><function>IMPRODUCT</function>(<parameter>z1</parameter>,<parameter>z2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -1534,7 +1534,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>IMSUM</function>(<parameter>z1</parameter>,<parameter>z2</parameter>)</synopsis>
+ <synopsis><function>IMSUM</function>(<parameter>z1</parameter>,<parameter>z2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -3923,18 +3923,27 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: integer</para>
+ <para><parameter>x</parameter>: integer (â?? 513 < <parameter>x</parameter> < 512)</para>
<para><parameter>places</parameter>: number of digits</para>
</refsect1>
<refsect1>
<title>Description</title>
- <para>If <parameter>places</parameter> is given, <function>DEC2BIN</function> pads the result with zeros to achieve exactly <parameter>places</parameter> digits. If this is not possible, <function>DEC2BIN</function> returns #NUM!</para>
+ <para>If <parameter>places</parameter> is given and <parameter>x</parameter> is non-negative, <function>DEC2BIN</function> pads the result with zeros to achieve exactly <parameter>places</parameter> digits. If this is not possible, <function>DEC2BIN</function> returns #NUM!</para>
+ <para>If <parameter>places</parameter> is given and <parameter>x</parameter> is negative, <parameter>places</parameter> is ignored.</para>
+ </refsect1>
+ <refsect1>
+ <title>Note</title>
+ <para>If <parameter>x</parameter> < â?? 512 or <parameter>x</parameter> > 511, <function>DEC2BIN</function> returns #NUM!</para>
</refsect1>
<refsect1>
<title>Microsoft Excel Compatibility</title>
<para>This function is Excel compatible.</para>
</refsect1>
<refsect1>
+ <title>OpenDocument Format (ODF) Compatibility</title>
+ <para>This function is OpenFormula compatible.</para>
+ </refsect1>
+ <refsect1>
<title>See also</title>
<para><link linkend="gnumeric-BIN2DEC"><function>BIN2DEC</function></link>,
<link linkend="gnumeric-DEC2OCT"><function>DEC2OCT</function></link>,
@@ -4322,7 +4331,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>INVSUMINV</function>(<parameter>x0</parameter>,<parameter>x1</parameter>)</synopsis>
+ <synopsis><function>INVSUMINV</function>(<parameter>x0</parameter>,<parameter>x1</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -5894,7 +5903,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>NPV</function>(<parameter>rate</parameter>,<parameter>value1</parameter>,<parameter>value2</parameter>)</synopsis>
+ <synopsis><function>NPV</function>(<parameter>rate</parameter>,<parameter>value1</parameter>,<parameter>value2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -8722,7 +8731,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>ISREF</function>(<parameter>value</parameter>)</synopsis>
+ <synopsis><function>ISREF</function>(<parameter>value</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -8877,7 +8886,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>AND</function>(<parameter>b0</parameter>,<parameter>b1</parameter>)</synopsis>
+ <synopsis><function>AND</function>(<parameter>b0</parameter>,<parameter>b1</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -9095,7 +9104,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>OR</function>(<parameter>b0</parameter>,<parameter>b1</parameter>)</synopsis>
+ <synopsis><function>OR</function>(<parameter>b0</parameter>,<parameter>b1</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -9170,7 +9179,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>XOR</function>(<parameter>b0</parameter>,<parameter>b1</parameter>)</synopsis>
+ <synopsis><function>XOR</function>(<parameter>b0</parameter>,<parameter>b1</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -9247,7 +9256,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>AREAS</function>(<parameter>reference</parameter>)</synopsis>
+ <synopsis><function>AREAS</function>(<parameter>reference</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -9277,7 +9286,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>ARRAY</function>(<parameter>v</parameter>)</synopsis>
+ <synopsis><function>ARRAY</function>(<parameter>v</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -9304,7 +9313,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>CHOOSE</function>(<parameter>index</parameter>,<parameter>value1</parameter>,<parameter>value2</parameter>)</synopsis>
+ <synopsis><function>CHOOSE</function>(<parameter>index</parameter>,<parameter>value1</parameter>,<parameter>value2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -11183,7 +11192,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>G_PRODUCT</function>(<parameter>x1</parameter>,<parameter>x2</parameter>)</synopsis>
+ <synopsis><function>G_PRODUCT</function>(<parameter>x1</parameter>,<parameter>x2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -11274,7 +11283,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>GCD</function>(<parameter>n0</parameter>,<parameter>n1</parameter>)</synopsis>
+ <synopsis><function>GCD</function>(<parameter>n0</parameter>,<parameter>n1</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -11342,7 +11351,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>HYPOT</function>(<parameter>n0</parameter>,<parameter>n1</parameter>)</synopsis>
+ <synopsis><function>HYPOT</function>(<parameter>n0</parameter>,<parameter>n1</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -11406,7 +11415,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>LCM</function>(<parameter>n0</parameter>,<parameter>n1</parameter>)</synopsis>
+ <synopsis><function>LCM</function>(<parameter>n0</parameter>,<parameter>n1</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -11811,7 +11820,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>MULTINOMIAL</function>(<parameter>x1</parameter>,<parameter>x2</parameter>,<parameter>xn</parameter>)</synopsis>
+ <synopsis><function>MULTINOMIAL</function>(<parameter>x1</parameter>,<parameter>x2</parameter>,<parameter>xn</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -11971,7 +11980,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>PRODUCT</function>(<parameter>values</parameter>)</synopsis>
+ <synopsis><function>PRODUCT</function>(<parameter>values</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -12526,7 +12535,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>SUM</function>(<parameter>values</parameter>)</synopsis>
+ <synopsis><function>SUM</function>(<parameter>values</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -12566,7 +12575,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>SUMA</function>(<parameter>area0</parameter>,<parameter>area1</parameter>)</synopsis>
+ <synopsis><function>SUMA</function>(<parameter>area0</parameter>,<parameter>area1</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -12634,7 +12643,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>SUMPRODUCT</function>(<parameter/>)</synopsis>
+ <synopsis><function>SUMPRODUCT</function>(<parameter/>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Description</title>
@@ -12667,7 +12676,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>SUMSQ</function>(<parameter>area0</parameter>,<parameter>area1</parameter>)</synopsis>
+ <synopsis><function>SUMSQ</function>(<parameter>area0</parameter>,<parameter>area1</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -14209,7 +14218,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>SIMTABLE</function>(<parameter>d1</parameter>,<parameter>d2</parameter>)</synopsis>
+ <synopsis><function>SIMTABLE</function>(<parameter>d1</parameter>,<parameter>d2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -14279,7 +14288,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>AVEDEV</function>(<parameter>number1</parameter>,<parameter>number2</parameter>)</synopsis>
+ <synopsis><function>AVEDEV</function>(<parameter>number1</parameter>,<parameter>number2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -14311,7 +14320,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>AVERAGE</function>(<parameter>number1</parameter>,<parameter>number2</parameter>)</synopsis>
+ <synopsis><function>AVERAGE</function>(<parameter>number1</parameter>,<parameter>number2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -14344,7 +14353,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>AVERAGEA</function>(<parameter>number1</parameter>,<parameter>number2</parameter>)</synopsis>
+ <synopsis><function>AVERAGEA</function>(<parameter>number1</parameter>,<parameter>number2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -14806,7 +14815,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>COUNT</function>(<parameter>number1</parameter>,<parameter>number2</parameter>)</synopsis>
+ <synopsis><function>COUNT</function>(<parameter>number1</parameter>,<parameter>number2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -14838,7 +14847,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>COUNTA</function>(<parameter>number1</parameter>,<parameter>number2</parameter>)</synopsis>
+ <synopsis><function>COUNTA</function>(<parameter>number1</parameter>,<parameter>number2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -14950,7 +14959,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>CRONBACH</function>(<parameter>ref1</parameter>,<parameter>ref2</parameter>)</synopsis>
+ <synopsis><function>CRONBACH</function>(<parameter>ref1</parameter>,<parameter>ref2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -15016,7 +15025,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>DEVSQ</function>(<parameter>number1</parameter>,<parameter>number2</parameter>)</synopsis>
+ <synopsis><function>DEVSQ</function>(<parameter>number1</parameter>,<parameter>number2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -15503,7 +15512,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>GEOMEAN</function>(<parameter>number1</parameter>,<parameter>number2</parameter>)</synopsis>
+ <synopsis><function>GEOMEAN</function>(<parameter>number1</parameter>,<parameter>number2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -15584,7 +15593,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>HARMEAN</function>(<parameter>number1</parameter>,<parameter>number2</parameter>)</synopsis>
+ <synopsis><function>HARMEAN</function>(<parameter>number1</parameter>,<parameter>number2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -15701,7 +15710,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>KURT</function>(<parameter>number1</parameter>,<parameter>number2</parameter>)</synopsis>
+ <synopsis><function>KURT</function>(<parameter>number1</parameter>,<parameter>number2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -15744,7 +15753,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>KURTP</function>(<parameter>number1</parameter>,<parameter>number2</parameter>)</synopsis>
+ <synopsis><function>KURTP</function>(<parameter>number1</parameter>,<parameter>number2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -16181,7 +16190,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>MAX</function>(<parameter>number1</parameter>,<parameter>number2</parameter>)</synopsis>
+ <synopsis><function>MAX</function>(<parameter>number1</parameter>,<parameter>number2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -16214,7 +16223,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>MAXA</function>(<parameter>number1</parameter>,<parameter>number2</parameter>)</synopsis>
+ <synopsis><function>MAXA</function>(<parameter>number1</parameter>,<parameter>number2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -16251,7 +16260,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>MEDIAN</function>(<parameter>number1</parameter>,<parameter>number2</parameter>)</synopsis>
+ <synopsis><function>MEDIAN</function>(<parameter>number1</parameter>,<parameter>number2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -16297,7 +16306,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>MIN</function>(<parameter>number1</parameter>,<parameter>number2</parameter>)</synopsis>
+ <synopsis><function>MIN</function>(<parameter>number1</parameter>,<parameter>number2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -16330,7 +16339,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>MINA</function>(<parameter>number1</parameter>,<parameter>number2</parameter>)</synopsis>
+ <synopsis><function>MINA</function>(<parameter>number1</parameter>,<parameter>number2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -16367,7 +16376,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>MODE</function>(<parameter>number1</parameter>,<parameter>number2</parameter>)</synopsis>
+ <synopsis><function>MODE</function>(<parameter>number1</parameter>,<parameter>number2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -18857,7 +18866,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>SKEW</function>(<parameter>number1</parameter>,<parameter>number2</parameter>)</synopsis>
+ <synopsis><function>SKEW</function>(<parameter>number1</parameter>,<parameter>number2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -18900,7 +18909,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>SKEWP</function>(<parameter>number1</parameter>,<parameter>number2</parameter>)</synopsis>
+ <synopsis><function>SKEWP</function>(<parameter>number1</parameter>,<parameter>number2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -19010,7 +19019,7 @@
<function>SSMEDIAN</function>
</refname>
<refpurpose>
- median for grouped data as commonly determined in the social sciences
+ median for grouped data
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -19023,7 +19032,7 @@
</refsect1>
<refsect1>
<title>Description</title>
- <para>The data is assumed to be grouped into intervals of width <parameter>interval</parameter>. Each data point in <parameter>array</parameter> is the midpoint of the interval containing the true data value. The median is calculated by interpolation within the median interval (the interval containing the median value), assuming that the true values within that interval are distributed uniformly:</para>
+ <para>The data are assumed to be grouped into intervals of width <parameter>interval</parameter>. Each data point in <parameter>array</parameter> is the midpoint of the interval containing the true value. The median is calculated by interpolation within the median interval (the interval containing the median value), assuming that the true values within that interval are distributed uniformly:</para>
<para>median = L + <parameter>interval</parameter>*(N/2 - CF)/F</para>
<para>where:</para>
<para>L = the lower limit of the median interval</para>
@@ -19093,7 +19102,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>STDEV</function>(<parameter>area1</parameter>,<parameter>area2</parameter>)</synopsis>
+ <synopsis><function>STDEV</function>(<parameter>area1</parameter>,<parameter>area2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -19135,7 +19144,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>STDEVA</function>(<parameter>area1</parameter>,<parameter>area2</parameter>)</synopsis>
+ <synopsis><function>STDEVA</function>(<parameter>area1</parameter>,<parameter>area2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -19174,7 +19183,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>STDEVP</function>(<parameter>area1</parameter>,<parameter>area2</parameter>)</synopsis>
+ <synopsis><function>STDEVP</function>(<parameter>area1</parameter>,<parameter>area2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -19212,7 +19221,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>STDEVPA</function>(<parameter>area1</parameter>,<parameter>area2</parameter>)</synopsis>
+ <synopsis><function>STDEVPA</function>(<parameter>area1</parameter>,<parameter>area2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -19288,7 +19297,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>SUBTOTAL</function>(<parameter>function_nbr</parameter>,<parameter>ref1</parameter>,<parameter>ref2</parameter>)</synopsis>
+ <synopsis><function>SUBTOTAL</function>(<parameter>function_nbr</parameter>,<parameter>ref1</parameter>,<parameter>ref2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -19526,7 +19535,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>VAR</function>(<parameter>area1</parameter>,<parameter>area2</parameter>)</synopsis>
+ <synopsis><function>VAR</function>(<parameter>area1</parameter>,<parameter>area2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -19568,7 +19577,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>VARA</function>(<parameter>area1</parameter>,<parameter>area2</parameter>)</synopsis>
+ <synopsis><function>VARA</function>(<parameter>area1</parameter>,<parameter>area2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -19611,7 +19620,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>VARP</function>(<parameter>area1</parameter>,<parameter>area2</parameter>)</synopsis>
+ <synopsis><function>VARP</function>(<parameter>area1</parameter>,<parameter>area2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -19647,7 +19656,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>VARPA</function>(<parameter>area1</parameter>,<parameter>area2</parameter>)</synopsis>
+ <synopsis><function>VARPA</function>(<parameter>area1</parameter>,<parameter>area2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -19930,7 +19939,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>CONCATENATE</function>(<parameter>s1</parameter>,<parameter>s2</parameter>)</synopsis>
+ <synopsis><function>CONCATENATE</function>(<parameter>s1</parameter>,<parameter>s2</parameter>,<parameter/>â?¦)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
diff --git a/src/func.c b/src/func.c
index b46684e..8e73649 100644
--- a/src/func.c
+++ b/src/func.c
@@ -35,6 +35,7 @@
#include <string.h>
#include <stdlib.h>
+#define UNICODE_ELLIPSIS "\xe2\x80\xa6"
#define F2(func,s) dgettext ((func)->textdomain->str, (s))
static GList *categories;
@@ -333,6 +334,7 @@ function_dump_defs (char const *filename, int dump_type)
GString *excel = g_string_new (NULL);
GString *note = g_string_new (NULL);
GString *seealso = g_string_new (NULL);
+ gint min, max;
fprintf (output_file, "@CATEGORY=%s\n",
F2(fd, fd->fn_group->display_name->str));
@@ -407,7 +409,14 @@ function_dump_defs (char const *filename, int dump_type)
}
}
- fprintf (output_file, "@SYNTAX=%s)\n", syntax->str);
+ function_def_count_args (fd, &min, &max);
+ if (max == G_MAXINT)
+ fprintf (output_file,
+ "@SYNTAX=%s," UNICODE_ELLIPSIS ")\n",
+ syntax->str);
+ else
+ fprintf (output_file, "@SYNTAX=%s)\n",
+ syntax->str);
if (arg_desc->len > 0)
fprintf (output_file, "@ARGUMENTDESCRIPTION=%s", arg_desc->str);
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]
