Bug 73798 - Allow export of tables from within LO Base to all file formats supported by Calc
Summary: Allow export of tables from within LO Base to all file formats supported by Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected) release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Database-Tables
  Show dependency treegraph
Reported: 2014-01-19 15:27 UTC by Gerry
Modified: 2022-11-12 04:08 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
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.