helpcontent2/source/text/scalc/05/02140000.xhp

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