<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:edmund.laugasson@gmail.com" title="Edmund Laugasson <edmund.laugasson@gmail.com>"> <span class="fn">Edmund Laugasson</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;">Status</td>
<td>NEEDINFO
</td>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>1
</td>
<td>
</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#c13">Comment # 13</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:edmund.laugasson@gmail.com" title="Edmund Laugasson <edmund.laugasson@gmail.com>"> <span class="fn">Edmund Laugasson</span></a>
</span></b>
<pre>I gave prepared files with detailed explanation and this is the situation. This
is not a comfortable bug but please see these files and you see the behaviour.
Without seeing the files and knowing how to link the data, you will not
understand the bug. When opening these files, you can see what data is manually
entered and what is generated by formulas. Please see also named cells I am
using.
Under preparing I mean by entering appropriate formulas. You can just copy the
formulas in order to repeat the bug. These formulas just replace inappropriate
symbols with appropriate one in e-mail addresses.
Please check my article with Google Translate -
<a href="https://translate.google.com/translate?sl=et&tl=en&u=https%3A%2F%2Flibreoffice.ee%2Fautomaatne-varskendamine-calcis%2F">https://translate.google.com/translate?sl=et&tl=en&u=https%3A%2F%2Flibreoffice.ee%2Fautomaatne-varskendamine-calcis%2F</a>
- there is longer explanation with exact steps.
When repeating the issue, just copy my prepared data about characters and
formulas as plain text to not copy possible buggy formatting. Repeat the
autorefresh part only.</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>