https://bugs.documentfoundation.org/show_bug.cgi?id=165000
Bug ID: 165000
Summary: MATCH error
Product: LibreOffice
Version: 24.2.7.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
MATCH function not finding an exact match as it should.
Steps to Reproduce:
1. names in column C, cells: C5= "boat one", C6= "boat two", C7= "boat three",
C8= "boat"
2. cells: D5= "bad1", D6= "bad2", D7= "bad3", D8= "good"
3. cell F5= "boat" which is the term I want to match exactly
4. Cell G5 contains formula": =INDEX(D5:D8,(MATCH(F5,C5:C8,0)))
5. The return value in cell G5 is "bad1" instead of "good" as it should be.
The intent is to find the value in column D that exactly matches the name from
columns C, but the match function is returning the first matching letters so it
stops at row 5 instead of row 8 as it should. This function has been working
correctly for a few years now in my spreadsheet, but something has changed in
the latest version of calc that has caused it to not work correctly.
Actual Results:
see "steps to reproduce"
Expected Results:
see "steps to reproduce"
Reproducible: Always
User Profile Reset: No
Additional Info:
see "steps to reproduce"
--
You are receiving this mail because:
You are the assignee for the bug.
