gnumeric r16666 - in trunk: . doc doc/C doc/de icons 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: Wed Jun 25 11:18:21 2008
New Revision: 16666
URL: http://svn.gnome.org/viewvc/gnumeric?rev=16666&view=rev

Log:
* Release 1.9.1


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

Modified: trunk/doc/C/func.defs
==============================================================================
--- trunk/doc/C/func.defs	(original)
+++ trunk/doc/C/func.defs	Wed Jun 25 11:18:21 2008
@@ -1396,11 +1396,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.
@@ -1424,11 +1424,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.
@@ -3515,6 +3515,16 @@
 @SEEALSO=TEXT
 
 @CATEGORY=Information
+ FUNCTION=GET FORMULA
+ SYNTAX=GET FORMULA(cell)
+ DESCRIPTION=EXPRESSION returns expression in @cell as a string, or empty if the cell is not an expression.
+ EXAMPLES=
+entering '=GET.FORMULA(A3)' in A2 = empty (assuming there is nothing in A3).
+entering '=GET.FORMULA(A2)' in A1 = '=GET.FORMULA(A3)'.
+
+ SEEALSO=EXPRESSION
+
+ CATEGORY=Information
 @FUNCTION=GETENV
 @SYNTAX=GETENV(string)
 @DESCRIPTION=GETENV retrieves a value from the execution environment.
@@ -7253,10 +7263,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.

Modified: trunk/doc/C/functions.xml
==============================================================================
--- trunk/doc/C/functions.xml	(original)
+++ trunk/doc/C/functions.xml	Wed Jun 25 11:18:21 2008
@@ -3469,7 +3469,7 @@
       <refsect1>
         <title>Description</title>
         <para><function>BESSELI</function> function returns the Neumann, Weber or Bessel function.</para>
-        <para><parameter>x</parameter> is where the function is evaluated. <parameter>y</parameter> is the order of the Bessel function, if non-integer it is truncated.</para>
+        <para><parameter>x</parameter> is where the function is evaluated. <parameter>y</parameter> is the order of the Bessel function.</para>
         <itemizedlist>
           <listitem>
             <para>If <parameter>x</parameter> or <parameter>y</parameter> are not numeric a #VALUE! error is returned.</para>
@@ -3478,7 +3478,7 @@
             <para>If <parameter>y</parameter> &lt; 0 a #NUM! error is returned.</para>
           </listitem>
           <listitem>
-            <para>This function is Excel compatible.</para>
+            <para>This function extends the Excel function of the same name to non-integer orders.</para>
           </listitem>
         </itemizedlist>
       </refsect1>
@@ -3555,7 +3555,7 @@
       </refsynopsisdiv>
       <refsect1>
         <title>Description</title>
-        <para><function>BESSELK</function> function returns the Neumann, Weber or Bessel function. <parameter>x</parameter> is where the function is evaluated. <parameter>y</parameter> is the order of the Bessel function, if non-integer it is truncated.</para>
+        <para><function>BESSELK</function> function returns the Neumann, Weber or Bessel function. <parameter>x</parameter> is where the function is evaluated. <parameter>y</parameter> is the order of the Bessel function.</para>
         <itemizedlist>
           <listitem>
             <para>If <parameter>x</parameter> or <parameter>y</parameter> are not numeric a #VALUE! error is returned.</para>
@@ -3564,7 +3564,7 @@
             <para>If <parameter>y</parameter> &lt; 0 a #NUM! error is returned.</para>
           </listitem>
           <listitem>
-            <para>This function is Excel compatible.</para>
+            <para>This function extends the Excel function of the same name to non-integer orders.</para>
           </listitem>
         </itemizedlist>
       </refsect1>
@@ -8540,6 +8540,37 @@
       </para>
       </refsect1>
     </refentry>
+    <refentry id="gnumeric-GET.FORMULA">
+      <refmeta>
+        <refentrytitle>
+          <function>GET.FORMULA</function>
+        </refentrytitle>
+      </refmeta>
+      <refnamediv>
+        <refname>
+          <function>GET.FORMULA</function>
+        </refname>
+        <refpurpose/>
+      </refnamediv>
+      <refsynopsisdiv>
+        <synopsis><function>GET.FORMULA</function>(<parameter>cell</parameter>)</synopsis>
+      </refsynopsisdiv>
+      <refsect1>
+        <title>Description</title>
+        <para>EXPRESSION returns expression in <parameter>cell</parameter> as a string, or empty if the cell is not an expression.</para>
+      </refsect1>
+      <refsect1>
+        <title>Examples</title>
+        <para/>
+        <para>entering '=<function>GET.FORMULA</function>(A3)' in A2 = empty (assuming there is nothing in A3).</para>
+        <para>entering '=<function>GET.FORMULA</function>(A2)' in A1 = '=<function>GET.FORMULA</function>(A3)'.</para>
+      </refsect1>
+      <refsect1>
+        <title>See also</title>
+        <para><link linkend="gnumeric-EXPRESSION"><function>EXPRESSION</function></link>.
+      </para>
+      </refsect1>
+    </refentry>
     <refentry id="gnumeric-GETENV">
       <refmeta>
         <refentrytitle>
@@ -19324,12 +19355,13 @@
         <refpurpose/>
       </refnamediv>
       <refsynopsisdiv>
-        <synopsis><function>ZTEST</function>(<parameter>ref</parameter>,<parameter>x</parameter>)</synopsis>
+        <synopsis><function>ZTEST</function>(<parameter>ref</parameter>,<parameter>x</parameter>[,<parameter>stddev</parameter>])</synopsis>
       </refsynopsisdiv>
       <refsect1>
         <title>Description</title>
         <para><function>ZTEST</function> returns the two-tailed probability of a z-test.</para>
         <para><parameter>ref</parameter> is the data set and <parameter>x</parameter> is the value to be tested.</para>
+        <para><parameter>stddev</parameter> is optionally an assumed standard deviation.</para>
         <itemizedlist>
           <listitem>
             <para>If <parameter>ref</parameter> contains less than two data items <function>ZTEST</function> returns #DIV/0! error.</para>

Modified: trunk/icons/Makefile.am
==============================================================================
--- trunk/icons/Makefile.am	(original)
+++ trunk/icons/Makefile.am	Wed Jun 25 11:18:21 2008
@@ -19,6 +19,8 @@
 	gnumeric-about.png	\
 	stf-druid.png
 
+EXTRA_DIST = $(icons_DATA) $(mimeicon_DATA)
+
 gtk_update_icon_cache = gtk-update-icon-cache -f -t $(datadir)/icons/hicolor
 
 install-data-hook: update-icon-cache