Ask Your Question

Calc: print a sheet to fit A4 [closed]

asked 2017-09-30 23:25:10 +0100

bwall gravatar image

updated 2017-09-30 23:30:44 +0100

Sounds simple but it doesn't work. I want two columns to print as wide as possible on A4. I set the print range which is portrait in shape. In Print Preview if I Format Page Scale to Fit Print Range the preview shows a massively narrow column.

If I choose Reduce/Enlarge I have to guess the % !!! If I get close with a guess, the print range never fills the width to the maximum because if I increase the percentage by just one point suddenly the columns are split over two pages.

There seems to be very little control available. The printer driver isn't any help either.

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 2020-10-16 16:16:46.207822

2 Answers

Sort by » oldest newest most voted

answered 2017-10-01 09:28:32 +0100

pierre-yves samyn gravatar image

updated 2017-10-01 09:32:17 +0100


Here's how I proceed:

  • FilePrint Preview▸click Margins to display margins.
  • Click Format PageSheet tab▸Scaling Mode:▸Fit print range(s) to widht/heightWidth: 1
  • Adjust the width of the columns with the mouse.


HTH - Regards

edit flag offensive delete link more

answered 2017-10-02 22:36:30 +0100

bwall gravatar image

Thanks. That helped.

edit flag offensive delete link more


A hint for the future: please don't use "Answer" to place comments and replies that don't themselves answer original question. The "Add comment" is for comments like this one that I'm replying to, and the "edit" is for making changes (clarifications, etc) to your original question.

It's OK (and great!), however, to answer your own question if you have found it; it will help others having similar issues in the future.

And please mark correct answer using check at the left to answer.

Mike Kaganski gravatar imageMike Kaganski ( 2017-10-03 08:45:35 +0100 )edit

Question Tools

1 follower


Asked: 2017-09-30 23:25:10 +0100

Seen: 2,724 times

Last updated: Oct 02 '17