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] Sat Jun 28 04:34:00 +
2008 ---
Further to drensink's workaround:
=SUMPRODUCT(ISNUMBER(FIND("S";A1:A200))) in a ce
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] Thu Oct 25 08:00:40 +
2007 ---
Further notes:
Issue 32344 discusses an enhancement to use wildcards, and general
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=75987
User drking changed the following:
What|Old value |New value
===
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] Tue Apr 3 21:26:41 +
2007 ---
I believe that {=SUM(A1:A200="S")*1} or =ISNUMBER(FIND("S";A1) are NOT a real
solut
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] Mon Apr 2 05:36:01 +
2007 ---
Thanks.
> Changing this would probably break some compatibility with Excel.
no co
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 +
2007 ---
The criteria for COUNTIF is case insensitive with or without regular expressions
li
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=75987
Issue #|75987
Summary|regular expression in calc formula
Component|Spreadsheet
Version|1.0.0
Plat