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
We discussed the topic in the design meeting and suggest to resolve as NAB/WF given that some alternative workflows exist.
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.
Created attachment 194050 [details] test file
[Automated Action] NeedInfo-To-Unconfirmed
(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.