What I am asking for is the same as the "Tip of the day day 120 of 225" (sheet zoom factor)

Link the scale factor to the page.

Thanks, Tracey

Typical use case for zoom is to accommodate to monitor distance. Meaning you don't want to adjust the zoom factor for each single sheet - the opposite of your request.

(In reply to Tracey from comment #0)
> I have the need to use a great variety of scaling-factors on different
> sheets while using the same standard page size and page orientation
> (depending on the amount of information loaded into the sheet).
Can you elaborate on this?

(In reply to Heiko Tietze from comment #2)
> Typical use case for zoom is to accommodate to monitor distance. Meaning you
> don't want to adjust the zoom factor for each single sheet - the opposite of
> your request.
> 

I hope you don't mean that such case is the main (and/or only) reason to change the zoom factor on a worksheet. A few different examples follow, FWIW.

One worksheet might contain detailed information on many items. Another worksheet might have summary information. On each of those, you might need to focus on a certain area of the whole worksheet, or you might need to see "the bigger picture" for diverse reasons.

Since Calc lacks the possibility of Tracing Precedents/Dependents on a different worksheet, there is a chance that both, the "details" and the "summary" might be located in the same worksheet, and so sometimes users need to focus on one area, whereas sometimes the need is to see the relations between different parts of a worksheet that might contain dozens or hundreds of columns.

While building a worksheet (e.g. formulas), you might have to zoom in/out in order to click/select some range. That range might be near the cell that contains the formula, or it might be much further away. While this happens, other worksheets on the same workbook were already built in the past and they require a different zoom factor, that rather should not be changed each time.

One worksheet might contain a lot of ("detail") data, a second worksheet might contain a "summary" of the data, and a third worksheet might contain graphs related either to the summary or to the detail data. Each of these might deserve a different use of zoom factors.

These are just a few examples of possible reasons to have different zoom factors on different worksheets, all being part of the same workbook.

Having said that, there is also the possibility that a user wants to change the zoom factor to all the worksheets (at once), instead of having to change it independently for each worksheet.

My point is that there are diverse workflows and needs. Sometimes the zoom factor should rather be modified for all the worksheets in a workbook at once, whereas sometimes each worksheet should rather have its own zoom factor independent of the others.

(In reply to Heiko Tietze from comment #2)
> Typical use case for zoom is to accommodate to monitor distance. Meaning you
> don't want to adjust the zoom factor for each single sheet - the opposite of
> your request.
> 
> (In reply to Tracey from comment #0)
> > I have the need to use a great variety of scaling-factors on different
> > sheets while using the same standard page size and page orientation
> > (depending on the amount of information loaded into the sheet).
> Can you elaborate on this?

What I am requesting is that the sheet scale-factor (for printing) be linked with the individual calc sheet and NOT the page-style (as it is now).

When page break view is selected the right & bottom margins are adjustable (which adjusts the scale-factor so the spread sheet will fit on the printed page).

When the scale-factor is linked to the page-style, all sheets with that page-style get the scale-factor adjusted and NOT just that 1 sheet (which is NOT at all desirable).

I would have to create a page-style for every scale-factor for every page size/orientation.
But this is not a good solution simply because the scale-factor is not known/set until the page margins are adjusted which automatically changes all the other sheets with the same page style (on-the-fly if you will).

Thanks, Tracey
I was just using the Tip-of-the-Day #120 of 225 concept as an example:
Just like the zoom factor can be linked with the individual sheet instead of all the sheets, I would like the (print) scale-factor be linked with each individual sheet (and not EVERY sheet the same page-style).

FWIW… Just in case someone is missing/mixing it, the zoom factor for the main area in Calc is not the same as the zoom factor for Print Preview, nor the same as having Breaking limits for each page (menu View > Page Break), nor the same as printing multiple "pages" on one physical page.

Created attachment 192778 [details]
Screenshot

(In reply to Tracey from comment #4)
> > (In reply to Tracey from comment #0)
> > > I have the need to use a great variety of scaling-factors...
> > Can you elaborate on this?
> 
> What I am requesting is that the sheet scale-factor (for printing) be linked
> with the individual calc sheet and NOT the page-style (as it is now).

In other words an automatic scale-to-content function? Meaning the slider in the print preview adjusts the scaling to print all data on one page or increases the size to fill the page.

(In reply to Heiko Tietze from comment #6)
> Created attachment 192778 [details]
> Screenshot
> 
> (In reply to Tracey from comment #4)
> > > (In reply to Tracey from comment #0)
> > > > I have the need to use a great variety of scaling-factors...
> > > Can you elaborate on this?
> > 
> > What I am requesting is that the sheet scale-factor (for printing) be linked
> > with the individual calc sheet and NOT the page-style (as it is now).
> 
> In other words an automatic scale-to-content function? Meaning the slider in
> the print preview adjusts the scaling to print all data on one page or
> increases the size to fill the page.

[automatic scale-to-content] is already functioning (and this is good).

The request is: associate/link/tie the scale-factor to the applicable sheet and NOT to the page-style.

Thanks, Tracey
Why: Right now the scale-factor is linked to the page-style.
When the margins for a give sheet are changed, ALL the sheets with the same page-style automatically have their scale-factor changed also even though scale-factor should ONLY apply 1 sheet and NOT apply to any other sheet.

(In reply to Tracey from comment #7)
> [automatic scale-to-content] is already functioning (and this is good).
Maybe off-topic, but how? Changing the page style from A4 to A5 does not change the print-out scaling but the zoom factor on how that smaller page is shown in the print preview.

The {print}scale-factor is currently to assigned/associated/linked to the page style.

Let's say I use 4 page styles: A4 portrait, A4 landscape, A5 portrait, A5 landscape.

Let's say I have calc file with numerous sheets with each sheet having varying amounts of information.

Let's say I want to change the {print}scale-factor for 1 of the sheets to fit the data to the printed page.

If I do that NOW, then all the sheets using the same page style also have their {print}scale-factor changed AND THAT {print}scale-factor is NOT applicable to the other sheets.

If I have a dozen different sheets that need a dozen different {print}scale-factors, I do NOT want to create a dozen different styles just to accommodate adjusting the {print}scale-factor.

The {print}scale-factor has to be linked to something for it to be applied to the sheet.

Therefore, linking the {print}scale-factor to each individual sheet is the logical method/procedure.

Thanks, Tracey
I need the {print}scale-factor to be re-assigned/associated/linked to each individual sheet.

Right, I just learned that the scaling control in the Print Preview is synced to the current page style's scaling factor, and I agree that it might be surprising for users to change that scaling by hand in the Print Preview, to make the content fit nicely on a page, to then find out that other sheets are affected.

My opinion is that this is a setting that's very much linked to printing / exporting to a fixed format / physical support, and therefore should remain tied to the page style.
I don't think we can have two conflicting settings, Page style scaling vs Sheet scaling, it would create too much confusion. And this kind of change is limited by the formats we support. If the formats support Page Style scaling, then we need to keep the UI for it. Maybe Regina has an opinion?

But maybe that's an issue in the Print Preview UI. The toolbar could:
- have the label "Page Style Scale" instead of just "Scale"
- or the section that contains "Format page", "Margins" and "Scale" should also show which is the active Page Style, maybe with a Page Style picker, to make it clearer that these settings are tied to it (and with "Format Page" re-labelled to e.g. "All Page Style Options"):

<navigation and zoom buttons> | [Current Page Style ▼] [Margins] [Scale] [All Page Style Options] | <close preview>

Do you think that would help, Tracey?

No.
Normally printers print on (1, 2, or 3) standard page sizes based on the paper tray.

If I have a dozen or two different sheets then I would have to create a dozen or two different page styles just to accommodate scale-factor when I want to fit the maximum information from a sheet on a page.

Linking the scale-factor to a page-style is an absolute a waste of the User's time and effort (unless the User rarely, if ever, uses the print scale-factor).

I now use the print scale-factor much more frequently.
Since each sheet can have a different scale-factor so why not link the scale-factor to the sheet which is far more useful and efficient for the User (I know the scale-factor has to be linked to something).

Thanks, Tracey

In calc, the screen zoom-size is for all sheets (regardless of the page style)... except/unless:
tools> options > LibreOffice Calc> View> and uncheck synchronize sheets
Then each sheet has its own zoom-size (regardless of the page style).

This is EXACTLY how I am asking the print-zoom to work.

The print-zoom being tied to each individual sheet is more (efficient / functionally beneficial) than tying the print-zoom to the page style.

Thanks, Tracey
It appears there is a greater commitment to styles than to practical functionality.