Speadsheet has problems in hardy
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
I hope someone can confirm this as it's very odd and very frustrating.
Question information
- Language:
- English Edit question
- Status:
- Open
- For:
- OpenOffice Edit question
- Assignee:
- No assignee Edit question
- Last query:
- Last reply:
Can you help with this problem?
Provide an answer of your own, or ask Jim Hutchinson for more information if necessary.