https://bugs.documentfoundation.org/show_bug.cgi?id=159425
Bug ID: 159425
Summary: ISBLANK(range)
Product: LibreOffice
Version: 7.6.4.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
To check a cell range for blank cells,
=AND(ISBLANK(C5:M5))
=OR(ISBLANK(C5:M5))
should return if all (or any) of the cells are blank. On Excel, this works.
But in LibreOffice the above formulae always return FALSE. :-( To put
clearly, they do not return errors, but return a wrong result.
I am aware we can work around the issue with formulae like
=COUNTBLANK(C5:M5)=COLUMNS(C5:M5)
=SUMPRODUCT(C5:M5)=COLUMNS(C5:M5)
but this makes formulae unneccessarily long, hard to read, error-prone on
edits, and less elegant.
I experienced this on the current release (see below) but the issue probably
exists for a long time, if not for every release.
Version: 7.6.4.1 (X86_64) / LibreOffice Community
Build ID: 60(Build:1)
CPU threads: 8; OS: Linux 6.7; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
7.6.4-2
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
