To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87966 Issue #|87966 Summary|Function frequency does not calculate correctly in 2.4 |.0 Component|Spreadsheet Version|OOo 2.4.0 Platform|PC URL|https://bugs.launchpad.net/ubuntu/+source/openoffice.o |rg/+bug/209474 OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|txwikinger
------- Additional comments from [EMAIL PROTECTED] Sun Apr 6 21:27:23 +0000 2008 ------- As Jim Hutchinson describes in (https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/209474): I mistakenly submitted this as question 28478. I'm adding it here as well since I can include the file. Sorry, but I'm not sure how to explain this problem. In short, the spreadsheet is not working correctly. I have a sheet with data on dice rolls for a project my daughter is working on. Column B and C, for example contain data on dice rolls. Column D is the sum of these two dice rolls using the sum function. She needed to count the frequencies of each sum (2, 3, 4...12). Using the frequency function this worked fine. After upgrading to hardy, however, the data is wrong. In the attached file, columns P and Q contain the frequencies of the sums in columns D and G. When opened with Open Office in Hardy, the values in these columns are not the same as those generated using Open Office in Windows (sorry, I had to test somewhere). For comparison, the values in cells P3-P13 should be: 2, 16, 31, 24, 30, 50, 33, 29, 16, 13, 8 For cells Q3-Q13: 5, 11, 24, 17, 35, 36, 33, 39, 32, 13, 7 When I open this file in Hardy I get the following (note that these seem to change with each save and open) P3-P13: 30, 16, 31, 24, 33, 50, 2, 29, 16, 13, 8 Q3-Q13: 33, 11, 24, 17, 36, 35, 5, 39, 32, 13, 7 (It works correctly on 2.3.0 and wrongly on 2.4.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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
