https://bugs.freedesktop.org/show_bug.cgi?id=58838
--- Comment #4 from Owen Genat <owen.ge...@gmail.com> --- David, I would agree. Furthermore, under Tools > Options... > LibreOffice Calc > Formula > Detailed calculation settings > Custom > Details... (v4.0.2.2) it makes no difference to the results of the example spreadsheet I provided whether "Treat empty string as zero" is set to True or False (default). On the surface, this would seem problematic, however I am not sure it is that simple. The reason I was hesitant to suggest my test as a confirmation is because it may illustrate more than one issue or even a different issue. The infix operator "=" may not be in error. Rather it could be the manner in which certain characters are handled or reported to the infix operator. It could also be a problem with the handling of the empty string value. I am not familiar with the code enough to determine is this is the case or not. >From the perspective of a user it does appear, in simple terms, that there is a problem of some kind, but what the technical nature of that problem is, I am uncertain. As mariosv indicates, if some of these characters have special meaning, it may not be possible to conduct equality tests via the infix operator "=". I will be interested in the outcome either way. -- 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