[Libreoffice-bugs] [Bug 122318] New: 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.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=122318

            Bug ID: 122318
           Summary: 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.
           Product: LibreOffice
           Version: 6.1.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: enmailadresse at gmail.com

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181225/e834dfb7/attachment.html>