Problem description: I have various spreadsheets within one file of different sizes. One I want width in pages 1, height in pages 4, the next tab I want width in pages 1, height in pages 2. I also have other tabs where I might want to print in landscape instead of portrait. I want all the spreadsheets in one file so I can convert to a PDF to send to recipients so they only have one file to open.
Steps to reproduce:
Current behavior: I set the scale mode for the first tab to 1 width, 4 height, but then when I go into second tab, the 1st tab's settings are defaulted.
Expected behavior: I should be able to set the scale mode for each tab, so if one requires 1 width, 4 height, the second tab requires 1 width, 1 height, and a third tab requires landscape, 1 width, 2 height, once I set the mode for each tab, those settings should be specific for each tab.
Platform (if different from the browser):
Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:9.0.1) Gecko/20100101 Firefox/9.0.1
Thanks for new idea
In LibreOffice all page setting is done via page styles. Enable Stylist (press F11) and create needed page styles, then assign them to different sheets.
Build ID: own W7 debug build
Windows 7 Professional SP1 64 bit
It seems that different scaling or page orientation is saved for 1st and 2nd sheets only. 3rd sheet is always copying settings of 2nd sheet, so when you change settings of 3rd - settings of 2nd are changed and vice versa. More sheets = the same problem. Changing 3rd will change 2nd and 4th. 1st keeps its settings.
Looks like it remembers "scaling factor" per page style. So, if we want use 5 sheets with different scaling, we should use 5 different page styles for them.
I don't get this enhancement request/bug report as I only can define one page settings per page style. How do you can have different scale factors within one page style? As the user can create as many page styles as needed, this should be closed as WORKSFORME.
The only issue I see here is that page styles are hidden by default. So, how can the user see what is needed to do to have more page styles?
1) Adding a new toolbar command in the print preview beside the current "Format Page" button, named like "Add new Page style..." or something like that. "Format Page" then can be changed to "Format Page style...". With this command, a new page style is created and automatically assigned to the current sheet.
2) Rework the "Format" menu and change the "Page..." menu item to a sub-menu "Page" with following items:
- "Format Page style..." (replaces the current "Page..." item)
- "Add new Page style..." (to add a new page style and assign it to the current sheet automatically)