[sc-issues] [Issue 97733] errors counted as 0 by cou ntif(...,"=0)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97733 User er changed the following: What|Old value |New value Version|OOo 3.1.1 |OOo 2.4.1 --- Additional comments from e...@openoffice.org Tue Feb 9 12:44:02 + 2010 --- Please don't fiddle with the version field, it indicates for which version an issue was reported first. Thanks. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97733] errors counted as 0 by cou ntif(...,"=0)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97733 User bfields changed the following: What|Old value |New value Version|OOo 2.4.1 |OOo 3.1.1 - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97733] errors counted as 0 by cou ntif(...,"=0)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97733 --- Additional comments from bfie...@openoffice.org Thu Feb 4 20:50:43 + 2010 --- Loaded testcase with 3.1.1 (from Ubuntu Karmic's openoffice-calc version 1:3.1.1-5ubuntu1), and it still gives the incorrect result (2). - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97733] errors counted as 0 by cou ntif(...,"=0)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97733 User er changed the following: What|Old value |New value Assigned to|spreadsheet |er Ever confirmed| |1 Status|UNCONFIRMED |NEW Subcomponent|code |programming Target milestone|--- |OOo 3.x --- Additional comments from e...@openoffice.org Wed Jan 7 12:37:26 + 2009 --- The result of course should be 1 and not 2. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97733] errors counted as 0 by cou ntif(...,"=0)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97733 --- Additional comments from bfie...@openoffice.org Sun Jan 4 04:23:43 + 2009 --- (Err, sorry, I meant to say the result in the Excel case is 1, not 0.) - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97733] errors counted as 0 by cou ntif(...,"=0)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97733 --- Additional comments from bfie...@openoffice.org Sun Jan 4 04:22:18 + 2009 --- Created an attachment (id=59119) testcase - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97733] errors counted as 0 by cou ntif(...,"=0)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97733 Issue #|97733 Summary|errors counted as 0 by countif(...,"=0) Component|Spreadsheet Version|OOo 2.4.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|bfields --- Additional comments from bfie...@openoffice.org Sun Jan 4 04:21:22 + 2009 --- Consider e.g. a spreadsheet with just: =1/0 0 1 =COUNTIF(A1:A3;"=0") The result in the fourth cell is 2. Excel gives 0, which seems more natural to me. (Noticed importing from an excel spreadsheet to Mac OpenOffice; reproduced OO behavior on a Ubuntu system.) - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org