<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 - External links in Calc via INDIRECT() always require an update"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=137541">137541</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>External links in Calc via INDIRECT() always require an update
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.0.2.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Chart
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>torgeriedel@gmx.de
</td>
</tr></table>
<p>
<div>
<pre>Description:
Description:
As a regression to 6.2.x stable releases cells with function INDIRECT() and
manual activation of external content is set in the options an "Error:540" is
shown in the cell, instead of the last correct fetched value.
Steps to Reproduce:
1. Set option "Update external links on request" in Calc
2. Add the location "/tmp" as trusted location
3. Extract the attached archive to /tmp
4. Open file Test_02.ods in Calc
5. It shows you the "Error:450" in cells B3 and B4
6. The update of the external links is request by calc
7. Manual update the external links, now "Test" is shown in B3 and B4
8. Close and save the file
9. Reopen the file Test_02.ods, it says "Error:450" again
Actual Results:
Even after saving a calc file after updating the external links and correct
values are displayed, there is an "Error:540" when reoping the file.
Expected Results:
The spreadsheet document must remember the last value of a successful update of
an external link. This worked in 6.2.x
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
Version: 7.0.2.2
Build ID: 00(Build:2)
CPU threads: 6; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Ubuntu package version: 1:7.0.2_rc2-0ubuntu0.20.04.2
Calc: threaded</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>