[libreoffice-users] Re: database2spreadsheet

Am 17.03.2015 um 13:14 schrieb hw:
> Am 16.03.2015 um 18:04 schrieb Andreas Säger:
> > Am 16.03.2015 um 16:18 schrieb hw:
> > >
> >
> > > Exactly: What the perl script does is way beyond the capabilities of a
> > > query and of formulas in a spread sheet.
> >
> > In which way? You are rather unspecific about your requirements.
>
> That's partly because the requirements are still evolving and not fixed
> yet.  The perl script performs some calculations and updates data in
> various tables based on data from a number of other tables, sometimes
> intertwining multiple queries to achieve the desired results.  It's
> non-trivial.

Not trivial, but this is what SQL does so you simply link the result of
one or more SQL queries to a spreadsheet. Having the data in a
spreadsheet you may perform spreadsheet calculations record wise and you
can lookup values from other record sets.

> Can I just point LO to the perl script that provides the required
> functions?  I can't even do that with the built-in BASIC.  Will it
> interpret the perl script?

No, but there are Python, JavaScript and Java as alternatives to the
Basic lingo. Just because this happens to be an office suite, nobody
forces you to work with Basic.

Being a Perl monger, why don't you dump all your results into csv files
and then link those files to a spreadsheet? (if it really has to be a
spreadsheet ... many users insist in using spreadsheets for no reason).


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