https://bugs.documentfoundation.org/show_bug.cgi?id=159425
LeroyG <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #3 from LeroyG <[email protected]> --- (In reply to Bernhard G from comment #0) > =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. But if result is TRUE when at least once cell is blank, how can I know when all cells are blank? Try with =COUNTIF($C5:$M5;"")>0 Not a bug for me. -- You are receiving this mail because: You are the assignee for the bug.
