Error Codes in %PRODUCTNAME Calc

From 940b4d1848e8c70ab7642901a68594e8016caffc Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 27 Apr 2024 18:51:28 +0200 Subject: Adding upstream version 1:7.0.4. Signed-off-by: Daniel Baumann --- helpcontent2/source/text/scalc/05/02140000.xhp | 426 ++++++++++++++++++++++ helpcontent2/source/text/scalc/05/empty_cells.xhp | 320 ++++++++++++++++ 2 files changed, 746 insertions(+) create mode 100644 helpcontent2/source/text/scalc/05/02140000.xhp create mode 100644 helpcontent2/source/text/scalc/05/empty_cells.xhp (limited to 'helpcontent2/source/text/scalc/05') diff --git a/helpcontent2/source/text/scalc/05/02140000.xhp b/helpcontent2/source/text/scalc/05/02140000.xhp new file mode 100644 index 000000000..e1f2d3de3 --- /dev/null +++ b/helpcontent2/source/text/scalc/05/02140000.xhp @@ -0,0 +1,426 @@ + + + + + + + + + Error Codes in %PRODUCTNAME Calc + /text/scalc/05/02140000.xhp + + + +error codes;list of +mw deleted "%PRODUCTNAME Calc;error codes" +Error Codes in %PRODUCTNAME Calc + 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 Status Bar. +### error message +invalid references; error messages + error messages;invalid references + #REF error message + +invalid names; error messages + #NAME error message + + + + + Error Code + + + Message + + + Explanation + + + + + ### + + +none + + + The cell is not wide enough to display the contents. + + + + + #FMT + + + none + + + This value is outside of limits valid for this format + + + + + 501 + + + Invalid character + + + Character in a formula is not valid. + + + + + 502 + + + Invalid argument + + + Function argument is not valid. For example, a negative number for the SQRT() function, for this please use IMSQRT(). + + + + + 503
#NUM! + + + Invalid floating point operation + + + A calculation results in an overflow of the defined value range. + + + + + 504 + + + Parameter list error + + + Function parameter is not valid, for example, text instead of a number, or a domain reference instead of cell reference. + + + + + 507, 508 + + + Error: Pair missing + + + Missing bracket, for example, closing brackets, but no opening brackets + + + + + 509 + + + Missing operator + + + Operator is missing, for example, "=2(3+4) * ", where the operator between "2" and "(" is missing. + + + + + 510 + + + Missing variable + + + Variable is missing, for example when two operators are together "=1+*2". + + + + + 511 + + + Missing variable + + + Function requires more variables than are provided, for example, AND() and OR(). + + + + + 512 + + + Formula overflow + + + + Compiler: the total number of internal tokens, (that is, operators, variables, brackets) in the formula exceeds 8192. + + + + + 513 + + + String overflow + + + + Compiler: an identifier in the formula exceeds 64 KB in size. Interpreter: a result of a string operation exceeds 64 KB in size. + + + + + 514 + + + Internal overflow + + + Sort operation attempted on too much numerical data (max. 100000) or a calculation stack overflow. + + + + + 515 + + + Internal syntax error + + + Unknown error. + + + + + 516 + + + Internal syntax error + + + Matrix is expected on the calculation stack, but is not available. + + + + + 517 + + + Internal syntax error + + + Unknown code, for example, a document with a newer function is loaded in an older version that does not contain the function. + + + + + 518 + + + Internal syntax error + + + Variable is not available + + + + + 519
#VALUE! + + + No result (instead of Err:519 cell displays #VALUE!) + + + 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.i63264 + + + + + 520 + + + Internal syntax error + + + Compiler creates an unknown compiler code. + + + + + 521
#NULL! + + + Internal syntax error (instead of Err:521 cell displays #NULL!) + + + No code or no result. + + + + + 522 + + + Circular reference + + + Formula refers directly or indirectly to itself and the Iterations option is not set under %PRODUCTNAME - Preferences +Tools - Options - %PRODUCTNAME Calc - Calculate.UFI: fixes #i23854# + + + + + 523 + + + The calculation procedure does not converge + + + Function missed a targeted value, or iterative references do not reach the minimum change within the maximum steps that are set.UFI: see #33769# + + + + + 524
#REF! + + +invalid references (instead of Err:524 cell displays #REF!) + + + + Compiler: a column or row description name could not be resolved. Interpreter: in a formula, the column, row, or sheet that contains a referenced cell is missing. + + + + + 525
#NAME? + + +invalid names (instead of Err:525 cell displays #NAME?) + + + 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. + + + + + 526 + + + Internal syntax error + + + Obsolete, no longer used, but could come from old documents if the result is a formula from a domain. + + + + + 527 + + + Internal overflow + + + + Interpreter: References, such as when a cell references a cell, are too encapsulated. + + + + + 530 + + + No AddIn + + + + Interpreter: AddIn not found. + + + + + 531 + + + No Macro + + + + Interpreter: Macro not found. + + + + + 532
#DIV/0! + + + Division by zero + + + Division operator / if the denominator is 0
Some more functions return this error, for example:
VARP with less than 1 argument
STDEVP with less than 1 argument
VAR with less than 2 arguments
STDEV with less than 2 arguments
STANDARDIZE with stdev=0
NORMDIST with stdev=0 + + + + + 533 + + + Nested arrays are not supported + + + For example, ={1;{2}} + + + + + 538 + + + Error: Array or matrix size + + + - + + + + + 539 + + + Unsupported inline array content + + + For example, ={1+2} + + + + + 540 + + + External content disabled + + + Happens if a function that requires (re)loading of external sources is encountered and the user hasn't confirmed reloading of external sources yet + + +

