https://bugs.documentfoundation.org/show_bug.cgi?id=159425
--- Comment #2 from Bernhard G <bernhard_gab...@web.de> --- Created attachment 192239 --> https://bugs.documentfoundation.org/attachment.cgi?id=192239&action=edit sample Excel365 file with formula =AND(ISEMPTY(range)) Initially I found this formula suggested on an Excel knowledge page (in German language): https://statorials.org/de/excel-ist-ein-leerer-bereich/ I made attached example XLSX file on a friend's Excel365 on Mac, also earlier today I successfully used same formula on another friend's Excel365 on Win. I cannot tell which version of Excel introduced this feature as I no longer use Excel myself, and currently have no older versions of Excel around. BTW, just spotting a minor error: the workarounds above should have been: =COUNTBLANK(C5:M5)=COLUMNS(C5:M5) =SUMPRODUCT(ISBLANK(C5:M5))=COLUMNS(C5:M5) which are equivalent, or respectively =COUNTBLANK(C5:M5)>0 =SUMPRODUCT(ISBLANK(C5:M5))>0 for the OR variant. -- You are receiving this mail because: You are the assignee for the bug.
