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