summaryrefslogtreecommitdiff
path: root/helpcontent2/source/text/scalc/05
diff options
context:
space:
mode:
authorFrank Peters <fpe@openoffice.org>2004-08-18 09:59:46 +0000
committerFrank Peters <fpe@openoffice.org>2004-08-18 09:59:46 +0000
commit4f48bcc7937fbc586af7720d4225768ee6913e2a (patch)
tree431c32101c9b8349fe8f420615df796296d69a90 /helpcontent2/source/text/scalc/05
#i33146# Initial checkin
Diffstat (limited to 'helpcontent2/source/text/scalc/05')
-rwxr-xr-xhelpcontent2/source/text/scalc/05/02140000.xhp352
-rw-r--r--helpcontent2/source/text/scalc/05/makefile.mk40
2 files changed, 392 insertions, 0 deletions
diff --git a/helpcontent2/source/text/scalc/05/02140000.xhp b/helpcontent2/source/text/scalc/05/02140000.xhp
new file mode 100755
index 0000000000..d59e7df043
--- /dev/null
+++ b/helpcontent2/source/text/scalc/05/02140000.xhp
@@ -0,0 +1,352 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--***********************************************************************
+ *
+ * The Contents of this file are made available subject to the terms of
+ * either of the following licenses
+ *
+ * - GNU Lesser General Public License Version 2.1
+ * - Sun Industry Standards Source License Version 1.1
+ *
+ * Sun Microsystems Inc., October, 2000
+ *
+ * GNU Lesser General Public License Version 2.1
+ * =============================================
+ * Copyright 2000 by Sun Microsystems, Inc.
+ * 901 San Antonio Road, Palo Alto, CA 94303, USA
+ *
+ * This library is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU Lesser General Public
+ * License version 2.1, as published by the Free Software Foundation.
+ *
+ * This library is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
+ * Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public
+ * License along with this library; if not, write to the Free Software
+ * Foundation, Inc., 59 Temple Place, Suite 330, Boston,
+ * MA 02111-1307 USA
+ *
+ *
+ * Sun Industry Standards Source License Version 1.1
+ * =================================================
+ * The contents of this file are subject to the Sun Industry Standards
+ * Source License Version 1.1 (the "License"); You may not use this file
+ * except in compliance with the License. You may obtain a copy of the
+ * License at http://www.openoffice.org/license.html.
+ *
+ * Software provided under this License is provided on an "AS IS" basis,
+ * WITHOUT WARRUNTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING,
+ * WITHOUT LIMITATION, WARRUNTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
+ * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
+ * See the License for the specific provisions governing your rights and
+ * obligations concerning the Software.
+ *
+ * The Initial Developer of the Original Code is: Sun Microsystems, Inc..
+ *
+ * Copyright: 2000 by Sun Microsystems, Inc.
+ *
+ * All Rights Reserved.
+ *
+ * Contributor(s): _______________________________________
+ *
+ *
+ ************************************************************************-->
+
+<helpdocument version="1.0">
+<meta>
+<topic id="textscalc0502140000xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Error Codes in %PRODUCTNAME Calc</title>
+<filename>/text/scalc/05/02140000.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2004-08-10T10:56:39">converted from old format - fpe</lastedited>
+</history>
+</meta>
+<body>
+<bookmark xml-lang="en-US" branch="index" id="bm_id3146797"><bookmark_value>error codes in %PRODUCTNAME Calc</bookmark_value>
+<bookmark_value>%PRODUCTNAME Calc; error codes</bookmark_value>
+</bookmark>
+<paragraph role="heading" id="hd_id3146797" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/05/02140000.xhp" name="Error Codes in %PRODUCTNAME Calc">Error Codes in <item type="productname">%PRODUCTNAME</item> Calc</link></paragraph>
+<paragraph role="paragraph" id="par_id3150275" xml-lang="en-US" l10n="U" oldref="2">This 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>
+<table id="tbl_id3147559">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153968" xml-lang="en-US" l10n="U" oldref="3">Error Code</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3125863" xml-lang="en-US" l10n="U" oldref="4">Message</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3151112" xml-lang="en-US" l10n="U" oldref="5">Explanation</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153188" xml-lang="en-US" l10n="U" oldref="6">501</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3148645" xml-lang="en-US" l10n="U" oldref="7">Invalid character</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3155854" xml-lang="en-US" l10n="U" oldref="8">Character in a formula is not valid, for example, "=1Eq" instead of "=1E2".</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3145253" xml-lang="en-US" l10n="U" oldref="9">502</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3147397" xml-lang="en-US" l10n="U" oldref="10">Invalid argument</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153160" xml-lang="en-US" l10n="U" oldref="11">Function argument is not valid, for example, a negative number for the root function.</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3154015" xml-lang="en-US" l10n="U" oldref="12">503</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3155766" xml-lang="en-US" l10n="U" oldref="13">Invalid floating point operation</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3159266" xml-lang="en-US" l10n="U" oldref="14">Division by 0, or another calculation that results in an overflow of the defined value range.</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3149258" xml-lang="en-US" l10n="U" oldref="15">504</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3147344" xml-lang="en-US" l10n="U" oldref="16">Parameter list error</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3147003" xml-lang="en-US" l10n="U" oldref="17">Function parameter is not valid, for example, text instead of a number, or a domain reference instead of cell reference.</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3154532" xml-lang="en-US" l10n="U" oldref="27">508</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3150107" xml-lang="en-US" l10n="U" oldref="28">Error: Pair missing</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3149129" xml-lang="en-US" l10n="U" oldref="29">Missing bracket, for example, closing brackets, but no opening brackets</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3149895" xml-lang="en-US" l10n="U" oldref="30">509</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3155097" xml-lang="en-US" l10n="U" oldref="31">Missing operator</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3154649" xml-lang="en-US" l10n="U" oldref="32">Operator is missing, for example, "=2(3+4) * ", where the operator between "2" and "(" is missing.</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153813" xml-lang="en-US" l10n="U" oldref="33">510</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153483" xml-lang="en-US" l10n="U" oldref="34">Missing variable</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3154710" xml-lang="en-US" l10n="U" oldref="35">Variable is missing, for example when two operators are together "=1+*2".</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3154739" xml-lang="en-US" l10n="U" oldref="36">511</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3145112" xml-lang="en-US" l10n="U" oldref="37">Missing variable</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3145319" xml-lang="en-US" l10n="U" oldref="38">Function requires more variables than are provided, for example, AND() and OR().</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3149050" xml-lang="en-US" l10n="U" oldref="39">512</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3150393" xml-lang="en-US" l10n="U" oldref="40">Formula overflow</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3159259" xml-lang="en-US" l10n="U" oldref="41">
+<emph>Compiler:</emph> the total number of internal tokens, (that is, operators, variables, brackets) in the formula exceeds 512. <emph>Interpreter:</emph> the total number of matrices that the formula creates exceeds 150. This includes basic functions that receive too large an array as a parameter (max. 0xFFFE, for example, 65534 bytes).</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3150537" xml-lang="en-US" l10n="U" oldref="42">513</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3147412" xml-lang="en-US" l10n="U" oldref="43">String overflow</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3145635" xml-lang="en-US" l10n="U" oldref="44">
+<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>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3149147" xml-lang="en-US" l10n="U" oldref="45">514</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3157904" xml-lang="en-US" l10n="U" oldref="46">Internal overflow</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3149352" xml-lang="en-US" l10n="U" oldref="47">Sort operation attempted on too much numerical data (max. 100000) or a calculation stack overflow.</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3154841" xml-lang="en-US" l10n="U" oldref="51">516</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3147423" xml-lang="en-US" l10n="U" oldref="52">Internal syntax error</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3148437" xml-lang="en-US" l10n="U" oldref="53">Matrix is expected on the calculation stack, but is not available.</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3155261" xml-lang="en-US" l10n="U" oldref="54">517</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153934" xml-lang="en-US" l10n="U" oldref="55">Internal syntax error</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3149507" xml-lang="en-US" l10n="U" oldref="56">Unknown code, for example, a document with a newer function is loaded in an older version that does not contain the function.</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3148585" xml-lang="en-US" l10n="U" oldref="57">518</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3149189" xml-lang="en-US" l10n="U" oldref="58">Internal syntax error</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3149545" xml-lang="en-US" l10n="U" oldref="59">Variable is not available</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3146142" xml-lang="en-US" l10n="U" oldref="60">519</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3155954" xml-lang="en-US" l10n="U" oldref="61">No result (#VALUE is in the cell rather than Err:519!)</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153108" xml-lang="en-US" l10n="U" oldref="62">Formula yields a value that does not corresponds to the definition, or a cell that is referenced in the formula contains text instead of a number.</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3150338" xml-lang="en-US" l10n="U" oldref="63">520</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3150017" xml-lang="en-US" l10n="U" oldref="64">Internal syntax error</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3148758" xml-lang="en-US" l10n="U" oldref="65">Compiler creates an unknown compiler code.</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3154324" xml-lang="en-US" l10n="U" oldref="66">521</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153737" xml-lang="en-US" l10n="U" oldref="67">Internal syntax error</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3155436" xml-lang="en-US" l10n="U" oldref="68">No result.</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153045" xml-lang="en-US" l10n="U" oldref="69">522</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3149008" xml-lang="en-US" l10n="U" oldref="70">Circular reference</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3157972" xml-lang="en-US" l10n="CHG" oldref="71">Formula refers directly or indirectly to itself and the <emph>Iterations</emph> option is not set under Tools - Options - %PRODUCTNAME Calc - Calculate.<comment>UFI: fixes #i23854#</comment></paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3149538" xml-lang="en-US" l10n="U" oldref="72">523</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3150930" xml-lang="en-US" l10n="U" oldref="73">The calculation procedure does not converge</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3150272" xml-lang="en-US" l10n="U" oldref="74">Financial statistics function missed a targeted value or iterations of circular references do not reach the minimum change within the maximum steps that are set.</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153544" xml-lang="en-US" l10n="U" oldref="75">524</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3154634"><bookmark_value>invalid references; error messages</bookmark_value>
+<bookmark_value>#REF error message</bookmark_value>
+</bookmark>
+<paragraph role="paragraph" id="par_id3154634" xml-lang="en-US" l10n="U" oldref="76">invalid references (instead of Err:524 cell contains #REF)</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3147539" xml-lang="en-US" l10n="U" oldref="77">
+<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>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3155984" xml-lang="en-US" l10n="U" oldref="78">525</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3148428"><bookmark_value>invalid names; error messages</bookmark_value>
+<bookmark_value>#NAME error message</bookmark_value>
+</bookmark>
+<paragraph role="paragraph" id="par_id3148428" xml-lang="en-US" l10n="U" oldref="79">invalid names (instead of Err:525 cell contains #NAME?)</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3156259" xml-lang="en-US" l10n="U" oldref="80">An identifier could not be evaluated, for example, no valid reference, no valid domain name, no column/row label, no macro, incorrect decimal divider, add-in not found.</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153720" xml-lang="en-US" l10n="U" oldref="81">526</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3154315" xml-lang="en-US" l10n="U" oldref="82">Internal syntax error</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3083286" xml-lang="en-US" l10n="U" oldref="83">Obsolete, no longer used, but could come from old documents if the result is a formula from a domain.</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3152483" xml-lang="en-US" l10n="U" oldref="84">527</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3152966" xml-lang="en-US" l10n="U" oldref="85">Internal overflow</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3149709" xml-lang="en-US" l10n="U" oldref="86">
+<emph>Interpreter: </emph>References, such as when a cell references a cell, are too encapsulated.</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</body>
+</helpdocument>
diff --git a/helpcontent2/source/text/scalc/05/makefile.mk b/helpcontent2/source/text/scalc/05/makefile.mk
new file mode 100644
index 0000000000..2e18b57c33
--- /dev/null
+++ b/helpcontent2/source/text/scalc/05/makefile.mk
@@ -0,0 +1,40 @@
+#*************************************************************************
+#*
+#* $Workfile:$
+#*
+#* Creation date KR 28.06.99
+#* last change $Author: fpe $ $Date: 2004-08-18 10:54:29 $
+#*
+#* $Revision: 1.1 $
+#*
+#* $Logfile:$
+#*
+#* Copyright 2000 Sun Microsystems, Inc. All Rights Reserved.
+#*
+#*************************************************************************
+
+# edit to match directory level
+PRJ = ..$/..$/..$/..
+# same for all makefiles in "help2"
+PRJNAME = help2
+# edit to match the current package
+PACKAGE = text/scalc/05
+# uniqe name (module wide);
+# using a modified forme of package should do here
+TARGET = text_scalc_05
+# edit to match the current module
+MODULE = scalc
+
+# --- Settings -----------------------------------------------------
+
+.INCLUDE : $(PRJ)$/settings.pmk
+.INCLUDE : settings.mk
+
+# this list matches the *.xml files to process
+HZIPFILES = \
+ 02140000.hzip
+
+# --- Targets ------------------------------------------------------
+
+.INCLUDE : target.mk
+.INCLUDE : $(PRJ)$/makefile.pmk
generated by cgit (git 2.34.1) at 2024-06-26 20:37:00 +0000