[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