[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

--- Comment #11 from himajin100000 at gmail.com ---
And what I can tell from the code,

=COUNTIF(B1:B5,"^$") returns 0, when regular expression is enable in option and
all the 5 cells in B1:B5 is empty.

However,
=COUNTIF(B1:B5,"") is 5

minor note:
honestly speaking, as of 2018-07-02T08:37(UTC) ,
I don't think I can find the INDICATED description on how MATCH function should
work for the empty cells. just VLOOKUP. I can agree that the document 
SUGGESTS/IMPLIES the behavior.

-- 
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/20180702/6a0fcfd1/attachment.html>