https://issues.apache.org/ooo/show_bug.cgi?id=122927
--- Comment #7 from Rob Weir <[email protected]> --- C3 is empty, but the test is for a space, not an empty cell. (It tests for " " not ""). Try entering a space in C3 and you'll get the 0. What is happening here is the evaluation falls through to the embedded IF(C3="N";125). Here the formula does not specify an "else" value. So the correct behavior, per the ODF standard, is to return FALSE(). See: http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018446_715980110 So I think this is correct. -- 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.
