this is my first question on the platform, long time fan, first time participating.
I am currently working with LibreOffice Calc and have encountered an issue with printing documents. I need to print a spreadsheet on A2 paper size (or larger), but the default print dialog in LibreOffice Calc restricts me to selecting no larger than A4. I've searched through the LibreOffice documentation and forums for a solution but haven't found a clear process to achieve this.
My Questions:
Environment:
I would greatly appreciate any guidance, tips, or solutions that could help me prepare a PDF document ready to print A2 or larger paper sizes effectively. Thank you in advance for your assistance!
What I've tried:
What a coincidence !
I literally just solved this very issue for a poster I am trying to print. You were really close in your research, I found the answer in the LibreOffice Help.
Here is my .ODF
document with the default A4 print helper lines:
You can see how the dashed lines are cutting through the table.
By going to Format > PageS Style
you get this dialog:
By selecting User
and setting width: 594mm
and height: 420mm
then hitting OK
you get the exact boundary you are looking for, the ISO standard A2 ( width x height ).
I also recommend unchecking the header
and footer
options.
Now all you need to do is Export Directly as PDF
And then this is the output:
Hope this helps.