Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

There are many limitations with Base tables which are linked from spreadsheets. One is that query functions are limited to COUNT(*) - that's it.

Turning Base into an actual database by creating a table with the sheet data (have to start with a new Base file) you get all the functions. You register the DB then you can access the data from a spreadsheet via Data Sources.

There are many limitations with Base tables which are linked from spreadsheets. One is that query functions are limited to COUNT(*) - that's it.

Turning Base into an actual database by creating a table with the sheet data (have to start with a new Base file) you get all the functions. You register the DB then you can access the data from a spreadsheet via Data Sources.

EDIT:

I should add, the table data in your Base file is basically a text file (internally specified as file-based-database). There is no real database associated with this process. The functions you are looking for are in the database which in the case of a default base file would be HSQLDB.