[Solved] Print Calc sheet to PDF, using a macro

[martius]

How to make a macro that exports a specific spreadsheet to PDF, considering the print area already defined in LibreOffice Calc?

[MrProgrammer]

How to make a macro that exports a specific spreadsheet to PDF, considering the print area already defined in LibreOffice Calc?

Please search first before posting. I found this in a few seconds. I do not offer to help further with writing macros.
[Solved] Save PrintRange as PDF to Desktop of Any User

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[martius]

Thank you!

[Zizi64]

The "Print" method can use a virtual PDF printer (if it is exist).
Ther "Export" method uses the built-in export feature

You you can use the "Export the Selection" option. Of course you must SELECT the cell range to export (by the macro) before you use that option.

Code: Select all

	Arg(0).Name = "Selection"
	Arg(0).Value = oRange

	args2(0).Name = "FilterName"
	args2(0).Value = "calc_pdf_Export"
	args2(1).Name = "FilterData"
	args2(1).Value = Arg()

	ThisComponent.storeToURL(Pdf_Local_URL, args2())

Where the oRange is a cell range object (you must get an Select it by your macro), and the Pdf_Local_URL is the place where you want to save the pdf file to.