Open Office Calc Print Portrait & Landscape

measekite · 08-12-2009, 01:27 AM

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?

catkin · 08-12-2009, 09:45 AM

If you don't get an answer here try http://www.oooforum.org. Meanwhile you could try Format->"Styles and Formatting" then make sure "All styles" is selected at the bottom of the window then click on the "Page styles" icon then right click in empty space below the listed page styles and create new styles for portait and landscape which you could then apply to sheets as required.

measekite · 08-12-2009, 11:40 AM

Quote:

Originally Posted by catkin

If you don't get an answer here try http://www.oooforum.org. Meanwhile you could try Format->"Styles and Formatting" then make sure "All styles" is selected at the bottom of the window then click on the "Page styles" icon then right click in empty space below the listed page styles and create new styles for portait and landscape which you could then apply to sheets as required.

In my Calc file I have the first page formated for Portrait. The next two sheets for Landscape. Currently I have two print jobs. Job 1 prints the Portrait sheet on my duplex printer and Job 2 prints the remaining 2 sheets on a single piece of paper.

What I would like to do is set my printer to print the entire file of 3 sheeets and to switch automatically from Portrait to Landscape. This, if I can figure out how to do it will yield the first piece of paper with page 1 in Portrait and page 2, the reverse side, in Landscape. The next piece of paper will have page 3 printed in Landscape with the other side blank.

What really happens is that OpenOffice does not tell the printer to automatically switch orientation. It seems that (HP 990Cse) File>Print:Properties dialog overrides the OpenOffice orientation. Therefore I have to creat two jobs with the printer dialog set as portrait for the first and landscape for the second.

I think this is a design bug in OpenOffice. I think that OpenOffice should override the File>Print

roperties dialog and the printer should use the page orientation when printing.

Any ideas on how to do this?