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.
*** Bug 53858 has been marked as a duplicate of this bug. ***
On pc Debian x86-64 with master sources updated today, I reproduced the problem. Eike: one for you?
marking as regression, also I'll have a look
I'm taking over.
Don't fight over it, I have more.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=5391bd1e54157457abe1098b29f067d6e0059113 resolved fdo#55369 accept fraction input if preset The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-3-6-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=bb3e32b00521633e68d9a412402bb21c87c5ef90&g=libreoffice-3-6-4 resolved fdo#55369 accept fraction input if preset It will be available already in LibreOffice 3.6.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-3-6": http://cgit.freedesktop.org/libreoffice/core/commit/?id=97b0efc6145cd7153c724c1135eb65ee941d60d5&g=libreoffice-3-6 resolved fdo#55369 accept fraction input if preset It will be available in LibreOffice 3.6.5. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Works fine in Version 3.6.5.0+ (Build ID: 95637e2).
Fixed for version Version 4.0.0.0.alpha0+ (Build ID: 04f2f0).
Works fine in Version 3.6.4.1 (Build ID: a9a0717).
updating version as I was able to verify that this existed in Version 3.6.0beta1 (Build ID: 1f1cdd) Running Bodhi Linux 2.2 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ QA & Devs are trying to find how many bugs were introduced within a minor release of 3.6 - this was introduced during the change from 3.5 to 3.6 :) Glad it got fixed