https://bugs.freedesktop.org/show_bug.cgi?id=55369
Priority: medium
Bug ID: 55369
Assignee: [email protected]
Summary: FORMATTING fraction displayed and treated as dates
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 3.6.1.2 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
Since version 3.6.xx a pre-formatted cell do not calculate the entered fraction
but applies the standard format rules to interpret the entry which results in
text display in cell (left aligned).
To replicate this do the following:
1) Format col A with cell format; Numbers Fraction "# ??/??"
2) enter in cell B1 =VALUE(A1)
3) copy B1 to B2:B10
4) Enter the data according to table
HINT: Don't use the fractions 1/2, 1/4, 3/4. They result in symbols due to
autocorrect table.
Table for Fraction Format hehavior:
LO Version | Entry A | Cell Display | Input Line | B = Value(Ax)
-----------------------------------------------------------------
3.5.xx | 1/8 | 1/8| 0.125 | 0.125
3.6.xx | 1/8 | 1/8 | 1/8 | 40916 = 1/8/2012
3.5.xx | 13/64 | 13/64| 0.203125 | 0.203125
3.6.xx | 13/64 | 13/64 | 13/64 | Err502
LO3.5.xx does the right job. LO3.6.xx does not recognize the formatting
for Fraction and interprets the entry as general format in this case tries to
make a Date out of it.
I set bug 53858 as duplicate. It had 2 different bugs described.
--
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
