Calc Guide 7.2

Appendix B
Error CodesCopyrightThis document is Copyright © 2021 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
Steve Fanning

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’s
mailing list: documentation@global.libreoffice.org.

Note
Everything you send to a mailing list, including your email address and any otherpersonal information that is written in the message, is publicly archived and cannot
be deleted.

Publication date and software version
Published November 2021. Based on LibreOffice 7.2 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.................................................................................................................................. 2Publication date and software version.......................................................................................2Introduction 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 containsthe 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 inLibreOffice 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; 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 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
CodeN/A

Message###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 tothis 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 to make the text match the current column width.
A calculation resulted in an overflow of the defined value
range.
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 under normalconditions. Errors listed as Not used are not currently assigned to any error condition
and will not occur.
Table 2: List of error codes
Code501

Message
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 itoccurs 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 ortoo small).
General error codes | 5Code504

Message
Parameter list error

505
506
507
508

Internal syntax error
Invalid semicolon
Pair missing
Pair missing

509

Missing operator

510

Missing variable

511

Missing variable

512

Formula overflow

513

String overflow

514

Internal overflow

515
516

Internal syntax error
Internal syntax error

517

Internal syntax error

518
519

Internal syntax error
No result (celldisplays #VALUE!)

520
521
522

Internal syntax error
Internal syntax error
Circular reference523

The calculation
procedure does notconverge

524

Invalid references(cell displays #REF!)

525

Invalid names (celldisplays #NAME?)

6 | Appendix B Error Codes

Explanation of the error
Function parameter is not valid; for example, text
instead of a number, or a domain reference instead ofa cell reference.
Not used.
Not used.
Not used.
Missing bracket or parenthesis; for example, closing
brackets but no opening brackets.
Operator is missing; for example,"=2(3+4)* ", where the operator between "2" and "("is missing.
Variable is missing; for example, when two operators
are together "=1+*2".
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, orthe total number of matrices the formula creates
exceeds 150. This includes basic functions that receive
too large an array as a parameter.
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
(max. 100000) or a calculation stack overflow.
Not used.
Matrix is expected on the calculation stack, but is notavailable.
Unknown error; for example, a document with a newer
function is loaded in an older version of Calc that does
not contain the function.
Variable is not available.
Formula yields a value that does not correspond to thedefinition, or a cell that is referenced in the formulacontains text instead of a number.
Compiler creates an unknown compiler code.
No result.
Formula refers directly or indirectly to itself and theIterations option is not selected under Tools >Options > LibreOffice Calc > Calculate.
Financial statistics function missed a targeted value, or
iterations of circular references do not reach theminimum change within the maximum steps that areset.
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; for example, novalid reference, no valid domain name, no column/row
label, no macro, incorrect decimal divider, add-in notfound.

Code526

Message
Internal syntax error

527Internal overflow

528 to531
532—533

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

538539
540

Division by zero (celldisplays #DIV/0!)

Explanation of the error
Obsolete, no longer used, but could come from olddocuments if the result is a formula from a domain.
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.
Not used.
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
For example, “={1;{2}}”—For example, “={1+2}”
Occurs when a function that requires (re)loading of
external sources is encountered and the user hasn't
confirmed reloading of external sources yet.

General error codes | 7