Ask Your Question
0

How to get 2 "sets" of columns per page in Calc

asked 2015-05-11 14:18:28 +0100

MtView gravatar image

I have a price file that has 3 columns ( part#, disc, price) and 25,000 rows. I need to print this out, but would like to be able to print 2 "sets" of 3 columns per page to cut down on the amount of pages. Additionally, it all is catagorized numerically, and needs to be the same as a phone book where you go down one column, then the next column, then you move to the next page. I should also say I will be printing both sides of the page in case it makes any difference.

edit retag flag offensive close merge delete

Comments

I tried that and it ends up flipping the page to landscape, and printing all the info in smaller font...and leaving lots of wasted space. Is there a way to do that and still keep the page oriented as portrait?

MtView gravatar imageMtView ( 2015-05-11 19:20:19 +0100 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2015-05-13 19:43:03 +0100

horst gravatar image

updated 2015-05-13 19:46:49 +0100

I think it is not possible in CALC. You have to export/import you sheet into WRITER and format the page with 2 colums (newspaper). There was an old question that I don't find right now.

Here is the link to my ols answer. It works.

edit flag offensive delete link more
0

answered 2015-05-11 15:50:24 +0100

m.a.riosv gravatar image

Menu/File/Print - Page layout - pages per sheet, is what you want?.

edit flag offensive delete link more

Comments

I tried that and it ends up flipping the page to landscape, and printing all the info in smaller font...and leaving lots of wasted space. Is there a way to do that and still keep the page oriented as portrait?

MtView gravatar imageMtView ( 2015-05-11 19:20:38 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-05-11 14:18:28 +0100

Seen: 82 times

Last updated: May 13 '15