On 30 April 2012 23:02, Andreas Säger <villeroy@t-online.de> wrote:
First you link a so called "Base document" to the database. Then you can link office documents. File>New>Database... [X] Connect to existing database Type: MySQL [X] Register the database Specify the connection details. Save the "Base document" (it is a configuration file actually). You may add some useful SELECT queries for your purposes. In Calc hit F4 and drag your table/query into the sheet. This creates a linked import range (see Data>Define...).
Perfect. At least now I can get data into a spreadsheet. Next I need to work out calling stored procedures and passing user parameters to the SP as well as automated updating (on open and on parameter changing). These are probably macro based rather than UI. Hopefully. Thank you for your reply though. Very useful. -- Richard Quadling Twitter : EE : Zend : Fantasy Shopper @RQuadling : http://e-e.com/M_248814.html : http://bit.ly/9O8vFY : http://fan.sh/106/5tw -- For unsubscribe instructions e-mail to: users+help@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