Issue 24313 - DB: Insert as Text: dates are shifted by -2 days
Summary: DB: Insert as Text: dates are shifted by -2 days
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: All All
: P2 Trivial with 2 votes (vote)
Target Milestone: OOo 1.1.2
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-01-12 14:00 UTC by Frank Schönheit
Modified: 2006-05-31 14:29 UTC (History)
2 users (show)

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

Attachments
Defect in 1.9 Still there (89.29 KB, image/png)
2005-09-03 09:00 UTC, pieterwolters 		no flags Details
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 Frank Schönheit 2004-01-12 14:00:46 UTC 
This is a 1.1.x version of issue 23878 resp. issue 22688.

Cite from issue 23878:
<cite>
Given:
Spreadsheet (SXW) as Datasource,
a columns is defined as "date" eg. dd/mm/yyyy

When the data is inserted "text" of "field" in a textdocument the date will be
subtracted by 2 days. this means: 

say "date"=5 dec 1977
then inserting will result in 3 dec 1977

This will not happen when inserting as a table!
</cite>

The bug is already fixed for the SRC680 branch, and in agreement with os and
msc, we also want to fix it for the 1.1.x branch (it probably won't make it into
1.1.1 anymore).

(side note: another effect of the same bug: setting up combo or list boxes to
display the content of a data field also shifts by 2 days, the same when binding
an ordinary text control to a date field.)
Comment 1 Oliver Specht 2004-01-12 14:21:09 UTC 
Required changes:
connectivity/source/commontools/DateConversion.cxx rev. 1.9.32.1
sw/source/ui/dbui/dbinsdlg.cxx rev. 1.39.42.1
Comment 2 hans_werner67 2004-02-02 12:24:23 UTC 
change subcomponent to 'none'
Comment 3 Oliver Specht 2004-03-16 13:25:51 UTC 
Fixed in cws ospp3
Comment 4 Oliver Specht 2004-03-19 08:31:49 UTC 
cws ospp3 is available on so-cwsserv04 (wntmsci8.pro and unxlngi5.pro)
Comment 5 marc.neumann 2004-03-26 10:18:04 UTC 
set to fixed
Comment 6 marc.neumann 2004-03-26 10:18:16 UTC 
verify in cws ospp3
Comment 7 marc.neumann 2004-04-27 09:28:56 UTC 
Hi,

fixed in OOo 1.1.2 which will be available soon -> close.
Feel free to reopen if this issue is not fixed in the final 1.1.2 build.

Bye Marc
Comment 8 pieterwolters 2005-09-03 09:00:47 UTC 
Created attachment 29288 [details]
Defect in 1.9 Still there
Comment 9 pieterwolters 2005-09-03 09:05:35 UTC 
Tried this in OOo 1.9.125 but defect still there. See attached file of screen shot.

It is when spreadsheets are registered as datasource and only when copied as
"field" and defect doesn't show when copied as "text" of "table".
Comment 10 pieterwolters 2005-09-03 09:12:13 UTC 
Defect doesn't show in OOo 1.1.4
Comment 11 marc.neumann 2005-09-13 13:23:35 UTC 
I open a new issue 54550 for the bug in the 1.9.xx version.