https://bugs.freedesktop.org/show_bug.cgi?id=75886
--- Comment #4 from [email protected] --- (In reply to comment #2) > 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... I agree. FWIW, I didn't create the spreadsheet with the issue. I'm just forced to use it... > 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. I think for my case doing =A1&(if(B1,"TRUE","FALSE")) because it is not locale dependent. As I mentioned before the formula is basically like this =VLOOKUP( D13&K13, S$12:U$23,2, FALSE()) Where D13 is a string and K13 is a cell whose value comes from a checkbox (i.e. boolean). S$12:U$23 is the table region being searched so by doing =VLOOKUP( D13& (if(K13,"TRUE","FALSE"), S$12:U$23,2, FALSE()) this should hopefully * Avoid the my issue with LibreOffice's behavior * Remove locale issues that would also occur with MS-Excel * Avoid needing to change the contents of the table being used with VLOOKUP() -- 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
