[gnomeweb-wml] Update of Gnumeric documentation



commit 278fb133b9ac703c91829809095f5e7e48dabac6
Author: Andreas J Guelzow <aguelzow pyrshep ca>
Date:   Wed Nov 30 23:40:05 2011 -0700

    Update of Gnumeric documentation

 .../gnumeric/doc/sect-data-errors.shtml            |   56 +++++++++++++++++++-
 1 files changed, 55 insertions(+), 1 deletions(-)
---
diff --git a/projects.gnome.org/gnumeric/doc/sect-data-errors.shtml b/projects.gnome.org/gnumeric/doc/sect-data-errors.shtml
index 26a7723..bb9f43d 100644
--- a/projects.gnome.org/gnumeric/doc/sect-data-errors.shtml
+++ b/projects.gnome.org/gnumeric/doc/sect-data-errors.shtml
@@ -76,8 +76,62 @@
 </ul>
 <p class="para block block-first">
     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. 
   </p>
+<p class="para block">
+    In <span class="application">Gnumeric</span> all error values have names that start with <span class="code" dir="ltr">#</span>. 
+    8 error values are standardized:
+  </p>
+<div class="table block block-indent">
+<div class="block block-first title title-formal"><span class="title"><span class="label"><span style="font-style: italic; ">Table 5-1</span>â</span>The standard error values of <span class="application">Gnumeric</span></span></div>
+<table summary="The standard error values of Gnumeric" style="border: solid 1px;">
+<thead><tr>
+<th style="text-align: left;" class="td-colsep">Name</th>
+<th style="text-align: center;">Normal Use</th>
+</tr></thead>
+<tbody>
+<tr>
+<td style="text-align: left;" class="td-colsep td-rowsep"><span class="code" dir="ltr">#DIV/0!</span></td>
+<td style="text-align: left;" class="td-rowsep">Division by zero occurred.</td>
+</tr>
+<tr class="tr-shade">
+<td style="text-align: left;" class="td-colsep td-rowsep"><span class="code" dir="ltr">#N/A</span></td>
+<td style="text-align: left;" class="td-rowsep">Not applicable. This is the result of the 
+  <span class="code" dir="ltr">=NA()</span> formula.
+  </td>
+</tr>
+<tr>
+<td style="text-align: left;" class="td-colsep td-rowsep"><span class="code" dir="ltr">#NAME?</span></td>
+<td style="text-align: left;" class="td-rowsep">An unknown function name or other name was encountered.</td>
+</tr>
+<tr class="tr-shade">
+<td style="text-align: left;" class="td-colsep td-rowsep"><span class="code" dir="ltr">#NULL!</span></td>
+<td style="text-align: left;" class="td-rowsep">The result of specifying an intersecting range that in fact does
+  <span class="emphasis">not</span> intersect.</td>
+</tr>
+<tr>
+<td style="text-align: left;" class="td-colsep td-rowsep"><span class="code" dir="ltr">#NUM!</span></td>
+<td style="text-align: left;" class="td-rowsep">A formula could not be evaluated because an invalid number was 
+  used as argument, for example <span class="code" dir="ltr">=SQRT(-1)</span>
+</td>
+</tr>
+<tr class="tr-shade">
+<td style="text-align: left;" class="td-colsep td-rowsep"><span class="code" dir="ltr">#REF!</span></td>
+<td style="text-align: left;" class="td-rowsep">An invalid cell adress or reference was encountered.</td>
+</tr>
+<tr>
+<td style="text-align: left;" class="td-colsep td-rowsep"><span class="code" dir="ltr">#UNKNOWN!</span></td>
+<td style="text-align: left;" class="td-rowsep">Usually the result of importing an unrecognized error from a
+  different file format.</td>
+</tr>
+<tr class="tr-shade">
+<td style="text-align: left;" class="td-colsep"><span class="code" dir="ltr">#VALUE!</span></td>
+<td style="text-align: left;">A formula could not be evaluated because the wrong type of argument
+  was used.</td>
+</tr>
+</tbody>
+</table>
+</div>
 </div></div>
 <div class="navbar navbar-bottom"><table class="navbar"><tr>
 <td class="navbar-prev"><a class="navbar-prev" href="sect-data-formulas.shtml" title="Formula Elements">Formula Elements</a></td>



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