https://bugs.documentfoundation.org/show_bug.cgi?id=54255
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
Status|NEW |RESOLVED
--- Comment #16 from Eike Rathke <[email protected]> ---
All three forms in comment 0 original description do *not* search for an empty
cell without content.
=match("",A1:A2,0) [1]
searches for content of an empty string.
=match("^$",A1:A2,0) [2]
searches for content with an empty paragraph.
=match(0,A1:A2,0) [3]
searches for content of numeric 0.
There is no way to find an empty cell with MATCH() or VLOOKUP() or HLOOKUP().
Also, the mentioned help page does not indicate this would be possible. It
describes the handling of empty cells *returned* by VLOOKUP() and in use with
comparison operators.
The search Criterion mentioned in comment 8 as used for the COUNTIF() family of
functions is a different syntax and completely unrelated.
The behaviour will not be changed.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
