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: 1. .... 2. .... 3. .... 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.
Checked with: LO 3.5.5.3 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? I suggest: 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)
Created attachment 162483 [details] excel 2019 print scaling options
Comment on attachment 162483 [details] excel 2019 print scaling options excel 2019 has these options on the print window while calc 6.4.2.2 has only some options, that too in the page styling and not on a global document level. calc should have these options as well