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