https://bugs.freedesktop.org/show_bug.cgi?id=74451

          Priority: medium
            Bug ID: 74451
          Assignee: libreoffice-bugs@lists.freedesktop.org
           Summary: Calc 4.2 Vlookup order parameter TRUE/FALSE doesn't
                    work as before and as Excel
          Severity: normal
    Classification: Unclassified
                OS: Windows (All)
          Reporter: masini.fabri...@gmail.com
          Hardware: All
            Status: UNCONFIRMED
           Version: unspecified
         Component: Spreadsheet
           Product: LibreOffice

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