To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113694 Issue #|113694 Summary|Time format error Component|Spreadsheet Version|1.0.0 Platform|PC URL| OS/Version|Windows 7 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|dbssbd
------- Additional comments from [email protected] Thu Aug 5 23:22:25 +0000 2010 ------- The date and time are displayed incorrectly if the time is 00:00:00 In the example below the date and time 04/01/10 0:00:00 enters twice: time = 40269 in line 2, and time = 40270 in line 26. I have OO 3.2.1 OOO320m18 (Build:9502) installed on W7 64 bit Dell Precision M4500 The .ods file is available. Best regards, DBSsbd Example: Date Time 04/01/10 0:00:00 04/01/10 1:00:00 04/01/10 2:00:00 04/01/10 3:00:00 04/01/10 4:00:00 04/01/10 5:00:00 04/01/10 6:00:00 04/01/10 7:00:00 04/01/10 8:00:00 04/01/10 9:00:00 04/01/10 10:00:00 04/01/10 11:00:00 04/01/10 12:00:00 04/01/10 13:00:00 04/01/10 14:00:00 04/01/10 15:00:00 04/01/10 16:00:00 04/01/10 17:00:00 04/01/10 18:00:00 04/01/10 19:00:00 04/01/10 20:00:00 04/01/10 21:00:00 04/01/10 22:00:00 04/01/10 23:00:00 04/01/10 0:00:00 04/02/10 1:00:00 04/02/10 2:00:00 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
