I really don’t want to have to export the whole file to calc and then delete everything except certain columns. Easier way?
I use a simple sql-query:
SELECT col1, col2 FROM table;
then I copy the result. As this is often repetitive: You can drag a query to the Spreadsheet, and save the spreadsheet. To repeat this to get current data you select refresh from menu data in your spreadsheet and your columns will be updated.
.
As villeroy linked his tutorial in another thread, it might also help you:
https://forum.openoffice.org/en/forum/viewtopic.php?f=75&t=18511
1 Like