[Libreoffice-bugs] [Bug 114660] COUNTIFS FUNCTION requires a reference to the inclusion of regular expressions in formulas
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?&DbPAR=WRITER&System=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
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
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
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
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;"<"&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. 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
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