[gnumeric] update to Gnumeric docs



commit d21e83f57164024999a99709a2b81ced624f6db9
Author: Andreas J Guelzow <aguelzow pyrshep ca>
Date:   Wed Nov 30 23:41:20 2011 -0700

    update to Gnumeric docs
    
    2011-11-30  Andreas J. Guelzow <aguelzow pyrshep ca>
    
    	* data-types.xml: update

 doc/C/ChangeLog      |    6 ++++-
 doc/C/data-types.xml |   61 ++++++++++++++++++++++++++++++++++++++++++++++++-
 2 files changed, 64 insertions(+), 3 deletions(-)
---
diff --git a/doc/C/ChangeLog b/doc/C/ChangeLog
index 485c306..f2347ba 100644
--- a/doc/C/ChangeLog
+++ b/doc/C/ChangeLog
@@ -1,6 +1,10 @@
 2011-11-30  Andreas J. Guelzow <aguelzow pyrshep ca>
 
-	* doc/C/files-formats.xml: update
+	* data-types.xml: update
+
+2011-11-30  Andreas J. Guelzow <aguelzow pyrshep ca>
+
+	* files-formats.xml: update
 	* func.defs: update
 	* functions.xml: update
 
diff --git a/doc/C/data-types.xml b/doc/C/data-types.xml
index 345c615..652c07e 100644
--- a/doc/C/data-types.xml
+++ b/doc/C/data-types.xml
@@ -849,9 +849,66 @@ FUNCTIONNAME(ARGUMENTS)
   
   <para>
     Cells can display error values if the formula contained in the
-    cell cannot be solved or if other anomalous conditions occur.
+    cell cannot be solved or if other anomalous conditions occur. 
   </para>
-
+  <para>
+    In &gnum; all error values have names that start with <code>#</code>. 
+    8 error values are standardized:
+  </para>
+<!--    TABLE    TABLE    TABLE    TABLE    TABLE    TABLE    -->
+<table frame='all'><title>The standard error values of &gnum;</title>
+<tgroup cols='2' align='left' colsep='1' rowsep='1'>
+<colspec colnum="1" colname="col1" colwidth="1*"/>
+<colspec colnum="2" colname="col2" colwidth="3*"/>
+<thead>
+<row>
+  <entry align="left">Name</entry>
+  <entry align="center">Normal Use</entry>
+</row>
+</thead>
+<tbody>
+<row>
+  <entry><code>#DIV/0!</code></entry>
+  <entry>Division by zero occurred.</entry> 
+</row>
+<row>
+  <entry><code>#N/A</code></entry>
+  <entry>Not applicable. This is the result of the 
+  <code>=NA()</code> formula.
+  </entry> 
+</row>
+<row>
+  <entry><code>#NAME?</code></entry>
+  <entry>An unknown function name or other name was encountered.</entry> 
+</row>
+<row>
+  <entry><code>#NULL!</code></entry>
+  <entry>The result of specifying an intersecting range that in fact does
+  <emphasis>not</emphasis> intersect.</entry> 
+</row>
+<row>
+  <entry><code>#NUM!</code></entry>
+  <entry>A formula could not be evaluated because an invalid number was 
+  used as argument, for example <code>=SQRT(-1)</code></entry> 
+</row>
+<row>
+  <entry><code>#REF!</code></entry>
+  <entry>An invalid cell adress or reference was encountered.</entry> 
+</row>
+<row>
+  <entry><code>#UNKNOWN!</code></entry>
+  <entry>Usually the result of importing an unrecognized error from a
+  different file format.</entry> 
+</row>
+<row>
+  <entry><code>#VALUE!</code></entry>
+  <entry>A formula could not be evaluated because the wrong type of argument
+  was used.</entry> 
+</row>
+</tbody>
+</tgroup>
+</table>
+<!--    TABLE    TABLE    TABLE    TABLE    TABLE    TABLE    -->
 
 </sect2>
 



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