IBM Support

Common error codes in Lotus Spreadsheets

Technote (FAQ)


Question

You encounter error codes while working within Lotus Spreadsheets. Where can one find out what these error codes signify?

Answer

This following table is an overview of the error messages for Lotus Spreadsheets. If the error occurs in the cell that contains the cursor, the error message is displayed on the Status Bar.


Error Code

Message

Explanation

501

Invalid character

Character in a formula is not valid, for example, "=1Eq" instead of "=1E2".

502

Invalid argument

Function argument is not valid, for example, a negative number for the root function.

503

Invalid floating point operation

Division by 0, or another calculation that results in an overflow of the defined value range.

504

Parameter list error

Function parameter is not valid, for example, text instead of a number, or a domain reference instead of cell reference.

505

Internal syntax error

Not used

506

Invalid semicolon

Not used

507

Error: Pair missing

Not used

508

Error: Pair missing

Missing bracket, 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

Compiler: the total number of internal tokens, (that is, operators, variables, brackets) in the formula exceeds 512. Interpreter: the total number of matrices that the formula creates exceeds 150. This includes basic functions that receive too large an array as a parameter (max. 0xFFFE, for example, 65534 bytes).

513

String overflow

Compiler: an identifier in the formula exceeds 64 KB in size. Interpreter: 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 code, for example, a document with a newer function is loaded in an older version that does not contain the function.

518

Internal syntax error

Variable is not available

519

No result (#VALUE is in the cell rather than Err:519!)

Formula yields a value that does not corresponds 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 File - Preferences - Productivity Tools - SpreadSheet Editor - 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 (instead of Err:524 cell contains #REF)

Compiler: a column or row description name could not be resolved. Interpreter: in a formula, the column, row, or sheet that contains a referenced cell is missing.

525

invalid names (instead of Err:525 cell contains #NAME?)

An identifier could not be evaluated, for example, no valid reference, no valid domain name, no column/row label, 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

Interpreter: References, such as when a cell references a cell, are too encapsulated.


**Note:** This information is available within the product's online help documentation.


Document information

More support for: IBM Notes
Embedded Symphony

Software version: 8.0

Operating system(s): Linux, Windows

Reference #: 1270725

Modified date: 10 June 2011