1

I have document with two sheets sheet1 and sheet2 and i want set orientation of sheet1 to portrait and orientation of sheet2 to landscape.

This can be done in Excel, but in OpenOffice when i set sheet1 to portrait and then sheet2 to landscape then both sheets are landscape.

How to do this in OpenOffice.org Calc?

1 Answer 1

2

You can do this by assigning different Sheet Styles to the respective sheet.

To create a sheet style with landscape orientation:

  1. Hit F11 to open the "Styles and Formatting" window (it may be already visible and docked);

    enter image description here

  2. Switch from "Cell Style" to "Sheet Styles";

    enter image description here

  3. Right-click and select "New" (there's only this option);

    enter image description here

  4. In the new Sheet Style properties, assign a name (for example, "Landscape"), and on the "Page" tab, set the Orientation to "Landscape";

    enter image description here

  5. Hit OK. Now, there's your new sheet style in the sheet styles list.

    enter image description here

  6. Select the sheet that should have landscape orientation, and double-click on the new page style entry in the "Styles and Formatting" window to apply it to the current sheet.

That's it.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .