I have a Calc spreadsheet that has 3 sheets. The first page is set for Portrait and the remaining pages are Landscape.

Currently I am printing each page as a separate print job.

I would like to print the entire Calc pages as one job where the printer prints the first page as portrait and the remaining pages as landscape without user intervention.

I do not see any command in the print dialog or in open office dialogs that tell the printer to change orientation. It seems that OpenOffice fails to tell the printer the page orientation.

Is there any way to accomplish this. If a macro is required how do you write it and how is it executed?