https://bugs.documentfoundation.org/show_bug.cgi?id=54497
David Lynch <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|NOTABUG |--- --- Comment #9 from David Lynch <[email protected]> --- The primary specification is the ODF at <http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#VLOOKUP>: If RangeLookup is FALSE or 0, DataSource does not need to be sorted and an exact match is searched. Each value in the first column of DataSource is examined in order (starting at the top) until its value matches Lookup. If no value matches, the #N/A Error is returned. ... an *exact* match is searched, no ifs or buts. Of lesser importance is any workaraound for this bug. Libreoffice should not be acquiescing in bugs in Excel. -- 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
