Frequently asked questions  Calc
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
What do the error codes (Err:NNN) in a LibreOffice spreadsheet mean?
ERRORTYPE Cell display  Code  Status Bar Message  Explanation of the error (Example) 

(None)
### 
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  
(None)
#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.
String for output error.
Example: Introduce  
32767
#N/A
7 
NotAvailable  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.

501

IllegalChar  Invalid character 
Invalid character in formula.
Same as the Invalid Name error (525) except that it occurs within a formula.
Example: 
502

IllegalArgument  Invalid argument 
An argument of a function has an invalid value.
Example:

503
#NUM!
6 
IllegalFPOperation  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.
Example: 
504

IllegalParameter  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.
Example:

505

Internal syntax error 
Not configured.  
506

Invalid decimal separator 
Not configured.  
507

Pair  Pair missing 
Missing bracket or parenthesis. 
508

PairExpected  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
(missing parentheses at the end of a formula are added automatically).
Example: 
509

OperatorExpected  Operator missing 
Example: 
510

VariableExpected  Variable missing 
Two operators, where the second is not a unitary operator, follow each other.
Example: 
511
_{1 (LO > 7.6)} 
ParameterExpected  Variable missing 
The function requires more variables than those provided.
Example: 
512

CodeOverflow  Formula overflow 
Formula too long. Compiler: This refers to the internal number of bits (512 maximum), which has nothing to do with the length of the character string in the formula in question, but depends on the number of operators, variables, parentheses, etc. The total number of internal tokens (that is, operators, variables, brackets) in the formula exceeds 8192, or the total number of matrices the formula creates exceeds 150. Interpreter: Formulas which generate too many matrices at once (150 maximum) and Basic functions which receive as parameters an array that is too large (OxFFE maximum is 65534 octets). This includes Basic functions that receive too large an array as a parameter (OxFFE maximum is 65534 octets). 
513

StringOverflow  String overflow 
Character string too long.
Compiler: An identifier in the formula exceeds 1024 characters (UTF16 code points) in size.
Interpreter: The result of an operation on a string of characters would exceed

514

StackOverflow  Internal overflow 
Internal capacity exceeded. An internal calculation stack overflow occurred. 
515

UnknownState  Internal syntax error 
Unknown error. 
516

UnknownVariable  Internal syntax 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

UnknownOpCode  Internal syntax 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

UnknownStackVariable  Internal syntax error 
Variable not available. A variable was supposed to be popped from the calculation stack but it is not available / not there. 
519
#VALUE!
3 
NoValue  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.
Example: 
520

UnknownToken  Internal syntactical error 
The compiler has generated a code which it cannot interpret.
Example: 
521
#NULL!
1_{ (LO > 7.6)} 
NoCode  No code or (no) intersection 
No code or no intersection
(since LibreOffice 7.6; it was set as
" 
522

CircularReference  Circular reference 
A formula refers directly or indirectly to itself and the Iterations option is not activated under

523

NoConvergence  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!
4 
NoRef  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/worksheet has been deleted or which is outside the table/worksheet.
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 worksheet that contains a referenced cell is missing or it is outside the worksheet.
Example: See

525
#NAME?
5 
NoName  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.
Example:

526

Internal syntax error 
Obsolete, no longer used; it may occur in (old) documents loaded in old versions of Calc.  
527

Internal overflow 
Internal capacity exceeded. Interpreter: Excessive nesting of references (the cell references a cell which references a cell which references a cell which...). References (such as when a cell references another cell...) are too encapsulated or deeply/excessively nested. This is an internal error and should not be displayed in LibreOffice.  
528

Not used.  
529

CellNoValue 
Interpreter, internal: no numeric value but numeric queried.  
530
#ADDIN?

NoAddin  Addin not found 
AddIn not found. 
531
#MACRO?

NoMacro  Macro not found 
Macro not available / not found. 
532
#DIV/0!
2 
DivisionByZero  Division by zero 
The denominator of a division operation ("

533

NestedArray  Nested arrays are not supported. 
Example: 
534

NotNumericString 
Interpreter, internal: no numeric value but numeric queried.  
535

JumpMatHasResult 
Interpreter, internal: jump matrix already has a result at this position.  
536

ElementNaN 
Interpreter, internal: (matrix) element is not a numeric value.  
537

RetryCircular 
Internal: keep dirty, retry interpreting next round.  
538

MatrixSize  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

BadArrayContent  Unsupported inline array content 
Bad inline array content, nonvalue/nonstring.
Example: 
540

LinkFormulaNeedingCheck  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. 
ERRORTYPE Cell display  Code  Status Bar Message  Explanation of the error (Example) 