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
A dynamic print range
Not able to use a calculation as a named range along with print rang
User Profile Reset: No
OpenGL enabled: Yes
make it possible to make a dynamic print range as stated in my description.
I can confirm described behavior in
CPU-Threads: 4; BS: Linux 4.12; UI-Render: Standard; VCL: gtk3_kde5;
Gebietsschema: de-DE (de_DE.UTF-8); Calc: group threaded
@Eike, @Winfried, I thought you might be interested in this issue...
I can confirm the bug in Version 22.214.171.124. Moreover the dynamic named range are not displayed in Pivot Table as possible input.
I created a dynamic named range called tt. Counting of entries works well (german: anzahl2(tt)). When I try to insert a pivot table I'm offered the named range as input but then there are no fields and inspecting the source area reveals a1 and nothing else.