How to print landscape and portrait sheets from the same Calc document

Having a Calc (.ods) document containing multiple sheets it happens that one sheet is better printed in portrait while another better prints in landscape.

Using Format > Page > Page-Tab to change the page layout seems not to allow setting differing layout options for the differing sheets. (Setting first portrait for the first sheet and afterwards landscape for the second sheet resets the layout option to landscape also for the first sheet.)

Is there any possibility to define the page layout sheet-wise and print all sheets with their respective orientation in one rush, or export all sheets in their respective orientation to a pdf file.

Your help much appreciated,

Karl

see: <solve>portrait in sheet1 and landscape in sheet2