Hi, I’m new to LibreOffice (french) and I can’t find a way to fit to a A4 page my table when I want to print it.
I mean, when I create rows and collums, I don’t see how much space it’s gonna take on a page of paper…
Any idea?
Two places to set:
Menu/Format/Print Ranges
Here you can define the ranges to print in the sheet, and rows and columns to repeat as headings.
Menu/Format/Page - Sheet - Scaling mode.
Here you have three options.
e.g. if you do not define a range the Scaling mode, and set Print ranges to number pages = 1, the an Auto adjust is made even if you add more rows or columns.
Play a bit with the options and I think you can find how to do it as you need.
- Click Page Preview icon (Ctrl+Shift+O)
- Then Click Format Page
- And select Scaling mode to “Fit print range(s) to width/height”
- Click OK
- Then Click Print File Directly icon (printer icon) to print
Format > Page > Page > Paper Format > Format (Select ‘A4’) > OK. This should get the page outlines / limits to be visible on your Worksheet. You can also set your margins to suit your requirements.
Follow the advice of mariosv,. which is a good one, but if you can’t get the right print-out let us know what do you want to print out:
calc, writer, or… landscape or portrait.