[libreoffice-users] Re: [calc]when link to external data, which is libreoffice .odb file, OK button disabled

Le 05/01/2014 18:32, Larry Evans a écrit :

Hi Larry,


> In calc, when I try to insert a link to:
>
>   ~/evansl/prog_dev/LibreOffice/database/products_supplier.odb
>
> from the Insert>Link to external Data...
>
> the OK button remains disabled.  How can I link to an existing
> database which was created with Libreoffice?

OLE linking of an ODB file is not supported (by any of the LO modules).
Your database file is either registered with LO, in which case it is
accessible to Calc/Writer and the other modules via the UNO API, and
whatever db interfaces those modules support, or it is unregistered, in
which case, you have to open a connection to the datasource first (e.g.
via macro) and then use that connection as the starting point for
manipulation of database objects within the module that you wish to use.

Calc supports database ranges obtained via queries in an ODB file, but
the ODB object is not embedded in the Calc document as such.

I don't really understand what exactly you are trying to achieve, so
maybe I have missed something ?

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