Apache OpenOffice (AOO) Bugzilla – Issue 52915
Allow the copying of database form "table control" object contents
Last modified: 2013-02-07 22:39:16 UTC
Database form table controls may contain information that is more useful than the tables they represent. EG they can include fewer columns, filtered or sorted data, list box columns which contain results from SQL queries, and have more precise data types (eg "currency"). However, there is no way that I know of to export the data as it is displayed in a table control : table control contents can not be copied and pasted into OOo Spreadsheet. The only way I can think of is by creating a database Query producing similar output. This is however a very burdensome task. Making table control contents copy-able would solve this problem gracefully.
this issue is reassigned to the user experience team for further evaluating
I added some other issues concerning this request, someone with more database knowledge should sort, please ...
you can copy and passte the result of the underlying query to a spreadsheet via F4