Calc Guide 24.2
Appendix B Error Codes
This document is Copyright © 2024 by the LibreOffice Documentation Team. Contributors are listed below. You may distribute it and/or modify it under the terms of either the GNU General Public License (https://www.gnu.org/licenses/gpl.html), version 3 or later, or the Creative Commons Attribution License (https://creativecommons.org/licenses/by/4.0/), version 4.0 or later.
All trademarks within this guide belong to their legitimate owners.
Steve Fanning 
Olivier Hallot 
B. Antonio Fernández 
Barbara Duprey 
Jean Hollis Weber 
Claire Wood 
Kees Kriek 
Steve Fanning 
Gordon Bates 
Felipe Viggiano 
Skip Masonsmith 

Please direct any comments or suggestions about this document to the Documentation Team’s forum at https://community.documentfoundation.org/c/documentation/loguides/ (registration is required) or send an email to: loguides@community.documentfoundation.org.
Note
Everything you send to a forum, including your email address and any other personal information that is written in the message, is publicly archived and cannot be deleted. Emails sent to the forum are moderated.
Published March 2024. Based on LibreOffice 24.2 Community.Other versions of LibreOffice may differ in appearance and functionality.
Introduction to Calc error codes
Calc provides feedback for errors of miscalculation, incorrect use of functions, invalid cell references and values, and other user initiated mistakes. The feedback may be displayed within the cell that contains the error (Figure 1), or on the Status bar (Figure 2), or in both, depending on the type of error. Generally speaking, if the error occurs in the cell that is selected (or contains the cursor), the error message is displayed on the Status bar.
As an example, Figure 1 shows the error code returned when a column is too narrow to display the entire formatted date. The date displayed within the input line, 04/05/1998, would fit within the cell without a problem, but the format used by the cell produces the date value Sunday, April 05, 1998.
Figure 1: Error codes displayed within cells
When the cell displaying the #REF! error code in Figure 1 is selected, the Status bar displays the error message as shown in Figure 2. This message is more descriptive than the message displayed in the cell, but it still may not provide enough information to correctly diagnose the problem. For fuller explanations, consult the following tables and the Help topic, Error Codes in LibreOffice Calc.
Figure 2: An error message displayed in the Status bar
This appendix presents error codes in two tables.
1) Table 1 lists error strings which are displayed within the cell that actually contains the error. Except in the cases of the ###, #FMT, and #N/A errors, they all correspond to a Calc error code number. Alphanumeric codes such as Err:502 and Err:511 can also appear in cells; these are not separately identified in the Table 1 but their meanings are given in Table 2.
2) Table 2 explains all of the error codes, listed by code number, including those error codes in the first table.
Tip
You can use the ERRORTYPE() function to find the code number for an error occurring in a different cell. Refer to the Help system for more detail about this function.
Table 1: Error codes in cells
Code 
Cell display 
Status bar message 
Explanation of the error 
 
### 
 
The column is too narrow to display the complete formatted contents of the cell. This is not really an error value, so there is no corresponding numerical error code. The solutions to this problem are to increase the width of the column, or select Format > Cells > Alignment and click either Wrap text automatically or Shrink to fit cell size in the Properties area so as to make the text match the current column width. 
 
#FMT 
 
This value is outside of the valid limits for this number format. This is not really an error value, so there is no corresponding numerical error code. 
 
#N/A 
Error: Value not available 
A result for the formula expression is not available. The formula cannot find what it has been asked to look for. This is not really an error value, so there is no corresponding numerical error code. 
#NUM! 
Error: Invalid numeric value 
Invalid floating point operation. Calculation result outside of the defined value range. A calculation that results in an overflow of the defined value range – a value too big or too small. 

#VALUE! 
Error: No value 
No valid result is possible. A function cannot supply a value corresponding to its definition; or a cell referenced in the formula contains text instead of an expected number. 

521 
#NULL! 
Error: No code or intersection 
No code or no intersection. The intersection of ranges produced zero cells. 
#REF! 
Error: Not a valid reference 
Compiler: a row or column heading could not be detected. Interpreter: the formula refers to a cell whose column, row, or table/sheet has been deleted or which is outside the table/sheet. The formula within the cell uses a reference that does not exist. Either a column or a row description name could not be resolved, or the column, row, or sheet that contains a referenced cell is missing or it is outside the sheet. 

