Bug 100067 - Spreadsheet Functions: Match and Vlookup for Exact match
Summary: Spreadsheet Functions: Match and Vlookup for Exact match
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-05-26 15:48 UTC by Mark_T2016
Modified: 2016-05-27 20:41 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Mark_T2016 2016-05-26 15:48:35 UTC 
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".
Comment 1 Mark_T2016 2016-05-26 16:14:35 UTC 
Confirmed the same issue is also present in 5.1.3.2, 32 bit version.

Also in 5.0.6.3 x64.
Comment 2 Eike Rathke 2016-05-26 17:17:44 UTC 
Check your setting of Tools - Options - Calc - Calculate, section "General Calculations" "Search criteria = and <> must apply to whole cells". Likely it's off, set it on.
Comment 3 Mark_T2016 2016-05-27 20:41:11 UTC 
Thanks, It was off, never expected this to be a configurable option.