Calc Guide

General error codes
The following table is an overview of the most common error messages for OOo Calc.
Note
Errors described as Internal errors should not be encountered by users
under normal conditions. Errors listed as Not used are not currently
assigned to any error condition and will not occur.
Code Message Explanation of the error
501 Invalid character Character in a formula is not valid. This error is the
same as the Invalid Name error (525) except that it
occurs within a formula. The cell containing the
error will display the #NAME? error reference.
502 Invalid argument Function argument is not valid; for example, a
negative number for the root function. This error
also occurs if more than one matching cell is found
by the DGET function.
503 Invalid floating
point operation
(cell displays
#NUM!)
Division by 0, or another calculation that results in
an overflow of the defined value range (a value too
big or too small).
504 Parameter list
error
Function parameter is not valid; for example, text
instead of a number, or a domain reference instead
of a cell reference.
505 Internal syntax
error
Not used.
506 Invalid semicolon Not used.
507 Pair missing Not used.
508 Pair missing Missing bracket or parenthesis; for example, closing
brackets but no opening brackets.
509 Missing operator Operator is missing; for example,
"=2(3+4) * ", where the operator between "2" and
"(" is missing.
510 Missing variable Variable is missing; for example, when two
operators are together "=1+*2".
511 Missing variable Function requires more variables than are provided;
for example, AND() and OR().
512 Formula overflow The total number of internal tokens (that is,
operators, variables, brackets) in the formula
exceeds 512, or the total number of matrices the
formula creates exceeds 150. This includes basic
functions that receive too large an array as a
parameter.
424 OpenOffice.org 3.3 Calc Guide