Created attachment 65848 [details]
Little Calc sheet, 1, Col formated as Fraction, 2.Col =VALUE(a?)
Entering a fraction (e.g 1/8) in cell which is formatted as FRACTION (# ??/??) results in displaying 1/8 but value is date 1/8/2012.
Locales is US
Steps to reproduce:
1. Format cell as Number > Fraction, select # ??/??
2. enter "1/8" into cell, hit ENTER
Cell displays "1/8" left justified, VALUE(refCell)=40916 which is a date for 1/8/2012
Cell should display "1/8" right justified, VALUE(refCell)=0.125
Excel does it right. If entered as "=1/8" or "+1/8" then correct display and value. Enter "1 1/8" ok.
Enter Result Value
1/4 ¼ char
1/2 ½ char
13/16 Err. 502 invalid date entry
Platform (if different from the browser):
Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:14.0) Gecko/20100101 Firefox/14.0.1
I was a bit pocking around and found 2 workarounds.
To avoid getting the symbols for 1/4, 1/2, 3/4 one has to disable the Autocorrect Function first.
Tools > Autocorrect Options.. > Tab:Option, uncheck "Use Replacement Table"
(Excel does not have replacement for the 3 symbols)
Use + or = before entering the fraction.
I consider this at least half a bug which should be fixed in the future.
I just checked out 3.5.5 and everything is fine there.
But in 3.6.x.x it is no longer working.
not resolved in 3.6.2.rc
*** This bug has been marked as a duplicate of bug 55369 ***