[gnomeweb-wml] Update of Gnumeric documentation
- From: Andreas J. Guelzow <guelzow src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [gnomeweb-wml] Update of Gnumeric documentation
- Date: Thu, 1 Dec 2011 06:40:43 +0000 (UTC)
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]