Apache OpenOffice (AOO) Bugzilla – Issue 60007
Date generation - 30-12-1899 problem
Last modified: 2013-08-07 15:12:27 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.
confirmed on Windows XP Pro SP2 with OOo 2.0.1
Confirmed on Linux (Kernel 2.4.22-10mdk) with OOo 1.0.7 also.
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
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.
Hi, not a bug but maybe an enhancement. We act as Excel do and use the zero date. So IMO this shouldn't be changed. Frank