Bug 159339

Summary:	Add option to export result set from query
Product:	LibreOffice	Reporter:	guser <guser>
Component:	Base	Assignee:	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".