print in landscape, b

Open new calc sheet and entry data into many cells.

Then try to print in landscape, by going to format, page.

But page doesn’t show?

Set the Print Range (Format - Print Range - Define/Edit)
and set the Orientation property of the applied Page Style.
.
Can you upload your .ods type sample file here?

Page and printer setup in Calc