Ask Your Question

How to print multiple sets of data per page [closed]

asked 2013-01-09 17:15:09 +0100

BugCatcher gravatar image

updated 2020-08-20 14:39:17 +0100

Alex Kemp gravatar image

I have two columns in LO Calc. They measure 3.75" left to right. The page is set to landscape. I would like to print more than one set of results on a page, but the page preview only shows one set with a whole lot of white space to the right of the data. If I print more than one page to a single page, I end up with the multiple pages, but they show tiny characters and a whole lot of wasted space. Unfortunately MS Excel does the same thing.

Am I the first to want to not waste paper?

How do I print using the entire page filled with data. Please don't tell me to make the font bigger.


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-27 12:13:46.510517

5 Answers

Sort by » oldest newest most voted

answered 2013-01-10 18:33:06 +0100

petermau gravatar image

If you choose FILE > Print > Page Layout you can specify the number (1-16) of spreadsheet pages to be printed per physical sheet. You may need to alter the logical page size to fit your data to remove the white space you currently have on the right side of the columns using Styles and Formatting (PF11) > Page Styles > Default > right click Modify.

edit flag offensive delete link more

answered 2014-07-02 15:56:22 +0100

EJRAS gravatar image

The way I got it: FORMAT -> PAGE -> SHEET -> SCALE

I'm translating the commands since my ersion of LibreOffice is in Brazilian Portuguese.

edit flag offensive delete link more

answered 2013-01-10 19:58:07 +0100

Retep_re gravatar image

Have you tried to adjust margins and scaling in Page Preview mode (File > Page Preview)?

Click on the margins button and then drag the dotted lines to increase the space available for printing. If that is not enough, you can use the slider (between "margins" and "close preview" to adjust the scale so that both columns fit on one page.

edit flag offensive delete link more


No matter what scaling I use, I still end up with only one set of data per page (col A and col b) and a lot of blank space on the page.

BugCatcher gravatar imageBugCatcher ( 2013-01-16 20:42:38 +0100 )edit

answered 2013-01-11 07:56:54 +0100

ROSt52 gravatar image

Is the colum width 3.75 inch per column? What is the width of the paper between the left and right margin?

If each column is 3.75 inch and you use A4 paper settings you could just be beyond the width of the area within the margins.

edit flag offensive delete link more


The paper is standard 8.5" x 11" in either portrait or landscape. This allow more than enough room to print 2 or 3 columns, but only one column is printed per page.

BugCatcher gravatar imageBugCatcher ( 2013-01-16 20:25:00 +0100 )edit

Column A is .7" and Column B is 3.45" so the total is 4.15". Guess I was off by .4" in my estimate. Still should be more than enough room in either format.

BugCatcher gravatar imageBugCatcher ( 2013-01-16 20:40:07 +0100 )edit

Can make the spreadsheet public to have a look into it?

ROSt52 gravatar imageROSt52 ( 2013-01-17 01:50:48 +0100 )edit

answered 2013-01-11 03:52:18 +0100

horst gravatar image

I think what you have to is this (not really pretty but it works).

Import your spreadsheet into writer. You have to use the HTML import NOT the spreadsheet!!! In writer set up your page with 2 or 3 columns.

edit flag offensive delete link more


Thank you. That does work. Why can I not do this with calc?

BugCatcher gravatar imageBugCatcher ( 2013-01-16 20:33:37 +0100 )edit

Good question!! We should ask this a developer.

horst gravatar imagehorst ( 2013-01-16 23:27:06 +0100 )edit

Question Tools


Asked: 2013-01-09 17:15:09 +0100

Seen: 5,588 times

Last updated: Jul 02 '14