Bug 159339

Summary: Add option to export result set from query
Product: LibreOffice Reporter: guser <guser>
Component: BaseAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: robert
Priority: medium    
Version: unspecified   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

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".