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.