gnumeric r16761 - in trunk: . 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

From: jody svn gnome org
To: svn-commits-list gnome org
Subject: gnumeric r16761 - in trunk: . 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
Date: Sat, 30 Aug 2008 13:38:05 +0000 (UTC)

Author: jody
Date: Sat Aug 30 13:38:05 2008
New Revision: 16761
URL: http://svn.gnome.org/viewvc/gnumeric?rev=16761&view=rev

Log:
2008-08-29  Jody Goldberg <jody gnome org>

	* Release 1.9.2


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/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	Sat Aug 30 13:38:05 2008
@@ -1007,16 +1007,6 @@
 @SEEALSO=DVAR
 
 @CATEGORY=Database
- FUNCTION=EXECSQL
- SYNTAX=EXECSQL(dsn,username,password,sql)
- DESCRIPTION=The EXECSQL function lets you execute a command in a database server, and show the results returned in current sheet. It uses libgda as the means for accessing the databases.
-For using it, you need first to set up a libgda data source.
- EXAMPLES=
-To get all the data from the table "Customers" present in the "mydatasource" GDA data source, you would use:
-EXECSQL("mydatasource","username","password","SELECT * FROM customers")
- SEEALSO=READDBTABLE
-
- CATEGORY=Database
 @FUNCTION=GETPIVOTDATA
 @SYNTAX=GETPIVOTDATA(pivot_table,field_name)
 @DESCRIPTION=GETPIVOTDATA function fetches summary data from a pivot table. @pivot_table is a cell range containing the pivot table. @field_name is the name of the field of which you want the summary data.
@@ -1027,16 +1017,6 @@
 
 @SEEALSO=
 
- CATEGORY=Database
- FUNCTION=READDBTABLE
- SYNTAX=READDBTABLE(dsn,username,password,table)
- DESCRIPTION=The READDBTABLE function lets you get the contents of a table, as stored in a database. For using it, you need first to set up a libgda data source.
-Note that this function returns all the rows in the given table. If you want to get data from more than one table or want a more precise selection (conditions), use the EXECSQL function.
- EXAMPLES=
-To get all the data from the table "Customers" present in the "mydatasource" GDA data source, you would use:
-READDBTABLE("mydatasource","username","password","customers")
- SEEALSO=EXECSQL
-
 @CATEGORY=Date/Time
 @FUNCTION=DATE
 @SYNTAX=DATE (year,month,day)
@@ -3030,15 +3010,14 @@
 
 @CATEGORY=Finance
 @FUNCTION=OPT_RGW
- SYNTAX=OPT_RGW(call_put_flag,spot,strike,t1,t2,rate,d,volatility)
+ SYNTAX=OPT_RGW(spot,strike,t1,t2,rate,d,volatility)
 @DESCRIPTION=OPT_RGW models the theoretical price of an american option according to the Roll-Geske-Whaley approximation where: 
- call_put_flag is 'c' or 'p' to indicate whether the option is a call or a put.
 @spot is the spot price of the underlying asset.
 @strike is the strike price at which the option is struck.
 @t1 is the time to the dividend payout.
 @t2 is the time to option expiration.
 @rate is the annualized rate of interest.
- d is the amount of the dividend to be paid.
+ d is the amount of the dividend to be paid expressed in currency.
 @volatility is the annualized rate of volatility of the underlying asset.
 
 @EXAMPLES=
@@ -3956,13 +3935,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

Modified: trunk/doc/C/functions.xml
==============================================================================
--- trunk/doc/C/functions.xml	(original)
+++ trunk/doc/C/functions.xml	Sat Aug 30 13:38:05 2008
@@ -2337,38 +2337,6 @@
       </para>
       </refsect1>
     </refentry>
-    <refentry id="gnumeric-EXECSQL">
-      <refmeta>
-        <refentrytitle>
-          <function>EXECSQL</function>
-        </refentrytitle>
-      </refmeta>
-      <refnamediv>
-        <refname>
-          <function>EXECSQL</function>
-        </refname>
-        <refpurpose/>
-      </refnamediv>
-      <refsynopsisdiv>
-        <synopsis><function>EXECSQL</function>(<parameter>dsn</parameter>,<parameter>username</parameter>,<parameter>password</parameter>,<parameter>sql</parameter>)</synopsis>
-      </refsynopsisdiv>
-      <refsect1>
-        <title>Description</title>
-        <para>The <function>EXECSQL</function> function lets you execute a command in a database server, and show the results returned in current sheet. It uses libgda as the means for accessing the databases.</para>
-        <para>For using it, you need first to set up a libgda data source.</para>
-      </refsect1>
-      <refsect1>
-        <title>Examples</title>
-        <para/>
-        <para>To get all the data from the table "Customers" present in the "mydatasource" GDA data source, you would use:</para>
-        <para><function>EXECSQL</function>("mydatasource","username","password","SELECT * FROM customers")</para>
-      </refsect1>
-      <refsect1>
-        <title>See also</title>
-        <para><link linkend="gnumeric-READDBTABLE"><function>READDBTABLE</function></link>.
-      </para>
-      </refsect1>
-    </refentry>
     <refentry id="gnumeric-GETPIVOTDATA">
       <refmeta>
         <refentrytitle>
