Bug 45056 - PRINTING: define different scale modes for different tabs in Calc
Summary: PRINTING: define different scale modes for different tabs in Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.4.5 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Blocks: Calc-Styles
  Show dependency treegraph
Reported: 2012-01-21 14:19 UTC by tomwoodsv
Modified: 2020-06-28 16:36 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

excel 2019 print scaling options (32.86 KB, image/png)
2020-06-28 16:34 UTC, johnks

Note You need to log in before you can comment on or make changes to this bug.
Description tomwoodsv 2012-01-21 14:19:43 UTC
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
Comment 1 sasha.libreoffice 2012-05-10 23:35:52 UTC
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.
Comment 2 bfoman (inactive) 2012-07-13 08:24:32 UTC
Checked with:
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.
Comment 3 sasha.libreoffice 2012-07-13 15:53:01 UTC
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.
Comment 4 Thomas Lendo 2018-10-17 19:41:51 UTC
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)
Comment 5 johnks 2020-06-28 16:34:51 UTC
Created attachment 162483 [details]
excel 2019 print scaling options
Comment 6 johnks 2020-06-28 16:36:46 UTC
Comment on attachment 162483 [details]
excel 2019 print scaling options

excel 2019 has these options on the print window while calc has only some options, that too in the page styling and not on a global document level.
calc should have these options as well