[Libreoffice-bugs] [Bug 52417] New: COUNTIF() wraps all regular expressions with ^ and $

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=52417

             Bug #: 52417
           Summary: COUNTIF() wraps all regular expressions with ^ and $
    Classification: Unclassified
           Product: LibreOffice
           Version: 3.5.3 release
          Platform: x86-64 (AMD64)
        OS/Version: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: freedesktop at multiwebinc.com


Created attachment 64571
  --> https://bugs.freedesktop.org/attachment.cgi?id=64571
Test file

Following the example from
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Regular_Expressions_in_Calc#Regular_expressions_in_Calc_functions
I am getting a different result. Entering:

=COUNTIF(cell , "text")

actually becomes:

=COUNTIF(cell , "^text$")

So if a cell contains "123textABC" doing =COUNTIF(cell , "text") will not find
a match, however it should. I have attached a test file which produces an error
with a few cells.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.