Issue 60007 - Date generation - 30-12-1899 problem
Summary: Date generation - 30-12-1899 problem
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.5
Hardware: All Windows 98
: P4 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2006-01-03 22:55 UTC by paulli
Modified: 2013-08-07 15:12 UTC (History)
5 users (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 paulli 2006-01-03 22:55:40 UTC
When entering a timevalue in a cell (e.g. 21:43) and format is set to include
the date, (e.g. DD-MM-YYYY TT:MM). The system generated information is
30-12-1899 so the displayed value is "30-12-1899 21:43:00".

It would be logical to use the current system time for fill-in.

I don't believe the issue to be related to my system/hardware as functions like
now() and today() work well.
Comment 1 lars 2006-01-04 17:56:53 UTC
confirmed on Windows XP Pro SP2 with OOo 2.0.1
Comment 2 paulli 2006-01-05 00:17:49 UTC
Confirmed on Linux (Kernel 2.4.22-10mdk) with OOo 1.0.7 also.
Comment 3 paulli 2006-01-05 09:31:10 UTC
The previous comment has an error. Sorry.

Confirmed on Linux (Kernel 2.4.22-10mdk) with OOo 1.1.5
Confirmed on WinNT 4.0 SP6 with OOo 1.1.4
Comment 4 ihnatesnstefan 2006-01-27 05:07:28 UTC
I could replicate the issue with OOo 2.0.1 and OOo 1.1.5 on Win XP Pro version 
2002 SP2.
The replication steps that I used are:
1.Open a new Spreadsheet document;
2.Enter 10:20 in cell A1 and Enter;
3.Right click on cell A1 and select “Format Cells…†from the menu;
4.Select the category “User-defined†and enter in the “Format code†textbox 
the format “DD-MM-YYYY HH:MMâ€;
5.Click OK and the value in the cell will change to “12/30/1899 20:10:00†

As a follow-up test I tried formatting the entered time to all the existing 
date formats that included the month, day and year. I observed the day added 
will always be 12/30/1899.

Probably there is a default value for the day used when only the time is 
specified in a date cell.  
Comment 5 frank 2006-01-31 15:43:30 UTC

not a bug but maybe an enhancement.

We act as Excel do and use the zero date. So IMO this shouldn't be changed.