https://issues.apache.org/ooo/show_bug.cgi?id=124248
--- Comment #4 from Andreas Säger <[email protected]> --- With column A being empty: =A1=FALSE() => TRUE (implicit conversion in boolean context) =A2="" => TRUE (implicit conversion in string context) =A3=0 => TRUE (implicit conversion in numeric context) also: =IF(A1;"y";"n") => n therefore =AND(A1;A2;A3) should return FALSE and not #VALUE! -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
