Issue 75118 - Dates rolling back by 1 day
Summary: Dates rolling back by 1 day
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: OOo 2.2
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: marc.neumann
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-03-05 07:53 UTC by x72m35
Modified: 2008-03-18 05:35 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description x72m35 2007-03-05 07:53:59 UTC 
This problem applies to an environment where data is imported from a PostgreSQL
database as an external data source using either psqlODBC driver or
OpenOffice.org's sdbc (postgresql-sdbc-0.7.4) driver.

When data imported from external data sources (PostgreSQL 8.1.x) are displayed,
DATES are rolled back by 1 DAY. Sometimes, when refreshed dates are shown
correctly and immediately rolled back by 1 day again.

Same Base file and Calc sheets for the same data set behave correctly when used
under OOo 2.1 with the same set of drivers.
Comment 1 thorsten.martens 2007-03-05 08:18:00 UTC 
TM->MSC: Sounds more like a base-problem than a framework-issue to me. Please
have a look.
Comment 2 x72m35 2007-03-05 08:23:51 UTC 
I've just verified on an OOo 2.2rc1/Windows XP installation too, same problem
exists.
Comment 3 x72m35 2007-04-17 09:41:01 UTC 
This problem is now in OOo 2.2.0.
Comment 4 ooo 2007-10-24 15:06:23 UTC 
Sounds pretty much like a duplicate, please verify fix in a milestone where cws
dr59 will have been integrated.

*** This issue has been marked as a duplicate of 76623 ***
Comment 5 x72m35 2007-10-27 07:17:24 UTC 
Yes the issue (http://www.openoffice.org/issues/show_bug.cgi?id=76623) describes
the very same same problem that I have reported about 6 months back while at
2.2rc1 stage.
Comment 6 kpalagin 2007-10-27 20:10:47 UTC 
x72m35,
please verify if the problem is fixed using one of future builds and close this 
issue as duplicate.
Comment 7 x72m35 2007-10-29 04:32:44 UTC 
kpalagin,

Appreciate if you could kindly tell me how to get a latest version (link for a
Win32 binary) which has got this fix in. Certainly I will test and then close
this as duplicate of 76623.
Comment 8 kpalagin 2008-02-12 11:36:12 UTC 
x72m35, 
finally you can get it at http://download.openoffice.org/680/?intcmp=1461.
Please see if the issue you describe still exists.
Comment 9 x72m35 2008-03-18 05:17:41 UTC 
kpalagin,

Yes it works correctly with all new versions. Thanks a lot.
Comment 10 x72m35 2008-03-18 05:26:11 UTC 
This issue (a duplicate of 76623) is now resolved.
Comment 11 x72m35 2008-03-18 05:35:41 UTC 
Closed