Le 11/11/13 14:59, Duncan Adams a écrit :
Hi Duncan, > I am attempting to connect a query such as > select quantity from item_table where location_id = 1 and item_id = 1 > and owner_id = 1 > to a Libreoffice Calc cell for instance sheet1.d7 I don't see how you can do this absent the use of a macro or some other script to parse the data in your cells that are not part of the query, then compose the query and send that to your pg backend. > > As a more complex version I would like to do something like > select quantity from item_table where location_id = Sheet2.E16 and > item_id = Sheet2.H16 and owner_id = Sheet2.C1 > (Drop down box's at those locations would give back full points although > not needed to make things work) > I would assume that the same would be required here, i.e. macros / scripting. You might try asking your question on the OpenOffice.org forum, I'm pretty certain something similar has been asked already. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
