LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Ubuntu
User Name
Password
Ubuntu This forum is for the discussion of Ubuntu Linux.

Notices


Reply
  Search this Thread
Old 08-12-2009, 02:27 AM   #1
measekite
Member
 
Registered: Aug 2007
Distribution: Ubuntu
Posts: 42

Rep: Reputation: 16
Question Open Office Calc Print Portrait & Landscape


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?
 
Old 08-12-2009, 10:45 AM   #2
catkin
LQ 5k Club
 
Registered: Dec 2008
Location: Tamil Nadu, India
Distribution: Debian
Posts: 8,577
Blog Entries: 31

Rep: Reputation: 1196Reputation: 1196Reputation: 1196Reputation: 1196Reputation: 1196Reputation: 1196Reputation: 1196Reputation: 1196Reputation: 1196
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.
 
Old 08-12-2009, 12:40 PM   #3
measekite
Member
 
Registered: Aug 2007
Distribution: Ubuntu
Posts: 42

Original Poster
Rep: Reputation: 16
Question

Quote:
Originally Posted by catkin View Post
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>Printroperties dialog and the printer should use the page orientation when printing.

Any ideas on how to do this?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help Please - Open Office CALC Formula's SangrelX Linux - Software 1 06-23-2009 10:42 PM
Open Office Calc in Debian Sid Zaskar Debian 5 11-23-2007 02:26 PM
Open Office Calc question Zaskar Linux - Desktop 3 11-21-2007 03:03 PM
Printer prints landscape when I specify portrait. bagley Linux - Newbie 7 05-06-2007 09:02 PM
elapsed time formula for open office calc philosophe Linux - Software 1 03-30-2005 06:32 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Ubuntu

All times are GMT -5. The time now is 09:27 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration