Error Codes in LibreOffice Calc
This following table is an overview of the error messages for \<item type=\"productname\"\>LibreOffice\</item\> Calc. If the error occurs in the cell that contains the cursor, the error message is displayed on the \<emph\>Status Bar\</emph\>.
\<bookmark_value\>invalid references; error messages\</bookmark_value\>\<bookmark_value\>error messages;invalid references\</bookmark_value\>\<bookmark_value\>#REF error message\</bookmark_value\> \<bookmark_value\>invalid names; error messages\</bookmark_value\>\<bookmark_value\>#NAME error message\</bookmark_value\>
Error Code |
Message |
Explanation |
### |
none |
The cell is not wide enough to display the contents. |
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 SQRT() function, for this please use IMSQRT(). |
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. |
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 8192. |
513 |
String overflow |
\<emph\>Compiler:\</emph\> an identifier in the formula exceeds 64 KB in size. \<emph\>Interpreter:\</emph\> 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. |
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 set under LibreOffice - PreferencesTools - Options - LibreOffice Calc - Calculate. |
523 |
The calculation procedure does not converge |
Function missed a targeted value, or iterative references do not reach the minimum change within the maximum steps that are set. |
524 |
invalid references (instead of Err:524 cell contains #REF) |
\<emph\>Compiler:\</emph\> a column or row description name could not be resolved. \<emph\>Interpreter:\</emph\> 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, 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 |
\<emph\>Interpreter: \</emph\>References, such as when a cell references a cell, are too encapsulated. |
532 |
Division by zero |
Division operator / if the denominator is 0 |