| Error Code | Message | Explanation |
|---|---|---|
| ### | none | The cell is not wide enough to display the contents. |
| #FMT | none | This value is outside of limits valid for this format |
| #N/A | Not Available | A result for the formula expression is not available. |
| 501 | Invalid character | Character in a formula is not valid. |
| 502 | Invalid argument | Function argument is not valid. For example, a negative number for the SQRT() function, for this please use IMSQRT(). |
| 503 #NUM! |
Invalid floating point operation | A calculation 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. |
| 507, 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 | Compiler: an identifier in the formula exceeds 1024 characters (UTF-16 code points) in size. Interpreter: a result of a string operation would exceed 256M characters (UTF-16 code points, so 512MiB) in size. |
| 514 | Internal overflow | An internal calculation stack overflow occurred. |
| 515 | Internal syntax error | Unknown error. |
| 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 #VALUE! |
No value (instead of Err:519 cell displays #VALUE!) | The 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 #NULL! |
No code or no intersection. | No code or no result. |
| 522 | Circular reference | Formula refers directly or indirectly to itself and the Iterations option is not set under Tools - 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 #REF! |
Not a valid reference (instead of Err:524 cell displays #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 #NAME? |
Invalid names | An identifier could not be evaluated, for example, no valid reference, no valid function name, no column/row label, no macro, incorrect decimal separator, add-in not found. |
| 527 | Internal overflow | Interpreter: References, such as when a cell references a cell, are too encapsulated. |
| 530 | No AddIn | Interpreter: AddIn not found. |
| 531 | No Macro | Interpreter: Macro not found. |
| 532 #DIV/0! |
Division by zero | Division operator / if the denominator is 0 Some more functions return this error, for example: VARP with less than 1 argument STDEVP with less than 1 argument VAR with less than 2 arguments STDEV with less than 2 arguments STANDARDIZE with stdev=0 NORMDIST with stdev=0 |
| 533 | Nested arrays are not supported | For example, ={1;{2}} |
| 538 | Error: Array or matrix size | The maximum limit for sorting has exceeded (the maximum is twice the maximum number of rows, so for 1048576 rows 2097152 entries). The same Err:538 is also used whenever a temporary matrix could not be allocated due to its size requirement. |
| 539 | Unsupported inline array content | For example, ={1+2} |
| 540 | External content disabled | A function that requires (re)loading of external sources is encountered and the user has not confirmed reloading of external sources yet. |