[Libreoffice-bugs] [Bug 144643] New: Defined name pointing to external worksheet does not work/cannot be created

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 144643
           Summary: Defined name pointing to external worksheet does not
                    work/cannot be created
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: nemeth at numbertext.org, varga.balazs3 at nisz.hu
            Blocks: 108917

Created attachment 175172
  --> https://bugs.documentfoundation.org/attachment.cgi?id=175172&action=edit
Starting file where we set define name

In the attached file there is a VLOOKUP function in B2, it can use a search
range in another file, that works.

However, if I wanted to change the same range in the other file to a defined
name in the Manage names window, it would no longer work: the Range selector
that I clicked closes when I click through to the other target file, but if I
manually type in the Range field the range that VLOOKUP used, it results a
non-functioning defined name. This is what is used in cell B3.

The request would be to get the UI to work, to allow the creation of a named
range pointing to another file.
Steps to reproduce:
1.      Open attached files in Calc
2.      Open Sheet – Named Ranges and Expressions - Define name in the
Reference-External-NamedRange.ods file
3.      Roll up the dialog with the button next to Range or formula expression
field, and try to select the A2:A13 range in the other file. The dialog
disappears.
4.      If you manually copy the file reference used in the VLOOKUP function in
the B2 cell and insert it to the Range or formula expression, and add a name
then the named range is created, but it won’t work This is demonstrated in the
B3 cell.

Actual results:
Err:510 error in cell B3
The Define name (and Manage Names) dialog does not allow the creation of named
ranges pointing to other files.

Expected results:
There should be result from the external worksheet in B3
The Define name (and Manage Names) dialog should allow the creation of named
ranges pointing to other files.

LibreOffice details:
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 47a8a65022e3fd7624c95d0341b4809aad11fddb
CPU threads: 8; OS: Windows 10.0 Build 18363; UI render: Skia/Vulkan; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: CL


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108917
[Bug 108917] [META] Cell references bugs and enhancements
-- 
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/20210921/4a7eb32b/attachment-0001.htm>