How to find out if a cell is (visibly) blank in LibreOffice Calc?
7
votes
3
answers
4437
views
In LibreOffice Calc the
=BLANK()
formula will only return TRUE
on cells with the underlying datatype ”blank”. In other words: If the cell contains a formula that returns nothing (or if it contains the empty text string), =BLANK()
will be FALSE
. Is there a way to check if a cell contains displayable content, such as a text string or a number?
In the screenshot below, the =ISBLANK(B3)
formula in C3
returns FALSE
, as the cell contains a formula returning nothing. How would I go about to check is a B:B cell is ”blank” in the sense of not containing any data?

Asked by leo
(172 rep)
Oct 12, 2021, 12:30 PM
Last activity: Jan 1, 2025, 08:13 PM
Last activity: Jan 1, 2025, 08:13 PM