https://bugs.freedesktop.org/show_bug.cgi?id=54974
--- Comment #1 from pierre-yves samyn <pierre-yves.sa...@laposte.net> 2012-09-16 11:19:36 UTC --- Hello IMHO This is not a bug and it's been like that since version 3.4 See bug 37860 or bug 37942 Already in previous versions (OOo 3.2.1 but 2.4.2 ...): ISTEXT(B1) = true if B1 = "" ISTEXT(B1) = false if B1 is empty So a string of zero length is not equal to nothing It would have been nice if the habit is to use ... =IF(A1<>""; A1) ... with a cell style "no leading zero" so as to not display FALSE in the case of untested alternative ... Regards Pierre-Yves -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs