[Solved] Printer page settings for EACH sheet

[mxdog]

In all the years I have been using spreadsheets (think lotus 1.0) I don't think I have ever run across this, at least for Open Office Calc.

Is there some way to define sheet print and/or printer properties per each SHEET and not the whole spreadsheet ?
Or... do I have to redefine the print properties every time I want to print a particular sheet tab ?
It seems like a fairly basic feature.

For instance the sheet i am working on has 4 sheets/tabs Lots,Boxes,Front Posters,Back-Posters
The Sheets;
Lots;print range is A1:H746 (13 pages) all cells being 10dpi and I print that to scale 85% Portrait mode, repeating line one header.
Boxes; print range is A1:K50 all cells being 8dpi and I print that in landscape mode, fit to one page(s)
The two posters sheets have very large print and are set for print ranges width/height portrait mode (about 47 pages) each poster having it's own print range i.e. page.

The trouble here is every time I want to print this document I have to change settings three times and print the portions I am after. Other then occasionally ruining some paper, it is a pain in the rear. This leads me to believe I might be missing some basic understanding of how to do this, if this is even possible in Calc. If not, can we get a feature request in ! One little tick box printer options per sheet (hehe, and some code of course) .

I know for a fact any printer will adjust on the fly ,so to speak, even if you just have to send the output as separate jobs per sheet (easiest way I would think) this from back in the day when I had to program/format each page to print , don't we all miss COBOL and main frame computers and control codes,control codes and yet more control codes ... sigh...

[MrProgrammer]

Is there some way to define sheet print and/or printer properties per each SHEET and not the whole spreadsheet?

Yes, read about page styles. You can have a different page style for each sheet.
Chapter 4: Using Styles and Templates in Calc

… can we get a feature request in?

No, developers do not review topics on this forum.

If this solved your problem please go to your first post use the Edit ✏️ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know