https://bugs.freedesktop.org/show_bug.cgi?id=74451
--- Comment #2 from eurovillprofi <and...@eurovill.com> --- I have the same problem in the Hungarian version of LibreOffice Calc (version 4.2.0.4), on windows xp (32bit). When the ordering function gets 0/FALSE value, VLOOKUP can not find anything, it gives the #NA result. It only works with the 1/TRUE value. (In reply to comment #0) > Goodmorning, > > I'm using the Italian version of Libreoffice 4.2 but when I use the vlookup > function and I put 0 to set ordering to fals as last parameter I always get > #N/D. > > Only if I set 1 it works. But this makes data inconsistent because I don't > want to be forced to set 1 (=true). > > In Calc 4.1 and before setting 0 (=false) worked normally. > > I reverted back to 4.1 because I use Vlookup in my daily job. > > Thanks for your attention > > Fabrizio -- 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