Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Copy and Paste of Table gets garbled in Calc|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||issues, maho.nakata, seagulljapan|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
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 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 application". 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
seagulljapan-san, 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
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 OpenOffice.org 3.0.0. I use Windows Vista and OpenOffice.org 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