Issue 23878 - Inserting date via datasource using SXC gives date-2 when using field or text
Summary: Inserting date via datasource using SXC gives date-2 when using field or text
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: PC Linux, all
: P2 Trivial (vote)
Target Milestone: OOo 2.0
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
: 22688 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-12-25 14:51 UTC by pieterwolters
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

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

Attachments
Sample spreadsheet (6.21 KB, application/octet-stream)
2003-12-25 14:55 UTC, pieterwolters 		no flags Details
Results in a Textfile (SXW) (7.39 KB, application/octet-stream)
2003-12-25 14:56 UTC, pieterwolters 		no flags Details
Explaining Presentation (208.57 KB, application/octet-stream)
2003-12-25 14:56 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 pieterwolters 2003-12-25 14:51:34 UTC 
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!

This also happens in OOo 1.0.3.1
Comment 1 pieterwolters 2003-12-25 14:55:19 UTC 
Created attachment 12113 [details]
Sample spreadsheet
Comment 2 pieterwolters 2003-12-25 14:56:13 UTC 
Created attachment 12114 [details]
Results in a Textfile (SXW)
Comment 3 pieterwolters 2003-12-25 14:56:56 UTC 
Created attachment 12115 [details]
Explaining Presentation
Comment 4 pieterwolters 2003-12-25 14:57:43 UTC 
See files for explaining the problem.
Comment 5 Frank Schönheit 2004-01-05 08:20:57 UTC 
correcting sub component (see
http://www.openoffice.org/issues/describecomponents.cgi?component=Database%20access,
please), and default owner
Comment 6 marc.neumann 2004-01-05 10:03:58 UTC 
Hi,

I can reproduce this.

Set target and send to the right developer.

Bye Marc
Comment 7 Oliver Specht 2004-01-07 15:01:57 UTC 
Fixed in cws os26 in sw/source/ui/dbui/dbinsdlg.cxx
Comment 8 Oliver Specht 2004-01-07 15:02:50 UTC 
*** Issue 22688 has been marked as a duplicate of this issue. ***
Comment 9 Frank Schönheit 2004-01-12 14:01:15 UTC 
submitted issue 24313, to also care for this problem on the 1.1.x branch
Comment 10 Oliver Specht 2004-01-16 08:40:43 UTC 
cws os26 can be found on so-cwsserv01, wntmsci8 and unxlngi5.pro
Comment 11 marc.neumann 2004-01-19 14:51:23 UTC 
verified in CWS os26
Comment 12 marc.neumann 2004-01-19 14:51:52 UTC 
verified in CWS os26
Comment 13 hans_werner67 2004-02-02 12:11:47 UTC 
change subcomponent to 'none'
Comment 14 marc.neumann 2004-04-27 10:20:22 UTC 
Hi,

fixed in current developer build -> close.
The current developer build can be found at
http://download.openoffice.org/680/index.html
Feel free to reopen if this issue is not fixed in the developer build.

Bye Marc