[sc-issues] [Issue 65221] SUMIF, COUNTIF, COUNTBLANK , DCOUNT, DSUM, ... with empty cells and "" an d ="" empty string criteria

2009-01-06 Thread ztevepowell
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=65221 --- Additional comments from ztevepow...@openoffice.org Tue Jan 6 09:36:59 + 2009 --- In the other issues consolidated here there is considerable confusion abou

[sc-issues] [Issue 97711] sumif criterion differs fr om cell formula

2009-01-06 Thread ztevepowell
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97711 --- Additional comments from ztevepow...@openoffice.org Tue Jan 6 09:19:06 + 2009 --- OK; I accept that this can be treated as a 'duplicate' of 65221. I will ad

[sc-issues] [Issue 97711] sumif criterion differs fr om cell formula

2009-01-05 Thread ztevepowell
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97711 User ztevepowell changed the following: What|Old value |New value

[sc-issues] [Issue 97711] sumif criterion differs fr om cell formula

2009-01-02 Thread ztevepowell
Assigned to|spreadsheet Reported by|ztevepowell --- Additional comments from ztevepow...@openoffice.org Fri Jan 2 20:05:45 + 2009 --- sumif(a1:a3;"<>y";b1:b3) produces 10 for the following input: A1 : A2 : n A3 : y