https://bugs.documentfoundation.org/show_bug.cgi?id=100177
--- Comment #4 from Octavio Alvarez <[email protected]> ---
The test file does not match the description.
Column C1 contains =IF(AND(B1>=E1,B1<=E1),"",B1) which is the equivalent of
IF(E1=E1) because it is otherwise a contradiction. So, this will always return
TRUE, and thus, C1 gets the value of B1, which contains a number.
Also, the file has C2 formatted as boolean. Boolean formatting shows FALSE on 0
and TRUE otherwise.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
