Apache OpenOffice (AOO) Bugzilla – Issue 110279
Pasting into a table assumes new table
Last modified: 2014-08-25 17:11:52 UTC
This is a new "bug" that appeared in 3.2. Here are steps to get this bug 1) If I have data in a spreasheet (calc or excel) highlighted, I then copy the data (control-C) 2) I then go to a table in oo base and right click on the table name. It brings up a menu as shown in oo_base_paste3.2.JPG that I have attached (hopefully). It assumes that I am creating a new table and gives it a Table name. In version 3.1 it assumed that I was pasting into the table that I right-clicked on and gave me the menu as shown in oo_base_paste3.1.JPG . 3) The 3.1 behavior is the correct behavior. If I want to create a new table I can right click on an open space (and not on a table name) and paste in the information as a new table. As it stands in 3.2, I now have to type in the name of the table. Thank you
Created attachment 68452 [details] 3.2 behavior
Created attachment 68453 [details] 3.1 paste behavior
I have tested this on a linux platform v3.2 (go-oo version) and on windows ooo v3.2 (vanilla version), but couldn't reproduce this defect... So unconfirmed on those versions I have mentioned above
Created attachment 76837 [details] Bug report comment I cannot replicate this bug by following the steps mentioned in the bug report. I installed 3.2 and ran the test on it using both Windows and Linux operating systems but I couldn’t reproduce it. Please be sure to provide concrete information about your development environment and other specific task performed that are not mentioned in the report. Since the bug couldn’t be replicated on either Windows or Linux, it is not an informative bug for those systems. The screenshot of bug replication process is attached as TablePaste.jpg. It gives the same option as required and expected in other versions.
This bug occurs when I am pasting in data from a multi-column spreadsheet into a table in a database that has multiple tables. I don't know why you can't reproduce it. The bug/behavior persists in versions after 3.2. Sigh.
It occurs for me on both Windows 7 and Windows XP.
Platform: Operating System: Windows 7 Home Premium Version 6.1.7601 Service Pack 1 Build 7601 (x64) Apache Open Office 3.4.1 AOO341m1 Build 9593 Rev 1372282 My test: I used a database with 3 tables named A, B, C The tables have the same definition. With the database open I created a spreadsheet with one sheet A1 to B5 import fields in a table, in row 1 contains the field names. So I performed the following steps: 1) In Calc Copy of the A1 B5 2) In Base Map Database Tables Case: Paste Special a) After positioning the cursor on Table A b) carried out right click with the mouse c) choose Paste Special d) opens the map Paste Special to the choice of the type of data to be glued e) whether you choose HTML or RTF after clicking OK f) opens the map Copy Table with Table name "Table1" and option "Definition and Data" active g) clicked Cancel to return to the Map Database Tables Case Paste a) After positioning the cursor on Table A b) carried out right click with the mouse c) choose Paste d) opens the map Copy Table with Table name "A" and option "Add Data" active e) clicked Cancel to return to the Map Database Tables Case Paste Special after Paste on same table a) After positioning the cursor on Table A b) carried out right click with the mouse c) choose Paste Special d) opens the map Paste Special to the choice of the type of data to be glued e) whether you choose HTML or RTF after clicking OK f) opens the map Copy Table with Table name "A" and option "Add Data" active. g) clicked Cancel to return to the Map Database Tables Paste Special Paste after the event but on different table a) After positioning the cursor on Table B b) carried out right click with the mouse c) choose Paste Special d) opens the map Paste Special to the choice of the type of data to be glued e) whether you choose HTML or RTF after clicking OK f) opens the map Copy Table with Table name "A" and option "Add Data" active. g) clicked Cancel to return to the Map Database Tables So I confirm the bug because the Paste Special not working properly. Set importance to normal