This might be a bug in your version of LibreOffice. The "query wizard" is useless anyway, particularly when used with a file based database (sheets, text, dBase, Thunderbird addresses). All you can query from a file based database is this:
Code: Select all
SELECT <field list>
FROM "Single Table"
WHERE <conditions>
ORDER BY <field list> ASC|DESC
This means that a query can return any order of columns and rows from one spreadsheet range representing a "list", filtered by complex conditions. This is more than a spreadsheet can do but does not require any "wizard". Simply use the "designer" tool or use a bare minimum of SQL.
Query a two-column list from 4 columns "Forename", "Surname", "Date" and "Category") of the spreadsheet "Sheet1".
Code: Select all
SELECT CONCAT("Surname", ', ', "Forename") AS "Full Name", "Date" AS "Birthday"
FROM "Sheet1"
WHERE MONTH("Date")=MONTH(CURDATE()) AND "Category"='Friends'
ORDER BY "Date" DESC
This concatenates the forenames and surnames with a comma to "Doe, John" filters the rows by the current month and by the friends category and orders the result set by the dates (latest on top). The field list in the SELECT clause supports alias names ("Column Label" AS "Other Name").
This is almost everything you can do with a sheet in Base.
There is a rather limited set of available functions:
http://www.openoffice.org/dba/specifica ... tions.html (for instance MONTH and CONCAT in the above example).
When referring to a "sheet", you always get the used area of the entire sheet as a database table.
Not every sheet is organized as an adjacent list. You can hide inadequate sheets via Base menu:Tools>Table Filter...
You can separate list ranges from other sheet content by means of "database ranges" (Calc menu:Data>Define...). Database ranges are treated as tables together with the used areas of the sheets.