Translation

02140000.xhp par_id3152967 help.text
English kAqvA
Context English English (United Kingdom) Actions
02140000.xhp
par_id3157972
help.text
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. 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.
02140000.xhp
par_id3150930
help.text
The calculation procedure does not converge The calculation procedure does not converge
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. 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 number of steps set.
02140000.xhp
par_id3153544
help.text
524<br/>#REF! 524<br/>#REF!
02140000.xhp
par_id3154634
help.text
invalid references (instead of Err:524 cell displays #REF!) 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. <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? 525<br/>#NAME?
02140000.xhp
par_id3148428
help.text
invalid names (instead of Err:525 cell displays #NAME?) 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. 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 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. 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 Internal overflow
02140000.xhp
par_id3149709
help.text
<emph>Interpreter: </emph>References, such as when a cell references a cell, are too encapsulated. <emph>Interpreter: </emph>References, such as when a cell references a cell, are too encapsulated.
02140000.xhp
par_id4152967
help.text
No AddIn No AddIn
02140000.xhp
par_id3149710
help.text
<emph>Interpreter: </emph>AddIn not found. <emph>Interpreter: </emph>AddIn not found.
02140000.xhp
par_id3152967
help.text
No Macro No Macro
02140000.xhp
par_id3149711
help.text
<emph>Interpreter: </emph>Macro not found. <emph>Interpreter: </emph>Macro not found.
02140000.xhp
par_id5324564
help.text
532<br/>#DIV/0! 532<br/>#DIV/0!
02140000.xhp
par_id7941831
help.text
Division by zero 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 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/>STANDARDISE with StandardDeviation=0<br/>NORMDIST with StandardDeviation=0
02140000.xhp
par_id951549820044260
help.text
Nested arrays are not supported Nested arrays are not supported
02140000.xhp
par_id781549820065619
help.text
For example, ={1;{2}} For example, ={1;{2}}
02140000.xhp
par_id521549825734781
help.text
Error: Array or matrix size Error: Array or matrix size
02140000.xhp
par_id931549825818729
help.text
Unsupported inline array content Unsupported inline array content
02140000.xhp
par_id551549825825905
help.text
For example, ={1+2} For example, ={1+2}
02140000.xhp
par_id131549825893410
help.text
External content disabled 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 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 Handling of Empty Cells
empty_cells.xhp
bm_id3146799
help.text
<bookmark_value>empty cells;handling of</bookmark_value> <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> <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. 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.

Loading…

No matching activity found.
Browse all component changes

Glossary

English English (United Kingdom)
No related strings found in the glossary.

String information

Context
02140000.xhp
par_id3152967
help.text
Source string description
kAqvA
Source string location
02140000.xhp
String age
9 months ago
Source string age
9 months ago
Translation file
en-GB/helpcontent2/source/text/scalc/05.po, string 69