Formatting Pages in CaLc
I have a spreadsheet with four sheets, the third of which I want printed in landscape and the rest in portrait. It seems when I set in Format-Page it formats all four the same forcing me to print each page separately. This is fine for printing but I want to save a four page .pdf with the one page as landscape. Can anyone tell me how to go about this please. Thanks John van Barneveld --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
Re: Formatting Pages in CaLc
Sent from JT's iMini - using voice dictation! > On Mar 2, 2017, at 18:44, John van Barneveld > wrote: > > This is fine for printing but I want to save a four page .pdf with the one > page as landscape. Can anyone tell me how to go about this please. Brute force solution: print the landscape page as a separate PDF; Print the other three pages, and then glue the two PDF files together. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Formatting Pages in CaLc
On 03/03/17 11:15 AM, Julian THOMAS wrote: Sent from JT's iMini - using voice dictation! On Mar 2, 2017, at 18:44, John van Barneveld wrote: This is fine for printing but I want to save a four page .pdf with the one page as landscape. Can anyone tell me how to go about this please. Brute force solution: print the landscape page as a separate PDF; Print the other three pages, and then glue the two PDF files together. Better is to use existing functionalities. Go to Format -> Styles and Formatting, the second icon at the top is Page Styles Create a Landscape and a Portrait Style for each sheet select the desired style. Happy printing. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Formatting Pages in Calc
At 23:44 02/03/2017 +, John van Barneveld wrote: I have a spreadsheet with four sheets, the third of which I want printed in landscape and the rest in portrait. It seems when I set in Format-Page it formats all four the same ... Because you are modifying the page style which currently applies to all parts of your document. ... forcing me to print each page separately. This is fine for printing ... Well, not exactly fine: it would be easier if you could set the third sheet to print in landscape automatically, of course - and you can. ... but I want to save a four page .pdf with the one page as landscape. There are workarounds for this, but you don't need these. Can anyone tell me how to go about this please. Page orientation is a property of page styles. If you have not consciously set any page style, all your pages will probably have the Default page style. You can see this when you go to Format | Page...: the panel is headed Page Style: Default. So all you need is to use a different page style for the rogue sheet. o Go to Format | Styles and Formatting... (or click the Styles and Formatting button in the Formatting toolbar, or press F11). o Click the Page Styles button in the Styles and Formatting window. o Click Default (or whatever your main style is called). o Click the "New Style from Selection" button. o Give your new style a name. o Right-click the new style name in the list and select Modify... . o Change the orientation of this style to Landscape. o With the rogue sheet displayed, double-click the new style name to apply it to that sheet. o Voilà! I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
