To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94476
User fst changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Wed Oct 22 09:27:58 +0000
2008 -------
Hi,
this is another problem with Excel's Leapyear fault.
Each day is represented by an integer starting at Zero. It's the same with all
Spreadsheet applications I know. Excel starts at 00. January 1900 whilst OOo
uses December 30, 1899. Therefore day 7 after the zero date is January 6, 1900.
So the result shown for 7.6 is correct. Dates after March 1, 1900 should be
correct for both applications.
to check Excel's Zero day just type zero into a cell and format it as
dd/mm/yyyy .
Frank
---------------------------------------------------------------------
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]
