1<?xml version="1.0" encoding="UTF-8"?> 2<helpdocument version="1.0"> 3 4<!-- 5*********************************************************************** 6 * 7 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 8 * 9 * Copyright 2000, 2010 Oracle and/or its affiliates. 10 * 11 * OpenOffice.org - a multi-platform office productivity suite 12 * 13 * This file is part of OpenOffice.org. 14 * 15 * OpenOffice.org is free software: you can redistribute it and/or modify 16 * it under the terms of the GNU Lesser General Public License version 3 17 * only, as published by the Free Software Foundation. 18 * 19 * OpenOffice.org is distributed in the hope that it will be useful, 20 * but WITHOUT ANY WARRANTY; without even the implied warranty of 21 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 22 * GNU Lesser General Public License version 3 for more details 23 * (a copy is included in the LICENSE file that accompanied this code). 24 * 25 * You should have received a copy of the GNU Lesser General Public License 26 * version 3 along with OpenOffice.org. If not, see 27 * <http://www.openoffice.org/license.html> 28 * for a copy of the LGPLv3 License. 29 * 30 ************************************************************************ 31 --> 32 33 34<meta> 35 <topic id="textscalc0502140000xml" indexer="include" status="PUBLISH"> 36 <title xml-lang="en-US" id="tit">Error Codes in %PRODUCTNAME Calc</title> 37 <filename>/text/scalc/05/02140000.xhp</filename> 38 </topic> 39 </meta> 40 <body> 41<bookmark xml-lang="en-US" branch="index" id="bm_id3146797"><bookmark_value>error codes;list of</bookmark_value> 42</bookmark><comment>mw deleted "%PRODUCTNAME Calc;error codes"</comment> 43<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> 44 <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> 45 <table id="tbl_id3147559"> 46 <tablerow> 47 <tablecell> 48 <paragraph xml-lang="en-US" id="par_id3153968" role="tablehead" l10n="U" oldref="3">Error Code</paragraph> 49 </tablecell> 50 <tablecell> 51 <paragraph xml-lang="en-US" id="par_id3125863" role="tablehead" l10n="U" oldref="4">Message</paragraph> 52 </tablecell> 53 <tablecell> 54 <paragraph xml-lang="en-US" id="par_id3151112" role="tablehead" l10n="U" oldref="5">Explanation</paragraph> 55 </tablecell> 56 </tablerow> 57 <tablerow> 58 <tablecell> 59 <paragraph xml-lang="en-US" id="par_id1668467" role="tablecontent" l10n="NEW">###</paragraph> 60 </tablecell> 61 <tablecell> 62<bookmark xml-lang="en-US" branch="index" id="bm_id0202201010205429"><bookmark_value>### error message</bookmark_value> 63</bookmark><comment>mw added "...error message" entry</comment> 64<paragraph xml-lang="en-US" id="par_id3165766" role="tablecontent" l10n="U" oldref="13">none</paragraph> 65 </tablecell> 66 <tablecell> 67 <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> 68 </tablecell> 69 </tablerow> 70 <tablerow> 71 <tablecell> 72 <paragraph xml-lang="en-US" id="par_id3153188" role="tablecontent" l10n="U" oldref="6">501</paragraph> 73 </tablecell> 74 <tablecell> 75 <paragraph xml-lang="en-US" id="par_id3148645" role="tablecontent" l10n="U" oldref="7">Invalid character</paragraph> 76 </tablecell> 77 <tablecell> 78 <paragraph xml-lang="en-US" id="par_id3155854" role="tablecontent" l10n="U" oldref="8">Character in a formula is not valid.</paragraph> 79 </tablecell> 80 </tablerow> 81 <tablerow> 82 <tablecell> 83 <paragraph xml-lang="en-US" id="par_id3145253" role="tablecontent" l10n="U" oldref="9">502</paragraph> 84 </tablecell> 85 <tablecell> 86 <paragraph xml-lang="en-US" id="par_id3147397" role="tablecontent" l10n="U" oldref="10">Invalid argument</paragraph> 87 </tablecell> 88 <tablecell> 89 <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> 90 </tablecell> 91 </tablerow> 92 <tablerow> 93 <tablecell> 94 <paragraph xml-lang="en-US" id="par_id3154015" role="tablecontent" l10n="U" oldref="12">503</paragraph> 95 <paragraph xml-lang="en-US" id="par_id1628467" role="tablecontent" l10n="NEW">#NUM!</paragraph> 96 </tablecell> 97 <tablecell> 98 <paragraph xml-lang="en-US" id="par_id3155766" role="tablecontent" l10n="U" oldref="13">Invalid floating point operation</paragraph> 99 </tablecell> 100 <tablecell> 101 <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> 102 </tablecell> 103 </tablerow> 104 <tablerow> 105 <tablecell> 106 <paragraph xml-lang="en-US" id="par_id3149258" role="tablecontent" l10n="U" oldref="15">504</paragraph> 107 </tablecell> 108 <tablecell> 109 <paragraph xml-lang="en-US" id="par_id3147344" role="tablecontent" l10n="U" oldref="16">Parameter list error</paragraph> 110 </tablecell> 111 <tablecell> 112 <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> 113 </tablecell> 114 </tablerow> 115 <tablerow> 116 <tablecell> 117 <paragraph xml-lang="en-US" id="par_id3154532" role="tablecontent" l10n="U" oldref="27">508</paragraph> 118 </tablecell> 119 <tablecell> 120 <paragraph xml-lang="en-US" id="par_id3150107" role="tablecontent" l10n="U" oldref="28">Error: Pair missing</paragraph> 121 </tablecell> 122 <tablecell> 123 <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> 124 </tablecell> 125 </tablerow> 126 <tablerow> 127 <tablecell> 128 <paragraph xml-lang="en-US" id="par_id3149895" role="tablecontent" l10n="U" oldref="30">509</paragraph> 129 </tablecell> 130 <tablecell> 131 <paragraph xml-lang="en-US" id="par_id3155097" role="tablecontent" l10n="U" oldref="31">Missing operator</paragraph> 132 </tablecell> 133 <tablecell> 134 <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> 135 </tablecell> 136 </tablerow> 137 <tablerow> 138 <tablecell> 139 <paragraph xml-lang="en-US" id="par_id3153813" role="tablecontent" l10n="U" oldref="33">510</paragraph> 140 </tablecell> 141 <tablecell> 142 <paragraph xml-lang="en-US" id="par_id3153483" role="tablecontent" l10n="U" oldref="34">Missing variable</paragraph> 143 </tablecell> 144 <tablecell> 145 <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> 146 </tablecell> 147 </tablerow> 148 <tablerow> 149 <tablecell> 150 <paragraph xml-lang="en-US" id="par_id3154739" role="tablecontent" l10n="U" oldref="36">511</paragraph> 151 </tablecell> 152 <tablecell> 153 <paragraph xml-lang="en-US" id="par_id3145112" role="tablecontent" l10n="U" oldref="37">Missing variable</paragraph> 154 </tablecell> 155 <tablecell> 156 <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> 157 </tablecell> 158 </tablerow> 159 <tablerow> 160 <tablecell> 161 <paragraph xml-lang="en-US" id="par_id3149050" role="tablecontent" l10n="U" oldref="39">512</paragraph> 162 </tablecell> 163 <tablecell> 164 <paragraph xml-lang="en-US" id="par_id3150393" role="tablecontent" l10n="U" oldref="40">Formula overflow</paragraph> 165 </tablecell> 166 <tablecell> 167 <paragraph xml-lang="en-US" id="par_id3159259" role="tablecontent" l10n="U" oldref="41"> 168 <emph>Compiler:</emph> the total number of internal tokens, (that is, operators, variables, brackets) in the formula exceeds 512.</paragraph> 169 </tablecell> 170 </tablerow> 171 <tablerow> 172 <tablecell> 173 <paragraph xml-lang="en-US" id="par_id3150537" role="tablecontent" l10n="U" oldref="42">513</paragraph> 174 </tablecell> 175 <tablecell> 176 <paragraph xml-lang="en-US" id="par_id3147412" role="tablecontent" l10n="U" oldref="43">String overflow</paragraph> 177 </tablecell> 178 <tablecell> 179 <paragraph xml-lang="en-US" id="par_id3145635" role="tablecontent" l10n="U" oldref="44"> 180 <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> 181 </tablecell> 182 </tablerow> 183 <tablerow> 184 <tablecell> 185 <paragraph xml-lang="en-US" id="par_id3149147" role="tablecontent" l10n="U" oldref="45">514</paragraph> 186 </tablecell> 187 <tablecell> 188 <paragraph xml-lang="en-US" id="par_id3157904" role="tablecontent" l10n="U" oldref="46">Internal overflow</paragraph> 189 </tablecell> 190 <tablecell> 191 <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> 192 </tablecell> 193 </tablerow> 194 <tablerow> 195 <tablecell> 196 <paragraph xml-lang="en-US" id="par_id3154841" role="tablecontent" l10n="U" oldref="51">516</paragraph> 197 </tablecell> 198 <tablecell> 199 <paragraph xml-lang="en-US" id="par_id3147423" role="tablecontent" l10n="U" oldref="52">Internal syntax error</paragraph> 200 </tablecell> 201 <tablecell> 202 <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> 203 </tablecell> 204 </tablerow> 205 <tablerow> 206 <tablecell> 207 <paragraph xml-lang="en-US" id="par_id3155261" role="tablecontent" l10n="U" oldref="54">517</paragraph> 208 </tablecell> 209 <tablecell> 210 <paragraph xml-lang="en-US" id="par_id3153934" role="tablecontent" l10n="U" oldref="55">Internal syntax error</paragraph> 211 </tablecell> 212 <tablecell> 213 <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> 214 </tablecell> 215 </tablerow> 216 <tablerow> 217 <tablecell> 218 <paragraph xml-lang="en-US" id="par_id3148585" role="tablecontent" l10n="U" oldref="57">518</paragraph> 219 </tablecell> 220 <tablecell> 221 <paragraph xml-lang="en-US" id="par_id3149189" role="tablecontent" l10n="U" oldref="58">Internal syntax error</paragraph> 222 </tablecell> 223 <tablecell> 224 <paragraph xml-lang="en-US" id="par_id3149545" role="tablecontent" l10n="U" oldref="59">Variable is not available</paragraph> 225 </tablecell> 226 </tablerow> 227 <tablerow> 228 <tablecell> 229 <paragraph xml-lang="en-US" id="par_id3146142" role="tablecontent" l10n="U" oldref="60">519</paragraph> 230 <paragraph xml-lang="en-US" id="par_id8169499" role="tablecontent" l10n="NEW">#VALUE</paragraph> 231 </tablecell> 232 <tablecell> 233 <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> 234 </tablecell> 235 <tablecell> 236 <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> 237 </tablecell> 238 </tablerow> 239 <tablerow> 240 <tablecell> 241 <paragraph xml-lang="en-US" id="par_id3150338" role="tablecontent" l10n="U" oldref="63">520</paragraph> 242 </tablecell> 243 <tablecell> 244 <paragraph xml-lang="en-US" id="par_id3150017" role="tablecontent" l10n="U" oldref="64">Internal syntax error</paragraph> 245 </tablecell> 246 <tablecell> 247 <paragraph xml-lang="en-US" id="par_id3148758" role="tablecontent" l10n="U" oldref="65">Compiler creates an unknown compiler code.</paragraph> 248 </tablecell> 249 </tablerow> 250 <tablerow> 251 <tablecell> 252 <paragraph xml-lang="en-US" id="par_id3154324" role="tablecontent" l10n="U" oldref="66">521</paragraph> 253 </tablecell> 254 <tablecell> 255 <paragraph xml-lang="en-US" id="par_id3153737" role="tablecontent" l10n="U" oldref="67">Internal syntax error</paragraph> 256 </tablecell> 257 <tablecell> 258 <paragraph xml-lang="en-US" id="par_id3155436" role="tablecontent" l10n="U" oldref="68">No result.</paragraph> 259 </tablecell> 260 </tablerow> 261 <tablerow> 262 <tablecell> 263 <paragraph xml-lang="en-US" id="par_id3153045" role="tablecontent" l10n="U" oldref="69">522</paragraph> 264 </tablecell> 265 <tablecell> 266 <paragraph xml-lang="en-US" id="par_id3149008" role="tablecontent" l10n="U" oldref="70">Circular reference</paragraph> 267 </tablecell> 268 <tablecell> 269 <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 270</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Calc - Calculate.<comment>UFI: fixes #i23854#</comment></paragraph> 271 </tablecell> 272 </tablerow> 273 <tablerow> 274 <tablecell> 275 <paragraph xml-lang="en-US" id="par_id3149538" role="tablecontent" l10n="U" oldref="72">523</paragraph> 276 </tablecell> 277 <tablecell> 278 <paragraph xml-lang="en-US" id="par_id3150930" role="tablecontent" l10n="U" oldref="73">The calculation procedure does not converge</paragraph> 279 </tablecell> 280 <tablecell> 281 <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> 282 </tablecell> 283 </tablerow> 284 <tablerow> 285 <tablecell> 286 <paragraph xml-lang="en-US" id="par_id3153544" role="tablecontent" l10n="U" oldref="75">524</paragraph> 287 <paragraph xml-lang="en-US" id="par_id2129886" role="tablecontent" l10n="NEW">#REF</paragraph> 288 </tablecell> 289 <tablecell> 290<bookmark xml-lang="en-US" branch="index" id="bm_id3154634"><bookmark_value>invalid references; error messages</bookmark_value> 291 <bookmark_value>error messages;invalid references</bookmark_value> 292 <bookmark_value>#REF error message</bookmark_value> 293</bookmark><comment>mw inserted "error..." entry</comment> 294<paragraph xml-lang="en-US" id="par_id3154634" role="tablecontent" l10n="U" oldref="76">invalid references (instead of Err:524 cell contains #REF)</paragraph> 295 </tablecell> 296 <tablecell> 297 <paragraph xml-lang="en-US" id="par_id3147539" role="tablecontent" l10n="U" oldref="77"> 298 <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> 299 </tablecell> 300 </tablerow> 301 <tablerow> 302 <tablecell> 303 <paragraph xml-lang="en-US" id="par_id3155984" role="tablecontent" l10n="U" oldref="78">525</paragraph> 304 <paragraph xml-lang="en-US" id="par_id4737083" role="tablecontent" l10n="NEW">#NAME?</paragraph> 305 </tablecell> 306 <tablecell> 307<bookmark xml-lang="en-US" branch="index" id="bm_id3148428"><bookmark_value>invalid names; error messages</bookmark_value> 308 <bookmark_value>#NAME error message</bookmark_value> 309</bookmark> 310<paragraph xml-lang="en-US" id="par_id3148428" role="tablecontent" l10n="U" oldref="79">invalid names (instead of Err:525 cell contains #NAME?)</paragraph> 311 </tablecell> 312 <tablecell> 313 <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> 314 </tablecell> 315 </tablerow> 316 <tablerow> 317 <tablecell> 318 <paragraph xml-lang="en-US" id="par_id3153720" role="tablecontent" l10n="U" oldref="81">526</paragraph> 319 </tablecell> 320 <tablecell> 321 <paragraph xml-lang="en-US" id="par_id3154315" role="tablecontent" l10n="U" oldref="82">Internal syntax error</paragraph> 322 </tablecell> 323 <tablecell> 324 <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> 325 </tablecell> 326 </tablerow> 327 <tablerow> 328 <tablecell> 329 <paragraph xml-lang="en-US" id="par_id3152483" role="tablecontent" l10n="U" oldref="84">527</paragraph> 330 </tablecell> 331 <tablecell> 332 <paragraph xml-lang="en-US" id="par_id3152966" role="tablecontent" l10n="U" oldref="85">Internal overflow</paragraph> 333 </tablecell> 334 <tablecell> 335 <paragraph xml-lang="en-US" id="par_id3149709" role="tablecontent" l10n="U" oldref="86"> 336 <emph>Interpreter: </emph>References, such as when a cell references a cell, are too encapsulated.</paragraph> 337 </tablecell> 338 </tablerow> 339 <tablerow> 340 <tablecell> 341 <paragraph xml-lang="en-US" id="par_id5324564" role="tablecontent" l10n="NEW">532</paragraph> 342 <paragraph xml-lang="en-US" id="par_id3623462" role="tablecontent" l10n="NEW">#DIV/0!</paragraph> 343 </tablecell> 344 <tablecell> 345 <paragraph xml-lang="en-US" id="par_id7941831" role="tablecontent" l10n="NEW">Division by zero</paragraph> 346 </tablecell> 347 <tablecell> 348 <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> 349 </tablecell> 350 </tablerow> 351 </table> 352 353 </body> 354</helpdocument>