Bug 53858 - FORMATTING: Entering fraction in pre-formated field results in dates or error
Summary: FORMATTING: Entering fraction in pre-formated field results in dates or error
Status: RESOLVED DUPLICATE of bug 55369
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.2.1 rc
Hardware: x86-64 (AMD64) Windows (All)
: highest major
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords: regression
Depends on:
Blocks:
 
Reported: 2012-08-20 20:17 UTC by Horst
Modified: 2012-09-26 21:13 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Little Calc sheet, 1, Col formated as Fraction, 2.Col =VALUE(a?) (9.01 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-08-20 20:17 UTC, Horst 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Horst 2012-08-20 20:17:35 UTC 
Created attachment 65848 [details]
Little Calc sheet, 1, Col formated as Fraction, 2.Col =VALUE(a?)

Problem description: 
 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
3. 

Current behavior:
Cell displays "1/8" left justified, VALUE(refCell)=40916 which is a date for 1/8/2012
Expected behavior:
Cell should display "1/8" right justified, VALUE(refCell)=0.125

Comment:
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
Comment 1 Horst 2012-08-22 20:06:55 UTC 
I was a bit pocking around and found 2 workarounds.
1.Workaround:
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)

2.Workaround:
Use + or = before entering the fraction. 
I consider this at least half a bug which should be fixed in the future.
Comment 2 Horst 2012-09-17 19:32:32 UTC 
I just checked out 3.5.5 and everything is fine there.
But in 3.6.x.x it is no longer working.
Comment 3 Horst 2012-09-17 22:16:09 UTC 
not resolved in 3.6.2.rc
Comment 4 Horst 2012-09-26 21:13:11 UTC 

*** This bug has been marked as a duplicate of bug 55369 ***