Calc Guide

Code Message Explanation of the error
513 String overflow An identifier in the formula exceeds 64 KB in size, or
a result of a string operation exceeds 64 KB in size.
514 Internal overflow Sort operation attempted on too much numerical
data (max. 100000) or a calculation stack overflow.
515 Internal syntax
error
Not used.
516 Internal syntax
error
Matrix is expected on the calculation stack, but is
not available.
517 Internal syntax
error
Unknown error; for example, a document with a
newer function is loaded in an older version of Calc
that does not contain the function.
518 Internal syntax
error
Variable is not available.
519 No result (cell
displays #VALUE)
Formula yields a value that does not correspond to
the definition, or a cell that is referenced in the
formula contains text instead of a number.
520 Internal syntax
error
Compiler creates an unknown compiler code.
521 Internal syntax
error
No result.
522 Circular reference Formula refers directly or indirectly to itself and the
Iterations option is not selected under Tools >
Options > OpenOffice.org Calc > Calculate.
523 The calculation
procedure does
not converge
Financial statistics function missed a targeted value,
or iterations of circular references do not reach the
minimum change within the maximum steps that are
set.
524 Invalid references
(cell displays
#REF!)
A column or row description name could not be
resolved, or the column, row, or sheet that contains
a referenced cell is missing.
525 Invalid names (cell
displays
#NAME?)
An identifier could not be evaluated; for example, no
valid reference, no valid domain name, no
column/row label, no macro, incorrect decimal
divider, add-in not found.
526 Internal syntax
error
Obsolete, no longer used, but could come from old
documents if the result is a formula from a domain.
527 Internal overflow References, such as when a cell references a cell,
are too encapsulated or deeply nested. This is an
internal error and should not be displayed in OOo
version 2.0 or greater.
Appendix C Calc Error Codes 425