You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Ari Heikkilä <ar...@ymail.com> on 2014/07/17 22:28:00 UTC

Calc changed dates catastrophically

Hi

I'm using Apache OO 4.1.0 Calc for booking thousands of rows of work, 
payment and billing. In each row are three dates (dd.mm.yy). In the late 
version there were tens of thousands of rows. But it was never like now:

When I saved the work and looked, almost all dates were changed 4y1d or 
4y2d older. Minority was not.
I take backups all the time, but unfortunately the last was then several 
days old, and I'v done plenty of updating data. Tracing my changes 
backward is hard days work.

Before trying to mend data, I want to know, how is it, that Calc does 
catastrophe like this. And how can I be sure, it doesn't make it again.

Versions of OO have been several in my use, but no bug of this kind, 
since and so far.

By Google I can find hints of problems of this kind, but no solution. 
And the community have not taken the bug for fixing. Surely the bug is 
difficult to repeat.
I guess, it must be with 'basedate', but I'v not changed it ever 
(naturally). If I change it now, the corrupted dates  shift 4y1d more 
older. The plain date-number in the cell have been shifted permanently.

If the corruption was frequent, i.e. ALL the dates was shifted the same, 
I could try by somewhat function or math. But there are at least three 
cases. Almost impossible.

Have anyone experience or advice?

Yours

Ari Heikkilä, Finland

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Fwd: Re: Calc changed dates catastrophically

Posted by Martin Groenescheij <Ma...@Groenescheij.COM>.
Forwarded to poster as he isn't subscribed.


-------- Original Message --------
Subject: 	Re: Calc changed dates catastrophically
Date: 	Fri, 18 Jul 2014 12:01:05 +1000
From: 	Martin Groenescheij <Ma...@Groenescheij.COM>
Reply-To: 	Martin@Groenescheij.COM
To: 	users@openoffice.apache.org
CC: 	Martin@Groenescheij.COM



Look at the date settings under Tools --> Options --> OpenOffice Calc 
--> Calculate
On the top right there is a setting for Date make sure you use the same 
as in the
previous version of Calc.

On 18-7-2014 6:28, Ari Heikkilä wrote:
> Hi
>
> I'm using Apache OO 4.1.0 Calc for booking thousands of rows of work, 
> payment and billing. In each row are three dates (dd.mm.yy). In the 
> late version there were tens of thousands of rows. But it was never 
> like now:
>
> When I saved the work and looked, almost all dates were changed 4y1d 
> or 4y2d older. Minority was not.
> I take backups all the time, but unfortunately the last was then 
> several days old, and I'v done plenty of updating data. Tracing my 
> changes backward is hard days work.
>
> Before trying to mend data, I want to know, how is it, that Calc does 
> catastrophe like this. And how can I be sure, it doesn't make it again.
>
> Versions of OO have been several in my use, but no bug of this kind, 
> since and so far.
>
> By Google I can find hints of problems of this kind, but no solution. 
> And the community have not taken the bug for fixing. Surely the bug is 
> difficult to repeat.
> I guess, it must be with 'basedate', but I'v not changed it ever 
> (naturally). If I change it now, the corrupted dates  shift 4y1d more 
> older. The plain date-number in the cell have been shifted permanently.
>
> If the corruption was frequent, i.e. ALL the dates was shifted the 
> same, I could try by somewhat function or math. But there are at least 
> three cases. Almost impossible.
>
> Have anyone experience or advice?
>
> Yours
>
> Ari Heikkilä, Finland
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>




Re: Calc changed dates catastrophically

Posted by Martin Groenescheij <Ma...@Groenescheij.COM>.
Look at the date settings under Tools --> Options --> OpenOffice Calc 
--> Calculate
On the top right there is a setting for Date make sure you use the same 
as in the
previous version of Calc.

On 18-7-2014 6:28, Ari Heikkilä wrote:
> Hi
>
> I'm using Apache OO 4.1.0 Calc for booking thousands of rows of work, 
> payment and billing. In each row are three dates (dd.mm.yy). In the 
> late version there were tens of thousands of rows. But it was never 
> like now:
>
> When I saved the work and looked, almost all dates were changed 4y1d 
> or 4y2d older. Minority was not.
> I take backups all the time, but unfortunately the last was then 
> several days old, and I'v done plenty of updating data. Tracing my 
> changes backward is hard days work.
>
> Before trying to mend data, I want to know, how is it, that Calc does 
> catastrophe like this. And how can I be sure, it doesn't make it again.
>
> Versions of OO have been several in my use, but no bug of this kind, 
> since and so far.
>
> By Google I can find hints of problems of this kind, but no solution. 
> And the community have not taken the bug for fixing. Surely the bug is 
> difficult to repeat.
> I guess, it must be with 'basedate', but I'v not changed it ever 
> (naturally). If I change it now, the corrupted dates  shift 4y1d more 
> older. The plain date-number in the cell have been shifted permanently.
>
> If the corruption was frequent, i.e. ALL the dates was shifted the 
> same, I could try by somewhat function or math. But there are at least 
> three cases. Almost impossible.
>
> Have anyone experience or advice?
>
> Yours
>
> Ari Heikkilä, Finland
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>