<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 - Defined name pointing to external worksheet does not work/cannot be created"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144643">144643</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Defined name pointing to external worksheet does not work/cannot be created
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>Inherited From OOo
</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>enhancement
</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>libreoffice@nisz.hu
</td>
</tr>
<tr>
<th>CC</th>
<td>nemeth@numbertext.org, varga.balazs3@nisz.hu
</td>
</tr>
<tr>
<th>Blocks</th>
<td>108917
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=175172" name="attach_175172" title="Starting file where we set define name">attachment 175172</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=175172&action=edit" title="Starting file where we set define name">[details]</a></span>
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</pre>
</div>
</p>
<div id="referenced">
<hr style="border: 1px dashed #969696">
<b>Referenced Bugs:</b>
<ul>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] Cell references bugs and enhancements"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108917">Bug 108917</a>] [META] Cell references bugs and enhancements
</li>
</ul>
</div>
<br>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>