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
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.
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
(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.
(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?
(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 :) ]
(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