Re: [libreoffice-users] Re: database2spreadsheet

Hi :)
Ahh, i thought Writer, Calc etc could only look-up data and could not input
or edit data.  I thought that was where the Base's internal Forms and
Reports were really useful?

So normal users could be kept in their safe familiar environment with no
fear of accidentally breaking anything much.  Meanwhile progressively more
skilled/knowledgeable workers could easily be given more and more
abilities.

Regards from
Tom :)



On 17 March 2015 at 17:37, Andreas Säger <villeroy@t-online.de> wrote:

> Am 17.03.2015 um 16:37 schrieb hw:
> > Am 16.03.2015 um 15:57 schrieb hw:
> > > Some experimentation is required at this point ...  Thank you for all
> > > the replies so far!
> >
> > Ok so I made a new spreadsheet and dragged a query from the datasources
> > view into it.  Apparently that fills rows in the spreadsheet with the
> > data obtained from the query.
> >
> > This can be useful and doesn't exactly seem to be what I would want in
> > each case:  What if the data in the underlying tables changes?  Will the
> > spreadsheet be updated automatically?
>
> Click any single cell in that import range and call Data>Refresh
> A one-line macro can update this on file open.
> You can also set a flag to that import range to not store the data
> within the spreadsheet. In this case you hit Enter when are prompted to
> update the unsaved import data on file open.
> You find this option under menu:Data>Define... pick your import range,
> [More Options]
> You can add a timer to the import range so it updates every x seconds.
>
> [Tutorial] Using registered datasources in Calc:
> > https://forum.openoffice.org/en/forum/viewtopic.php?f=75&t=18511
>
>
> > What if I edit the data in the spreadsheet?  I suppose I cannot update
> > the underlying tables through the query.  So I pulled a table into the
> > spreadsheet and after an hour or so, I had to kill LO because it didn't
> > seem to do anything anymore.
>
> Your edits will be lost on next refresh.
> For database input you can add a true input form to this spreadsheet
> document or any other office document (Writer, Calc Draw).
> In some cases you may use the data source window for data entry into
> updatable record sets.
>
>
> --
> To unsubscribe e-mail to: users+unsubscribe@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

-- 
To unsubscribe e-mail to: users+unsubscribe@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