[Dropped] Print 2 pages per sheet in LibreOffice

[whaler]

My spreadsheet is 3 columns wide, and I'd like to print 2 pages per sheet in portrait mode. When I do this from the printing dialog, it shrinks the pages and I get a *lot* of whitespace between them.

Here is the only (old) thread I found, and it basically says it's not possible to do what I want:
viewtopic.php?t=71024&hilit=print%2A+pages+per+sheet

Is that true? Can I get it into LibreWriter somehow and have more control?
Thanks....

[Zizi64]

My spreadsheet is 3 columns wide, and I'd like to print 2 pages per sheet in portrait mode. When I do this from the printing dialog, it shrinks the pages and I get a *lot* of whitespace between them.

Please upload an ODF type sample file here.


Otherwise, there is not such "Columns" feature in the LO Calc, what exist in the LO Writer. And there is not "Booklet printing" feature in the LO Calc, what exists in the LO Writer.

You can create a Custom sheet for the printing. You can reference the cells from the original sheet to the "Print sheet" as you want it. (Use forced page Breaks in the Sheets with with preformatted cells, then the rows will not slide to the next printed page.) Yes, this is a workaround only, and you must create it manually.