Andis wrote:
Hello!
I have calc spreadsheet models for water management modelling with
rather complicated calculations and lot of data, so calc works with them
vary slowly. I want to separate data input from calculation part and
make database for input data and then use it as source for calculation
files.
My question - is it possible to assign database field to certain calc
cell like, for instance, in writer documents?
May be stupid question, but it would solve many problems for me.
Andis
I prefer this method:
Before import, create a single-cell database range at A1 and assign any
appropriate name you like. For each import range I use cell A1 on a
separate sheet.
Call Data>Define Range...
Name "myQueryName" refers to $myQuery1.$A$1
Hit button "More Options" and select "Insert/Remove Cells" and "Keep
Formatting". The latter refers to the spreadsheet's formatting rather
than database's number-format.
"Don't save imported Ranges" may be useful in order to enforce updating
on load.
Hit button "Add" and define other start-cells A1 on other sheets if
required.
Now drag your datasource objects into your own defined database-ranges.
Say "Yes" to "Replace contents of myQueryName?"
Create formulas next to the database ranges and apply some pretty
formatting if you like.
Select a either a single cell or the entire database-range in order to
get Menu:Data>Refresh enabled.
If the size of the underlying query has changed, the database-range will
be adjusted to the new size, *including the neighbouring formulas* and
cell formatting.
You can use the adjusted database range names in formulas, just like
other named references.
=ROWS(myQuery1)-1 returns the record-count without header.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
