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.
-- When you drag the query icon from the left pane of the data source
window onto a Calc cell you will get a semi-automatic link. Call
menu:Data>Refresh to refresh the link.
-- When you drag selected row selectors you get a copy of selected rows.
The top-left corner of a row set selects all rows. Same with queries,
views and tables opened from some database window.
-- Dragging a query icon from the database window creates a refreshable
link as well but the link breaks when the connection closes. Bug or not
bug? Who cares?
-- From a form you can copy from the additional grid view. Hit the last
button on the navigation tool bar.
The linked data range resizes dynamically with every refresh.
Any formula cells directly adjacent to the import range will expand and
shrink with the resized data range. So the clearly defined row sets of a
database enable dynamically resizing formula ranges. A feature that does
not exist with a pure spreadsheet. Tons of silly macro code have been
written for this.
Its properties are accessible via menu:Data>Define...
Below [More Options] we have 4 widely unknown options:
1) Contains column labels (always true for database imports)
2) Keep formatting: spreadsheet formatting overrides any Base
formatting. Should be true by default.
3) Insert/remove cells: Do not overwrite/clear cells when the database
range expands/shrinks. Should be true by default, particularly with
resizing formula ranges.
4) Don't save imported data. Useful with very large row sets and when
you want to refresh on open. Prompts for refresh when opening the file.
For unsubscribe instructions e-mail to: email@example.com
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
Impressum (Legal Info)
: 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