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]
