I am using OPENOFFICE.ORG 2.0 Version and I have come across a
disturbing problem bet. OPENOFFICE CALC. & MICROSOFT EXCEL.
Using EXCEL, when I enter “1 Jan 1900”, it gives me the day as SUNDAY
whereas OPENOFFICE CALC returns the day as MONDAY.
Similarly, “31 Jan 1900” with EXCEL is TUESDAY, whereas OPRENOFFICE
CALC it is WEDNESDAY.
I have also tried using the “CHOOSE” Function in both applications, but
with the same result.
The same applies to some other dates as well but not all.
I would be glad to receive your comments.
My understanding is that this is a bug in Excel. They wrongly assumed that
1900 was a leap year, when it wasn't. For the sake of compatibility, they
have left the error in Excel.
I agree that it is disturbing that they could get something like that
wrong.
The big question is: Should Calc also share the same bug for
compatibility's sake? Some would say yes. I'd probably say no.
What do you think?
Adrian
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
