diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2023-04-26 18:30:15 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2023-05-08 20:21:38 +0200 |
| commit | baa3ad9698dfc80375109478ff88d7929dfb62ea (patch) | |
| tree | 025e38e1d7a8514e8c714dd063a669ac01d07cdc | |
| parent | 254accc37f7b37e29b0353376d7af557fe04ae03 (diff) | |
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.hallot@libreoffice.org>
| -rw-r--r-- | source/text/scalc/05/02140000.xhp | 67 |
1 files changed, 33 insertions, 34 deletions
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> @@ -75,6 +75,17 @@ </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> </tablecell> <tablecell> @@ -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> |