Hi, > 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'.
The default starting date is 30 December 1899 = 0 please see https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_Date_%26_Time_functions Regards Oliver --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org