https://bugs.freedesktop.org/show_bug.cgi?id=77343
m.a.riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG CC| |[email protected] --- Comment #1 from m.a.riosv <[email protected]> --- Hi Nick, thanks for reporting. If you disable regular expressions in: Menu/Tools/Options/LibreOffice calc/Calculation - regular expression, the formula works fine. Please take in account that COUNTIF() use regular expressions and the parenthesis are part of them, to search for a parenthesis with regular expressions activated you need to precede the parenthesis with a back slash \( or \). (Search in the help for regular expression to learn more about it). To solve this situation you can do: =COUNTIF(A1:A4;SUBSTITUTE(SUBSTITUTE(A1;"(";"\(");")";"\)")) So for me there is not a bug, please if you are not agree reopen it. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
