https://bugs.documentfoundation.org/show_bug.cgi?id=164635
--- Comment #4 from Willy <[email protected]> --- By the way, the function NOT to my opinion correctly resolves the pure "named range". So the formula "=AND(NOT(NOT(bool1)); NOT(NOT(bool2)))" works fine. I also tested some other functions accepting several arguments like CONCAT, CONCATENATE, SUM. While CONCATENATE resolves the named range as I expected, the functions CONCAT and SUM always take the content of the whole range. In general it should be clear, if the function resolves the values out of the range row by row or it takes the content of the whole range. May be for the logical functions AND, OR and XOR there will be a second function like it is for CONCATENATE and CONCAT, where it is clear how they handle ranges. -- You are receiving this mail because: You are the assignee for the bug.
