<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - link to external data does not work when named range of cells containing linked formulas"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=120744">bug 120744</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>erack@redhat.com
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - link to external data does not work when named range of cells containing linked formulas"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=120744#c17">Comment # 17</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - link to external data does not work when named range of cells containing linked formulas"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=120744">bug 120744</a>
from <span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>(In reply to Edmund Laugasson from <a href="show_bug.cgi?id=120744#c0">comment #0</a>)
<span class="quote">> Actual Results:
> Formulas are overwritten with absolute path and therefore named cell range
> with linked data does not work anymore - formulas will be broken.</span >
That observation is not correct. The formula *displays* the absolute path (as
always for external URIs). Whether subsequently loading a file will take an
absolute or a relative URI depends on the settings when saving the file, Tools
-> Options -> Load/Save -> General, Save URLs relative to file system.
I don't understand even why you are trying to link an "external" file that is
not an external file but the very same document and have each link reload every
second. Doing so might ask for trouble, yes, though in general it should be
handled generously. For referencing data in the same document on a different
sheet simply use 3D references such as $Sheet1.A1 or named ranges, either
global or sheet scope level.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>