openoffice-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Perry 'Johnny' Levine <perrylev...@netscape.net>
Subject DATE ISSUE in OpenOffice Spreadsheet
Date Mon, 05 Oct 2015 09:49:10 GMT
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.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message