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: https://www.youtube.com/watch?v=8Jnt6_ef2vE

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.