https://bugs.freedesktop.org/show_bug.cgi?id=56205
Priority: medium
Bug ID: 56205
Assignee: [email protected]
Summary: FORMATTING fractions displayed misleading and
calculated wrong
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 3.6.2.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 68817
--> https://bugs.freedesktop.org/attachment.cgi?id=68817&action=edit
TFRACXLS.XLSX
Formatting a cell in fraction format the displayed results are misleading and
wrong. The predefined formats are "# ?/?" which displays PI correctly as "3
1/7" as closest fraction. Creating userdefined formats like "?/?" or "??/??"
produces still correct results.
If you create userdefined formats with a fixed denominator like "?/n"
(n={2..9}) the result is displayed as "#?/n"-Format with missing blank. The
resulting string tricks you in believing you get the right result but you don't
(see rows 3 to 5 in table).
The problem is that the parser interprets formats "?/n" (n={2..9}) as "#?/n"
with missing displayed blank.
Format PI display should be
?/? 22/7 22/7
??/?? 311/99 311/99
?/8 31/8 25/8 or (3 1/8)
?/7 31/7 22/7 or (3 1/7)
?/6 31/6 19/6 or (3 1/6)
Furthermore if you save the file as .ods, close calc, open saved file all
fraction formats "?/n" are reset to "?/?".
The number format dialog shows none of the previously defined formats, they are
in the list but reset to a default format.
We might have 2 bugs here:
1) the reset/not saving part can be related to bug 38097
2) the display flaw is new and was discussed in the same bug
I created a test file with Excel TFRACXLS.XLSX. It might have one flaw line 2
shows 22/7 which is closer to PI than 311/99??
File opened in CALC has all formats but wrong display. Saving file as .ods,
reopen -> formats resetted to ?/?.
Gnumeric has the same right behavior as Excel.
Saving the file in Excel as .ods results in chaos in CALC but not in Gnumeric
(another bug??).
I tested it with LO3.5.5 up to 3.6.2.2.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
