Translation

empty_cells.xhp par_id481535143557533 help.text
English 23UDU
Context English Armenian, Classical (Armenia) (xcl) Actions
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)
empty_cells.xhp
par_id661535143336012
help.text
=ISTEXT(VLOOKUP(1;A1:C1;3))
empty_cells.xhp
par_id11535143336012
help.text
FALSE (C1)
empty_cells.xhp
par_id661535143373396
help.text
=ISBLANK(B1)
empty_cells.xhp
par_id281535143396581
help.text
=ISBLANK(C1)
empty_cells.xhp
par_id31535143422248
help.text
=ISBLANK(VLOOKUP(1;A1:C1;2))
empty_cells.xhp
par_id871535143422248
help.text
TRUE (B1, previously was FALSE)
empty_cells.xhp
par_id731535143454577
help.text
=ISBLANK(VLOOKUP(1;A1:C1;3))
empty_cells.xhp
par_id941535143454577
help.text
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:
empty_cells.xhp
par_id251535143557533
help.text
Case
empty_cells.xhp
par_id441535143557533
help.text
Formula
empty_cells.xhp
par_id481535143557533
help.text
Results and comments
empty_cells.xhp
par_id311535143557534
help.text
A1: <Empty>
empty_cells.xhp
par_id961535143557535
help.text
Displays 0, but is just a reference to an empty cell.
empty_cells.xhp
par_id441535143762523
help.text
=ISNUMBER(A1)
empty_cells.xhp
par_id751535143810734
help.text
=ISTEXT(A1)
empty_cells.xhp
par_id121535143920008
help.text
=ISNUMBER(B1)
empty_cells.xhp
par_id391535143920009
help.text
FALSE (Microsoft Excel: TRUE)
empty_cells.xhp
par_id371535143961386
help.text
=ISTEXT(B1)
empty_cells.xhp
par_id111535144016852
help.text
TRUE (Microsoft Excel: FALSE)
empty_cells.xhp
par_id771535144043975
help.text
C1: =VLOOKUP(...) with empty cell result
empty_cells.xhp
par_id311535144043975
help.text
displays empty (Microsoft Excel: displays 0)
empty_cells.xhp
par_id761535144080504
help.text
=ISNUMBER(VLOOKUP(...))
empty_cells.xhp
par_id11535144101388
help.text
=ISTEXT(VLOOKUP(...))
empty_cells.xhp
par_id131535144123734
help.text
=ISNUMBER(C1)
empty_cells.xhp
par_id151535144123735
help.text
FALSE (Microsoft Excel: TRUE)
empty_cells.xhp
par_id981535144159183
help.text
=ISTEXT(C1)
Component Translation Difference to current string
This translation Propagated Empty LibreOffice Help – 7.2/text/scalc/05
The following string has different context, but the same source.
Empty LibreOffice Help – 7.2/text/scalc/05

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_id481535143557533
help.text
Source string description
23UDU
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 117