+ + diff --git a/helpcontent2/source/text/scalc/05/empty_cells.xhp b/helpcontent2/source/text/scalc/05/empty_cells.xhp new file mode 100644 index 000000000..56ccc19b7 --- /dev/null +++ b/helpcontent2/source/text/scalc/05/empty_cells.xhp @@ -0,0 +1,320 @@ + + + + + + + + +Handling of Empty Cells +/text/scalc/05/empty_cells.xhp + + + + + empty cells;handling of +i86303 +Handling of Empty Cells + +In older versions of the software, empty cells were forced to numeric 0 in some contexts and to empty string in others, except in direct comparison where =A1=0 and =A1="" both resulted in TRUE if A1 was empty. Emptiness now is inherited until used, so both =VLOOKUP(...)=0 and =VLOOKUP(...)="" give TRUE if the lookup resulted in an empty cell being returned. +A simple reference to an empty cell is still displayed as numeric 0 but is not necessarily of type numeric anymore, so also comparisons with the referencing cell work as expected. +For the following examples, A1 contains a number, B1 is empty, C1 contains the reference to B1: + + + + Case + + + Formula + + + Results and comments + + + + + A1: 1
B1: <Empty> + + + C1: =B1 + + + Displays 0 + + + + + =B1=0 + + + TRUE + + + + + =B1="" + + + + + + + + =C1=0 + + + + + + + + =C1="" + + + TRUE (previously was FALSE) + + + + + =ISNUMBER(B1) + + + FALSE + + + + + =ISNUMBER(C1) + + + FALSE (previously was TRUE) + + + + + =ISNUMBER(VLOOKUP(1;A1:C1;2)) + + + FALSE (B1) + + + + + =ISNUMBER(VLOOKUP(1;A1:C1;3)) + + + FALSE (C1, previously was TRUE) + + + + + =ISTEXT(B1) + + + + + + + + =ISTEXT(C1) + + + + + + + + =ISTEXT(VLOOKUP(1;A1:C1;2)) + + + FALSE (B1, previously was TRUE) + + + + + =ISTEXT(VLOOKUP(1;A1:C1;3)) + + + FALSE (C1) + + + + + =ISBLANK(B1) + + + + + + + + =ISBLANK(C1) + + + + + + + + =ISBLANK(VLOOKUP(1;A1:C1;2)) + + + TRUE (B1, previously was FALSE) + + + + + =ISBLANK(VLOOKUP(1;A1:C1;3)) + + + FALSE (C1) + + +

+Note that Microsoft Excel behaves different and always returns a number as the result of a reference to an empty cell or a formula cell with the result of an empty cell. For example: + + + + Case + + + Formula + + + Results and comments + + + + + A1: <Empty> + + + B1: =A1 + + + Displays 0, but is just a reference to an empty cell. + + + + + =ISNUMBER(A1) + + + + + + + + =ISTEXT(A1) + + + + + + + + =A1=0 + + + + + + + + =A1="" + + + + + + + + =ISNUMBER(B1) + + + FALSE (Microsoft Excel: TRUE) + + + + + =ISTEXT(B1) + + + + + + + + =B1=0 + + + + + + + + =B1="" + + + TRUE (Microsoft Excel: FALSE) + + + + + C1: =VLOOKUP(...) with empty cell result + + + displays empty (Microsoft Excel: displays 0) + + + + + =ISNUMBER(VLOOKUP(...)) + + + + + + + + =ISTEXT(VLOOKUP(...)) + + + + + + + + =ISNUMBER(C1) + + + FALSE (Microsoft Excel: TRUE) + + + + + =ISTEXT(C1) + + + + + +

+ + -- cgit v1.2.3