[Libreoffice-bugs] [Bug 42097] Formula: Search criteria fail with parenthesis and bracket characters

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Tue Oct 25 13:17:20 PDT 2011


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

--- Comment #2 from Christopher Alby <ccalby at mailbag.com> 2011-10-25 13:17:20 PDT ---
Correction, browser crashed and I missed this on the retype, sorry:

My formulas above should have a cell argument of A1 not S7: 

....
and cell A2 contains:

  =COUNTIF(A1,"this (is) [a] test")

the result of A2's formula is returned as 0 when is should be 1.  Escaping the
characters with single quotes gave the same result, e.g.:  =COUNTIF(A1,"this
'('is')' '['a']' test").
....

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


More information about the Libreoffice-bugs mailing list