Issue 15425 - Date format converts data to fraction
Summary: Date format converts data to fraction
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta2
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2003-06-09 07:45 UTC by gailtb
Modified: 2013-02-07 22:41 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description gailtb 2003-06-09 07:45:02 UTC
I set the format of a cell to Date, DD/MM/YY.
Entering 1/6 in the cell defaults to 1 June this year, as I expect.
But entering 1/2 and 1/4 defaults to fractions instead of dates.

This was also an issue in version 1.0.1 from which I've just upgraded.
Comment 1 oc 2003-06-20 10:05:15 UTC
This behaviour is a feature which you can turn off by TOOLS-AUTO
CORRECT-OPTIONS-"Replace 1/2... with ...". 
Comment 2 gailtb 2003-07-15 21:46:52 UTC
This isn't meaningful behaviour.  I want 1/2 to convert to a 
fraction character in a numeric field, so I don't want to disable 
the auto-correct option.  But it just doesn't make sense for this 
behaviour to apply in a date field.
Comment 3 oc 2004-06-04 11:14:06 UTC
Issue reopened
Comment 4 oc 2004-06-04 11:16:21 UTC
As it is mentioned in
the default for the autoformat has to be changed => Bettina, please take over
for targeting a future implementation.
Comment 5 oc 2004-06-04 11:16:55 UTC
changing issue type to enhancement
Comment 6 bettina.haberer 2010-05-21 14:58:22 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".