Calc only prints a few cells of page

When attempting to print a spreadsheet, only a few cells from somewhere in the middle of the sheet appear. The only remedy I’ve found is to copy and paste the spreadsheet into a new file. This has happened on a few files. I’ve gone through all the settings I can find. What am I missing?

Seems there is defined a range for print in:
Menu/Format/Print ranges/Edit

Yup, that was it. It’s my father-in-law’s computer, and I’m not quite sure how he managed to have a selection in there…

If the answer solves your question please tick the :heavy_check_mark:.