Translation

empty_cells.xhp par_id941535142746122 help.text
English y3GkG
Context English Armenian, Classical (Armenia) (xcl) Actions
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:
empty_cells.xhp
par_id291535142746121
help.text
Case
empty_cells.xhp
par_id441535142746121
help.text
Formula
empty_cells.xhp
par_id261535142746121
help.text
Results and comments
empty_cells.xhp
par_id941535142746122
help.text
A1: 1<br/>B1: <Empty>
empty_cells.xhp
par_id851535142746123
help.text
Displays 0
empty_cells.xhp
par_id981535142948275
help.text
<variable id="vtrue">TRUE</variable>
empty_cells.xhp
par_id1001535143031604
help.text
TRUE (previously was FALSE)
empty_cells.xhp
par_id201535143064244
help.text
=ISNUMBER(B1)
empty_cells.xhp
par_id421535143064245
help.text
<variable id="vfalse">FALSE</variable>
empty_cells.xhp
par_id681535143124250
help.text
=ISNUMBER(C1)
empty_cells.xhp
par_id211535143124250
help.text
FALSE (previously was TRUE)
empty_cells.xhp
par_id221535143151829
help.text
=ISNUMBER(VLOOKUP(1;A1:C1;2))
empty_cells.xhp
par_id271535143151830
help.text
FALSE (B1)
empty_cells.xhp
par_id861535143183196
help.text
=ISNUMBER(VLOOKUP(1;A1:C1;3))
empty_cells.xhp
par_id371535143183197
help.text
FALSE (C1, previously was TRUE)
empty_cells.xhp
par_id191535143228538
help.text
=ISTEXT(B1)
empty_cells.xhp
par_id251535143279847
help.text
=ISTEXT(C1)
empty_cells.xhp
par_id641535143301636
help.text
=ISTEXT(VLOOKUP(1;A1:C1;2))
empty_cells.xhp
par_id391535143301637
help.text
FALSE (B1, previously was TRUE)

Loading…

No matching activity found.
Browse all component changes

Glossary

English Armenian, Classical (Armenia) (xcl)
No related strings found in the glossary.

String information

Context
empty_cells.xhp
par_id941535142746122
help.text
Source string description
y3GkG
Source string location
empty_cells.xhp
String age
a year ago
Source string age
a year ago
Translation file
xcl/helpcontent2/source/text/scalc/05.po, string 90