https://bugs.documentfoundation.org/show_bug.cgi?id=54255
Mike Kaganski <mikekagan...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|REOPENED |RESOLVED
Resolution|--- |NOTABUG
--- Comment #18 from Mike Kaganski <mikekagan...@hotmail.com> ---
(In reply to David Lynch from comment #17)
As you mentioned, the specification defines the Search argument as 'Scalar',
which is defined in ODF 1.3 sect. 4.11.2 'Scalar' (there's the same definition
in ODF 1.2, so the spec version doesn't matter in this case):
> A Scalar value is a value that has a single value. A reference to more than
> one
> cell is not a scalar (by itself), and is converted to one as described below.
> An
> array with more than one element is not a scalar. The types Number (including
> a
> complex number), Logical, and Text are scalars.
Further, there is ODF 1.3 sect. 4.7 'Empty Cell':
> An empty cell is neither zero nor the empty string, and an empty cell can be
> distinguished from cells containing values (including zero and the empty
> string).
> An empty cell is not the same as an Error, in particular, it is
> distinguishable
> from the Error #N/A (not available).
No, there is no need in MATCH to define any kind of "exception allowed for
empty cells", because the standard already defines that empty cell is not the
same as the scalars you can put into the function's 'Search' argument. Neither
"" nor 0 (nor any regex) may match an empty cell.
No, this in not a bug, nor should it change.
--
You are receiving this mail because:
You are the assignee for the bug.
