openoffice-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Oliver Brinzing <Oliver.Brinz...@gmx.de>
Subject Re: DATE ISSUE in OpenOffice Spreadsheet
Date Mon, 05 Oct 2015 17:02:47 GMT
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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org


Mime
View raw message