@@ -2403,38 +2371,6 @@
       </para>
       </refsect1>
     </refentry>
-    <refentry id="gnumeric-READDBTABLE">
-      <refmeta>
-        <refentrytitle>
-          <function>READDBTABLE</function>
-        </refentrytitle>
-      </refmeta>
-      <refnamediv>
-        <refname>
-          <function>READDBTABLE</function>
-        </refname>
-        <refpurpose/>
-      </refnamediv>
-      <refsynopsisdiv>
-        <synopsis><function>READDBTABLE</function>(<parameter>dsn</parameter>,<parameter>username</parameter>,<parameter>password</parameter>,<parameter>table</parameter>)</synopsis>
-      </refsynopsisdiv>
-      <refsect1>
-        <title>Description</title>
-        <para>The <function>READDBTABLE</function> function lets you get the contents of a table, as stored in a database. For using it, you need first to set up a libgda data source.</para>
-        <para>Note that this function returns all the rows in the given table. If you want to get data from more than one table or want a more precise selection (conditions), use the EXECSQL function.</para>
-      </refsect1>
-      <refsect1>
-        <title>Examples</title>
-        <para/>
-        <para>To get all the data from the table "Customers" present in the "mydatasource" GDA data source, you would use:</para>
-        <para><function>READDBTABLE</function>("mydatasource","username","password","customers")</para>
-      </refsect1>
-      <refsect1>
-        <title>See also</title>
-        <para><link linkend="gnumeric-EXECSQL"><function>EXECSQL</function></link>.
-      </para>
-      </refsect1>
-    </refentry>
   </sect1>
   <sect1 id="CATEGORY_DateTime">
     <title>Date/Time</title>
@@ -7358,18 +7294,17 @@
         <refpurpose/>
       </refnamediv>
       <refsynopsisdiv>
-        <synopsis><function>OPT_RGW</function>(<parameter>call_put_flag</parameter>,<parameter>spot</parameter>,<parameter>strike</parameter>,<parameter>t1</parameter>,<parameter>t2</parameter>,<parameter>rate</parameter>,<parameter>d</parameter>,<parameter>volatility</parameter>)</synopsis>
+        <synopsis><function>OPT_RGW</function>(<parameter>spot</parameter>,<parameter>strike</parameter>,<parameter>t1</parameter>,<parameter>t2</parameter>,<parameter>rate</parameter>,<parameter>d</parameter>,<parameter>volatility</parameter>)</synopsis>
       </refsynopsisdiv>
       <refsect1>
         <title>Description</title>
         <para><function>OPT_RGW</function> models the theoretical price of an american option according to the Roll-Geske-Whaley approximation where:</para>
-        <para><parameter>call_put_flag</parameter> is 'c' or 'p' to indicate whether the option is a call or a put.</para>
         <para><parameter>spot</parameter> is the spot price of the underlying asset.</para>
         <para><parameter>strike</parameter> is the strike price at which the option is struck.</para>
         <para><parameter>t1</parameter> is the time to the dividend payout.</para>
         <para><parameter>t2</parameter> is the time to option expiration.</para>
         <para><parameter>rate</parameter> is the annualized rate of interest.</para>
-        <para><parameter>d</parameter> is the amount of the dividend to be paid.</para>
+        <para><parameter>d</parameter> is the amount of the dividend to be paid expressed in currency.</para>
         <para><parameter>volatility</parameter> is the annualized rate of volatility of the underlying asset.</para>
       </refsect1>
       <refsect1>
@@ -9806,18 +9741,20 @@
       </refsynopsisdiv>
       <refsect1>
         <title>Description</title>
-        <para><function>INDIRECT</function> function returns the contents of the cell pointed to by the <parameter>ref_text</parameter> string. The string specifies a single cell reference the format of which is either A1 or R1C1 style. The style is set by the <parameter>format</parameter> boolean, which defaults to the A1 style.</para>
+        <para><function>INDIRECT</function> function returns the contents of the cell pointed to by the <parameter>ref_text</parameter> string. The string specifies a single cell reference the format of which is either A1 or R1C1 style. The boolean <parameter>format</parameter> controls how <parameter>ref_text</parameter> is to be interpreted: TRUE (the default) for A1 style and FALSE for R1C1 style.</para>
         <itemizedlist>
           <listitem>
-            <para>If <parameter>ref_text</parameter> is not a valid reference returns #REF!</para>
+            <para>If <parameter>ref_text</parameter> is not a valid reference in the style controlled by <parameter>format</parameter>, returns #REF!</para>
           </listitem>
         </itemizedlist>
       </refsect1>
       <refsect1>
         <title>Examples</title>
         <para/>
-        <para>If A1 contains 3.14 and A2 contains A1, then</para>
+        <para>If A1 contains 3.14 and A2 contains "A1", then</para>
         <para><function>INDIRECT</function>(A2) equals 3.14.</para>
+        <para>If B1 contains 23 and A1 contains "R1C2", then</para>
+        <para><function>INDIRECT</function>(A1,FALSE) equals 23.</para>
       </refsect1>
       <refsect1>
         <title>See also</title>

[Date Prev][Date Next] [Thread Prev][Thread Next] [Thread Index] [Date Index] [Author Index]