There seems to be an issue of how some1900 dates are being stored in the 
OpenOffice spreadsheet.

It is my understanding that dates are stored with spreadsheet as a serial 
number starting with 01/01/1900
being stored as a '1'.

When 01/01/1900 is looked at as a general number format in OpenOffice it 
appears as '2' versus a '1'.
When 02/01/1900 is looked at as a general number format in OpenOffice is 
appears as '33' versus '32'.
When 12/31/1900 is looked at as a general number format in OpenOffice it 
appears as '366' which would be correct
since 1900 is a leap year.


12/31/1900 is the stored as the correct serial number because 02/29/1900 is not 
considered a valid date in 
OpenOffice and therefore 03/01/1900 is stored as a '61' which is correct and 
the following dates are stored
correct for 1900. 

Will look at other years which are leap years to see if similar problem exists.

Reply via email to