<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 - External links in Calc via INDIRECT() always require an update"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=137541">bug 137541</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;">Hardware</td>
<td>x86-64 (AMD64)
</td>
<td>All
</td>
</tr>
<tr>
<td style="text-align:right;">OS</td>
<td>Linux (All)
</td>
<td>All
</td>
</tr>
<tr>
<td style="text-align:right;">Component</td>
<td>Chart
</td>
<td>Calc
</td>
</tr>
<tr>
<td style="text-align:right;">Version</td>
<td>7.0.2.2 release
</td>
<td>6.2.6.2 release
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - External links in Calc via INDIRECT() always require an update"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=137541#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - External links in Calc via INDIRECT() always require an update"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=137541">bug 137541</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>With
<span class="quote">> 1. Set option "Update external links on request" in Calc</span >
it behaves as set. The INDIRECT() function is a volatile function that needs to
be recalculated, so until the infobar's "Allow updating" button is activated
the result of obtaining uncached external data is Err:540.
This behaviour is a security measurement and was implemented for 6.2.6, which
may explain the contradictory "it works / does not work" in 6.2.x
Data is uncached here because the INDIRECT() function, contrary to direct
external references, does not add its results to cached data tables saved with
the document.
If unconditional loading of external resources is wanted then instead of
updating on request use the "Always (from trusted locations)" setting. The
requesting document has to reside in a trusted location, so in this case
Test_02.ods (and Test_03.ods).</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>