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

Reply via email to