<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Not possible to create a dynamic Named Range with a calculated reference (like with OFFSET) and use it as a Print Range, like Excel can."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122318">122318</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Not possible to create a dynamic Named Range with a calculated reference (like with OFFSET) and use it as a Print Range, like Excel can.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>enmailadresse@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
In Excel I can assign the code
OFFSET($Sheet2.$A$1;0;0;(COUNT($Sheet2.$D:$D)+1);4) as a Named Range to define
a dynamic print area, and then assign the Named Range under Print Range.
If I try to do the same in LibreOffice Calc it doesn't work; I can't see the
Named Range when I choose Choose Format - Print Ranges - Edit.
When I define a named range and select the checkbox "Print range" under "Range
option", I'm offered this named range when editing print ranges. However, a
named range based on a calculated reference (like with OFFSET) is not offered
as a print range.
You can see a video on how they do it in Excel here:
<a href="https://www.youtube.com/watch?v=8Jnt6_ef2vE">https://www.youtube.com/watch?v=8Jnt6_ef2vE</a>
My problem is that I administer some CALC sheets that may vary between 2000 to
40000 rows, and that some other coworkers uses this sheets to print reports. If
I have to print all 40000 rows it will print over 400 pages, and that's not
necessary if I have only 2000 rows. I would therefore appreciate if you could
do this service available in LibreOffice Calc.
Steps to Reproduce:
1. Assign the code OFFSET($Sheet2.$A$1;0;0;(COUNT($Sheet2.$D:$D)+1);4) as an
Named Range
2. Use this Named Range as a Print Range
Actual Results:
A dynamic print range
Expected Results:
Not able to use a calculation as a named range along with print rang
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
make it possible to make a dynamic print range as stated in my description.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>