[gnumeric] update to Gnumeric docs
- From: Andreas J. Guelzow <guelzow src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [gnumeric] update to Gnumeric docs
- Date: Thu, 1 Dec 2011 06:41:57 +0000 (UTC)
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]