Apache OpenOffice (AOO) Bugzilla – Issue 118363
Copy From OOo Base Query Fails To Grab Full Selection
Last modified: 2013-11-17 10:01:11 UTC
If all rows and columns from a query result are selected, copied to the clipboard, and pasted into a cell of a new Calc spreadsheet, only a subset of the selection is pasted. These are the steps needed to re-create the failure: 1. Open an OOo Base database. 2. Click on [Queries] in the "Database" pane. 3. Double-click a query that returns three or more columns of results. 4. Click the top left cell to select all rows and columns (i.e. records and fields). 5. Select Edit -> Copy 6. Select File -> New -> Spreadsheet 7. In the new spreadsheet window, select Edit -> Paste In Base 3.3, on both Linux (Fedore Core 8) and Windows (Vista), only a subset of columns are pasted into the spreadsheet. In Base 3.2.1, this works properly on both platforms.
I can not confirm it with OOo 3.3 downloaded from OOo site, under opensuse 12.1 same rpm version as in FC, and under win7. Tested with OOo 3.4 Beta, too. The query results inserted fully. Can you try with OOo 3.4 Beta?
r4zoli, you asked: > Can you try with OOo 3.4 Beta? Yes. I will give it a shot this week. Thanks!
getting rid of value "enhancement" for field "severity". For enhancement the field "issue type" shall be used.
I experience this problem also using windows. I assumed this was a memory issue when using this due to large queries (up tp 30,000 records and 6 fields)
Version 4.0 probably needs to be added to this issue also. Tested with a Report rather than a SQL query. In this case, the column contained 5 items, but only pasted one. I am not sure if the processing for this in Report would be identical to a direct SQL query though.
Confirmed this some time ago and confirmed. Hoping it can be resolved for 4.0.1
I don't believe that this can be fixed in 4.0.1 but if somebody will provide a patch I will approve it as showstopper