content/documentation/faqs/spreadsheet/015.html

<meta http-equiv="REFRESH" content="10;url=http://wiki.services.openoffice.org/wiki/Documentation/FAQ">
<h3>This page is outdated. You will be redirected to <a href="http://wiki.services.openoffice.org/wiki/Documentation/FAQ">http://wiki.services.openoffice.org
/wiki/Documentation/FAQ</a> shortly.</h3>
<div style="margin-bottom: 10em;"></div>
<p><a href="../../index.html">Documentation</a> / <a
 href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
 href="014.html" accesskey="p">Previous</a>-<a href="016.html"
 accesskey="n">Next</a></p>
<h3>What do each of the error codes (Err:NNN) in
OpenOffice.org spreadsheets mean?</h3>
<table border="2" cellpadding="2" cellspacing="2">
  <tbody>
    <tr>
      <th> Error Code </th>
      <th> Cleartext </th>
      <th> Explanation </th>
    </tr>
    <tr>
      <td> 501 </td>
      <td> Invalid character </td>
      <td> The error is a character that is invalid in this context,
e.g.
=1Eq instead of =1E2. </td>
    </tr>
    <tr>
      <td> 502 </td>
      <td> Invalid argument </td>
      <td> A function argument has an invalid value, e.g. a negative
number for the root function. </td>
    </tr>
    <tr>
      <td> 503 </td>
      <td> Invalid floating point operation </td>
      <td> Division by 0 or other calculation that would result in an
overflow of the defined value range.</td>
    </tr>
    <tr>
      <td> 504 </td>
      <td> Parmeter list error </td>
      <td> A function parameter is an invalid type, e.g. text instead
of number, or domain reference instead of cell reference. </td>
    </tr>
    <tr>
      <td> 505 </td>
      <td> Internal syntax error </td>
      <td> <br/>
      </td>
    </tr>
    <tr>
      <td> 506 </td>
      <td> Invalid semicolon </td>
      <td> <br/>
      </td>
    </tr>
    <tr>
      <td> 507 </td>
      <td> Error: Pair missing </td>
      <td> <br/>
      </td>
    </tr>
    <tr>
      <td> 508 </td>
      <td> Error: Pair missing </td>
      <td> For example, closing parenthesis without opening parenthesis
or missing closing parenthesis in the middle of the formula (missing
closing parenthesis at the end of a formula is added automatically). </td>
    </tr>
    <tr>
      <td> 509 </td>
      <td>Missing operator </td>
      <td> E.g. =2(3+4) * operator missing between the 2 and the (. </td>
    </tr>
    <tr>
      <td> 510 </td>
      <td> Missing variable </td>
      <td> Two operators in a row, e.g. =1+*2. </td>
    </tr>
    <tr>
      <td> 511 </td>
      <td> Missing variable </td>
      <td> The function requires more variables than are provided, e.g.
AND() and OR() without parameter. </td>
    </tr>
    <tr>
      <td> 512 </td>
      <td>Formula overflow </td>
      <td> Compiler: as the name indicates, the internal number of
tokens
that has nothing to do with the formula string length is indicated
(max. 512) rather than the number of operators, variables, parentheses,
etc. Interpreter: Formulas that create several matrices at once (max.
150), including basic functions that would receive too large an array
as a parameter (max. 0xFFFE, i.e. 65534 bytes). </td>
    </tr>
    <tr>
      <td> 513 </td>
      <td> String overflow </td>
      <td> Compiler: an identifier in the formula exceeds 255
characters.
Interpreter: a result of a string operation exceeds 255 characters. </td>
    </tr>
    <tr>
      <td> 514 </td>
      <td> Internal overflow </td>
      <td> Sort operations with too much numerical data (max. 100000)
or calculation stack overflow. </td>
    </tr>
    <tr>
      <td> 515 </td>
      <td>Internal syntax error </td>
      <td> <br/>
      </td>
    </tr>
    <tr>
      <td> 516 </td>
      <td> Internal syntax error </td>
      <td> A matrix is expected on the calculation stack but is not
available. </td>
    </tr>
    <tr>
      <td> 517 </td>
      <td> Internal syntax error </td>
      <td> Unknown OpCode, e.g. a document with a newer function is
loaded in an older version that does not contain the function. </td>
    </tr>
    <tr>
      <td>518 </td>
      <td> Internal syntax error </td>
      <td> A variable was supposed to be popped from the calculation
stack but is not available. </td>
    </tr>
    <tr>
      <td> 519 </td>
      <td> No result (#VALUE is in the cell rather than Err:519!) </td>
      <td> A function could not deliver a value that corresponds to the
definition or a cell referenced in the formula contains text rather
than a number. </td>
    </tr>
    <tr>
      <td> 520 </td>
      <td> Internal syntax error </td>
      <td> The compiler created an unknown compiler code. </td>
    </tr>
    <tr>
      <td>521 </td>
      <td> Internal syntax error </td>
      <td> No result on the calculation stack. </td>
    </tr>
    <tr>
      <td> 522 </td>
      <td> Circular reference </td>
      <td> A formula refers directly or indirectly to itself and the
iterations are not activated under Tools/Options/Table
Document/Calculate. </td>
    </tr>
    <tr>
      <td> 523 </td>
      <td> The calculation procedure does not converge </td>
      <td> Some financial statistics functions miss a targeted value or
iterations of circular references do not reach the minimum change
within the maximum steps set. </td>
    </tr>
    <tr>
      <td>524 </td>
      <td> Invalid reference (#REF is in the cell rather than Err:524) </td>
      <td> Compiler: a column/row description name could not be
resolved.
Interpreter: in the formula, a cell is referenced whose column, row or
table was deleted. </td>
    </tr>
    <tr>
      <td>525 </td>
      <td> Invalid name (#NAME is in the cell rather than Err:525) </td>
      <td> Compiler; An identifier could not be resolved (no reference,
no domain name, no column/row description, no macro, etc.) Interpreter:
same as runtime, e.g. basic function or AddIn, not found </td>
    </tr>
    <tr>
      <td>526 </td>
      <td>Internal syntax error </td>
      <td> Obsolete, no longer used, but could come from old documents
if the result was a formula from a domain. </td>
    </tr>
    <tr>
      <td>527 </td>
      <td>Internal overflow </td>
      <td> Interpreter: references too encapsulated (cell references
cell, the cell references, the cell references,...) </td>
    </tr>
  </tbody>
</table>
<p><b>Note:</b> a '###' in a cell is not an error, but an indication
that the
column is too narrow to display the data properly. For more information
read <a href="002.html">I
see '###' in a cell that formerly held data. How can
I see my data again?</a></p>
<p><b>Hint: </b>The error code definitions live in the Help files.</p>
<ol>
  <li>In an OpenOffice.org window, go to the <b>Help</b> drop-down
menu, then select <b>Contents</b>.</li>
  <li>Select the <b>Index</b> tab by clicking on it.</li>
  <li>In the <b>Search</b> input box, type <b>error codes</b>. An
index list will pop up, with "error codes" in it.</li>
  <li>Under the error codes section in the index list, double-click on <b>OpenOffice.org
Calc</b>. This brings up the page of calc error codes.</li>
</ol>
<p><a href="../../index.html">Documentation</a> / <a
 href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
 href="014.html" accesskey="p">Previous</a>-<a href="016.html"
 accesskey="n">Next</a></p>