Bug 94630 - print two sheets on the same page in portrait, one above the other
Summary: print two sheets on the same page in portrait, one above the other
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.3.2 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Print-Dialog
  Show dependency tree / graph
 
Reported: 2015-09-30 03:44 UTC by Raphaël Droz
Modified: 2023-12-07 15:47 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
use-case (77.99 KB, image/jpeg)
2019-12-03 15:54 UTC, Raphaël Droz 		Details
symptom (107.18 KB, image/jpeg)
2019-12-03 15:55 UTC, Raphaël Droz 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Raphaël Droz 2015-09-30 03:44:34 UTC 
Using LibreOffice Calc 4.3.3
I have two sheets, both can easily fit in the 210mm of an A4 (few columns)
and both can easily fit in the 297/2 = 140mm of the half-height of an A4 (few lines).

I want to print both of them on a single page, one above this other, in portrait mode.

I can't.

If I do
Print > Page Layout > Pages per Sheet set to 2
The preview show a portrait page, whose smallest dimension (width) is divided in two with one sheet on each side. The [1 2] number confirms that. Using "top to bottom" does not change anything (I would expect it the change the layout to consider the verticality as the direction)

If I do:
Print > Page Layout > Pages per Sheet set to "Custom"
Pages = 2 by 1, neither "Orientation" nor "Order" give me a chance to get the request result (they do not affect the layout in Portrait)

If I do:
Print > Page Layout > Pages per Sheet set to "Custom"
Pages = 2 by 1, then "Order" = "Top to Bottom", I can see the first sheet
over the second one. But this leave a big blank space on the right side of the page (which is expected to contain 2 other sheets). This is not an acceptable workaround since sheet are needlessly ridiculously small.

Is the layout even supported? How? Where is it documented?
Comment 1 Buovjaga 2015-10-02 09:15:42 UTC 
It seems you are right.

Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+
Build ID: 25de5cfa43b2b1cb7d7214470acc7719839e13fe
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2015-10-01_08:49:54
Locale: en-US (fi_FI)
Comment 2 QA Administrators 2016-11-08 10:35:16 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2019-12-03 14:48:04 UTC Comment hidden (obsolete)
Comment 4 Raphaël Droz 2019-12-03 15:54:03 UTC 
Created attachment 156271 [details]
use-case

Use-case attached.
Comment 5 Raphaël Droz 2019-12-03 15:55:34 UTC 
Created attachment 156272 [details]
symptom

And the symptom.
Bug still exists as of Libreoffice 6.3.3.2 (ubuntu 19.10)
Comment 6 QA Administrators 2021-12-03 04:40:34 UTC Comment hidden (obsolete)
Comment 7 Raphaël Droz 2021-12-06 04:53:47 UTC 
Still exists
Comment 8 QA Administrators 2023-12-07 03:18:06 UTC Comment hidden (obsolete)
Comment 9 Raphaël Droz 2023-12-07 15:47:32 UTC 
Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 4; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: en-US
Ubuntu package version: 7.3.7
Calc: threaded