Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

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?

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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.