[Bug 115177] New - Even more string issues

[bugzilla-daemon widget gnome org]

Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

http://bugzilla.gnome.org/show_bug.cgi?id=115177

Changed by jan.moren@lucs.lu.se.

--- shadow/115177	Sat Jun 14 09:30:40 2003
+++ shadow/115177.tmp.29923	Sat Jun 14 09:30:40 2003
@@ -0,0 +1,242 @@
+Bug#: 115177
+Product: Gnumeric
+Version: CVS
+OS: Linux
+OS Details: rh9
+Status: NEW   
+Resolution: 
+Severity: minor
+Priority: Normal
+Component: General
+AssignedTo: jody@gnome.org                            
+ReportedBy: jan.moren@lucs.lu.se               
+TargetMilestone: ---
+URL: 
+Cc: gnome-i18n@gnome.org
+Summary: Even more string issues
+
+#: plugins/fn-stat/functions.c:221
+msgid ""
+"@FUNCTION=VAR\n"
+"@SYNTAX=VAR(b1, b2, ...)\n"
+"@DESCRIPTION=VAR estimates the variance of a sample of a population. To get "
+"the true variance of a complete population use @VARP.\n"
+"\n"
+
+-- Should likely not be "@VARP", but "VARP" instead.
+
+---
+
+#: plugins/fn-stat/functions.c:878
+msgid ""
+"@FUNCTION=COUNTA\n"
+"@SYNTAX=COUNTA(b1, b2, ...)\n"
+"@DESCRIPTION=COUNTA returns the number of arguments passed not including "
+"empty cells.\n"
+"\n"
+"* This function is Excel compatible.\n"
+"\n"
+"@EXAMPLES=\n"
+"Let us assume that the cells A1, A2, ..., A5 contain numbers and strings "
+"11.4, \"missing\", \"missing\", 25.9, and 40.1.  Then\n"
+"COUNTA(A1:A5) equals 5.\n"
+
+-- The example is wrong; it should return 3.
+
+---
+
+#: plugins/fn-stat/functions.c:952
+  (Also:
+  #: plugins/fn-stat/functions.c:994
+  
+msgid ""
+"@FUNCTION=MIN\n"
+"@SYNTAX=MIN(b1, b2, ...)\n"
+"@DESCRIPTION=MIN returns the value of the element of the values passed that "
+"has the smallest value. With negative numbers considered smaller than "
+"positive numbers.\n"
+
+-- Should be "... the smallest value, with negative numbers ..." for MIN
+and "... the largest value, with ..." for MAX.
+
+---
+#: plugins/fn-stat/functions.c:1036
+msgid ""
+"@FUNCTION=SKEW\n"
+"@SYNTAX=SKEW(n1, n2, ...)\n"
+"@DESCRIPTION=SKEW returns an unbiased estimate for skewness of a "
+"distribution.\n"
+"\n"
+"Note, that this is only meaningful if the underlying distribution really has "
+"a third moment.  The skewness of a symmetric (e.g., normal) distribution is "
+"zero.\n"
+"\n"
+"* Strings and empty cells are simply ignored.* If less than three numbers "
+"are given, SKEW returns #DIV/0! error.\n"
+"* This function is Excel compatible.\n"
+
+-- "* If less than three ..." should be on its own line.
+
+---
+
+
+#: plugins/fn-stat/functions.c:1514
+  (Also:
+  #: plugins/fn-stat/functions.c:1554
+
+msgid ""
+"@FUNCTION=BETADIST\n"
+"@SYNTAX=BETADIST(x,alpha,beta[,a,b])\n"
+"@DESCRIPTION=BETADIST function returns the cumulative beta distribution. @a "
+"is the optional lower bound of @x and @b is the optional upper bound of @x. "
+"If @a is not given, BETADIST uses 0.\n"
+"\n"
+"* If @b is not given, BETADIST uses 1.\n"
+"* If @x < @a or @x > @b BETADIST returns #NUM! error.\n"
+"* If @alpha <= 0 or @beta <= 0, BETADIST returns #NUM! error.\n"
+"* If @a >= @b BETADIST returns #NUM! error.\n"
+
+-- Either the line "If @a is not given ..." should be moved down and
+prefixed with a star like the others, or the line "If @b is not given ..."
+should be moved up and concatenated with the "If @a ..." line.
+
+---
+
+#: plugins/fn-stat/functions.c:1881
+msgid ""
+"@FUNCTION=BINOMDIST\n"
+"@SYNTAX=BINOMDIST(n,trials,p,cumulative)\n"
+"@DESCRIPTION=BINOMDIST function returns the binomial distribution. @n is the "
+"number of successes, @trials is the total number of independent trials, @p "
+"is the probability of success in trials, and @cumulative describes whether "
+"to return the sum of thebinomial function from 0 to @n.\n"
+
+-- "the binomial" rather than "thebinomial"
+
+"\n"
+"* If @n or @trials are non-integer they are truncated.\n"
+"* If @n < 0 or @trials < 0 BINOMDIST returns #NUM! error.\n"
+"* If @n > trials BINOMDIST returns #NUM! error.\n"
+"* If @p < 0 or @p > 1 BINOMDIST returns #NUM! error.\n"
+
+-- "@trials" rather than "trials"
+
+---
+
+#: plugins/fn-stat/functions.c:1967
+msgid ""
+"@FUNCTION=CRITBINOM\n"
+"@SYNTAX=CRITBINOM(trials,p,alpha)\n"
+"@DESCRIPTION=CRITBINOM function returns the smallest value for which "
+"thecumulative is greater than or equal to a given value. @n is the number of "
+
+-- "the cumulative"
+
+---
+
+#: plugins/fn-stat/functions.c:2289
+msgid ""
+"@FUNCTION=KURT\n"
+"@SYNTAX=KURT(n1, n2, ...)\n"
+"@DESCRIPTION=KURT returns an unbiased estimate of the kurtosis of a data "
+"set.\n"
+"Note, that this is only meaningful is the underlying distribution really has "
+
+-- "... only meaningful if the underlying ..."
+
+---
+
+#: plugins/fn-stat/functions.c:2425
+msgid ""
+"@FUNCTION=FISHER\n"
+"@SYNTAX=FISHER(x)\n"
+"@DESCRIPTION=FISHER function returns the Fisher transformation at @x.\n"
+"\n"
+"* If @x is not-number FISHER returns #VALUE! error.\n"
+
+-- "non-number" or "not a number"
+
+---
+
+#: plugins/fn-stat/functions.c:3283
+msgid ""
+"@FUNCTION=VARPA\n"
+"@SYNTAX=VARPA(number1,number2,...)\n"
+"@DESCRIPTION=VARPA returns the variance based on the entire population.  "
+"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.\n"
+"\n"
+"* This function is Excel compatible.\n"
+"\n"
+"@EXAMPLES=\n"
+"Let us assume that the cells A1, A2, ..., A5 contain numbers and strings "
+"11.4, 17.3, \"missing\", 25.9, and 40.1.  Then\n"
+"VARPA(A1:A5) equals 182.8904.\n"
+"\n"
+"@SEEALSO=VARP,VARP"
+
+-- @SEEALSO is wrong; maybe should be "@SEEALSO=VAR,VARA" ?
+
+---
+
+#: plugins/fn-stat/functions.c:3899
+msgid ""
+"@FUNCTION=LINEST\n"
+"@SYNTAX=LINEST(known_y's[,known_x's[,const[,stat]]])\n"
+"@DESCRIPTION=LINEST function calculates the ``least squares'' line that best "
+
+...
+
+"\n"
+"* If @known_x's is omitted, an array {1, 2, 3, ...} is used.\n"
+"If @known_y's and @known_x's have unequal number of data points, LINEST "
+"returns #NUM! error.\n"
+
+-- Add a star to the last line above: "* If @known_y's and ..."
+
+
+---
+
+#: plugins/fn-stat/functions.c:4547
+msgid ""
+"@FUNCTION=TREND\n"
+"@SYNTAX=TREND(known_y's[,known_x's],new_x's])\n"
+
+-- Something is wrong with the function prototype - the first ']' is likely
+superfluous. Or, possibly, perhaps of the form
+"(known_y's[,known_x's[,new_x's]])", since the docs treat missing known_x
+and new_x separately.
+
+---
+
+#: plugins/fn-stat/functions.c:4659
+  (Also in:
+  #: plugins/fn-stat/functions.c:4911
+  )
+msgid ""
+"@FUNCTION=LOGEST\n"
+"@SYNTAX=LOGEST(known_y's[,known_x's,const,stat])\n"
+
+...
+
+"@SEEALSO=LOGEST,GROWTH,TREND"
+
+-- Should not refer to itself in the @SEEALSO-section.
+
+---
+
+#: plugins/fn-stat/functions.c:5796
+msgid "p,mean,stddev"
+
+-- The parameter is spelled interchangeably as "stdev" and "stddev" over
+the whole application. I haven't had the energy to actually mark each and
+every place.
+
+---
+
+#: plugins/fn-stat/functions.c:5799
+msgid "x,meean,stdev"
+
+-- "mean"