https://bugs.freedesktop.org/show_bug.cgi?id=54497
Bug #: 54497
Summary: VLOOKUP is not case sensitive
Classification: Unclassified
Product: LibreOffice
Version: 3.5.5.3 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
a1:a4={"A","a","=char(192)","=char(224)"}
b1:b4={1,2,3,4}
=VLOOKUP(A1,$A$1:$B$4,2,0) is 1
=VLOOKUP(A1,$A$1:$B$4,2,0) is 1
=VLOOKUP(A1,$A$1:$B$4,2,0) is 3
=VLOOKUP(A1,$A$1:$B$4,2,0) is 3
The VLOOKUP documentation in LibreOffice:
"If SortOrder is set to FALSE or zero, an exact match must be found, otherwise
the error Error: Value Not Available will be the result. Thus with a value of
zero the data does not need to be sorted in ascending order."
In OpenDocument-v1.2-part2, 6.14.12
"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."
Both documents specify an *exact* match. In 3.5.5.3, VLOOKUP is not behaving
in this manner.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- 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
