I wanted to build an awesome place for people to discuss module specific issues, but I don't have any more time for this, and there are much better places to discuss Perl-related issues. I'd recommend asking your question on Stack Overflow or on Perl Monks.
If you are looking for a Perl tutorial or Perl-related news, I hope these links will serve you well.
OpenOffice-OODoc
Posted on 2006-04-13 20:48:42-07 by lfrancois
Conversion from ods to pdf
Hello, What is the better way if you want make a conversion spreadsheet to pdf? Is it possible to do it with the perl package OpenOffice::OODoc? Because I don't find anything in pod documentation about it. Best Regards, Ludo
Direct Responses: 2162 | Write a response
Posted on 2006-04-13 22:39:25-07 by jeunice in response to 2161
Re: Conversion from ods to pdf

OpenOffice::OODoc isn't going to help you much there. At least not natively. You could, I guess, use OpenOffice::OODoc to extract the XML contents, then use XLST to generate attractive HTML, XHTML, or XSL-FO. But at the end of this, you're still going to need a program of some sort to render the markup into PDF.

The program I know of to render ODS is OpenOffice itself. It works quite nicely. You can either use the built-in Export to PDF function, or you can Print to a PDF-capable virtual printer, such as the Adobe PDF printer supplied in the commercial Adobe Acrobat (v7) package.

To automate this process, we use OO macros, called from outside of OpenOffice. If you'd like help on that, I'd be happy to send you the required macros & mechanism for calling from Perl. Drop me a line at jeunice EMAIL illuminata DOT com

Direct Responses: 2163 | Write a response
Posted on 2006-04-14 01:16:23-07 by lfrancois in response to 2162
Re: Conversion from ods to pdf
Finally I use this help: http://www.xml.com/pub/a/2006/01/11/from-microsoft-to-openoffice.html?page=1 Is it similar to your purpose? But I would know, if there was a more "perl" way to do it. Thanks for your help, Ludo
Direct Responses: 2164 | Write a response
Posted on 2006-04-14 12:39:52-07 by jeunice in response to 2163
Re: Conversion from ods to pdf

In addition to http://www.xml.com/pub/a/2006/01/11/from-microsoft-to-openoffice.html?page=1 I would recommend this http://www.oooforum.org/forum/viewtopic.phtml?t=3549

Putting these two together gives you pretty much everything you need to (i) figure out what formats you can export OpenOffice content to, (ii) invoke OpenOffice to do the export, and (ii-a) how to use OO Basic macros within OO to coordinate the process.

It'd be ideal to get this encoded into a Perl module for CPAN. Yet another "wanna do" project on the stack. ;-)

Direct Responses: Write a response