To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50460 Issue #:|50460 Summary:|Date Default of 30/12/1899 gives strange results in |MS Excel files Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|Opteron/x86_64 URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P4 Subcomponent:|configuration Assigned to:|spreadsheet Reported by:|tonytarrant
------- Additional comments from [EMAIL PROTECTED] Wed Jun 8 00:58:37 -0700 2005 ------- The date default is showing 30/12/1899 and can not be changed. This seems odd because it makes date value: 0=30/12/1899 1=31/12/1899 2=1/1/1900 The choice of 30 December appears to have no logic, and may be an error. This compares to MS Excel: 0=31/12/1899 1=1/1/1900 i.e. 1 being the first date of the century which is logical. It is therefore possible to have an MS Excel workbook with date formulae that get completely screwed up when opened in Calc. Result opening attached in MS Excel: 01/01/1900 02/01/1900 2.00 21 Result opening attached in Calc: 31/12/1899 1/01/1900 2.00 21 This would appear to affect all workbooks with date values. TT. PS: Couldn't work out attachments so here are the MS Excel cell values/formulae: A1 & B1 formatted as dates, C1 as decimal 2, all other cells normal so display is as above. 1 =A1+1 =B1 =B1&A1 --------------------------------------------------------------------- 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]