Issue 123502 - MATCH returns last position for empty value
Summary: MATCH returns last position for empty value
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.0.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-10-20 12:35 UTC by Andreas Säger
Modified: 2013-10-20 15:56 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

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

Note You need to log in before you can comment on or make changes to this issue.
Description Andreas Säger 2013-10-20 12:35:48 UTC 
MATCH(<empty cell>;A1:A5) returns 5

It used to be #N/A as:
VLOOKUP(<empty cell>;A1:A5;1) returns #N/A
Comment 1 Regina Henschel 2013-10-20 13:17:23 UTC 
It is not clear, what <empty cell> means and it is not clear, what content is in the cells A1:A5. Please attach a document with this error.
Comment 2 Andreas Säger 2013-10-20 14:35:05 UTC 
=MATCH(A1;{11;12;13;14;15}) returns 5 if A1 is empty, blank, null, nada, nothing.
It should return #N/A.
Comment 3 Regina Henschel 2013-10-20 15:56:44 UTC 
I do not find an explicit rule, what to do in case of a reference to an empty cell. But #N/A makes sense, OpenOffice.org 1 had returned #N/A, and both LibreOffice and Gnumeric return #N/A. So I support to change the behavior to return #N/A for a reference to an empty cell.