https://bugs.freedesktop.org/show_bug.cgi?id=75886
GerardF <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #2 from GerardF <[email protected]> --- Comparing the function result of TRUE() with the string TRUE is not advisable in my humble opinion, even with Excel, as the result of boolean function is locale dependant. Open your file with Excel and an other language and you will have problems... ="hello"&TRUE() will return "helloVRAI" with french locale and this differs from the string "helloTRUE". But if you really want to use this kind of formula, you can use the TEXT function (who is also locale dependant): ="hello"&TEXT(TRUE();"BOOLEAN") will return "helloTRUE" in EN locale. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
