Translation

empty_cells.xhp par_id271535143151830 help.text
English eHH8h
Context English English (United Kingdom) Actions
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)
empty_cells.xhp
par_id221535143151829
help.text
=ISNUMBER(VLOOKUP(1;A1:C1;2)) =ISNUMBER(VLOOKUP(1;A1:C1;2))
empty_cells.xhp
par_id271535143151830
help.text
FALSE (B1) FALSE (B1)
empty_cells.xhp
par_id861535143183196
help.text
=ISNUMBER(VLOOKUP(1;A1:C1;3)) =ISNUMBER(VLOOKUP(1;A1:C1;3))
empty_cells.xhp
par_id371535143183197
help.text
FALSE (C1, previously was TRUE) FALSE (C1, previously was TRUE)
empty_cells.xhp
par_id191535143228538
help.text
=ISTEXT(B1) =ISTEXT(B1)
empty_cells.xhp
par_id251535143279847
help.text
=ISTEXT(C1) =ISTEXT(C1)
empty_cells.xhp
par_id641535143301636
help.text
=ISTEXT(VLOOKUP(1;A1:C1;2)) =ISTEXT(VLOOKUP(1;A1:C1;2))
empty_cells.xhp
par_id391535143301637
help.text
FALSE (B1, previously was TRUE) FALSE (B1, previously was TRUE)
empty_cells.xhp
par_id661535143336012
help.text
=ISTEXT(VLOOKUP(1;A1:C1;3)) =ISTEXT(VLOOKUP(1;A1:C1;3))
empty_cells.xhp
par_id11535143336012
help.text
FALSE (C1) FALSE (C1)
empty_cells.xhp
par_id661535143373396
help.text
=ISBLANK(B1) =ISBLANK(B1)
empty_cells.xhp
par_id281535143396581
help.text
=ISBLANK(C1) =ISBLANK(C1)
empty_cells.xhp
par_id31535143422248
help.text
=ISBLANK(VLOOKUP(1;A1:C1;2)) =ISBLANK(VLOOKUP(1;A1:C1;2))
empty_cells.xhp
par_id871535143422248
help.text
TRUE (B1, previously was FALSE) TRUE (B1, previously was FALSE)
empty_cells.xhp
par_id731535143454577
help.text
=ISBLANK(VLOOKUP(1;A1:C1;3)) =ISBLANK(VLOOKUP(1;A1:C1;3))
empty_cells.xhp
par_id941535143454577
help.text
FALSE (C1) FALSE (C1)
empty_cells.xhp
par_id4217047
help.text
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: 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:

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
par_id271535143151830
help.text
Source string description
eHH8h
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 99