Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index




Dan Lewis wrote:


     Yes, you can link to a Base query with Calc. With Cal open, use the
F4 key to open the Data Source window. (You will have to register the
database before it will appear in this window.) The left side is the
name of the registered databases. Click the arrow in front of the
database to see that you can get data from from a table or query. When
you select one of these, its data appears in table form on the right
side.

--Dan



Dan,
Wow!  That worked fine.  Thanks.
However, I had to copy and paste the database data from the Data Source window into the Calc spreadsheet. Is there a way to dynamically get the current data to the spreadsheet so I don't have to cut and paste every time I have new data? If so, it would be a lot less error-prone (and easier). However, I can see that not being able to do so, is not a show-stopper for using Calc to do my reports. Note that the data copy, although it took a little time, was *much* faster than Report Builder! :-)
I am going to have to play with this some more...
Thanks very much.
Girvin



--
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.