gnumeric r17075 - in branches/gnumeric-1-8: . doc doc/C doc/de plugins/applix plugins/corba plugins/derivatives plugins/dif plugins/excel plugins/fn-complex plugins/fn-database plugins/fn-date plugins/fn-eng plugins/fn-erlang plugins/fn-financial plugins/fn-info plugins/fn-logical plugins/fn-lookup plugins/fn-math plugins/fn-r plugins/fn-random plugins/fn-stat plugins/fn-string plugins/fn-tsa plugins/gb plugins/gda plugins/gnome-db plugins/gnome-glossary plugins/guile plugins/html plugins/lotus-123 plugins/mps plugins/numtheory plugins/numtheory/doc plugins/oleo plugins/openoffice plugins/paradox plugins/perl-loader plugins/plan-perfect plugins/psiconv plugins/py-func plugins/python-loader plugins/qpro plugins/sample_datasource plugins/sc plugins/sylk plugins/uihello plugins/xbase po po-functions src/dialogs src/tools src/tools/solver src/tools/solver/glpk src/tools/solver/lp_solve src/widgets test tools

[jody svn gnome org]

Author: jody
Date: Sun Jan 18 17:03:12 2009
New Revision: 17075
URL: http://svn.gnome.org/viewvc/gnumeric?rev=17075&view=rev

Log:
2009-01-18  Jody Goldberg <jody gnome org>

	* Release 1.8.4


Modified:
   branches/gnumeric-1-8/ChangeLog
   branches/gnumeric-1-8/doc/C/ChangeLog
   branches/gnumeric-1-8/doc/C/func.defs
   branches/gnumeric-1-8/doc/ChangeLog
   branches/gnumeric-1-8/doc/de/ChangeLog
   branches/gnumeric-1-8/plugins/applix/ChangeLog
   branches/gnumeric-1-8/plugins/corba/ChangeLog
   branches/gnumeric-1-8/plugins/derivatives/ChangeLog
   branches/gnumeric-1-8/plugins/dif/ChangeLog
   branches/gnumeric-1-8/plugins/excel/ChangeLog
   branches/gnumeric-1-8/plugins/fn-complex/ChangeLog
   branches/gnumeric-1-8/plugins/fn-database/ChangeLog
   branches/gnumeric-1-8/plugins/fn-date/ChangeLog
   branches/gnumeric-1-8/plugins/fn-eng/ChangeLog
   branches/gnumeric-1-8/plugins/fn-erlang/ChangeLog
   branches/gnumeric-1-8/plugins/fn-financial/ChangeLog
   branches/gnumeric-1-8/plugins/fn-info/ChangeLog
   branches/gnumeric-1-8/plugins/fn-logical/ChangeLog
   branches/gnumeric-1-8/plugins/fn-lookup/ChangeLog
   branches/gnumeric-1-8/plugins/fn-math/ChangeLog
   branches/gnumeric-1-8/plugins/fn-r/ChangeLog
   branches/gnumeric-1-8/plugins/fn-random/ChangeLog
   branches/gnumeric-1-8/plugins/fn-stat/ChangeLog
   branches/gnumeric-1-8/plugins/fn-string/ChangeLog
   branches/gnumeric-1-8/plugins/fn-tsa/ChangeLog
   branches/gnumeric-1-8/plugins/gb/ChangeLog
   branches/gnumeric-1-8/plugins/gda/ChangeLog
   branches/gnumeric-1-8/plugins/gnome-db/ChangeLog
   branches/gnumeric-1-8/plugins/gnome-glossary/ChangeLog
   branches/gnumeric-1-8/plugins/guile/ChangeLog
   branches/gnumeric-1-8/plugins/html/ChangeLog
   branches/gnumeric-1-8/plugins/lotus-123/ChangeLog
   branches/gnumeric-1-8/plugins/mps/ChangeLog
   branches/gnumeric-1-8/plugins/numtheory/ChangeLog
   branches/gnumeric-1-8/plugins/numtheory/doc/ChangeLog
   branches/gnumeric-1-8/plugins/oleo/ChangeLog
   branches/gnumeric-1-8/plugins/openoffice/ChangeLog
   branches/gnumeric-1-8/plugins/paradox/ChangeLog
   branches/gnumeric-1-8/plugins/perl-loader/ChangeLog
   branches/gnumeric-1-8/plugins/plan-perfect/ChangeLog
   branches/gnumeric-1-8/plugins/psiconv/ChangeLog
   branches/gnumeric-1-8/plugins/py-func/ChangeLog
   branches/gnumeric-1-8/plugins/python-loader/ChangeLog
   branches/gnumeric-1-8/plugins/qpro/ChangeLog
   branches/gnumeric-1-8/plugins/sample_datasource/ChangeLog
   branches/gnumeric-1-8/plugins/sc/ChangeLog
   branches/gnumeric-1-8/plugins/sylk/ChangeLog
   branches/gnumeric-1-8/plugins/uihello/ChangeLog
   branches/gnumeric-1-8/plugins/xbase/ChangeLog
   branches/gnumeric-1-8/po-functions/ChangeLog
   branches/gnumeric-1-8/po/ChangeLog
   branches/gnumeric-1-8/src/dialogs/ChangeLog
   branches/gnumeric-1-8/src/tools/ChangeLog
   branches/gnumeric-1-8/src/tools/solver/ChangeLog
   branches/gnumeric-1-8/src/tools/solver/glpk/ChangeLog
   branches/gnumeric-1-8/src/tools/solver/lp_solve/ChangeLog
   branches/gnumeric-1-8/src/widgets/ChangeLog
   branches/gnumeric-1-8/test/ChangeLog
   branches/gnumeric-1-8/tools/ChangeLog

