Hello "e", (real names are appreciated in this list)
> 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. The latter is the only way to go. There's a functionality to update the range (somewhere in the Tools menu, IIRC), To not do this manually all the time, you could record a macro for this action, and bind this macro to the document's OnLoad event (Tools/Customize/Events). This should open the document and immediately update the range. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
