Issue 80916 - copy&paste from writer prepends first field of row with a space
Summary: copy&paste from writer prepends first field of row with a space
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: OOo 2.4
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks: 20748
  Show dependency tree
 
Reported: 2007-08-22 01:43 UTC by ms2
Modified: 2008-03-10 13:03 UTC (History)
1 user (show)

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

Attachments
base file for testing (3.90 KB, application/vnd.sun.xml.base)
2007-08-22 01:45 UTC, ms2 		no flags Details
writer doc containit data to copy (7.86 KB, application/vnd.oasis.opendocument.text)
2007-08-22 01:46 UTC, ms2 		no flags Details
copy_paste from Writer to Calc with leading blanks (14.67 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-01-16 21:23 UTC, dnomier 		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 ms2 2007-08-22 01:43:19 UTC 
Task:
Copy data from writer to an existing base table appending data.

Error:
The first line of data is not inserted into the target table.

Database:
Internal HSQLDB
registered Data Source

Tested with:
2.2.0
680m2

OS:
Win98se

Reproduce:
- open attached .odb file plus the .odt
- activate writer doc and select the complete table
- hit the copy button in the toolbar
- activate the base window
- select the tables container
- hit the paste button in the toolbar
- the import assistant window pops up
  - type in "Artikel" as table name
  - select "append data"
  - click next (not sure if necessary)
  - click finish
- open the table "Artikel"

You'll see: the first field of every row has one space prepended

(the first row of data is missing, this is another issue)
Comment 1 ms2 2007-08-22 01:45:38 UTC 
Created attachment 47699 [details]
base file for testing
Comment 2 ms2 2007-08-22 01:46:34 UTC 
Created attachment 47700 [details]
writer doc containit data to copy
Comment 3 ms2 2007-08-22 01:55:07 UTC 
the other issue concerning the missing first row is issue 80917
Comment 4 Frank Schönheit 2007-08-22 10:07:29 UTC 
confirming, targeting, assigning
Comment 5 dupreyb 2007-08-24 16:05:38 UTC 
In my case, it also added a trailing blank. While this is not as obvious, it
interferes with queries (e.g.,IS EMPTY, tests on what should be single-character
fields), and is even more likely to cause length violations during a copy
attempt when there is a short VARCHAR.
Comment 6 dupreyb 2007-08-24 17:03:16 UTC 
Just noticed something else here - the problem was reported only for the first
field, but all my text fields from Writer got both leading and trailing blanks,
not just the first.
Comment 7 ocke.janssen 2007-10-15 11:48:34 UTC 
Fixed in cws dba24c
Comment 8 ocke.janssen 2007-10-15 13:09:30 UTC 
.
Comment 9 ocke.janssen 2007-11-05 06:34:41 UTC 
Please verify. Thanks.
Comment 10 marc.neumann 2007-11-12 15:05:20 UTC 
verified in CWS dba24c

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fdba24c
Comment 11 dnomier 2008-01-16 21:23:22 UTC 
Created attachment 50919 [details]
copy_paste from Writer to Calc with leading blanks
Comment 12 drewjensen.inbox 2008-03-10 13:03:10 UTC 
Tested w / xp and build m_10

closing