Apache OpenOffice (AOO) Bugzilla – Issue 35485
Arbitrary precision in fraction number formats
Last modified: 2017-05-20 11:13:38 UTC
previously I have report this issue, but I think I did write the problem clearly and correctly. Hear is the problem: When I enter =(1/60)^2 in spreadsheet, it come out 0.000277777777777778 in both excell and spreadsheet(openoffice1.1.3) if I want it display in decimal. However, If I enter the formula =(1/60)^2 in excel and make a custom format on the cell with # ?/????, it would come out 1/3600. But if I make a custom format in openoffice(1.1.3) with # ?/????, the outcome is 1/3333. This is incorrect because the square of (1/60) is 1/3600, but is not 1/3333. I would consider this is a serious bug in spreadsheet.
Hi Niklas, a known rounding error ? Frank
No, a deliberate decision. The full iteration for the closest fraction is done only up to 3 digits. Above that, an approximation is used. Maybe this should be changed, but I don't consider it important at the moment.
Accepted. Adjusting summary.
P4 OOoLater.
Reset assigne to the default "issues@openoffice.apache.org".