Created attachment 175314 [details] Sample Base database to demonstrate no copy/paste as text Base tables and queries not copied to the clipboard as text objects. 1. Open the attached database in Base 2. Tables, double-click sport to open 3. Select the whole table by clicking the top left-hand corner box 4. Edit, Copy 5. Open text editor (eg notepad in win10) - can't paste 6. Open Calc, Edit, Paste - works as expected Expected: table/query grid would be held in the clipboard as a text object with a tab between columns Version: 7.2.0.3 (x64) / LibreOffice Community Build ID: 2a7ea282da28d665a7dc086360567b4aea27bf08 CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: en-AU (en_AU); UI: en-GB Calc: threaded
You are right: There is no simple text exported. There will be exported content, which could be interpreted as a table. You could input this content into Calc, also directly in Writer as a Writer table or in Writer as RTF or HTML. With HSQLDB you could also execute through Tools → SQL SELECT * INTO TEXT "sport.csv" FROM "sport" and you will get a *.csv file separated by comma in the same folder the Base file is saved. Don't know why there should be an enhancement to export *.csv or something else also to Base. You will get this when exporting from Calc for other databases also. I will change this one to New, because the description is right and there isn't exported text. But I won't expect text here. Set also the Importance to "enhancement", because it never has been planned to work in this way.
(In reply to Robert Großkopf from comment #1) > I will change this one to New, because the description is right and there > isn't exported text. But I won't expect text here. Set also the Importance > to "enhancement", because it never has been planned to work in this way. Such functionality exists, for example, in MySQL Workbench, and if I recall correctly, in Kexi, and other UI grid based frontends (e.g. SQLiteManager) for data display, and uses the system clipboard or more advanced clipboard functionality to enable copy/paste of raw data from the grid view to any other input window accepting such clipboard input. IMHO, this is also a valid request. The way around the limitation of pasting into Calc is clunky in comparison to the other visualization tools out there.