1<?xml version="1.0" encoding="UTF-8"?>
2
3<!--***********************************************************
4 *
5 * Licensed to the Apache Software Foundation (ASF) under one
6 * or more contributor license agreements.  See the NOTICE file
7 * distributed with this work for additional information
8 * regarding copyright ownership.  The ASF licenses this file
9 * to you under the Apache License, Version 2.0 (the
10 * "License"); you may not use this file except in compliance
11 * with the License.  You may obtain a copy of the License at
12 *
13 *   http://www.apache.org/licenses/LICENSE-2.0
14 *
15 * Unless required by applicable law or agreed to in writing,
16 * software distributed under the License is distributed on an
17 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
18 * KIND, either express or implied.  See the License for the
19 * specific language governing permissions and limitations
20 * under the License.
21 *
22 ***********************************************************-->
23
24<helpdocument version="1.0">
25<meta>
26<topic id="textscalc0502140000xml" indexer="include" status="PUBLISH">
27<title xml-lang="en-US" id="tit">Error Codes in %PRODUCTNAME Calc</title>
28<filename>/text/scalc/05/02140000.xhp</filename>
29</topic>
30</meta>
31<body>
32<bookmark xml-lang="en-US" branch="index" id="bm_id3146797">
33<bookmark_value>error codes;list of</bookmark_value>
34</bookmark><comment>mw deleted "%PRODUCTNAME Calc;error codes"</comment>
35<paragraph xml-lang="en-US" id="hd_id3146797" role="heading" level="1" l10n="U" oldref="1"><link href="text/scalc/05/02140000.xhp" name="Error Codes in %PRODUCTNAME Calc">Error Codes in <item type="productname">%PRODUCTNAME</item> Calc</link></paragraph>
36<paragraph xml-lang="en-US" id="par_id3150275" role="paragraph" l10n="U" oldref="2">The following table is an overview of the error messages for <item type="productname">%PRODUCTNAME</item> Calc. If the error occurs in the cell that contains the cursor, the error message is displayed on the <emph>Status Bar</emph>.</paragraph>
37<table id="tbl_id3147559">
38<tablerow>
39<tablecell>
40<paragraph xml-lang="en-US" id="par_id3153968" role="tablehead" l10n="U" oldref="3">Error Code</paragraph>
41</tablecell>
42<tablecell>
43<paragraph xml-lang="en-US" id="par_id3125863" role="tablehead" l10n="U" oldref="4">Message</paragraph>
44</tablecell>
45<tablecell>
46<paragraph xml-lang="en-US" id="par_id3151112" role="tablehead" l10n="U" oldref="5">Explanation</paragraph>
47</tablecell>
48</tablerow>
49<tablerow>
50<tablecell>
51<paragraph xml-lang="en-US" id="par_id1668467" role="tablecontent" l10n="NEW">###</paragraph>
52</tablecell>
53<tablecell>
54<bookmark xml-lang="en-US" branch="index" id="bm_id0202201010205429">
55<bookmark_value>### error message</bookmark_value>
56</bookmark><comment>mw added "...error message" entry</comment>
57<paragraph xml-lang="en-US" id="par_id3165766" role="tablecontent" l10n="U" oldref="13">none</paragraph>
58</tablecell>
59<tablecell>
60<paragraph xml-lang="en-US" id="par_id3169266" role="tablecontent" l10n="CHG" oldref="14">The cell is not wide enough to display the contents.</paragraph>
61</tablecell>
62</tablerow>
63<tablerow>
64<tablecell>
65<paragraph xml-lang="en-US" id="par_id3153188" role="tablecontent" l10n="U" oldref="6">501</paragraph>
66</tablecell>
67<tablecell>
68<paragraph xml-lang="en-US" id="par_id3148645" role="tablecontent" l10n="U" oldref="7">Invalid character</paragraph>
69</tablecell>
70<tablecell>
71<paragraph xml-lang="en-US" id="par_id3155854" role="tablecontent" l10n="U" oldref="8">Character in a formula is not valid.</paragraph>
72</tablecell>
73</tablerow>
74<tablerow>
75<tablecell>
76<paragraph xml-lang="en-US" id="par_id3145253" role="tablecontent" l10n="U" oldref="9">502</paragraph>
77</tablecell>
78<tablecell>
79<paragraph xml-lang="en-US" id="par_id3147397" role="tablecontent" l10n="U" oldref="10">Invalid argument</paragraph>
80</tablecell>
81<tablecell>
82<paragraph xml-lang="en-US" id="par_id3153160" role="tablecontent" l10n="U" oldref="11">Function argument is not valid, for example, a negative number for the root function.</paragraph>
83</tablecell>
84</tablerow>
85<tablerow>
86<tablecell>
87<paragraph xml-lang="en-US" id="par_id3154015" role="tablecontent" l10n="U" oldref="12">503</paragraph>
88<paragraph xml-lang="en-US" id="par_id1628467" role="tablecontent" l10n="NEW">#NUM!</paragraph>
89</tablecell>
90<tablecell>
91<paragraph xml-lang="en-US" id="par_id3155766" role="tablecontent" l10n="U" oldref="13">Invalid floating point operation</paragraph>
92</tablecell>
93<tablecell>
94<paragraph xml-lang="en-US" id="par_id3159266" role="tablecontent" l10n="CHG" oldref="14">A calculation results in an overflow of the defined value range.</paragraph>
95</tablecell>
96</tablerow>
97<tablerow>
98<tablecell>
99<paragraph xml-lang="en-US" id="par_id3149258" role="tablecontent" l10n="U" oldref="15">504</paragraph>
100</tablecell>
101<tablecell>
102<paragraph xml-lang="en-US" id="par_id3147344" role="tablecontent" l10n="U" oldref="16">Parameter list error</paragraph>
103</tablecell>
104<tablecell>
105<paragraph xml-lang="en-US" id="par_id3147003" role="tablecontent" l10n="U" oldref="17">Function parameter is not valid, for example, text instead of a number, or a domain reference instead of cell reference.</paragraph>
106</tablecell>
107</tablerow>
108<tablerow>
109<tablecell>
110<paragraph xml-lang="en-US" id="par_id3154532" role="tablecontent" l10n="U" oldref="27">508</paragraph>
111</tablecell>
112<tablecell>
113<paragraph xml-lang="en-US" id="par_id3150107" role="tablecontent" l10n="U" oldref="28">Error: Pair missing</paragraph>
114</tablecell>
115<tablecell>
116<paragraph xml-lang="en-US" id="par_id3149129" role="tablecontent" l10n="U" oldref="29">Missing bracket, for example, closing brackets, but no opening brackets</paragraph>
117</tablecell>
118</tablerow>
119<tablerow>
120<tablecell>
121<paragraph xml-lang="en-US" id="par_id3149895" role="tablecontent" l10n="U" oldref="30">509</paragraph>
122</tablecell>
123<tablecell>
124<paragraph xml-lang="en-US" id="par_id3155097" role="tablecontent" l10n="U" oldref="31">Missing operator</paragraph>
125</tablecell>
126<tablecell>
127<paragraph xml-lang="en-US" id="par_id3154649" role="tablecontent" l10n="U" oldref="32">Operator is missing, for example, "=2(3+4) * ", where the operator between "2" and "(" is missing.</paragraph>
128</tablecell>
129</tablerow>
130<tablerow>
131<tablecell>
132<paragraph xml-lang="en-US" id="par_id3153813" role="tablecontent" l10n="U" oldref="33">510</paragraph>
133</tablecell>
134<tablecell>
135<paragraph xml-lang="en-US" id="par_id3153483" role="tablecontent" l10n="U" oldref="34">Missing variable</paragraph>
136</tablecell>
137<tablecell>
138<paragraph xml-lang="en-US" id="par_id3154710" role="tablecontent" l10n="U" oldref="35">Variable is missing, for example when two operators are together "=1+*2".</paragraph>
139</tablecell>
140</tablerow>
141<tablerow>
142<tablecell>
143<paragraph xml-lang="en-US" id="par_id3154739" role="tablecontent" l10n="U" oldref="36">511</paragraph>
144</tablecell>
145<tablecell>
146<paragraph xml-lang="en-US" id="par_id3145112" role="tablecontent" l10n="U" oldref="37">Missing variable</paragraph>
147</tablecell>
148<tablecell>
149<paragraph xml-lang="en-US" id="par_id3145319" role="tablecontent" l10n="U" oldref="38">Function requires more variables than are provided, for example, AND() and OR().</paragraph>
150</tablecell>
151</tablerow>
152<tablerow>
153<tablecell>
154<paragraph xml-lang="en-US" id="par_id3149050" role="tablecontent" l10n="U" oldref="39">512</paragraph>
155</tablecell>
156<tablecell>
157<paragraph xml-lang="en-US" id="par_id3150393" role="tablecontent" l10n="U" oldref="40">Formula overflow</paragraph>
158</tablecell>
159<tablecell>
160<paragraph xml-lang="en-US" id="par_id3159259" role="tablecontent" l10n="U" oldref="41">
161<emph>Compiler:</emph> the total number of internal tokens, (that is, operators, variables, brackets) in the formula exceeds 512.</paragraph>
162</tablecell>
163</tablerow>
164<tablerow>
165<tablecell>
166<paragraph xml-lang="en-US" id="par_id3150537" role="tablecontent" l10n="U" oldref="42">513</paragraph>
167</tablecell>
168<tablecell>
169<paragraph xml-lang="en-US" id="par_id3147412" role="tablecontent" l10n="U" oldref="43">String overflow</paragraph>
170</tablecell>
171<tablecell>
172<paragraph xml-lang="en-US" id="par_id3145635" role="tablecontent" l10n="U" oldref="44">
173<emph>Compiler:</emph> an identifier in the formula exceeds 64 KB in size. <emph>Interpreter:</emph> a result of a string operation exceeds 64 KB in size.</paragraph>
174</tablecell>
175</tablerow>
176<tablerow>
177<tablecell>
178<paragraph xml-lang="en-US" id="par_id3149147" role="tablecontent" l10n="U" oldref="45">514</paragraph>
179</tablecell>
180<tablecell>
181<paragraph xml-lang="en-US" id="par_id3157904" role="tablecontent" l10n="U" oldref="46">Internal overflow</paragraph>
182</tablecell>
183<tablecell>
184<paragraph xml-lang="en-US" id="par_id3149352" role="tablecontent" l10n="U" oldref="47">Sort operation attempted on too much numerical data (max. 100000) or a calculation stack overflow.</paragraph>
185</tablecell>
186</tablerow>
187<tablerow>
188<tablecell>
189<paragraph xml-lang="en-US" id="par_id3154841" role="tablecontent" l10n="U" oldref="51">516</paragraph>
190</tablecell>
191<tablecell>
192<paragraph xml-lang="en-US" id="par_id3147423" role="tablecontent" l10n="U" oldref="52">Internal syntax error</paragraph>
193</tablecell>
194<tablecell>
195<paragraph xml-lang="en-US" id="par_id3148437" role="tablecontent" l10n="U" oldref="53">Matrix is expected on the calculation stack, but is not available.</paragraph>
196</tablecell>
197</tablerow>
198<tablerow>
199<tablecell>
200<paragraph xml-lang="en-US" id="par_id3155261" role="tablecontent" l10n="U" oldref="54">517</paragraph>
201</tablecell>
202<tablecell>
203<paragraph xml-lang="en-US" id="par_id3153934" role="tablecontent" l10n="U" oldref="55">Internal syntax error</paragraph>
204</tablecell>
205<tablecell>
206<paragraph xml-lang="en-US" id="par_id3149507" role="tablecontent" l10n="U" oldref="56">Unknown code, for example, a document with a newer function is loaded in an older version that does not contain the function.</paragraph>
207</tablecell>
208</tablerow>
209<tablerow>
210<tablecell>
211<paragraph xml-lang="en-US" id="par_id3148585" role="tablecontent" l10n="U" oldref="57">518</paragraph>
212</tablecell>
213<tablecell>
214<paragraph xml-lang="en-US" id="par_id3149189" role="tablecontent" l10n="U" oldref="58">Internal syntax error</paragraph>
215</tablecell>
216<tablecell>
217<paragraph xml-lang="en-US" id="par_id3149545" role="tablecontent" l10n="U" oldref="59">Variable is not available</paragraph>
218</tablecell>
219</tablerow>
220<tablerow>
221<tablecell>
222<paragraph xml-lang="en-US" id="par_id3146142" role="tablecontent" l10n="U" oldref="60">519</paragraph>
223<paragraph xml-lang="en-US" id="par_id8169499" role="tablecontent" l10n="NEW">#VALUE</paragraph>
224</tablecell>
225<tablecell>
226<paragraph xml-lang="en-US" id="par_id3155954" role="tablecontent" l10n="U" oldref="61">No result (#VALUE is in the cell rather than Err:519!)</paragraph>
227</tablecell>
228<tablecell>
229<paragraph xml-lang="en-US" id="par_id3153108" role="tablecontent" l10n="CHG" oldref="62">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.<comment>i63264</comment></paragraph>
230</tablecell>
231</tablerow>
232<tablerow>
233<tablecell>
234<paragraph xml-lang="en-US" id="par_id3150338" role="tablecontent" l10n="U" oldref="63">520</paragraph>
235</tablecell>
236<tablecell>
237<paragraph xml-lang="en-US" id="par_id3150017" role="tablecontent" l10n="U" oldref="64">Internal syntax error</paragraph>
238</tablecell>
239<tablecell>
240<paragraph xml-lang="en-US" id="par_id3148758" role="tablecontent" l10n="U" oldref="65">Compiler creates an unknown compiler code.</paragraph>
241</tablecell>
242</tablerow>
243<tablerow>
244<tablecell>
245<paragraph xml-lang="en-US" id="par_id3154324" role="tablecontent" l10n="U" oldref="66">521</paragraph>
246</tablecell>
247<tablecell>
248<paragraph xml-lang="en-US" id="par_id3153737" role="tablecontent" l10n="U" oldref="67">Internal syntax error</paragraph>
249</tablecell>
250<tablecell>
251<paragraph xml-lang="en-US" id="par_id3155436" role="tablecontent" l10n="U" oldref="68">No result.</paragraph>
252</tablecell>
253</tablerow>
254<tablerow>
255<tablecell>
256<paragraph xml-lang="en-US" id="par_id3153045" role="tablecontent" l10n="U" oldref="69">522</paragraph>
257</tablecell>
258<tablecell>
259<paragraph xml-lang="en-US" id="par_id3149008" role="tablecontent" l10n="U" oldref="70">Circular reference</paragraph>
260</tablecell>
261<tablecell>
262<paragraph xml-lang="en-US" id="par_id3157972" role="tablecontent" l10n="CHG" oldref="71">Formula refers directly or indirectly to itself and the <emph>Iterations</emph> option is not set under <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences
263</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Calc - Calculate.<comment>UFI: fixes #i23854#</comment></paragraph>
264</tablecell>
265</tablerow>
266<tablerow>
267<tablecell>
268<paragraph xml-lang="en-US" id="par_id3149538" role="tablecontent" l10n="U" oldref="72">523</paragraph>
269</tablecell>
270<tablecell>
271<paragraph xml-lang="en-US" id="par_id3150930" role="tablecontent" l10n="U" oldref="73">The calculation procedure does not converge</paragraph>
272</tablecell>
273<tablecell>
274<paragraph xml-lang="en-US" id="par_id3150272" role="tablecontent" l10n="CHG" oldref="74">Function missed a targeted value, or <link href="text/shared/optionen/01060500.xhp">iterative references</link> do not reach the minimum change within the maximum steps that are set.<comment>UFI: see #33769#</comment></paragraph>
275</tablecell>
276</tablerow>
277<tablerow>
278<tablecell>
279<paragraph xml-lang="en-US" id="par_id3153544" role="tablecontent" l10n="U" oldref="75">524</paragraph>
280<paragraph xml-lang="en-US" id="par_id2129886" role="tablecontent" l10n="NEW">#REF</paragraph>
281</tablecell>
282<tablecell>
283<bookmark xml-lang="en-US" branch="index" id="bm_id3154634">
284<bookmark_value>invalid references; error messages</bookmark_value>
285<bookmark_value>error messages;invalid references</bookmark_value>
286<bookmark_value>#REF error message</bookmark_value>
287</bookmark><comment>mw inserted "error..." entry</comment>
288<paragraph xml-lang="en-US" id="par_id3154634" role="tablecontent" l10n="U" oldref="76">invalid references (instead of Err:524 cell contains #REF)</paragraph>
289</tablecell>
290<tablecell>
291<paragraph xml-lang="en-US" id="par_id3147539" role="tablecontent" l10n="U" oldref="77">
292<emph>Compiler:</emph> a column or row description name could not be resolved. <emph>Interpreter:</emph> in a formula, the column, row, or sheet that contains a referenced cell is missing.</paragraph>
293</tablecell>
294</tablerow>
295<tablerow>
296<tablecell>
297<paragraph xml-lang="en-US" id="par_id3155984" role="tablecontent" l10n="U" oldref="78">525</paragraph>
298<paragraph xml-lang="en-US" id="par_id4737083" role="tablecontent" l10n="NEW">#NAME?</paragraph>
299</tablecell>
300<tablecell>
301<bookmark xml-lang="en-US" branch="index" id="bm_id3148428">
302<bookmark_value>invalid names; error messages</bookmark_value>
303<bookmark_value>#NAME error message</bookmark_value>
304</bookmark>
305<paragraph xml-lang="en-US" id="par_id3148428" role="tablecontent" l10n="U" oldref="79">invalid names (instead of Err:525 cell contains #NAME?)</paragraph>
306</tablecell>
307<tablecell>
308<paragraph xml-lang="en-US" id="par_id3156259" role="tablecontent" l10n="U" oldref="80">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.</paragraph>
309</tablecell>
310</tablerow>
311<tablerow>
312<tablecell>
313<paragraph xml-lang="en-US" id="par_id3153720" role="tablecontent" l10n="U" oldref="81">526</paragraph>
314</tablecell>
315<tablecell>
316<paragraph xml-lang="en-US" id="par_id3154315" role="tablecontent" l10n="U" oldref="82">Internal syntax error</paragraph>
317</tablecell>
318<tablecell>
319<paragraph xml-lang="en-US" id="par_id3083286" role="tablecontent" l10n="U" oldref="83">Obsolete, no longer used, but could come from old documents if the result is a formula from a domain.</paragraph>
320</tablecell>
321</tablerow>
322<tablerow>
323<tablecell>
324<paragraph xml-lang="en-US" id="par_id3152483" role="tablecontent" l10n="U" oldref="84">527</paragraph>
325</tablecell>
326<tablecell>
327<paragraph xml-lang="en-US" id="par_id3152966" role="tablecontent" l10n="U" oldref="85">Internal overflow</paragraph>
328</tablecell>
329<tablecell>
330<paragraph xml-lang="en-US" id="par_id3149709" role="tablecontent" l10n="U" oldref="86">
331<emph>Interpreter:</emph> References, such as when a cell references a cell, are too encapsulated.</paragraph>
332</tablecell>
333</tablerow>
334<tablerow>
335<tablecell>
336<paragraph xml-lang="en-US" id="par_id5324564" role="tablecontent" l10n="NEW">532</paragraph>
337<paragraph xml-lang="en-US" id="par_id3623462" role="tablecontent" l10n="NEW">#DIV/0!</paragraph>
338</tablecell>
339<tablecell>
340<paragraph xml-lang="en-US" id="par_id7941831" role="tablecontent" l10n="NEW">Division by zero</paragraph>
341</tablecell>
342<tablecell>
343<paragraph xml-lang="en-US" id="par_id5844294" role="tablecontent" l10n="NEW">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</paragraph>
344</tablecell>
345</tablerow>
346</table>
347</body>
348</helpdocument>
349