https://bugs.documentfoundation.org/show_bug.cgi?id=159425
--- Comment #5 from Bernhard G <[email protected]> --- (In reply to LeroyG from comment #3) > (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? The AND and OR variants are not equivalent. First variant is to check if ALL cells in range are blank. Second variant is to check if ANY cell in range is blank. > Try with =COUNTIF($C5:$M5;"")>0 ... for the OR variant, and =COUNTIF($C5:$M5;"")=COLUMNS($C5:$M5) for the AND variant. I agree there are workarounds, I even listed some myself. This is not the point. > Not a bug for me. Looking at Rafael Lima's insight in #c4 above, I am no longer sure this is an error in strict technical sense. But I still believe it is really badly designed logic, and horrible UX, to deliver a constant FALSE whenever an array formula was entered with regular [Enter] key instead of [Shift]-[Ctrl]-[Enter] (which can easily happen on a busy day). Particularly as the cursor moves away from the affected cell with both plain [Enter] and [Shift]-[Ctrl]-[Enter], so the effect is not immediately visible unless the cell is manually focused again. Also, this only takes effect after the cell contents was factually changed (at least e.g. by adding a character and removing it). Just entering a cell by [F2] and confirming with [Shift]-[Ctrl]-[Enter] will NOT change its status from regular formula to array formula. So, it affords a clumsy procedure to change a formula from regular to array. I might accept this if there was a valuable use of the regular formula. But does it make any sense for the regular (non-array) formula =AND(ISBLANK(range)) to produce a constant FALSE irrespective of the range's contents? Is there any context where this would be helpful/useful in any way? -- You are receiving this mail because: You are the assignee for the bug.
