https://bugs.freedesktop.org/show_bug.cgi?id=55369
Priority: medium Bug ID: 55369 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: FORMATTING fraction displayed and treated as dates Severity: normal Classification: Unclassified OS: All Reporter: hom...@yahoo.com 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs