When I set the print orientation for Sheet 1 to Landscape the print orientation for Sheet 2 is also changed even though the data on Sheet 2 is better printed with orientation = Portrait. What is the rationale for this behavior?
Orientation is a property of page styles. When you change the orientation of your first sheet, you are actually changing the orientation of its page style and therefore of all sheets with the same page style.
Is there a preference setting that unlinks the sheets with regard to print orientation?
Give them different page styles:
o Go to Format | Styles and Formatting ... (or click the Styles and Formatting icon in the Formatting toolbar or press F11).
o Click Page Styles in its toolbar.
o Click New Style from Selection.
o Give your new style a name.
o Right-click the new name and select Modify... .
o Adjust the style properties as desired - presumably including setting Landscape on the Page tab.
o Bring each sheet to the front in turn and double-click the appropriate style to apply it.
I trust this helps.
Brian Barker