To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94801





------- Additional comments from [EMAIL PROTECTED] Fri Oct 10 10:38:52 +0000 
2008 -------
I'd like to clarify the issue, since my first attempt to simplify the case was
apparently misleading.

1. Enter "C++" into cell A1 (without the quotes)
2. Enter =countif(A1:A1;"=C++") into cell A2
3. Enter =A1="C++" into cell A3

Results:
A2 shows "0" (regexes enabled for formulas) or "1" (regexes disabled)
A3 always shows TRUE

The result for cell A2 is consistent with the documentation (although I'd rather
have an additional parameter for COUNTIF to decide if I want regexes interpreted
in this formula instead of an application-global setting). The results for cell
A3 is at best irritating. It *is* a formula, and as such the global "regexes
enabled for formulas" setting should be respected. 
Furthermore, I don't quite see why a comparison as *part* of a function call
gives not the same result as when I use the comparison by itself.



---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to