To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=75987
------- Additional comments from [EMAIL PROTECTED] Sun Apr 1 23:32:09 +0000
2007 -------
The criteria for COUNTIF is case insensitive with or without regular expressions
like it is in Excel with or without wildcards. Changing this would probably
break some compatibility with Excel.
If you want to count exact case sensitive matches of the entire string you can
use an array formula like {=SUM(A1:A200="S")*1} or {=SUM(A1:A200="s")*1} . Enter
the formula without the {} and then CTRL-SHIFT-ENTER rather than ENTER.
If you need to compare case sensitive substrings rather than the entire string
use =ISNUMBER(FIND("S";A1) or =ISNUMBER(FIND("s";A1) in Cell B1 then copy and
paste the formula into Cells B2 to B200 so you have TRUE or FALSE in column B.
Then use =COUNTIF(B1:B200;1) to count the number of TRUEs.
---------------------------------------------------------------------
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]
