Speadsheet has problems in hardy

Asked by Jim Hutchinson

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:
Revision history for this message
Jim Hutchinson (jphutch) said :
#1

Oops, I meant to do a bug report. It's bug 209474.

I have confirmed similar behavior on two separate installs of Hardy.

Can you help with this problem?

Provide an answer of your own, or ask Jim Hutchinson for more information if necessary.

To post a message you must log in.