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