Re: spreadsheet dates

[Morten Welinder <mwelinder gmail com>]

Ok, sit down and take a deep breath.  Make sure you sharp objects are within
reach.

Excel's numbering which Gnumeric follows incorrectly assumes that
the year 1900 was a leap year.

Evidently, OOo did not follow that crap, but that means that if you import
xls files with dates before 1-Mar-1900, then you will see different dates
(although they might try to patch things up -- an inherently impossible
task to get 100% correct).

:-/

Morten



> If I do this in gnumeric 1.5.5, I get
>
>       0  1899-12-31
>       1  1900-01-01
>   33105  1990-08-20
>
> But in OpenOffice.org 1.1.4 I get
>
>       0  1899-12-30
>       1  1899-12-31
>   33105  1990-08-20