Modified: branches/gnumeric-1-8/doc/C/func.defs
==============================================================================
--- branches/gnumeric-1-8/doc/C/func.defs	(original)
+++ branches/gnumeric-1-8/doc/C/func.defs	Sun Jan 18 17:03:12 2009
@@ -1376,11 +1376,11 @@
 @SYNTAX=BESSELI(x,y)
 @DESCRIPTION=BESSELI function returns the Neumann, Weber or Bessel function.
 
- x is where the function is evaluated. @y is the order of the Bessel function, if non-integer it is truncated.
+ x is where the function is evaluated. @y is the order of the Bessel function.
 
 * If @x or @y are not numeric a #VALUE! error is returned.
 * If @y < 0 a #NUM! error is returned.
-* This function is Excel compatible.
+* This function extends the Excel function of the same name to non-integer orders.
 
 @EXAMPLES=
 BESSELI(0.7,3) equals 0.007367374.
@@ -1404,11 +1404,11 @@
 @CATEGORY=Engineering
 @FUNCTION=BESSELK
 @SYNTAX=BESSELK(x,y)
- DESCRIPTION=BESSELK function returns the Neumann, Weber or Bessel function. @x is where the function is evaluated. @y is the order of the Bessel function, if non-integer it is truncated.
+ DESCRIPTION=BESSELK function returns the Neumann, Weber or Bessel function. @x is where the function is evaluated. @y is the order of the Bessel function.
 
 * If @x or @y are not numeric a #VALUE! error is returned.
 * If @y < 0 a #NUM! error is returned.
-* This function is Excel compatible.
+* This function extends the Excel function of the same name to non-integer orders.
 
 @EXAMPLES=
 BESSELK(3,9) equals 397.95880.
@@ -1934,6 +1934,17 @@
 @SEEALSO=AMORDEGRC
 
 @CATEGORY=Finance
+ FUNCTION=atl_last
+ SYNTAX=ATL_LAST (tag)
+ DESCRIPTION=ATL_LAST is a sample implemention of a real time data source. It takes a string tag and monitors the named pipe /tmp/atl for changes to the value of that tag.
+
+* This is not intended to be generally enabled and is OFF by default.
+
+ EXAMPLES=
+ATL_LAST("IBM")
+ SEEALSO=
+
+ CATEGORY=Finance
 @FUNCTION=COUPDAYBS
 @SYNTAX=COUPDAYBS(settlement,maturity,frequency[,basis,eom])
 @DESCRIPTION=COUPDAYBS returns the number of days from the beginning of the coupon period to the settlement date.