#NAME? 
Error: Invalid name 
An identifier could not be evaluated: no valid reference, no valid function name, no column/row label, no macro, incorrect decimal separator, addin not found. 

#DIV/0! 
Error: Division by zero 
The denominator of a division operation ("/") is 0 (zero). Several functions can also return this error. 
The following table is an overview of the most common error messages for LibreOffice Calc.
Note
Errors described as Internal errors should not be encountered by users under normal conditions.
Table 2: List of error codes
Code 
Status bar message 
Explanation of the error 
501 
Error: Invalid character 
Invalid character in formula. Similar to the Invalid Name error (525) except that it occurs within a formula. 
502 
Error: Invalid argument 
An argument of a function has an invalid value. This error also occurs if more than one matching cell is found by the DGET() function. 
503 (#NUM!) 
Error: Invalid numeric value 
Invalid floating point operation. Calculation result outside of the defined value range. A calculation that results in an overflow of the defined value range – a value too big or too small. 
504 
Error in parameter list 
The type of a parameter of a function is invalid. For instance, a parameter of a function is text instead of a number. 
507 
Error: in bracketing 
Missing bracket or parenthesis 
508 
Error: in bracketing 
Missing bracket or parenthesis. For instance, closing parenthesis without an opening parenthesis, or a missing closing parenthesis in the middle of a formula. 
509 
Error: Operator missing 
An operator is missing. 
510 
Error: Variable missing 
Two operators, where the second is not a unitary operator, follow each other. 
511 
Error: Variable missing 
The function requires more variables than those provided. 
512 
Error: Formula overflow 
Formula too long / complex. For example, the total number of internal tokens (that is, operators, variables, brackets) in the formula exceeds 8192. 
513 
Error: String overflow 
Character string too long. 
514 
Error: Internal overflow 
Internal capacity exceeded. An internal calculation stack overflow occurred. 
515 
Internal syntactical error 
Unknown error. 
516 
Internal syntactical error 
Matrix is expected on the calculation stack, but it is not available. The calculation stack should contain a matrix but it is not there. 
517 
Internal syntactical error 
Unknown operation code. A document containing a newer feature is loaded in an older version of Calc that did not support that feature. 
518 
Internal syntactical error 
Variable not available. A variable was supposed to be popped from the calculation stack but it is not available / not there. 
519 (#VALUE!) 
Error: No value 
No valid result is possible. A function cannot supply a value corresponding to its definition; or a cell referenced in the formula contains text instead of an expected number. 
520 
Internal syntactical error 
The compiler has generated a code which it cannot interpret. 
521 (#NULL!) 
Error: No code or intersection 
No code or no intersection. The intersection of ranges produced zero cells. 
522 
Error: Circular reference 
A formula refers directly or indirectly to itself and the Iterations option is not activated under Tools > Options > LibreOffice Calc > Calculate. 
523 
Error: Calculation does not converge 
The calculation procedure does not converge. A function missed a targeted value (tends towards a given value but does not reach it), or iterative references do not reach the minimum change within the defined maximum steps (increments) that are set. 
524 (#REF!) 
Error: Not a valid reference 
Compiler: a row or column heading could not be detected. Interpreter: the formula refers to a cell whose column, row, or table/sheet has been deleted or which is outside the table/sheet. The formula within the cell uses a reference that does not exist. Either a column or a row description name could not be resolved, or the column, row, or sheet that contains a referenced cell is missing or it is outside the sheet. 
525 (#NAME?) 
Error: Invalid name 
An identifier could not be evaluated: no valid reference, no valid function name, no column/row label, no macro, incorrect decimal separator, addin not found. 
530 (#ADDIN?) 
Error: Addin not found 
Addin not found. 
531 (#MACRO?) 
Error: Macro not found 
Macro not available / not found. 
532 (#DIV/0!) 
Error: Division by zero 
The denominator of a division operation ("/") is 0 (zero). Several functions can also return this error. 
533 
Nested arrays are not supported 
Nested arrays are not supported. 
538 
Error: Array or matrix size 
Invalid size of array. The maximum limit for sorting has been exceeded. The limit is twice the maximum number of rows, so for 1,048,576 rows the limit is 2,097,152 entries. Also obtained whenever a temporary matrix could not be allocated due to its size requirement. 
539 
Unsupported inline array content 
Bad inline array content, nonvalue/nonstring. 
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. 