From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- helpcontent2/source/text/scalc/05/02140000.xhp | 426 +++++++++++++++++++++++++ 1 file changed, 426 insertions(+) create mode 100644 helpcontent2/source/text/scalc/05/02140000.xhp (limited to 'helpcontent2/source/text/scalc/05/02140000.xhp') diff --git a/helpcontent2/source/text/scalc/05/02140000.xhp b/helpcontent2/source/text/scalc/05/02140000.xhp new file mode 100644 index 000000000..4a54582a7 --- /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 value (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! + + +Not a valid reference (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 + + +
+ + -- cgit v1.2.3