Mailing-List: contact dev-help@openoffice.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@openoffice.apache.org
Subject: Re: DATE ISSUE in OpenOffice Spreadsheet
To: dev@openoffice.apache.org
References: <1503767a581-7166-23733@webprd-m28.mail.aol.com>
From: Oliver Brinzing <Oliver.Brinzing@gmx.de>
Message-ID: <5612AD37.5000006@gmx.de>
Date: Mon, 5 Oct 2015 19:02:47 +0200
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:38.0) Gecko/20100101
 Thunderbird/38.2.0
MIME-Version: 1.0
In-Reply-To: <1503767a581-7166-23733@webprd-m28.mail.aol.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

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