To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72687 Issue #|72687 Summary|Date System: the 1900 Date System and the 1904 Date Sy |stem Component|Spreadsheet Version|OOo 2.1 Platform|All URL|http://support.microsoft.com/?scid=kb%3Ben-us%3B214330 |&x=5&y=13 OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|configuration Assigned to|spreadsheet Reported by|jlcheng
------- Additional comments from [EMAIL PROTECTED] Sun Dec 17 22:53:06 -0800 2006 ------- Ref: http://support.microsoft.com/?scid=kb%3Ben-us%3B214330&x=5&y=13 I have find OO.o has three "Date System", that's very good. But I find MS Excel default date system is different to OO.o's default. OO.o's default is "value 0 corresponds 12/30/1899", it's not the 1900 date system. And the worse is no the 1900 date system in OO.o. You can find the other two is "value 0 corresponds 1/1/1900" and "value 0 corresponds 1/1/1904". One is not named date sysytem and the other is the 1904 date system. I guess maybe OO.o default date system is not right, should be the 1900 date system, and should be "value 0 corresponds 12/31/1899". I think my idea maybe right. Do you think so? Attachment file is screen shot of calc option with OO.o 2.1.0. --------------------------------------------------------------------- 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]
