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+unsubscr...@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