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