Re: [libreoffice-users] Re: database2spreadsheet

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.

> > Even letting aside that using the BASIC dialect of LO is very awkward
> > (just think of the inability to return from a function ...) and that it
> > doesn't even have a decent editor, LO is far too unreliable for anything
> > like this.
>
> Basic can not return from a function? I'm no fan of that awkward and
> almost extinct language of the 90ies but sometimes I use quick&dirty
> Basic functions in spreadsheets or even Basic functions calling Python
> functions.

It's what you get when you write a macro to provide you with a function 
you can use in your spread sheets.  I don't like it, either, and I'd 
gladly do it in perl instead.

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?

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