https://bugs.documentfoundation.org/show_bug.cgi?id=159425
Rafael Lima <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #4 from Rafael Lima <[email protected]> --- This actually works in Calc. But for you to apply the formula as an array formula you must press Ctrl+Shitf+Enter. So basically do the following: 1) Enter the formula =AND(ISBLANK(C5:M5)) in cell A1 2) Instead of pressing Enter, press Ctrl+Shift+Enter You'll know you did it right because the formula bar will show {AND(ISBLANK(C5:M5))} to indicate this is an array formula. The reason for this ticket is that now Excel automatically understands that this is an array formula. Maybe LO should do the same. -- You are receiving this mail because: You are the assignee for the bug.
