<!DOCTYPE html>
<html lang="en-US">
<head>
<base href="../../../../">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Error Codes in LibreOffice Calc</title>
<link rel="shortcut icon" href="media/navigation/favicon.ico">
<link type="text/css" href="normalize.css" rel="Stylesheet">
<link type="text/css" href="default.css" rel="Stylesheet">
<link type="text/css" href="prism.css" rel="Stylesheet">
<script type="text/javascript" src="polyfills.js"></script><script type="text/javascript" src="languages.js"></script><script type="text/javascript" src="fuzzysort.js"></script><script type="text/javascript" src="prism.js"></script><script type="text/javascript" src="help2.js" defer></script><script type="text/javascript" src="a11y-toggle.js" defer></script><script type="text/javascript" src="en-US/langnames.js" defer></script><script type="text/javascript" src="paginathing.js" defer></script><script type="text/javascript" src="en-US/bookmarks.js" defer></script><script type="text/javascript" src="en-US/contents.js" defer></script><script type="text/javascript" src="help.js" defer></script><meta name="viewport" content="width=device-width,initial-scale=1">
</head>
<body itemscope="true" itemtype="http://schema.org/TechArticle">
<div class="header-extrawurst">
<header><div class="logo-container"><a class="logo" href="en-US/text/shared/05/new_help.html"><div class="symbol"></div>
<p>LibreOffice 6.4 Help</p></a></div></header><div class="modules">
<button type="button" data-a11y-toggle="modules-nav" id="modules" onclick="setupModules('', 'en-US');">Module</button><nav id="modules-nav"></nav>
</div>
</div>
<aside class="rightside"><input id="accordion-1" name="accordion-menu" type="checkbox"><label for="accordion-1">Contents</label><div id="Contents" class="contents-treeview"></div></aside><aside class="leftside"><div id="Index">
<div class="index-label">Index 🔎︎ </div>
<div id="Bookmarks">
<input id="search-bar" type="text" class="search" placeholder="Search in chosen module"><nav class="index"></nav>
</div>
</div></aside><div id="DisplayArea" itemprop="articleBody">
<a name="bm_id3146797"></a><meta itemprop="keywords" content="error codes,list of">
<h1 itemprop="articleSection" id="hd_id3146797">Error Codes in <span class="productname">LibreOffice</span> Calc</h1>
<p id="par_id3150275" class="paragraph">The following table is an overview of the error messages for <span class="productname">LibreOffice</span> Calc. If the error occurs in the cell that contains the cursor, the error message is displayed on the <span class="emph">Status Bar</span>.</p>
<a name="bm_id0202201010205429"></a><meta itemprop="keywords" content="### error message">
<a name="bm_id3154634"></a><meta itemprop="keywords" content="invalid references, error messages">
<meta itemprop="keywords" content="error messages,invalid references">
<meta itemprop="keywords" content="#REF error message">
<a name="bm_id3148428"></a><meta itemprop="keywords" content="invalid names, error messages">
<meta itemprop="keywords" content="#NAME error message">
<table border="1" class="" cellpadding="0" cellspacing="0">
<tr>
<td rowspan="" colspan="" class="tableheadcell">
<p id="par_id3153968" class="tableheadintable">Error Code</p>
</td>
<td rowspan="" colspan="" class="tableheadcell">
<p id="par_id3125863" class="tableheadintable">Message</p>
</td>
<td rowspan="" colspan="" class="tableheadcell">
<p id="par_id3151112" class="tableheadintable">Explanation</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id1668467" class="tablecontentintable">###</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3165766" class="tablecontentintable">none</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3169266" class="tablecontentintable">The cell is not wide enough to display the contents.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3153188" class="tablecontentintable">501</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3148645" class="tablecontentintable">Invalid character</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3155854" class="tablecontentintable">Character in a formula is not valid.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3145253" class="tablecontentintable">502</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3147397" class="tablecontentintable">Invalid argument</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3153160" class="tablecontentintable">Function argument is not valid. For example, a negative number for the SQRT() function, for this please use IMSQRT().</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3154015" class="tablecontentintable">503<br>#NUM!</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3155766" class="tablecontentintable">Invalid floating point operation</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3159266" class="tablecontentintable">A calculation results in an overflow of the defined value range.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3149258" class="tablecontentintable">504</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3147344" class="tablecontentintable">Parameter list error</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3147003" class="tablecontentintable">Function parameter is not valid, for example, text instead of a number, or a domain reference instead of cell reference.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3154532" class="tablecontentintable">507, 508</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3150107" class="tablecontentintable">Error: Pair missing</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3149129" class="tablecontentintable">Missing bracket, for example, closing brackets, but no opening brackets</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3149895" class="tablecontentintable">509</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3155097" class="tablecontentintable">Missing operator</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3154649" class="tablecontentintable">Operator is missing, for example, "=2(3+4) * ", where the operator between "2" and "(" is missing.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3153813" class="tablecontentintable">510</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3153483" class="tablecontentintable">Missing variable</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3154710" class="tablecontentintable">Variable is missing, for example when two operators are together "=1+*2".</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3154739" class="tablecontentintable">511</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3145112" class="tablecontentintable">Missing variable</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3145319" class="tablecontentintable">Function requires more variables than are provided, for example, AND() and OR().</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3149050" class="tablecontentintable">512</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3150393" class="tablecontentintable">Formula overflow</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3159259" class="tablecontentintable">
<span class="emph">Compiler:</span> the total number of internal tokens, (that is, operators, variables, brackets) in the formula exceeds 8192.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3150537" class="tablecontentintable">513</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3147412" class="tablecontentintable">String overflow</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3145635" class="tablecontentintable">
<span class="emph">Compiler:</span> an identifier in the formula exceeds 64 KB in size. <span class="emph">Interpreter:</span> a result of a string operation exceeds 64 KB in size.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3149147" class="tablecontentintable">514</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3157904" class="tablecontentintable">Internal overflow</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3149352" class="tablecontentintable">Sort operation attempted on too much numerical data (max. 100000) or a calculation stack overflow.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3154842" class="tablecontentintable">515</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3147424" class="tablecontentintable">Internal syntax error</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3148438" class="tablecontentintable">Unknown error.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3154841" class="tablecontentintable">516</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3147423" class="tablecontentintable">Internal syntax error</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3148437" class="tablecontentintable">Matrix is expected on the calculation stack, but is not available.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3155261" class="tablecontentintable">517</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3153934" class="tablecontentintable">Internal syntax error</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3149507" class="tablecontentintable">Unknown code, for example, a document with a newer function is loaded in an older version that does not contain the function.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3148585" class="tablecontentintable">518</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3149189" class="tablecontentintable">Internal syntax error</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3149545" class="tablecontentintable">Variable is not available</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3146142" class="tablecontentintable">519<br>#VALUE</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3155954" class="tablecontentintable">No result (#VALUE is in the cell rather than Err:519!)</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3153108" class="tablecontentintable">The 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.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3150338" class="tablecontentintable">520</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3150017" class="tablecontentintable">Internal syntax error</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3148758" class="tablecontentintable">Compiler creates an unknown compiler code.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3154324" class="tablecontentintable">521</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3153737" class="tablecontentintable">Internal syntax error</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3155436" class="tablecontentintable">No result.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3153045" class="tablecontentintable">522</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3149008" class="tablecontentintable">Circular reference</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3157972" class="tablecontentintable">Formula refers directly or indirectly to itself and the <span class="emph">Iterations</span> option is not set under <span id="swlnsysidm180" class="switchinline"><span hidden="true" id="MACidm181" class="MAC">LibreOffice - Preferences
</span><span hidden="true" id="defaultidm182">Tools - Options</span></span> - LibreOffice Calc - Calculate.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3149538" class="tablecontentintable">523</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3150930" class="tablecontentintable">The calculation procedure does not converge</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3150272" class="tablecontentintable">Function missed a targeted value, or <a target="_top" href="en-US/text/shared/optionen/01060500.html">iterative references</a> do not reach the minimum change within the maximum steps that are set.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3153544" class="tablecontentintable">524<br>#REF</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3154634" class="tablecontentintable">invalid references (instead of Err:524 cell contains #REF)</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3147539" class="tablecontentintable">
<span class="emph">Compiler:</span> a column or row description name could not be resolved. <span class="emph">Interpreter:</span> in a formula, the column, row, or sheet that contains a referenced cell is missing.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3155984" class="tablecontentintable">525<br>#NAME?</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3148428" class="tablecontentintable">invalid names (instead of Err:525 cell contains #NAME?)</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3156259" class="tablecontentintable">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.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3153720" class="tablecontentintable">526</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3154315" class="tablecontentintable">Internal syntax error</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3083286" class="tablecontentintable">Obsolete, no longer used, but could come from old documents if the result is a formula from a domain.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3152483" class="tablecontentintable">527</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3152966" class="tablecontentintable">Internal overflow</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3149709" class="tablecontentintable">
<span class="emph">Interpreter: </span>References, such as when a cell references a cell, are too encapsulated.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3152484" class="tablecontentintable">530</p>
</td>
<td rowspan="" colspan="">
<p id="par_id4152967" class="tablecontentintable">No AddIn</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3149710" class="tablecontentintable">
<span class="emph">Interpreter: </span>AddIn not found.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id3152485" class="tablecontentintable">531</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3152967" class="tablecontentintable">No Macro</p>
</td>
<td rowspan="" colspan="">
<p id="par_id3149711" class="tablecontentintable">
<span class="emph">Interpreter: </span>Macro not found.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id5324564" class="tablecontentintable">532<br>#DIV/0!</p>
</td>
<td rowspan="" colspan="">
<p id="par_id7941831" class="tablecontentintable">Division by zero</p>
</td>
<td rowspan="" colspan="">
<p id="par_id5844294" class="tablecontentintable">Division operator / if the denominator is 0<br>Some more functions return this error, for example:<br>VARP with less than 1 argument<br>STDEVP with less than 1 argument<br>VAR with less than 2 arguments<br>STDEV with less than 2 arguments<br>STANDARDIZE with stdev=0<br>NORMDIST with stdev=0</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id231549820000708" class="tablecontentintable">533</p>
</td>
<td rowspan="" colspan="">
<p id="par_id951549820044260" class="tablecontentintable">Nested arrays are not supported</p>
</td>
<td rowspan="" colspan="">
<p id="par_id781549820065619" class="tablecontentintable"> For example, ={1;{2}} </p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id961549825716936" class="tablecontentintable">538</p>
</td>
<td rowspan="" colspan="">
<p id="par_id521549825734781" class="tablecontentintable">Error: Array or matrix size</p>
</td>
<td rowspan="" colspan="">
<p id="par_id601549825744677" class="tablecontentintable"> - </p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id41549825806618" class="tablecontentintable">539</p>
</td>
<td rowspan="" colspan="">
<p id="par_id931549825818729" class="tablecontentintable">Unsupported inline array content</p>
</td>
<td rowspan="" colspan="">
<p id="par_id551549825825905" class="tablecontentintable"> For example, ={1+2} </p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_id441549825884434" class="tablecontentintable">540</p>
</td>
<td rowspan="" colspan="">
<p id="par_id131549825893410" class="tablecontentintable">External content disabled</p>
</td>
<td rowspan="" colspan="">
<p id="par_id881549825900965" class="tablecontentintable"> Happens if a function that requires (re)loading of external sources is encountered and the user hasn't confirmed reloading of external sources yet </p>
</td>
</tr>
</table>
<br>
</div>
<div class="search-frame"></div>
<div class="donation-frame"></div>
<footer><div id="DEBUG" class="debug">
<h3 class="bug">Help content debug info:</h3>
<p>This page is: <a href="https://opengrok.libreoffice.org/xref/help/source/text/scalc/05/02140000.xhp" target="_blank">/text/scalc/05/02140000.xhp</a></p>
<p>Title is: Error Codes in %PRODUCTNAME Calc</p>
<p id="bm_module"></p>
<p id="bm_system"></p>
<p id="bm_HID"></p>
</div></footer>
</body>
</html>