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

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.

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

Take a look to this threads maybe can help: