Translation

empty_cells.xhp bm_id3146799 help.text
English nVAzC
Context English English (United Kingdom) Actions
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.
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. A simple reference to an empty cell is still displayed as numeric 0 but is not necessarily of type numeric any more, 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: For the following examples, A1 contains a number, B1 is empty, C1 contains the reference to B1:
empty_cells.xhp
par_id291535142746121
help.text
Case Case
empty_cells.xhp
par_id441535142746121
help.text
Formula Formula
empty_cells.xhp
par_id261535142746121
help.text
Results and comments Results and comments
empty_cells.xhp
par_id941535142746122
help.text
A1: 1<br/>B1: <Empty> A1: 1<br/>B1: <Empty>
empty_cells.xhp
par_id851535142746123
help.text
Displays 0 Displays 0
empty_cells.xhp
par_id981535142948275
help.text
<variable id="vtrue">TRUE</variable> <variable id="vtrue">TRUE</variable>
empty_cells.xhp
par_id1001535143031604
help.text
TRUE (previously was FALSE) TRUE (previously was FALSE)
empty_cells.xhp
par_id201535143064244
help.text
=ISNUMBER(B1) =ISNUMBER(B1)
empty_cells.xhp
par_id421535143064245
help.text
<variable id="vfalse">FALSE</variable> <variable id="vfalse">FALSE</variable>
empty_cells.xhp
par_id681535143124250
help.text
=ISNUMBER(C1) =ISNUMBER(C1)
empty_cells.xhp
par_id211535143124250
help.text
FALSE (previously was TRUE) FALSE (previously was TRUE)

Loading…

No matching activity found.
Browse all component changes

Glossary

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

String information

Context
empty_cells.xhp
bm_id3146799
help.text
Source string description
nVAzC
Source string location
empty_cells.xhp
String age
a year ago
Source string age
a year ago
Translation file
en-GB/helpcontent2/source/text/scalc/05.po, string 82