date fields in org2 base seem to revert to 1 Jan 1970

[Bruce Hill]

Every time I have entered a date in a date field in a table, no matter what the date entered was, it has reverted to 1 Jan 1970

[Matthias Klose (doko)]

works fine for me. please could you exactly describe, what you are doing? which version is openoffice.org-calc?

[Bruce Hill (bloomhill)]

Hello Matthias

I have recently installed an UBUNTU version which the disk cover describes
as:
Ubuntu 5.10 Breezy Badger [free CD with LINUX FORMAT magazine]

It is coupled with Gnome version:
2.12.1 03/10/05

According to the opening screen it is:
OpenOffice.org 2.0

But in HELP>ABOUT OPENOFFICE.ORG I read:
open office.org 1.9.129

 but at the bottom of this screen in small print it says:
openoffice.org2-core 1.9.129-0.1ubuntu4, Fri Oct 7 18:39:57 UTC 2005

What was I trying to do? Make a model of a bookkeeping system. The first
step was to make a table representing a simplified cash journal.

Using CREATE TABLE IN DESIGN VIEW I chose 6 entry fields: [ID (auto
number);] DATE (date field, d mmmm yyyy) ITEM (text, description of
transaction); FOLIO (integer, as a key to ledger pages); DEBIT (currency);
and CREDIT (currency). To be honest, I let the program handle the ID field.

All fields, except the date field, seem to work OK. When I key in a date --
say "16 Apr 2006" -- that date stays visible until the remaining fields of
the entry/row are filled in. As soon as I move on to the next entry, the "16
Apr 2006" is replaced by "1 Jan 1970".

I have tried deleting OPENOFFICE and reinstalling it from UBUNTU repository.
That didn't improve anything.

I have thought about installing OPENOFFICE from another source haven't yet
worked out how to do that.

Thanks for responding
Bruce Hill

>-----Original Message-----
>From: <email address hidden> [mailto:<email address hidden>]On Behalf Of
>Matthias Klose
>Sent: Saturday, April 15, 2006 7:40 PM
>To: <email address hidden>
>Subject: [Bug 37966] Re: date fields in org2 base seem to revert to 1
>Jan 1970
>
>
>works fine for me. please could you exactly describe, what you are
>doing? which version is openoffice.org-calc?
>
>
>** Changed in: openoffice.org2 (Ubuntu)
>Sourcepackagename: openoffice.org2 => openoffice.org
> Assignee: (unassigned) => Matthias Klose
> Status: Unconfirmed => Needs Info
>--
>date fields in org2 base seem to revert to 1 Jan 1970
>https://launchpad.net/malone/bugs/37966

[Ivan Vilata i Balaguer (ivilata)]

I'm experiencing (rather suffering) the same problem as Bruce with OO.o 2.0 Base (Matthias, I'm afraid you misunderstood it by Calc). I thought it would have something to do with locales (I use ca_ES.UTF-8) or date format (DD/MM/YYYY), but I have tried with en_US.UTF-8 and other date formats and it just behaves the same.

I'm also using openoffice.org2-core 1.9.129-0.1ubuntu4, Fri Oct 7 18:39:57 UTC 2005. Please don't hesitate to ask me for more information, thanks.

[Matthias Klose (doko)]

please recheck with 2.0.2, either the package in dapper, or the one found for breezy at
https://lists.ubuntu.com/archives/ubuntu-devel/2006-May/017716.html

(please note that the breezy package is not supported and may contain bugs).

[अशोक कुमार (ashok-kumar)]

I also suffered the same problem. This problem was there in Windows version also till 2.0.1. However, it was found rectified in version 2.0.2 in Windows. Therefore, I was eagerly waiting for Ubuntu 6.06 Dapper Drake which was to come with version 2.0.2. This problem was found rectified there.

However, 2.0.2 has it own share of bugs. I was confortably using 1.9.129 with JDBC driver in Ubuntu 5.10 to connect to MySQL servers on localhost and on other computers also. But OpenOffoce 2.0.2 crashes when it tries to load JDBC driver. Details are available at Bug No.50063.

[Matthias Klose (doko)]

seems to be fixed in edgy and in feisty