Only the header is printing

A workbook I’ve used for a couple of years and had no issues with.
I made a change to the font for the page header.
Now, when I go to print, all looks well at first but then print preview ( and actual print) shows only the header with none of the spreadsheet content.
Any ideas what I’ve done?

If you expect any decent answer, edit your question to add OS, LO version and format file is saved with (.ods or .xls(x). Have you updated recently to a newer version? Is this the same printer or a newer one? Which fonts (the older and the newer ones)? Is the header font also used in the spreadsheet content?

You changed the font for the header range.

Is, by any chance, that range still selected?

If you print while a range is selected, the print dialog sometimes assumes that you want to print that selection only.

The different behavior, i.e. whether “Selection” is automatically activated or must be manually selected, may be version dependent. Hence the request from ajlittoz for details makes very much sense, in this case as always.

Choose menu Format - Print Ranges - Edit… and check the values for Print Range.

See LibreOffice Help on Edit Print Ranges.


Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information.

Check the mark (Answer markCorrect answer mark) to the left of the answer that solves your question.