Andreas Saeger ha scritto:
Franco Fornari schrieb:
Hi Mechtilde, Frank,
yes, of course, but those data change frequently and I don't like too
much to have more than one instance of the same database, in
different formats. Perhaps is it worth a request for an enhancement?
Do you think that such a proposal would be interesting for many users?
Keep your data with some preselecting queries and views in the
database and use the spreadsheet for scenarios, complex calculations,
pretty presentation and aggregation (for instance data pilots) of
imported data. This way you get the best from both components, while
keeping the data in one place. Calc-Menu:Data>Refresh refreshes the
sheet's data. A nice input form can prevent some typos, duplicates and
inconsistancies. No spreadsheet is supposed to do that. A "real"
database provides consistant storage with multi-user access from any
frontend (OOo-form, web-form, other tools).
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Hi Andreas,
yes, I certainly agree with all your suggestions, but the data I was
referring to come from the web in Excel format. Then, each time I'd have
to delete the old tables in my database and import the new ones from the
spreadsheet ,again. This is doable, sure, but I'd prefer, each time,
overwrite the spreadsheet, only. That's all. ;-)
Ciao,
Franco
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
