[libreoffice-users] Re: database2spreadsheet

Am 06.03.2015 um 09:08 schrieb Alex Thurgood:
> Le 04/03/2015 10:59, hw a écrit :
>
> Hi,
>
> > In a future step, I would like to integrate graphics into the
> > spreadsheet which could be created by a perl script with gnuplot from
> > data in the database; the images could reside in a directory and rows in
> > the database would have a field referring to the file name of the image.
>
> If you are going to use Perl to manipulate graphic objects to insert
> into a Calc document, why not use Perl for everything, including
> querying your db, outputting your data in the desired format, and
> inserting that array of data into a Perl-created/manipulated Calc file ?

Because all this has been implemented already to be used by anyone
without coding.
Hit F4 and drag your query into your favourite spreadsheet template.
Add spreadsheet formulas, (conditional) formatting, charts and stuff.
Finally, you may remove the "store data" flag from the import range so
the user is prompted to update the import range when opening this
document. All this works reliably out of the box.


> Look at the following Perl modules :
> ODF::lpod
> OpenOffice::UNO
> OpenOffice::OODoc

How much time does it take to re-implemented the built-in functionality?
And why?


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