Apache OpenOffice (AOO) Bugzilla – Issue 25502
Input "0 7/12" displayed as "4/7"
Last modified: 2004-02-16 11:16:33 UTC
Open a new spreadsheet. Type into any cell "0 7/12". Press Enter. Fraction is displayed as "4/7", expected: "7/12" The input line shows "0,583333333333333" which correctly approximates "7/12". So this bug won't result in wrong calculations. However this wrong display of a fraction is extremely irritating and could result in people believing Calc can't calculate, which is why I set priority to P1. By the way: This behaviour seems to be related with "7" as a numerator in a fraction.
Another one with 9 as numerator: type "0 9/12", turns into "1/9".
The cause of that is the format code. By default it is "# ?/?". So when you have only one digit for the denominator the nearest to 0.583333333333333 ist 4/7. Perhaps changing the default to "# #?/#?" can solve the problem. In case of "0 9/12" I get correctly "3/4" by OOo1.1 on Win98.
Thanks, Regina. The fractions are displayed correctly now with the format settings you suggested. I will attach a document which shows various wrongly displayed fractions, with both the default and the user defined fraction formats. "0 9/12" is not among them. I can't repeat that myself, maybe a mistake on my side.
Created attachment 13145 [details] bugdoc cont. wrongly displayed fractions
Hi, sorry to tell you that this is not a bug. The '?' stands for one decimal in this case and therefore the result from 9/10 (0.9) is the same as the nearest one 8/9 which is 0.89. Using the nearest equivalent for displaying the result is the goal, so we work as specified. Also the compatibility between Excel and Calc has to be considered. And Excel works in the same way as Calc do. So sorry to tell you but this is not a bug. Frank PS. The priority choosen is much to high. Prio 1 means the whole application is useless or can't be started. This is clearly not the case.
closed wontfix