[users] Re: Export to PDF each page in a separate file.

[Jallan]

annonygmouse wrote:

OK. Got it.
But what I _actually_ wanted is an option in the "PDF options dialog"
that said something like "Export each sheet to a separate file"
Like: name.xls
        ---->  name_sheet1.pdf
        ---->  name_sheet2.pdf
        ---->  ....
        ---->  name_sheetN.pdf
But any other automatic method will suit me too :)
Any hint?

If you want to get into programming in OOBasic and you already know some 
programming, it would be fairly easy to write a macro which loops 
through all spreadsheets in the current Calc document, first selecting 
the entire sheet and then exporting the selected range to a PDF with the 
name of the sheet as the stem of the filename.

Jallan

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]