Bug 159339 - Add option to export result set from query
Summary: Add option to export result set from query
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-01-23 13:56 UTC by guser
Modified: 2024-01-29 14:16 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description guser 2024-01-23 13:56:52 UTC 
Currently Base does not support exporting the result set to a file (e.g. CSV or ODS) in the query window.
Please add Export to the menu to save the result set to a file.
Comment 1 James Spencer 2024-01-24 08:52:08 UTC 
If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. https://littlerunmo.com/

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)
Comment 2 Robert Großkopf 2024-01-24 10:46:08 UTC 
Open a new Calc file.
Right mouseclick on the query → copy.
Right mouseclick on Calc sheet → insert.

You could also use this extension:
https://extensions.openoffice.org/node/18410
Have tested it with LO 7.4.7.2 → Exports directly to CSV.
Comment 3 guser 2024-01-29 11:44:24 UTC 
I think such a simple feature could be part of LibreOffice Base and there was no need to run LibreOffice Calc or install a plugin.
Comment 4 Robert Großkopf 2024-01-29 14:16:14 UTC 
This function isn't implemented yet, but is possible to get it working with an extension.

I will set this one to "New" and "Enhancement".