Bug 160610 - Print multiple non-contiguous print ranges on a single page in LibreOffice Calc
Summary: Print multiple non-contiguous print ranges on a single page in LibreOffice Calc
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-04-10 09:10 UTC by Orwel
Modified: 2024-05-10 13:56 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
test file (11.98 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-05-09 11:19 UTC, Orwel
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Orwel 2024-04-10 09:10:24 UTC
Description:
It would be helpful if LO could print in sCalc more non-contiguous selected ranges on a single page, as I think now it is not possible - you can only print each selected ranges on separate pages, or you can print them as 2 pages on 1 sheet, but which prints the cells in a half dimension (as page is .

Steps to Reproduce:
1. Select 2 ranges, e.g. A1:F23 + B82:G95 with some data inside them
2. Define Print ranges
3. Print

Actual Results:
A1:F23 = Print page 1
B82:G95 = Print page 2

Expected Results:
Would be great if the dimension of the paper allows it, a possibility to print both ranges on one sheet would exist.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 24.2.2.2 (X86_64) / LibreOffice Community
Build ID: d56cc158d8a96260b836f100ef4b4ef25d6f1a01
Comment 1 m_a_riosv 2024-04-10 13:14:53 UTC
Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon.
Comment 2 Stéphane Guillou (stragu) 2024-04-26 02:22:18 UTC
UX/Design team, what do you think?
Something like "suppress space between print ranges"? Sounds prone to complications.
I also tested printing only "selected cells" to no avail: it prints whatever is in between the ranges too.
As a cumbersome workaround:
1. Hide columns/rows
2. Define a single print range
3. Print
Comment 3 Heiko Tietze 2024-04-26 06:51:46 UTC
(In reply to Orwel from comment #0)
> Would be great if the dimension of the paper allows it, a possibility to
> print both ranges on one sheet would exist.
Please elaborate a bit so we can see if this might be handy for the majority.
Comment 4 Cor Nouws 2024-05-08 18:40:26 UTC
(In reply to Orwel from comment #0)
> Expected Results:
> Would be great if the dimension of the paper allows it, a possibility to
> print both ranges on one sheet would exist.
Hi Orwel,
For some cases it could be useful, especially when e.g. the width of the ranges are similar. In other cases it will produce nasty/ugly results.
So if added as option, one to handle with care.

Did you consider hiding rows/columns in a range, so that only visible stuff is printed? That would (in some cases) remove the need to have multiple print ranges?
Comment 5 Cor Nouws 2024-05-08 18:52:40 UTC
(In reply to Cor Nouws from comment #4)

> Did you consider hiding rows/columns in a range, so that only visible stuff
> is printed? That would (in some cases) remove the need to have multiple
> print ranges?
[Heiko kindly reminds that Stéphane also mentioned hiding stuff :) ]
Comment 6 Eyal Rozenberg 2024-05-08 22:07:25 UTC
(In reply to Stéphane Guillou (stragu) from comment #2)
> As a cumbersome workaround:
> 1. Hide columns/rows
> 2. Define a single print range
> 3. Print

Is that really so cumbersome?

Also, other alternatives:

* Copy the two ranges to a new sheet

or

* link to the ranges from a new sheet (i.e. use =OldSheet!B11 , or wherever the range starts, then drag to copy with the rows and columns to get the full range; and elsewhere on the same page repeat the same for the second range
Comment 7 Heiko Tietze 2024-05-09 06:19:33 UTC
We discussed the topic in the design meeting and suggest to resolve as NAB/WF given that some alternative workflows exist.
Comment 8 Orwel 2024-05-09 11:19:25 UTC
Hi everybody, thank you for dealing with this issue.
See attached ods file.
Steps to reproduce:
1. Open the file.
2. Mark/Select B9:C10 + D56:E57 + G1:H2 + H14:I15
3. Define print range
4. Try to print.
Result: 8 small cells are printed on 4 sheets.
Workaround with hiding columns/rows is possible, but sometimes requires a lot of effort with hiding/unhiding correct rows/columns - see my file: you have to hide columns: A, F, J-Z + rows 3-13, 16-55, 58-104 and define print range... if there would be some other cells to be printed, e.g. L20:M21, the result would be a print range of 2 sheets.

But I could understand, if the solution is hardly implementable.
Comment 9 Orwel 2024-05-09 11:19:52 UTC
Created attachment 194050 [details]
test file
Comment 10 QA Administrators 2024-05-10 03:17:18 UTC Comment hidden (obsolete)
Comment 11 Cor Nouws 2024-05-10 13:56:59 UTC
(In reply to Orwel from comment #8)
> Result: 8 small cells are printed on 4 sheets.
thanks for the example file.
> But I could understand, if the solution is hardly implementable.
Not sure, but more important is that a clear use case is missing. The example, to me in any case, doesn't show a realistic one.
So let's follow the decision from comment 7.