Calc Guide 7.5

Appendix B
Error CodesCopyrightThis document is Copyright © 2023 by the LibreOffice Documentation Team. Contributors arelisted 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 CreativeCommons Attribution License (https://creativecommons.org/licenses/by/4.0/), version 4.0 or later.
All trademarks within this guide belong to their legitimate owners.

Contributors
To this edition
Skip Masonsmith

Kees Kriek

To previous editionsBarbara Duprey
Kees Kriek
Felipe ViggianoJean Hollis Weber
Steve Fanning

Claire Wood
Gordon Bates

Feedback
Please direct any comments or suggestions about this document to the Documentation Team’sforum at https://community.documentfoundation.org/c/documentation/loguides/ (registration isrequired) or send an email to: loguides@community.documentfoundation.org.

Note
Everything you post to a forum, including your email address and any otherpersonal information that is written in the message, is publicly archived andcannot be deleted. E-mails sent to the forum are moderated.

Publication date and software version
Published February 2023. Based on LibreOffice 7.5 Community.
Other versions of LibreOffice may differ in appearance and functionality.

Documentation for LibreOffice is available at https://documentation.libreoffice.org/en/Contents
Copyright.......................................................................................................................... 2Contributors................................................................................................................................2Feedback....................................................................................................................................2
Publication date and software version........................................................................................2

Introduction to Calc error codes....................................................................................4
Error codes displayed within cells.................................................................................5
General error codes.........................................................................................................5Appendix B Error Codes | 3

Introduction to Calc error codes
Calc provides feedback for errors of miscalculation, incorrect use of functions, invalid cellreferences 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, dependingon 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 thecell 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 theerror 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 theproblem. 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 theerror. Except in the case of the ### error, they all correspond to a Calc error code
number. Alphanumeric codes such as Err502 and Err511 can also appear in cells; theseare 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 codesin 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 thisfunction.

4 | Appendix B Error Codes

Error codes displayed within cells
Table 1: Error codes in cells
CodeMessage
N/A###503#NUM!

519#VALUE!

524

#REF!

525

#NAME?

532#DIV/0!

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 thisproblem are to increase the width of the column, or selectFormat > Cells > Alignment and click either Wrap text
automatically or Shrink to fit cell size in the Properties area tomake the text match the current column width.
A calculation resulted in an overflow of the defined valuerange.
The formula within the cell returns a value that does notcorrespond to the definition of the formula or functions used.
This error could also mean that the cell referenced by theformula contains text instead of a number.
The formula within the cell uses a reference that does notexist. Either a column or row description name could not beresolved, or the column, row, or sheet that contains areferenced cell is missing.
An identifier could not be evaluated: no valid reference, novalid domain name, no column/row label, no macro, incorrect
decimal divider, add-in not found. For example, entering in acell =sum(bob*5) where there is no cell named “bob” orcontaining the text “bob” generates this error.
Division operator / if the denominator is 0.
Some more functions return this error; see next table fordetails.

General error codes
The following table is an overview of the most common error messages for LibreOffice Calc.

NoteErrors described as Internal errors should not be encountered by users undernormal conditions. Errors listed as Not used are not currently assigned to anyerror condition and will not occur.
Table 2: List of error codes
CodeMessage
501
Invalid character
502

Invalid argument

503

Invalid floating point
operation (celldisplays #NUM!)

Explanation of the error
Character in a formula is not valid. This error is thesame as the Invalid Name error (525) except that it
occurs within a formula. The cell containing the error will
display the #NAME? error reference.
Function argument is not valid; for example, a negative
number for the SQRT() function. This error also occurs
if more than one matching cell is found by the DGET()
function.
Division by 0, or another calculation that results in an
overflow of the defined value range (a value too big or
too small).
General error codes | 5

504507,508509

510
511
512

513
514
515
516
517

518
519

520
521
522

523

524

525

526
527

Parameter list error

Function parameter is not valid; for example, text
instead of a number, or a domain reference instead of acell reference.
Missing bracket or parenthesis; for example, closing
Pair missing
brackets but no opening brackets.
Missing operator
Operator is missing; for example,"=2(3+4)* ", where the operator between "2" and "(" ismissing.
Variable is missing; for example, when two operators
Missing variable
are together "=1+*2".
Missing variable
Function requires more variables than are provided; forexample, AND() and OR().
The total number of internal tokens (that is, operators,variables, brackets) in the formula exceeds 8192, or theFormula overflow
total number of matrices the formula creates exceeds
150. This includes basic functions that receive too large
an array as a parameter.
String overflow
An identifier in the formula exceeds 64 KB in size, or a
result of a string operation exceeds 64 KB in size.
Sort operation attempted on too much numerical data
Internal overflow(max. 100000) or a calculation stack overflow.
Internal syntax error
Unknown error.
Matrix is expected on the calculation stack, but is not
Internal syntax error
available.
Internal syntax error
Unknown error; for example, a document with a newer
function is loaded in an older version of Calc that does
not contain the function.
Internal syntax error
Variable is not available.
No result (cell displays Formula yields a value that does not correspond to the#VALUE!)
definition, or a cell that is referenced in the formulacontains text instead of a number.
Internal syntax error
Compiler creates an unknown compiler code.
Internal syntax error
No code or no result.
(cell displays #NULL!)
Formula refers directly or indirectly to itself and the
Circular reference
Iterations option is not selected under Tools > Options> LibreOffice Calc > Calculate.
The calculation
Function missed a targeted value, or iterations ofprocedure does not
circular references do not reach the minimum change
converge
within the maximum steps that are set.
A column or row description name could not beInvalid references (cellresolved, or the column, row, or sheet that contains adisplays #REF!)
referenced cell is missing.
Invalid names (cellAn identifier could not be evaluated; for example, nodisplays #NAME?)
valid reference, no valid domain name, no column/row
label, no macro, incorrect decimal divider, add-in notfound.
Obsolete, no longer used, but could come from oldInternal syntax error
documents if the result is a formula from a domain.
Internal overflow
References, such as when a cell references a cell, are
too encapsulated or deeply nested. This is an internal
error and should not be displayed in LibreOffice.

6 | Appendix B Error Codes

528 to529
‍530
‍531
532

533
538
539
540

—Not used.

No AddIn
No Macro
Division by zero (celldisplays #DIV/0!)

Add-in not found.
Macro not found.
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 argumentsSTDEV with less than 2 arguments
STANDARDIZE with stdev=0
NORMDIST with stdev=0

Nested arrays are notsupported
Error: Array or matrix
size
Unsupported inline
array content
External content
disabled

For example, “={1;{2}}”Array or matrix size invalid.
For example, “={1+2}”
Occurs when a function that requires (re)loading ofexternal sources is encountered and the user hasn't
confirmed reloading of external sources yet.

General error codes | 7