https://bugs.documentfoundation.org/show_bug.cgi?id=164635
--- Comment #6 from m_a_riosv <[email protected]> --- (In reply to Willy from comment #3) >... > 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? AND() AND(a1:a2;b1:b2) = AND(a1;a2;b1;b2) > 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. For you maybe, but it depends on the context and the function to be able to handle it as an array. Please, @Eike could you let a comment. -- You are receiving this mail because: You are the assignee for the bug.
