https://bugs.documentfoundation.org/show_bug.cgi?id=100067
Bug ID: 100067
Summary: Spreadsheet Functions: Match and Vlookup for Exact
match
Product: LibreOffice
Version: 5.1.3.2 rc
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
When using the spreadsheet functions MATCH or VLOOKUP to search a table for an
exact match, where sort order or type = 0, these functions only seem to look at
the number of characters of the search criterion within the strings of the
search array.
For example search for "dev" will be considered an exact match to "develop",
but this is clearly not an exact match.
Search for exact match implies both strings must be the same length.
Tested with regular expressions enabled and disabled and both give the same
result.
I checked using Excel 2010, which seems to give the expected result, "dev" does
not match "develop".
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
