Apache OpenOffice (AOO) Bugzilla – Issue 98772
Copy and Paste of Table gets garbled in Calc
Last modified: 2013-02-07 22:35:21 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.
Created attachment 59842 [details] bugdoc
*** Issue 98761 has been marked as a duplicate of this issue. ***
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?
"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. -------------------------------------------------------
Created attachment 59875 [details] copy and paste the table into calc
Created attachment 59876 [details] copy and paste the table into calc
"Drag and Drop" means the following: 1. Drag the table icon "æ§‹æ–‡" 2. Drop it in Calc
Created attachment 59877 [details] drag and drop the table into calc (not garbled)
Created attachment 59878 [details] drag and drop the table into calc (not garbled)
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.
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.
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 ...
Wow really?!
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?
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
Created attachment 59913 [details] copy and paste to Writer
Created attachment 59914 [details] copy and paste to Impress
Created attachment 59915 [details] copy and paste to Draw