You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/10/20 14:35:48 UTC
[Bug 123502] New: MATCH returns last position for empty value
https://issues.apache.org/ooo/show_bug.cgi?id=123502
Bug ID: 123502
Issue Type: DEFECT
Summary: MATCH returns last position for empty value
Product: Calc
Version: 4.0.1
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: editing
Assignee: issues@openoffice.apache.org
Reporter: villeroy@t-online.de
CC: issues@openoffice.apache.org
MATCH(<empty cell>;A1:A5) returns 5
It used to be #N/A as:
VLOOKUP(<empty cell>;A1:A5;1) returns #N/A
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123502] MATCH returns last position for empty value
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123502
Regina Henschel <rb...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |rb.henschel@t-online.de
--- Comment #1 from Regina Henschel <rb...@t-online.de> ---
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.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123502] MATCH returns last position for empty value
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123502
--- Comment #2 from Andreas Säger <vi...@t-online.de> ---
=MATCH(A1;{11;12;13;14;15}) returns 5 if A1 is empty, blank, null, nada,
nothing.
It should return #N/A.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123502] MATCH returns last position for empty value
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123502
Regina Henschel <rb...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
Ever confirmed|0 |1
--- Comment #3 from Regina Henschel <rb...@t-online.de> ---
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.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.