How do I force Calc header to stay a fixed size?

In our company we’re using pricelists that for several reasons do not always have the same width. I would like to avoid adding a header manually on each page and do it the proper way, by adding it as a header. However, the problem below appears when trying to print/export pdf.

Normal view

Zoomed out view

As I zoom out, the header gets squished, regardless if i have “Autofit Height” enabled in header options.

Is there a way to do this properly? Just using a linked header image in the sheet itself is, as far as I’ve found, the only reliable way.

I made some tests and could not find a solution to your problem.

On the other side, I also understand why it is no possible. You print at different scaling factors and the scaling factor is the dominant parameter for the print out.

I would try to see if a Writer table could be the solution because the page size remains the same.