Print different Calc sheets with different orientation or scale

How do I print (and save the print formatting) some sheets landscape and other sheets portrait within the same spreadsheet/document? Excel (2002) allows me to specify different orientation/scale for each sheet; LibreOffice seemingly applies the same formatting to all sheets.

You need one page style for different sheet print options.
With F11 or Menu/Format/Styles and formatting, you can see the box to manage the styles, select the second icon, page styles, select one style, right click and then new, once set the options as you like.
To apply the style to one sheet, select the sheet and double click the desired style.