[libreoffice-users] Re: Postgres and Calc

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+unsubscribe@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