Issue 10893 - Date Format and Date handling
Summary: Date Format and Date handling
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.1
Hardware: PC Windows 2000
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: jimdelilah
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-01-23 18:11 UTC by jimdelilah
Modified: 2013-08-07 15:15 UTC (History)
2 users (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 jimdelilah 2003-01-23 18:11:38 UTC 
Date Format needs to be inproved.  These are the following Issues I have with 
the date format.
1) Dates are not persistant. When a date is entered in some format MMM D YYYY
(Dec 8 2002) and then the date format is changed to YYYY MMM D (2002 Dec 8) the 
dates DO NOT change.  When changing the date format the data display needs to 
change to reflect the change.
   -- Solution?  When a cell has a date format, store the date in an internal 
format.  Then when the date format changes redisplay the cell to reflect the 
change.

2) Date cells CANNOT be sorted (by date of course).  The above solution would 
also work for this problem.

Comment::  As far as I could tell MS Office Excel 97 and XP do not have the 
above features/enhancements.  Making this change would give an advantage over 
MS office.
Comment 1 jimdelilah 2003-01-23 20:59:23 UTC 
it appears my folly has got the best of me.
The date format does work and does sort.  I was using it wrong.  I 
thought that because the date format was MMM YYYY I could enter Dec 
1999 and it would be recognized as a date.  I now realize that I must 
enter 12/01/1999 and then it will be automatacally converted to the 
MMM YYYY format.

My next suggestion is that if a date is entered in the date format 
assigned to the cell then that date format will be recognized.
(I have a feeling this could open a can of worms!)


PS
maybe someone could tell me why I cant Add/Edit Issues using Mozilla 
web browser. It keeps telling me to login.  After I login I can view 
my issues and other things.  But when I try to File and Issue or Edit 
an issue, I get the "You must Login" Screen.

Thanks.
Comment 2 t8m 2003-03-15 14:30:37 UTC 
I would like to join the suggestion to recognize the date format
assigned to the cell for date input. And I think it should be
recognized first in the assigned format and if the date parsing fails
then the language default should be tried.

Also see probably duplicate issue 11689.
Comment 3 oc 2003-09-17 09:41:25 UTC 
Hi Bettina, one4you
Comment 4 jimdelilah 2003-10-02 19:02:15 UTC 
This issue is a duplicate of Issue 3820.
I don't have the access rights to change its status to DUPLICATE.
Or I just don't know how.
Comment 5 bettina.haberer 2003-12-04 18:01:21 UTC 
Hello Jim, this feature will be implemented in OO.o 2.0. Please have a
look at the specification on
http://specs.openoffice.org/calc/ease-of-use/enhance_number_recognition.sxw

Please keep this one on your owner (until it is implemented) or close
it. Thank you.
Comment 6 jimdelilah 2003-12-04 20:28:25 UTC 
The requests made in comment 1 have been fixed in version 1.1.0.
   1) Dates do change format when the date format is changed.
   2) The date field can be sorted in any format.
Comment 7 jimdelilah 2003-12-04 20:29:55 UTC 
Because this bug has been fixed and because the bug was not dependent
on the enhanced number recognition, I am closing it.