Issue 16862 - enter date as yyyy, default formats to yy
Summary: enter date as yyyy, default formats to yy
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: philmperry
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-07-15 04:09 UTC by philmperry
Modified: 2013-08-07 15:15 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 philmperry 2003-07-15 04:09:25 UTC 
I encounter a problem when simply entering a date in mm/dd/yyyy
format, but using the default cell format (in USA locale), which
is mm/dd/yy. The full 4-digit year is still in the data, but is
displayed as a 2-digit year. What I would like Calc's behavior to be
is, if a year is entered as four digits (e.g. mm/dd/yyyy) that the
default format for that locale be selected as one with a 4-digit
year, rather than the one with a 2-digit year. If the user explicitly
selects a date format, then of course that should be followed, but if
the format is allowed to default, it should show the full four digits
of the year if that is what was entered.

ref: issue 14735 is similar
Comment 1 oc 2003-09-17 09:40:16 UTC 
Hi Bettina, one4you
Comment 2 bettina.haberer 2003-12-10 09:59:40 UTC 
Hi, this kind of problem is covered by the following specification to be found
here. Please have a look. You can keep this issue or close it. Thank you.

http://specs.openoffice.org/calc/ease-of-use/enhance_number_recognition.sxw
Comment 3 thorsten.ziehm 2004-09-02 15:52:25 UTC 
This feature is implemented in the current version of OOo. 2.0. Please have a
look at issue 22345.
Comment 4 thorsten.ziehm 2004-09-02 15:52:41 UTC 
closed!