OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: Re: [office-formula] Rob Weir's article on Microsoft XML dateproblems

> > Excel thinks that 1900 was a leap year
> > 
> > OpenFormula avoids this.
> > We do NOT require that implementations get 1900 WRONG.
> Btw, this is the reason why the "usual" null-date in OOoCalc is
> 1899-12-30 instead of 1899-12-31 as in Excel, being able to both
> correctly handle 1900 as a leap year and to get correct dates from
> 1900-03-01 on, with the consequence that all dates between 1900-01-01
> and 1900-02-28 when calculated from serial date values differ by one day
> between Excel and OOoCalc.
> Should we add this quirk to the notes of section "4.2.2 Date and DateTime"?

Yes, I think that's a good idea, and the paragraph above is a good start.
Is there anything else we should note?

--- David A. Wheeler

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]