Ask Your Question

How can I print non-adjacent columns on a single page in Calc? [closed]

asked 2013-09-22 22:47:29 +0200

elektrokokke gravatar image

updated 2015-11-09 09:48:49 +0200

Alex Kemp gravatar image

In LibreOffice Calc, I have a spreadsheet with a number of columns. I want to print only a subset of those columns, which are not adjacent. I want all of those columns to be printed on the same page (provided the table fits on one page, which in my case, it does).

I have tried the following things:

  • Select the desired columns (non-adjacent columns can be selected by pressing the Ctrl-key), then select File->Print and choose "Print selected cells". The result is that all columns between the first selected column and the last selected column are printed, regardless whether they are selected or not. Thus there are columns in the printout that I don't want printed.
  • Select the desired columns and create a print range using the selection. This results in each contiguous group of columns to be printed on a page together. For each contiguous group of columns there is a new page in the printout. Thus the result has more pages than I want. In addition, strangely enough, The first print range is repeated on each printed page.
  • Resized the columns width to 0 for each column I don't want to print. This is the only thing that worked for me, but I find it very cumbersome and a very bad way to do it. It seems like a very very daft workaround.

So here's my question: is there a right way to do what I want, or is it impossible in LibreOffice Calc?

Btw.: I have tried this in LibreOffice 3.3, 3.6, and 4.0.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-09 09:49:05.422544


Have you tried hiding the columns? Right-click the column header and select hide. Assuming you are on Windows.

Mano Engel gravatar imageMano Engel ( 2013-09-22 23:18:52 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-09-23 01:58:51 +0200

m.a.riosv gravatar image

updated 2013-09-23 01:59:21 +0200

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-09-22 22:47:29 +0200

Seen: 2,971 times

Last updated: Sep 23 '13