To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87954 Issue #|87954 Summary|values in a frequency array randomly move around Component|Spreadsheet Version|OOo 2.4.0 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|viewing Assigned to|spreadsheet Reported by|jphutch
------- Additional comments from [EMAIL PROTECTED] Sun Apr 6 15:22:21 +0000 2008 ------- Sorry, but I'm not sure how to explain this problem. I have a sheet with data on dice rolls. In the attached file, 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. I used the "frequency" array formula in order to count the frequencies of each sum (2, 3, 4...12). Using a computer running Ubuntu Gutsy Gibbon and I believe version 2.3 of OO, the frequency function worked fine. After upgrading to Hardy and version 2.4, however, the data is out of order. 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 or on Linux version 2.3. 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 (but 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 I hope someone can confirm this as it's very odd and very frustrating. I have confirmed similar behavior on two separate installs of Hardy. PS, I thought I would be able to attach a file but I don't see the option. In case I can't, I originally filed this bug on Launchpad. The files are there https://bugs.edge.launchpad.net/ubuntu/+source/openoffice.org/+bug/209474. --------------------------------------------------------------------- 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]
