Hi! I'm new with OpenOffice. I've made SQLite database and one form and query to it, and succesfully read and written into database with those.
But what I wan't is to retrieve a table in the database and put it in Calc so that data is up to date every time I open the calc spreadsheet. Sounds simple, eh? But I don't know how much data there is, so I wan't a scrollbar and list that can grow in size. I've made this with a some form control, but I can't reference the content of that list box elsewhere in my spreadsheet. It is just a "graphic" object floating and not linked to any cells, so I can't reference its contents! Alternatively tried to drag and drop table from data sources view, OK, but it just inserts numbers. Those are just numbers and next time I open the spreadsheet I have to do retrieve new data manually again. Any help appreciated. EK --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
