source/text/scalc/05/02140000.xhp | 67 ++++++++++++++++++--------------------
1 file changed, 33 insertions(+), 34 deletions(-)
New commits:
commit baa3ad9698dfc80375109478ff88d7929dfb62ea
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Wed Apr 26 18:30:15 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Mon May 8 20:21:38 2023 +0200
tdf#153574 Update error code Help page
+ add #N/A error
+ removed 526
+ updated 521, 504, 513, 514, 525, 538
+
Change-Id: Ie1bf57cd8f13fb60e64d89c14a20bb2d8a04fb4a
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/151078
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/05/02140000.xhp
b/source/text/scalc/05/02140000.xhp
index 4c31d49c70..914d9635b1 100644
--- a/source/text/scalc/05/02140000.xhp
+++ b/source/text/scalc/05/02140000.xhp
@@ -26,18 +26,18 @@
<filename>/text/scalc/05/02140000.xhp</filename>
</topic>
</meta>
- <body>
-<bookmark branch="index" id="bm_id3146797"><bookmark_value>error codes;list
of</bookmark_value>
-</bookmark><comment>mw deleted "%PRODUCTNAME Calc;error codes"</comment>
-<h1 id="hd_id3146797"><link href="text/scalc/05/02140000.xhp">Error Codes in
<item type="productname">%PRODUCTNAME</item> Calc</link></h1>
- <paragraph id="par_id3150275" role="paragraph">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>
-<bookmark branch="index" id="bm_id0202201010205429"><bookmark_value>### error
message</bookmark_value></bookmark>
-<bookmark branch="index" id="bm_id3154634"><bookmark_value>invalid references;
error messages</bookmark_value>
- <bookmark_value>error messages;invalid
references</bookmark_value>
- <bookmark_value>#REF error message</bookmark_value>
-</bookmark>
-<bookmark branch="index" id="bm_id3148428"><bookmark_value>invalid names;
error messages</bookmark_value>
- <bookmark_value>#NAME error message</bookmark_value>
+<body>
+<h1 id="hd_id3146797"><link href="text/scalc/05/02140000.xhp">Error Codes in
%PRODUCTNAME Calc</link></h1>
+ <paragraph id="par_id3150275" role="paragraph">The following table is an
overview of the error messages for %PRODUCTNAME Calc. If the error occurs in
the cell that contains the cursor, the error message is displayed on the
<emph>Status Bar</emph>.</paragraph>
+<bookmark branch="index" id="bm_id0202201010205429">
+<bookmark_value>### error message</bookmark_value>
+<bookmark_value>invalid references; error messages</bookmark_value>
+<bookmark_value>error messages;invalid references</bookmark_value>
+<bookmark_value>invalid names; error messages</bookmark_value>
+<bookmark_value>#REF error message</bookmark_value>
+<bookmark_value>#N/A error message</bookmark_value>
+<bookmark_value>#NAME error message</bookmark_value>
+<bookmark_value>error codes;list of</bookmark_value>
</bookmark>
<table id="tbl_id3147559">
<tablerow>
@@ -56,7 +56,7 @@
<paragraph id="par_id1668467" role="tablecontent"
localize="false">###</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id3165766" role="tablecontent">none</paragraph>
+ <paragraph id="par_id3165766"
role="tablecontent">none</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id3169266" role="tablecontent">The cell is
not wide enough to display the contents.</paragraph>
@@ -73,6 +73,17 @@
<paragraph id="par_id3169267" role="tablecontent">This value is
outside of limits valid for this format</paragraph>
</tablecell>
</tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id591682523247670"
role="tablecontent">#N/A</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id491682523247671" role="tablecontent">Not
Available</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id211682523247672" role="tablecontent">A
result for the formula expression is not available.</paragraph>
+ </tablecell>
+ </tablerow>
<tablerow>
<tablecell>
<paragraph localize="false" id="par_id3153188"
role="tablecontent">501</paragraph>
@@ -114,7 +125,7 @@
<paragraph id="par_id3147344" role="tablecontent">Parameter
list error</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3147003" role="tablecontent">Function
parameter is not valid, for example, text instead of a number, or a domain
reference instead of cell reference.</paragraph>
+ <paragraph id="par_id3147003" role="tablecontent">Function
parameter is not valid, for example, text instead of a number.</paragraph>
</tablecell>
</tablerow>
<tablerow>
@@ -182,7 +193,7 @@
</tablecell>
<tablecell>
<paragraph id="par_id3145635" role="tablecontent">
- <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>
+ <emph>Compiler:</emph> an identifier in the formula exceeds
1024 bytes in size. <emph>Interpreter:</emph> a result of a string operation
exceeds 256 MB in size.</paragraph>
</tablecell>
</tablerow>
<tablerow>
@@ -193,7 +204,7 @@
<paragraph id="par_id3157904" role="tablecontent">Internal
overflow</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3149352" role="tablecontent">Sort
operation attempted on too much numerical data (max. 100000) or a calculation
stack overflow.</paragraph>
+ <paragraph id="par_id3149352" role="tablecontent">An internal
calculation stack overflow occurred.</paragraph>
</tablecell>
</tablerow>
<tablerow>
@@ -267,7 +278,7 @@
<paragraph localize="false" id="par_id3154324"
role="tablecontent">521<br/>#NULL!</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3153737" role="tablecontent">Internal
syntax error (instead of Err:521 cell displays #NULL!)</paragraph>
+ <paragraph id="par_id3153737" role="tablecontent">No code or no
intersection.</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id3155436" role="tablecontent">No code or no
result.</paragraph>
@@ -281,8 +292,7 @@
<paragraph id="par_id3149008" role="tablecontent">Circular
reference</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3157972" role="tablecontent">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
-</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> -
%PRODUCTNAME Calc - Calculate.<comment>UFI: fixes #i23854#</comment></paragraph>
+ <paragraph id="par_id3157972" role="tablecontent">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 -</caseinline><defaultinline>Tools -
Options</defaultinline></switchinline> - %PRODUCTNAME Calc -
Calculate.<comment>UFI: fixes #i23854#</comment></paragraph>
</tablecell>
</tablerow>
<tablerow>
@@ -313,21 +323,10 @@
<paragraph id="par_id3155984"
role="tablecontent">525<br/>#NAME?</paragraph>
</tablecell>
<tablecell>
-<paragraph id="par_id3148428" role="tablecontent">invalid names (instead of
Err:525 cell displays #NAME?)</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id3156259" role="tablecontent">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>
- <paragraph localize="false" id="par_id3153720"
role="tablecontent">526</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id3154315" role="tablecontent">Internal
syntax error</paragraph>
+<paragraph id="par_id3148428" role="tablecontent">Invalid names</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3083286" role="tablecontent">Obsolete, no
longer used, but could come from old documents if the result is a formula from
a domain.</paragraph>
+ <paragraph id="par_id3156259" role="tablecontent">An identifier
could not be evaluated, for example, no valid reference, no valid function
name, no column/row label, no macro, incorrect decimal separator, add-in not
found.</paragraph>
</tablecell>
</tablerow>
<tablerow>
@@ -396,7 +395,7 @@
<paragraph id="par_id521549825734781"
role="tablecontent">Error: Array or matrix size</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id601549825744677" role="tablecontent"
localize="false"> - </paragraph>
+ <paragraph id="par_id601549825744677" role="tablecontent">The
maximum limit for sorting has exceeded (the maximum is twice the maximum
number of rows, so for 1048576 rows 2097152 entries). The same Err:538 is also
used whenever a temporary matrix could not be allocated due to its size
requirement.</paragraph>
</tablecell>
</tablerow>
<tablerow>
@@ -418,7 +417,7 @@
<paragraph id="par_id131549825893410"
role="tablecontent">External content disabled</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id881549825900965" role="tablecontent">
Happens if a function that requires (re)loading of external sources is
encountered and the user hasn't confirmed reloading of external sources yet
</paragraph>
+ <paragraph id="par_id881549825900965" role="tablecontent">A
function that requires (re)loading of external sources is encountered and the
user has not confirmed reloading of external sources yet.</paragraph>
</tablecell>
</tablerow>
</table>
