[Libreoffice-bugs] [Bug 114660] COUNTIFS FUNCTION requires a reference to the inclusion of regular expressions in formulas

[bugzilla-daemon]

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

sdc.bla...@youmail.dk changed:

   What|Removed |Added

 Status|NEW |RESOLVED
   Assignee|libreoffice-b...@lists.free |sdc.bla...@youmail.dk
   |desktop.org |
 Resolution|--- |FIXED

--- Comment #7 from sdc.bla...@youmail.dk ---
Confirm that all examples in: 
https://help.libreoffice.org/7.1/en-US/text/scalc/01/func_countifs.html?=WRITER=UNIX

give the results as described on that page, when using 7.1.0.0.alpha1+

Have added a paragraph to the section of examples using regular expressions, to
indicate that it is necessary to enable regular expressions in formulas in the
Options.  Closing as FIXED.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114660] COUNTIFS FUNCTION requires a reference to the inclusion of regular expressions in formulas

[bugzilla-daemon]

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

--- Comment #6 from Commit Notification 
 ---
Seth Chaiklin committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/help/commit/4e4118d7e8b08b9ea42e37f75f7ef168bdab0745

tdf#114660 add explanation about setting regex option in Calc help example

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114660] COUNTIFS FUNCTION requires a reference to the inclusion of regular expressions in formulas

[bugzilla-daemon]

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

Commit Notification  changed:

   What|Removed |Added

 Whiteboard||target:7.1.0

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114660] COUNTIFS FUNCTION requires a reference to the inclusion of regular expressions in formulas

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 Blocks|80430   |


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=80430
[Bug 80430] [META] LOCALHELP: Features x Documentation gap
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114660] COUNTIFS FUNCTION requires a reference to the inclusion of regular expressions in formulas

[bugzilla-daemon]

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

--- Comment #5 from MM  ---
(In reply to tagezi from comment #3)
> (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;"<"(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.

Thanks for pointing that out, now it reads 0 instead of 1. Still no err 507
though.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114660] COUNTIFS FUNCTION requires a reference to the inclusion of regular expressions in formulas

[bugzilla-daemon]

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

tagezi  changed:

   What|Removed |Added

   Keywords||easyHack
 Status|NEEDINFO|NEW
   Hardware|x86-64 (AMD64)  |All
Summary|COUNTIFS FUNCTION   |COUNTIFS FUNCTION requires
   |documentation and   |a reference to the
   |correction not consistent   |inclusion of regular
   ||expressions in formulas
   Severity|normal  |trivial

--- Comment #4 from tagezi  ---
Tools -> Options... LibreOffice Calc -> Enable regular expressions in formulas

source/text/scalc/01/func_countifs.xhp

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs