Issue 98772

Summary: Copy and Paste of Table gets garbled in Calc
Product: Base Reporter: khirano
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, maho.nakata, seagulljapan
Version: OOo 3.0   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
copy and paste the table into calc
copy and paste the table into calc
drag and drop the table into calc (not garbled)
drag and drop the table into calc (not garbled)
copy and paste to Writer
copy and paste to Impress
copy and paste to Draw none

Description khirano 2009-02-03 08:07:11 UTC
I will attach bug doc, "tate.odb"

If you copy and paste the table "構文" in the bug doc to Calc, Japanese letters
get garbled.

But if you drag and drop the table into Calc, they don't get garbled.
Comment 1 khirano 2009-02-03 08:09:33 UTC
Created attachment 59842 [details]
Comment 2 khirano 2009-02-03 08:15:46 UTC
*** Issue 98761 has been marked as a duplicate of this issue. ***
Comment 3 Frank Schönheit 2009-02-03 15:00:30 UTC
hmm, cannot reproduce in OOo 3.0 on Windows XP. However, I am not sure I
completely get you, and reading Japanese is certainly nothing I am able to.
Could you attach screen shots of the table/spreadsheet, to better demonstrate
the differences? Also, how exactly do you do the copy'n'paste?
Comment 4 khirano 2009-02-03 22:47:41 UTC
"Copy and Paste" means the following:
(This is from Online Help)
Importing and Exporting Data in Base:
An easy method to import and export database tables uses Calc as a "helper

Exporting data from Base

You copy a table from Base to a new Calc sheet, then you can save or export the
data to any file format that Calc supports.
1.Open the database file that contains the database table to be exported. Click
Tables to view the tables, or click Queries to view the queries.
2.Choose File - New - Spreadsheet.
3.In the Base window, right-click the name of the table to export. Choose Copy
from the context menu.
4.Click cell A1 in the new Calc window, then choose Edit - Paste.
Now you can save or export the data to many file types.
Comment 5 khirano 2009-02-03 23:08:02 UTC
Created attachment 59875 [details]
copy and paste the table into calc
Comment 6 khirano 2009-02-03 23:09:19 UTC
Created attachment 59876 [details]
copy and paste the table into calc
Comment 7 khirano 2009-02-03 23:13:30 UTC
"Drag and Drop" means the following:

1. Drag the table icon "構文"
2. Drop it in Calc
Comment 8 khirano 2009-02-03 23:16:22 UTC
Created attachment 59877 [details]
drag and drop the table into calc (not garbled)
Comment 9 khirano 2009-02-03 23:17:27 UTC
Created attachment 59878 [details]
drag and drop the table into calc (not garbled)
Comment 10 Frank Schönheit 2009-02-04 08:33:04 UTC
thanks for the screenshots, I indeed would agree the data in the first one is
garbage only.
Unfortunately, I still cannot reproduce the problem. In the way you described
it, copying the table from Base to Calc produces the correct result here. Which
leaves me with no idea how to reproduce the issue :(

Is the "OS=Windows XP" and "Version=OOo 3.0" information above correc? Just to
ensure we're talking about the same environment here.

Another question, which might or might now bring us nearer to the problem's root
cause, is whether pasting the table into other applications (Writer, but also
non-OOo applications capable of pasting HTML text) shows the same behavior.
Comment 11 seagulljapan 2009-02-04 09:00:16 UTC
Dear fs

What kind of letters do you use for the reproduce?
This problem happens on using 2 byte characters like Japanese letters, I think.
If you don't have a PC which can type and show 2 byte characters, it may not happen.
Comment 12 Frank Schönheit 2009-02-04 09:20:47 UTC

I don't fully get your question, sorry. I open the attached database document,
and display the contained table (by double-clicking it). This displays all
Japanese characters correctly.
Then, I copy'n'paste this table to a spreadsheet document (with the procedure
outlined by khirano-san above), and again, all characters look fine - exactly
like in the "base-table-drag-and-drop.jpg" attachment. So I think my system is
fine with Japanese text in general. It's probably something in our environments
which is different, but I do not have the slightest clue ...
Comment 13 seagulljapan 2009-02-04 09:48:08 UTC
Wow really?!
Comment 14 Frank Schönheit 2009-02-04 09:53:07 UTC
no, I'm just pretending to not see the bug, to not be forced to fix it :)
(hey, that was kidding only).

No, indeed this works as expected here. Since you also seem to see the bug: See
my above question, please. Does pasting the table into other applications
produce the proper result?
Comment 15 khirano 2009-02-04 13:23:15 UTC
Original reporter (seagulljapan) uses Windows XP SP3 and 3.0.0.
I use Windows Vista and 3.0.1.
We both can reproduce the issue.

Now I've tried copy and paste the table into Writer, Impress and Draw.
1. Writer: When I tried to paste it into Writer, "Insert Database Columns"
dialog popped up, so I did "Insert data as Table," this didn't get Japanese
letters garbled.
2. Impress: garbled
3. Draw: garbled

I will attach these 3 docs, .odt, .odp and .odg
Comment 16 khirano 2009-02-04 13:24:49 UTC
Created attachment 59913 [details]
copy and paste to Writer
Comment 17 khirano 2009-02-04 13:26:15 UTC
Created attachment 59914 [details]
copy and paste to Impress
Comment 18 khirano 2009-02-04 13:27:34 UTC
Created attachment 59915 [details]
copy and paste to Draw