Bug 73798

Summary: Allow export of tables from within LO Base to all file formats supported by Calc
Product: LibreOffice Reporter: Gerry <gerry.treppel>
Component: BaseAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: fitojb, gmolleda, iplaw67, miarederami, robert
Priority: medium    
Version: 4.1.4.2 release   
Hardware: Other   
OS: All   
See Also: https://bugs.freedesktop.org/show_bug.cgi?id=51872
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108441    

Description Gerry 2014-01-19 15:27:58 UTC 
Currently it is not possible to export database tables from within Base to a file. The only way to export tables is to drag&drop the table to an open Calc window. See [1]. The only alternativeto export tables is to connect to a writable data source (e.g. spreadsheet tables are not writable) and drag&drop the table to the other LO Base window. This is very cumbersome. Base is not able to just export to a file. 

Enhancement request:
(1) Allow via "File" -> "Export" and via right mouse click on a database table to export the table(s) to a file (e.g. .ods)
(2) Support for the export all file formats that are supported by LibreOffice Calc.
(3) Allow also the export of multiple database tables at the same time, as they could be saved in the target file format also as different table or as different spreadsheet tab.


[1] https://help.libreoffice.org/Common/Importing_and_Exporting_Data_in_Base
Comment 1 Robert Großkopf 2014-01-21 20:58:29 UTC 
Can confirm this "bug" - isn't a buggy behavior but a feature request.

One hint: You could also export by direct SQL

SELECT * INTO TEXT "Table_outside" FROM "Tableinside"

You will get a *.csv-file of the table (or the whole query).

This could work by the right mouseclick on the table - but there couldn't be exported one file for all tables with File → Export - it's impossible with *.csv.
Comment 2 Alex Thurgood 2015-01-03 17:41:23 UTC Comment hidden (noise)
Comment 3 gmolleda 2022-11-05 14:32:12 UTC 
This is very important that Base export to CSV, etc. because Calc only have 1 048 576 rows while Base table could have more rows.