Formatting Pages in CaLc

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Formatting Pages in CaLc

John van Barneveld
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
Reply | Threaded
Open this post in threaded view
|

Re: Formatting Pages in CaLc

Julian Thomas


Sent from JT's iMini - using voice dictation!

> On Mar 2, 2017, at 18:44, John van Barneveld <[hidden email]> 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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Formatting Pages in CaLc

Martin Groenescheij


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 <[hidden email]> 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: [hidden email]
> For additional commands, e-mail: [hidden email]
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Formatting Pages in Calc

Brian Barker
In reply to this post by John van Barneveld
At 23:44 02/03/2017 +0000, 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: [hidden email]
For additional commands, e-mail: [hidden email]