1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 302dbb15cSAndrew Rist<!--*********************************************************** 454be4daeSmseidel * 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 1254be4daeSmseidel * 1302dbb15cSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 1454be4daeSmseidel * 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. 2154be4daeSmseidel * 2202dbb15cSAndrew Rist ***********************************************************--> 2302dbb15cSAndrew Rist 2454be4daeSmseidel<helpdocument version="1.0"> 25cdf0e10cSrcweir<meta> 2654be4daeSmseidel<topic id="textscalc0502140000xml" indexer="include" status="PUBLISH"> 2754be4daeSmseidel<title xml-lang="en-US" id="tit">Error Codes in %PRODUCTNAME Calc</title> 2854be4daeSmseidel<filename>/text/scalc/05/02140000.xhp</filename> 2954be4daeSmseidel</topic> 3054be4daeSmseidel</meta> 3154be4daeSmseidel<body> 3254be4daeSmseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3146797"> 3354be4daeSmseidel<bookmark_value>error codes;list of</bookmark_value> 34cdf0e10cSrcweir</bookmark><comment>mw deleted "%PRODUCTNAME Calc;error codes"</comment> 35cdf0e10cSrcweir<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> 3654be4daeSmseidel<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> 3754be4daeSmseidel<table id="tbl_id3147559"> 3854be4daeSmseidel<tablerow> 3954be4daeSmseidel<tablecell> 4054be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3153968" role="tablehead" l10n="U" oldref="3">Error Code</paragraph> 4154be4daeSmseidel</tablecell> 4254be4daeSmseidel<tablecell> 4354be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3125863" role="tablehead" l10n="U" oldref="4">Message</paragraph> 4454be4daeSmseidel</tablecell> 4554be4daeSmseidel<tablecell> 4654be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3151112" role="tablehead" l10n="U" oldref="5">Explanation</paragraph> 4754be4daeSmseidel</tablecell> 4854be4daeSmseidel</tablerow> 4954be4daeSmseidel<tablerow> 5054be4daeSmseidel<tablecell> 5154be4daeSmseidel<paragraph xml-lang="en-US" id="par_id1668467" role="tablecontent" l10n="NEW">###</paragraph> 5254be4daeSmseidel</tablecell> 5354be4daeSmseidel<tablecell> 5454be4daeSmseidel<bookmark xml-lang="en-US" branch="index" id="bm_id0202201010205429"> 5554be4daeSmseidel<bookmark_value>### error message</bookmark_value> 56cdf0e10cSrcweir</bookmark><comment>mw added "...error message" entry</comment> 57cdf0e10cSrcweir<paragraph xml-lang="en-US" id="par_id3165766" role="tablecontent" l10n="U" oldref="13">none</paragraph> 5854be4daeSmseidel</tablecell> 5954be4daeSmseidel<tablecell> 6054be4daeSmseidel<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> 6154be4daeSmseidel</tablecell> 6254be4daeSmseidel</tablerow> 6354be4daeSmseidel<tablerow> 6454be4daeSmseidel<tablecell> 6554be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3153188" role="tablecontent" l10n="U" oldref="6">501</paragraph> 6654be4daeSmseidel</tablecell> 6754be4daeSmseidel<tablecell> 6854be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3148645" role="tablecontent" l10n="U" oldref="7">Invalid character</paragraph> 6954be4daeSmseidel</tablecell> 7054be4daeSmseidel<tablecell> 7154be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3155854" role="tablecontent" l10n="U" oldref="8">Character in a formula is not valid.</paragraph> 7254be4daeSmseidel</tablecell> 7354be4daeSmseidel</tablerow> 7454be4daeSmseidel<tablerow> 7554be4daeSmseidel<tablecell> 7654be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3145253" role="tablecontent" l10n="U" oldref="9">502</paragraph> 7754be4daeSmseidel</tablecell> 7854be4daeSmseidel<tablecell> 7954be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3147397" role="tablecontent" l10n="U" oldref="10">Invalid argument</paragraph> 8054be4daeSmseidel</tablecell> 8154be4daeSmseidel<tablecell> 8254be4daeSmseidel<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> 8354be4daeSmseidel</tablecell> 8454be4daeSmseidel</tablerow> 8554be4daeSmseidel<tablerow> 8654be4daeSmseidel<tablecell> 8754be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3154015" role="tablecontent" l10n="U" oldref="12">503</paragraph> 8854be4daeSmseidel<paragraph xml-lang="en-US" id="par_id1628467" role="tablecontent" l10n="NEW">#NUM!</paragraph> 8954be4daeSmseidel</tablecell> 9054be4daeSmseidel<tablecell> 9154be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3155766" role="tablecontent" l10n="U" oldref="13">Invalid floating point operation</paragraph> 9254be4daeSmseidel</tablecell> 9354be4daeSmseidel<tablecell> 9454be4daeSmseidel<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> 9554be4daeSmseidel</tablecell> 9654be4daeSmseidel</tablerow> 9754be4daeSmseidel<tablerow> 9854be4daeSmseidel<tablecell> 9954be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3149258" role="tablecontent" l10n="U" oldref="15">504</paragraph> 10054be4daeSmseidel</tablecell> 10154be4daeSmseidel<tablecell> 10254be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3147344" role="tablecontent" l10n="U" oldref="16">Parameter list error</paragraph> 10354be4daeSmseidel</tablecell> 10454be4daeSmseidel<tablecell> 10554be4daeSmseidel<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> 10654be4daeSmseidel</tablecell> 10754be4daeSmseidel</tablerow> 10854be4daeSmseidel<tablerow> 10954be4daeSmseidel<tablecell> 11054be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3154532" role="tablecontent" l10n="U" oldref="27">508</paragraph> 11154be4daeSmseidel</tablecell> 11254be4daeSmseidel<tablecell> 11354be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3150107" role="tablecontent" l10n="U" oldref="28">Error: Pair missing</paragraph> 11454be4daeSmseidel</tablecell> 11554be4daeSmseidel<tablecell> 11654be4daeSmseidel<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> 11754be4daeSmseidel</tablecell> 11854be4daeSmseidel</tablerow> 11954be4daeSmseidel<tablerow> 12054be4daeSmseidel<tablecell> 12154be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3149895" role="tablecontent" l10n="U" oldref="30">509</paragraph> 12254be4daeSmseidel</tablecell> 12354be4daeSmseidel<tablecell> 12454be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3155097" role="tablecontent" l10n="U" oldref="31">Missing operator</paragraph> 12554be4daeSmseidel</tablecell> 12654be4daeSmseidel<tablecell> 12754be4daeSmseidel<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> 12854be4daeSmseidel</tablecell> 12954be4daeSmseidel</tablerow> 13054be4daeSmseidel<tablerow> 13154be4daeSmseidel<tablecell> 13254be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3153813" role="tablecontent" l10n="U" oldref="33">510</paragraph> 13354be4daeSmseidel</tablecell> 13454be4daeSmseidel<tablecell> 13554be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3153483" role="tablecontent" l10n="U" oldref="34">Missing variable</paragraph> 13654be4daeSmseidel</tablecell> 13754be4daeSmseidel<tablecell> 13854be4daeSmseidel<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> 13954be4daeSmseidel</tablecell> 14054be4daeSmseidel</tablerow> 14154be4daeSmseidel<tablerow> 14254be4daeSmseidel<tablecell> 14354be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3154739" role="tablecontent" l10n="U" oldref="36">511</paragraph> 14454be4daeSmseidel</tablecell> 14554be4daeSmseidel<tablecell> 14654be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3145112" role="tablecontent" l10n="U" oldref="37">Missing variable</paragraph> 14754be4daeSmseidel</tablecell> 14854be4daeSmseidel<tablecell> 14954be4daeSmseidel<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> 15054be4daeSmseidel</tablecell> 15154be4daeSmseidel</tablerow> 15254be4daeSmseidel<tablerow> 15354be4daeSmseidel<tablecell> 15454be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3149050" role="tablecontent" l10n="U" oldref="39">512</paragraph> 15554be4daeSmseidel</tablecell> 15654be4daeSmseidel<tablecell> 15754be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3150393" role="tablecontent" l10n="U" oldref="40">Formula overflow</paragraph> 15854be4daeSmseidel</tablecell> 15954be4daeSmseidel<tablecell> 16054be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3159259" role="tablecontent" l10n="U" oldref="41"> 16154be4daeSmseidel<emph>Compiler:</emph> the total number of internal tokens, (that is, operators, variables, brackets) in the formula exceeds 512.</paragraph> 16254be4daeSmseidel</tablecell> 16354be4daeSmseidel</tablerow> 16454be4daeSmseidel<tablerow> 16554be4daeSmseidel<tablecell> 16654be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3150537" role="tablecontent" l10n="U" oldref="42">513</paragraph> 16754be4daeSmseidel</tablecell> 16854be4daeSmseidel<tablecell> 16954be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3147412" role="tablecontent" l10n="U" oldref="43">String overflow</paragraph> 17054be4daeSmseidel</tablecell> 17154be4daeSmseidel<tablecell> 17254be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3145635" role="tablecontent" l10n="U" oldref="44"> 17354be4daeSmseidel<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> 17454be4daeSmseidel</tablecell> 17554be4daeSmseidel</tablerow> 17654be4daeSmseidel<tablerow> 17754be4daeSmseidel<tablecell> 17854be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3149147" role="tablecontent" l10n="U" oldref="45">514</paragraph> 17954be4daeSmseidel</tablecell> 18054be4daeSmseidel<tablecell> 18154be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3157904" role="tablecontent" l10n="U" oldref="46">Internal overflow</paragraph> 18254be4daeSmseidel</tablecell> 18354be4daeSmseidel<tablecell> 18454be4daeSmseidel<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> 18554be4daeSmseidel</tablecell> 18654be4daeSmseidel</tablerow> 18754be4daeSmseidel<tablerow> 18854be4daeSmseidel<tablecell> 18954be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3154841" role="tablecontent" l10n="U" oldref="51">516</paragraph> 19054be4daeSmseidel</tablecell> 19154be4daeSmseidel<tablecell> 19254be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3147423" role="tablecontent" l10n="U" oldref="52">Internal syntax error</paragraph> 19354be4daeSmseidel</tablecell> 19454be4daeSmseidel<tablecell> 19554be4daeSmseidel<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> 19654be4daeSmseidel</tablecell> 19754be4daeSmseidel</tablerow> 19854be4daeSmseidel<tablerow> 19954be4daeSmseidel<tablecell> 20054be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3155261" role="tablecontent" l10n="U" oldref="54">517</paragraph> 20154be4daeSmseidel</tablecell> 20254be4daeSmseidel<tablecell> 20354be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3153934" role="tablecontent" l10n="U" oldref="55">Internal syntax error</paragraph> 20454be4daeSmseidel</tablecell> 20554be4daeSmseidel<tablecell> 20654be4daeSmseidel<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> 20754be4daeSmseidel</tablecell> 20854be4daeSmseidel</tablerow> 20954be4daeSmseidel<tablerow> 21054be4daeSmseidel<tablecell> 21154be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3148585" role="tablecontent" l10n="U" oldref="57">518</paragraph> 21254be4daeSmseidel</tablecell> 21354be4daeSmseidel<tablecell> 21454be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3149189" role="tablecontent" l10n="U" oldref="58">Internal syntax error</paragraph> 21554be4daeSmseidel</tablecell> 21654be4daeSmseidel<tablecell> 21754be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3149545" role="tablecontent" l10n="U" oldref="59">Variable is not available</paragraph> 21854be4daeSmseidel</tablecell> 21954be4daeSmseidel</tablerow> 22054be4daeSmseidel<tablerow> 22154be4daeSmseidel<tablecell> 22254be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3146142" role="tablecontent" l10n="U" oldref="60">519</paragraph> 22354be4daeSmseidel<paragraph xml-lang="en-US" id="par_id8169499" role="tablecontent" l10n="NEW">#VALUE</paragraph> 22454be4daeSmseidel</tablecell> 22554be4daeSmseidel<tablecell> 22654be4daeSmseidel<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> 22754be4daeSmseidel</tablecell> 22854be4daeSmseidel<tablecell> 22954be4daeSmseidel<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> 23054be4daeSmseidel</tablecell> 23154be4daeSmseidel</tablerow> 23254be4daeSmseidel<tablerow> 23354be4daeSmseidel<tablecell> 23454be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3150338" role="tablecontent" l10n="U" oldref="63">520</paragraph> 23554be4daeSmseidel</tablecell> 23654be4daeSmseidel<tablecell> 23754be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3150017" role="tablecontent" l10n="U" oldref="64">Internal syntax error</paragraph> 23854be4daeSmseidel</tablecell> 23954be4daeSmseidel<tablecell> 24054be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3148758" role="tablecontent" l10n="U" oldref="65">Compiler creates an unknown compiler code.</paragraph> 24154be4daeSmseidel</tablecell> 24254be4daeSmseidel</tablerow> 24354be4daeSmseidel<tablerow> 24454be4daeSmseidel<tablecell> 24554be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3154324" role="tablecontent" l10n="U" oldref="66">521</paragraph> 24654be4daeSmseidel</tablecell> 24754be4daeSmseidel<tablecell> 24854be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3153737" role="tablecontent" l10n="U" oldref="67">Internal syntax error</paragraph> 24954be4daeSmseidel</tablecell> 25054be4daeSmseidel<tablecell> 25154be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3155436" role="tablecontent" l10n="U" oldref="68">No result.</paragraph> 25254be4daeSmseidel</tablecell> 25354be4daeSmseidel</tablerow> 25454be4daeSmseidel<tablerow> 25554be4daeSmseidel<tablecell> 25654be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3153045" role="tablecontent" l10n="U" oldref="69">522</paragraph> 25754be4daeSmseidel</tablecell> 25854be4daeSmseidel<tablecell> 25954be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3149008" role="tablecontent" l10n="U" oldref="70">Circular reference</paragraph> 26054be4daeSmseidel</tablecell> 26154be4daeSmseidel<tablecell> 26254be4daeSmseidel<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 263cdf0e10cSrcweir</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Calc - Calculate.<comment>UFI: fixes #i23854#</comment></paragraph> 26454be4daeSmseidel</tablecell> 26554be4daeSmseidel</tablerow> 26654be4daeSmseidel<tablerow> 26754be4daeSmseidel<tablecell> 26854be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3149538" role="tablecontent" l10n="U" oldref="72">523</paragraph> 26954be4daeSmseidel</tablecell> 27054be4daeSmseidel<tablecell> 27154be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3150930" role="tablecontent" l10n="U" oldref="73">The calculation procedure does not converge</paragraph> 27254be4daeSmseidel</tablecell> 27354be4daeSmseidel<tablecell> 27454be4daeSmseidel<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> 27554be4daeSmseidel</tablecell> 27654be4daeSmseidel</tablerow> 27754be4daeSmseidel<tablerow> 27854be4daeSmseidel<tablecell> 27954be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3153544" role="tablecontent" l10n="U" oldref="75">524</paragraph> 28054be4daeSmseidel<paragraph xml-lang="en-US" id="par_id2129886" role="tablecontent" l10n="NEW">#REF</paragraph> 28154be4daeSmseidel</tablecell> 28254be4daeSmseidel<tablecell> 28354be4daeSmseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3154634"> 28454be4daeSmseidel<bookmark_value>invalid references; error messages</bookmark_value> 28554be4daeSmseidel<bookmark_value>error messages;invalid references</bookmark_value> 28654be4daeSmseidel<bookmark_value>#REF error message</bookmark_value> 287cdf0e10cSrcweir</bookmark><comment>mw inserted "error..." entry</comment> 288cdf0e10cSrcweir<paragraph xml-lang="en-US" id="par_id3154634" role="tablecontent" l10n="U" oldref="76">invalid references (instead of Err:524 cell contains #REF)</paragraph> 28954be4daeSmseidel</tablecell> 29054be4daeSmseidel<tablecell> 29154be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3147539" role="tablecontent" l10n="U" oldref="77"> 29254be4daeSmseidel<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> 29354be4daeSmseidel</tablecell> 29454be4daeSmseidel</tablerow> 29554be4daeSmseidel<tablerow> 29654be4daeSmseidel<tablecell> 29754be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3155984" role="tablecontent" l10n="U" oldref="78">525</paragraph> 29854be4daeSmseidel<paragraph xml-lang="en-US" id="par_id4737083" role="tablecontent" l10n="NEW">#NAME?</paragraph> 29954be4daeSmseidel</tablecell> 30054be4daeSmseidel<tablecell> 30154be4daeSmseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3148428"> 30254be4daeSmseidel<bookmark_value>invalid names; error messages</bookmark_value> 30354be4daeSmseidel<bookmark_value>#NAME error message</bookmark_value> 304cdf0e10cSrcweir</bookmark> 305cdf0e10cSrcweir<paragraph xml-lang="en-US" id="par_id3148428" role="tablecontent" l10n="U" oldref="79">invalid names (instead of Err:525 cell contains #NAME?)</paragraph> 30654be4daeSmseidel</tablecell> 30754be4daeSmseidel<tablecell> 30854be4daeSmseidel<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> 30954be4daeSmseidel</tablecell> 31054be4daeSmseidel</tablerow> 31154be4daeSmseidel<tablerow> 31254be4daeSmseidel<tablecell> 31354be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3153720" role="tablecontent" l10n="U" oldref="81">526</paragraph> 31454be4daeSmseidel</tablecell> 31554be4daeSmseidel<tablecell> 31654be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3154315" role="tablecontent" l10n="U" oldref="82">Internal syntax error</paragraph> 31754be4daeSmseidel</tablecell> 31854be4daeSmseidel<tablecell> 31954be4daeSmseidel<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> 32054be4daeSmseidel</tablecell> 32154be4daeSmseidel</tablerow> 32254be4daeSmseidel<tablerow> 32354be4daeSmseidel<tablecell> 32454be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3152483" role="tablecontent" l10n="U" oldref="84">527</paragraph> 32554be4daeSmseidel</tablecell> 32654be4daeSmseidel<tablecell> 32754be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3152966" role="tablecontent" l10n="U" oldref="85">Internal overflow</paragraph> 32854be4daeSmseidel</tablecell> 32954be4daeSmseidel<tablecell> 33054be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3149709" role="tablecontent" l10n="U" oldref="86"> 331*7c98f0e8Smseidel<emph>Interpreter:</emph> References, such as when a cell references a cell, are too encapsulated.</paragraph> 33254be4daeSmseidel</tablecell> 33354be4daeSmseidel</tablerow> 33454be4daeSmseidel<tablerow> 33554be4daeSmseidel<tablecell> 33654be4daeSmseidel<paragraph xml-lang="en-US" id="par_id5324564" role="tablecontent" l10n="NEW">532</paragraph> 33754be4daeSmseidel<paragraph xml-lang="en-US" id="par_id3623462" role="tablecontent" l10n="NEW">#DIV/0!</paragraph> 33854be4daeSmseidel</tablecell> 33954be4daeSmseidel<tablecell> 34054be4daeSmseidel<paragraph xml-lang="en-US" id="par_id7941831" role="tablecontent" l10n="NEW">Division by zero</paragraph> 34154be4daeSmseidel</tablecell> 34254be4daeSmseidel<tablecell> 34354be4daeSmseidel<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> 34454be4daeSmseidel</tablecell> 34554be4daeSmseidel</tablerow> 34654be4daeSmseidel</table> 34754be4daeSmseidel</body> 34854be4daeSmseidel</helpdocument> 349