Apache OpenOffice (AOO) Bugzilla – Issue 75842
Very limited clipboard functionality
Last modified: 2013-08-07 15:45:17 UTC
The possibility to copy and paste of database records/multiple records/certain part of db is very limited in comparison with MS-ACCESS. It is possible to copy and paste certain record (or group of records) via drag&drop command from OO base into OO calc/ on into OO base. Copy and paste command from menu copies only one field all the times. I did not find the way how to copy whole record from OO calc (like a selection of multiple fieds) back into OO base. Also I did not find the way how to copy only certain selected fields (or only one selected column) from OO base into OO calc. Nothing (menu, short cuts Ctrl+C Ctrl+V, drag&drog)is working. Copy/paste (menu, short cuts Ctrl+C Ctrl+V, drag&drog) of multiple cells form OO base into third party apps (e.g. Excell) is not working.
clu->mkout: marking the data in speadsheet and d&d it on the table container of the database opens the copy table dialog -> here you can make some of your wanted settings
the rest is a valid feature enhancement
send further to the requirements team