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 <mar...@groenescheij.com>
Reply-To: mar...@groenescheij.com
To: users@openoffice.apache.org
CC: mar...@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-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
