I’m trying to create PDFs from LibreOffice Calc spreadsheets. To match the company’s style, the header and footer have background colors set and should cover the whole width of the resulting PDF.
The footer is an actual LO footer to display the page numbers. It stretches correctly to both sides and to the bottom of the PDF, no margin is visible.
The “header” is actually the first four rows of the sheet set to repeat, because it needs to reference cells in other sheets (author, date, version, classification, etc). This one clearly has a white margin to the right.
I set all margins in the page style dialog to zero. I got a warning when I did that about being outside the printable area, but since this document will never actually be printed (only exported as PDF), I went ahead and ignored the warning. The print range is properly defined, and the sheet is set to fit the width in 1 page (the height limit is left unset). The paper size is also correct; following the advice of another post in this forum, I tried using “Custom” instead of A4, but that had no effect.
I was wondering if the “printable area” warning could be the reason, so I installed a virtual PDF printer (via cups-pdf) with no margin requirements from the printer hardware. I set it as the default printer for this document, but that did not solve the problem.
I have added a minimal example document. The margin is visible in the “print preview” display and in the exported PDF: test2.ods (20.9 KB)
I am using LibreOffice 7.3.7.2 on Kubuntu Linux.
How can I get rid of this margin?
ed 1: added LO version
ed 2: better example document without custom font
