RE: [users] Date issue on open office.org calc

2007-07-12 Thread Kirill S. Palagin
-Original Message- From: Lasantha Marian [mailto:[EMAIL PROTECTED] Sent: Thursday, July 12, 2007 8:39 AM This problem has been there since the beginning of OOo 2.2.x (starting with RCs') and I have brought the attention of the developers also to the same by this bug report

Re: [users] Date issue on open office.org calc

2007-07-12 Thread Robin Laing
Lasantha Marian wrote: *--- Original Message * *Subject: * [users] Date issue on open office.org calc *Date: *Thu, 12/Jul/2007 5:01:13 AM +0550 *From: *Jonathon Coombes [EMAIL PROTECTED] *To: * users@openoffice.org On 11/07/2007, at 9:56 PM, Lasantha Marian

Re: [users] Date issue on open office.org calc

2007-07-11 Thread Harold Fuchs
Lasantha Marian wrote: This problem has been there since the beginning of OOo 2.2.x (starting with RCs') and I have brought the attention of the developers also to the same by this bug report (http://www.openoffice.org/issues/show_bug.cgi?id=75118). Nothing positive has happened yet. OOo 2.0.x

Re: [users] Date issue on open office.org calc

2007-07-11 Thread Michael Adams
On Wed, 11 Jul 2007 17:50:54 +0100 Harold Fuchs wrote: Could this be connected to the fact that Excel wrongly believes that 1900 was a leap year? Dates are stored as the number of dates since some epoc date, often 1/1/1900. Using this we see that, using *Excel* 1 Jan 1900 is stored as 0

Re: [users] Date issue on open office.org calc

2007-07-11 Thread Jonathon Coombes
On 11/07/2007, at 9:56 PM, Lasantha Marian wrote: This problem has been there since the beginning of OOo 2.2.x (starting with RCs') and I have brought the attention of the developers also to the same by this bug report (http://www.openoffice.org/issues/show_bug.cgi?id=75118). Nothing positive

Re: [users] Date issue on open office.org calc

2007-07-11 Thread Jonathon Coombes
On 12/07/2007, at 2:50 AM, Harold Fuchs wrote: Lasantha Marian wrote: This problem has been there since the beginning of OOo 2.2.x (starting with RCs') and I have brought the attention of the developers also to the same by this bug report

Re: [users] Date issue on open office.org calc

2007-07-11 Thread Lasantha Marian
*--- Original Message * *Subject: * [users] Date issue on open office.org calc *Date: *Wed, 11/Jul/2007 10:20:54 PM +0550 *From: *Harold Fuchs [EMAIL PROTECTED] *To: * users@openoffice.org *CC: * Jonathon Coombes [EMAIL PROTECTED] Lasantha Marian wrote:

Re: [users] Date issue on open office.org calc

2007-07-11 Thread Lasantha Marian
*--- Original Message * *Subject: * [users] Date issue on open office.org calc *Date: *Thu, 12/Jul/2007 5:01:13 AM +0550 *From: *Jonathon Coombes [EMAIL PROTECTED] *To: * users@openoffice.org On 11/07/2007, at 9:56 PM, Lasantha Marian wrote: This problem

Re: [users] Date issue on open office.org calc

2007-07-04 Thread Gary Dale
Guan Kiet Yeo wrote: Dear Sir, I'm using version 2.2.1 of OpenOffice.org Calc. My problem is the date after I save and then re-open the file, the date that I have key in the worksheet will totally run out. It will change to 2days earlier. For example, I key in 07/01/07, it will show