/

List of LibreOffice Calc Error Codes

2546 views

A reference list of LibreOffice Calc error codes with explanations.

LibreOffice Calc offers feedback for errors, including miscalculations, improper function usage, invalid cell references or values, and other user mistakes. Depending on the specific error, this feedback can be shown within the cell itself, on the status bar, or even both.

Generally, the error message is displayed on the status bar if the error happens in the currently selected cell or the cell where the cursor is located.

LibreOffice Calc Error Code - places
LibreOffice Calc Error Code – places

Error codes for Cells

###

  • Code: None
  • Explanation: 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 to make the text match the current column width.

Err502

  • Code: 502
  • Explanation: The function argument is invalid, or the DGET function finds more than one matching cell.

#NUM!

  • Code: 503
  • Explanation: A calculation resulted in an overflow of the defined value range.

#VALUE

  • Code: 519
  • Explanation: The formula within the cell returns a value that does not correspond to the definition of the formula or functions used. This error could also mean that the cell referenced by the formula contains text
    instead of a number.

#REF!

  • Code: 524
  • Explanation: The formula within the cell uses a reference that does not exist. Either a column or row description name could not be resolved, or the column, row, or sheet that contains a referenced cell is missing.

#NAME?

  • Code: 525
  • Explanation: An identifier could not be evaluated: no valid reference, no valid domain name, no column/row label, no macro, incorrect decimal divider, add-in not found. For example, entering in a cell =sum(bob*5) where there is no cell named “bob” or containing the text “bob” generates this error.

#DIV/0!

  • Code: 532
  • Explanation: Division operator / if the denominator is 0.

General Error Codes

Error codeError messageError description
501Invalid characterCharacter in a formula is not valid. This error is the same as the Invalid Name error (525) except that it occurs within a formula. The cell containing the error will display the #NAME? error reference.
502Invalid argumentFunction argument is not valid; for example, a negative
number for the root function. This error also occurs if more
than one matching cell is found by the DGET function.
503Invalid floating point
operation (cell
displays #NUM!)
Division by 0, or another calculation that results in an
overflow of the defined value range (a value too big or too
Small).
504Parameter list errorFunction parameter is not valid; for example, text instead of
a number, or a domain reference instead of a cell reference.
505Internal syntax error
506Invalid semicolon
507Pair missing
508Pair missingMissing bracket or parenthesis; for example, closing
brackets but no opening brackets.
509Missing operatorOperator is missing; for example,
“=2(3+4) * “, where the operator between “2” and “(” is
Missing.
510Missing variableVariable is missing; for example, when two operators are
Together “=1+*2”.
511Missing variableFunction requires more variables than are provided; for
example, AND() and OR().
512Formula overflowThe total number of internal tokens (that is, operators,
variables, brackets) in the formula exceeds 512, or the total
number of matrices the formula creates exceeds 150. This
includes basic functions that receive too large an array as a
Parameter.
513String overflowAn identifier in the formula exceeds 64 KB in size, or a result
of a string operation exceeds 64 KB in size.
514Internal overflowSort operation attempted on too much numerical data (max.
100000) or a calculation stack overflow.
515Internal syntax errorNot used
516Internal syntax errorMatrix is expected on the calculation stack, but is not
Available.
517Internal syntax errorUnknown error; for example, a document with a newer
function is loaded in an older version of Calc that does not
contain the function.
518Internal syntax errorVariable is not available.
519No result (cell
displays #VALUE)
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.
520Internal syntax errorCompiler creates an unknown compiler code.
521Internal syntax errorNo result
522Circular referenceFormula refers directly or indirectly to itself and the
Iterations option is not selected under Tools → Options →
LibreOffice Calc → Calculate.
523The calculation
procedure does not
Converge
Financial statistics function missed a targeted value, or
iterations of circular references do not reach the minimum
change within the maximum steps that are set.
524Invalid references
(cell displays #REF!)
A column or row description name could not be resolved, or
the column, row, or sheet that contains a referenced cell is
Missing.
525Invalid names (cell
displays #NAME?)
An identifier could not be evaluated; for example, no valid
reference, no valid domain name, no column/row label, no
macro, incorrect decimal divider, add-in not found.
526Internal syntax errorObsolete, no longer used, but could come from old
documents if the result is a formula from a domain.
527Internal overflowReferences, 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.
528 to 531NoneNot used
532Division by zeroDivision 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

Closing Notes

I hope you find the explanation for the LibreOffice Calc error for your spreadsheet and able to resolve it.

Join our Telegram channel and stay informed on the move.

Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

0 Comments
Inline Feedbacks
View all comments