Page format got stuck in lanscape in Calc

I have a file with two sheets, one to be printed in portrait and the second to be printed lanscape. When I did the first sheet (portrait), it printed correctly. Then I created a second sheet, (for landscape printing) and it also printed correctly. But, alas, when I tried to print my first sheet again, it printed landscape even though I formatted it for portrait printing. No matter what I do, I can’t make it print portrait again. Is there a solution for this? Thanks.

.xls format does not work either…tired of no real answers or support!!!

Just to inform that the problem vanished by saving the file in .xls format instead of .ods. Strange!

it does not work in .xls format either

see Print different Calc sheets with different orientation or scale

Didn’t work in LB