@@ -3926,13 +3937,15 @@
 @CATEGORY=Lookup
 @FUNCTION=INDIRECT
 @SYNTAX=INDIRECT(ref_text[,format])
- DESCRIPTION=INDIRECT function returns the contents of the cell pointed to by the @ref_text string. The string specifies a single cell reference the format of which is either A1 or R1C1 style. The style is set by the @format boolean, which defaults to the A1 style.
+ DESCRIPTION=INDIRECT function returns the contents of the cell pointed to by the @ref_text string. The string specifies a single cell reference the format of which is either A1 or R1C1 style. The boolean @format controls how @ref_text is to be interpreted: TRUE (the default) for A1 style and FALSE for R1C1 style.
 
-* If @ref_text is not a valid reference returns #REF! 
+* If @ref_text is not a valid reference in the style controlled by @format, returns #REF! 
 @EXAMPLES=
-If A1 contains 3.14 and A2 contains A1, then
+If A1 contains 3.14 and A2 contains "A1", then
 INDIRECT(A2) equals 3.14.
 
+If B1 contains 23 and A1 contains "R1C2", then
+INDIRECT(A1,FALSE) equals 23.
 @SEEALSO=AREAS,INDEX,CELL
 
 @CATEGORY=Lookup
@@ -7233,10 +7246,11 @@
 
 @CATEGORY=Statistics
 @FUNCTION=ZTEST
- SYNTAX=ZTEST(ref,x)
+ SYNTAX=ZTEST(ref,x[,stddev])
 @DESCRIPTION=ZTEST returns the two-tailed probability of a z-test.
 
 @ref is the data set and @x is the value to be tested.
+ stddev is optionally an assumed standard deviation.
 
 * If @ref contains less than two data items ZTEST returns #DIV/0! error.
 * This function is Excel compatible.
@@ -7574,3 +7588,59 @@
 
 @SEEALSO=DOLLAR, FIXED, TEXT
 
+ CATEGORY=Time Series Analysis
+ FUNCTION=interpolation
+ SYNTAX=interpolation(abscissas,ordinates,targets[,interpolation])
+ DESCRIPTION= 
+interpolation returns interpolated values corresponding
+to the given abscissa targets as a one column matrix.
+
+ abscissas are the absicssas of the data to interpolate.
+ ordinates are the ordinates of the data to interpolate.
+* Strings and empty cells in @abscissas and @ordinates are simply ignored.
+ targets are the abscissas of the interpolated data. If several data
+are provided, they must be in the same column, in consecutive cells
+ interpolation is the method to be used for the interpolation;
+possible values are:
+- 0: linear;
+- 1: linear with averaging;
+- 2: staircase;
+- 3: staircase with averaging;
+- 4: natural cubic spline;
+- 5: natural cubic spline with averaging.
+
+If an averaging method is used, the number of returned values
+is one less than the number of targets since the evaluation is made by
+averaging the interpolation over the interval between two consecutive data;
+in that case, the targets values must be given in increasing order.
+
+ CATEGORY=Time Series Analysis
+ FUNCTION=periodogram
+ SYNTAX=periodogram(ordinates,[filter,[abscissas,[interpolation,[number]]]])
+ DESCRIPTION= 
+periodogram returns the periodogram of the data
+as a one column matrix.
+
+ ordinates are the ordinates of the data to interpolate.
+ filter gives the window function to  be used. Possible values are:
+- 0: no filter (rectangular window);
+- 1: Bartlett (triangular window);
+- 2: Hahn (cosine window);
+- 3: Welch (parabolic window);
+ abscissas are the absicssas of the data to interpolate. If no
+abscissa is given, it is supposed that the data absicssas are regularly
+spaced. Otherwise, an interpolation method will be used to evaluate
+regularly spaced data.
+* Strings and empty cells in @abscissas and @ordinates are simply ignored.
+ interpolation is the method to be used for the interpolation;
+possible values are:
+- 0: linear;
+- 1: linear with averaging;
+- 2: staircase;
+- 3: staircase with averaging;
+- 4: natural cubic spline;
+- 5: natural cubic spline with averaging.
+ number is the number of interpolated data to be used. If not given,
+a default number is automatically evaluated.
+
+