Translation

02140000.xhp par_id5324564 help.text
English gBQnb
Context English Luxembourgish Actions
02140000.xhp
par_id3150272
help.text
Function missed a targeted value, or <link href="text/shared/optionen/01060500.xhp">iterative references</link> do not reach the minimum change within the maximum steps that are set.
02140000.xhp
par_id3153544
help.text
524<br/>#REF!
02140000.xhp
par_id3154634
help.text
invalid references (instead of Err:524 cell displays #REF!)
02140000.xhp
par_id3147539
help.text
<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.
02140000.xhp
par_id3155984
help.text
525<br/>#NAME?
02140000.xhp
par_id3148428
help.text
invalid names (instead of Err:525 cell displays #NAME?)
02140000.xhp
par_id3156259
help.text
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.
02140000.xhp
par_id3154315
help.text
Internal syntax error
02140000.xhp
par_id3083286
help.text
Obsolete, no longer used, but could come from old documents if the result is a formula from a domain.
02140000.xhp
par_id3152966
help.text
Internal overflow
02140000.xhp
par_id3149709
help.text
<emph>Interpreter: </emph>References, such as when a cell references a cell, are too encapsulated.
02140000.xhp
par_id4152967
help.text
No AddIn
02140000.xhp
par_id3149710
help.text
<emph>Interpreter: </emph>AddIn not found.
02140000.xhp
par_id3152967
help.text
No Macro
02140000.xhp
par_id3149711
help.text
<emph>Interpreter: </emph>Macro not found.
02140000.xhp
par_id5324564
help.text
532<br/>#DIV/0!
02140000.xhp
par_id7941831
help.text
Division by zero
02140000.xhp
par_id5844294
help.text
Division operator / if the denominator is 0<br/>Some more functions return this error, for example:<br/>VARP with less than 1 argument<br/>STDEVP with less than 1 argument<br/>VAR with less than 2 arguments<br/>STDEV with less than 2 arguments<br/>STANDARDIZE with stdev=0<br/>NORMDIST with stdev=0
02140000.xhp
par_id951549820044260
help.text
Nested arrays are not supported
02140000.xhp
par_id781549820065619
help.text
For example, ={1;{2}}
02140000.xhp
par_id521549825734781
help.text
Error: Array or matrix size
02140000.xhp
par_id931549825818729
help.text
Unsupported inline array content
02140000.xhp
par_id551549825825905
help.text
For example, ={1+2}
02140000.xhp
par_id131549825893410
help.text
External content disabled
02140000.xhp
par_id881549825900965
help.text
Happens if a function that requires (re)loading of external sources is encountered and the user hasn't confirmed reloading of external sources yet
empty_cells.xhp
tit
help.text
Handling of Empty Cells
empty_cells.xhp
bm_id3146799
help.text
<bookmark_value>empty cells;handling of</bookmark_value>
empty_cells.xhp
hd_id1502121
help.text
<variable id="empty_cells"><link href="text/scalc/05/empty_cells.xhp">Handling of Empty Cells</link></variable>
empty_cells.xhp
par_id8266853
help.text
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.
empty_cells.xhp
par_id2733542
help.text
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.
empty_cells.xhp
par_id4238715
help.text
For the following examples, A1 contains a number, B1 is empty, C1 contains the reference to B1:

Loading…

No matching activity found.
Browse all component changes

Glossary

English Luxembourgish
No related strings found in the glossary.

String information

Context
02140000.xhp
par_id5324564
help.text
Source string description
gBQnb
Source string location
02140000.xhp
String age
9 months ago
Source string age
9 months ago
Translation file
lb/helpcontent2/source/text/scalc/05.po, string 71