https://bugs.documentfoundation.org/show_bug.cgi?id=164635
--- Comment #3 from Willy <[email protected]> --- (In reply to m_a_riosv from comment #2) > But I don't think it is a bug. > The function evaluate as ranges, not as arrays. > You can test it putting the whole values in bool1 and bool2 as 1 e.g. > > It is possible to achieve what you want with > =AND(bool1*bool2) According to the documentation the function AND should support "cell ranges of logical values". https://help.libreoffice.org/latest/en-US/text/scalc/01/04060105.html?DbPAR=CALC When using the formula "= bool1 & bool2" I get correct values like "01", "00", "10" or "11". But the logical functions AND, OR, XOR fail to handle named ranges. All these function accept an array of expressions as arguments. But each argument (expression) should be treated like in other formulas. > The function evaluate as ranges, not as arrays. Which function do you mean? What means evaluate as ranges? For me a "named range" is an array or a matrix. In other words a two dimensional area within the sheet. -- You are receiving this mail because: You are the assignee for the bug.
