Issue 15425 - Date format converts data to fraction
Summary: Date format converts data to fraction
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-06-09 07:45 UTC by gailtb
Modified: 2013-02-07 22:41 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

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
http://specs.openoffice.org/calc/ease-of-use/enhance_number_recognition.sxw
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".