Ask Your Question

fit to page A4 with calc problem [closed]

asked 2012-11-22 10:44:23 +0200

Benoit M. gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-28 23:15:26.854169

3 Answers

Sort by » oldest newest most voted

answered 2012-11-23 01:26:18 +0200

m.a.riosv gravatar image

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.

edit flag offensive delete link more

answered 2012-11-23 04:26:31 +0200

ROSt52 gravatar image

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.

edit flag offensive delete link more

answered 2014-07-11 07:49:57 +0200

semphai gravatar image
  1. Click Page Preview icon (Ctrl+Shift+O)
  2. Then Click Format Page
  3. And select Scaling mode to "Fit print range(s) to width/height"
  4. Click OK
  5. Then Click Print File Directly icon (printer icon) to print
edit flag offensive delete link more


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.

dejayajay gravatar imagedejayajay ( 2015-01-17 09:37:12 +0200 )edit

Question Tools


Asked: 2012-11-22 10:44:23 +0200

Seen: 61,618 times

Last updated: Jul 11 '14