[Libreoffice-bugs] [Bug 114660] COUNTIFS FUNCTION documentation and correction not consistent

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Dec 26 18:11:38 UTC 2017


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

--- Comment #3 from tagezi <lera.goncharuk at gmail.com> ---
(In reply to MM from comment #1)
> Unconfirmed on windows 7 x64 with Version: 6.0.0.1
> Build ID: d2bec56d7865f05a1003dc88449f2b0fdd85309a
> CPU threads: 3; OS: Windows 6.1; UI render: default; 
> 
> I get the normal outcome instead of err507.
> Only with =COUNTIFS(A2:A6;E2&".*";B2:B6;"<"&MAX(B2:B6)) I get 3 as outcome
> instead of 1.

You forgot to enter a pen in the E2 cell.
And it seems, the behavior of regex has been 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/20171226/281cf2af/attachment.html>


More information about the Libreoffice-bugs mailing list