[Libreoffice-bugs] [Bug 54255] MATCH does not find empty cells

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=54255

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|NEW                         |RESOLVED

--- Comment #16 from Eike Rathke <erack at redhat.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191129/d268b58f/attachment.html>