Page orientation in libreoffice calc 6.2.5 [Solved]

[sameerjamadar]

libreoffice version 6.2.5
query for calc

1. when i select page orientation viz. landscape or portrait in format page its apply for whole workbook.
2. it is possible to to give different page orientation to different sheets in one workbook.
3. format page setting automatically applied for all sheets in one workbook
4. please figure it out this problem.

[jodybingo]

Hi Sameer,
Hit F11 on your keyboard, this will open up the Styles formatting (alternatively you click on Styles in the menu bar then choose Manage Styles).
From there you can define page styles. Set up the page style you want and you can apply that style to any page you want by double clicking on your newly created page style while the page you want changed is active.
You can also edit this style and the changes will be applied to all sheets that have this style used, but keep in mind you will not be able to modify the style if any sheet using the style is protected

[sameerjamadar]

thanks jodybingo for answering me. I follow what you wrote but i could not find it. I thinks is for cell style in particular sheet. Actually I created one workbook that contain 3 sheet. I want to do only first sheet in horizontal & remaining two in vertical. When i select layout>format page and select orientation horizontal its applied for all sheet.

[jodybingo]

When hitting F11, at the top you have 2 options (icons). One is for Cell Styles and the other is for Page Styles. Select the Page Styles, define the style you want and then when on the sheet you want the style to apply to, double clik the style in the list. It will apply to that sheet

[sameerjamadar]

OMG I did not see that icon, Once again I thank you wholeheartedly.

[jodybingo]

My pleasure!!