<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 - FILEOPEN: Multiple external link chain with several calc documents doesn't work properly any more"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126928">126928</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILEOPEN: Multiple external link chain with several calc documents doesn't work properly any more
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.0.4 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>Calc
</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:
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 code 540
is shown in the cell, instead of the last correct fetched value.
In addition if you have a chain of such links with at least 3 documents
involved the cell keeps showing the error code, although external content was
activated.
Steps to Reproduce:
Scenario 1:
1. Make sure that in the calc options you have "Update of external links" set
to "On request" (I have calc in german, hopefully it is correct translated)
2. Open attached Test_02.ods
3. Click in the bar on "Activate content"
Scenario 2:
1. Make sure that in the calc options you have "Update of external links" set
to "On request" (I have calc in german, hopefully it is correct translated)
2. Open attached Test_03.ods
3. Click in the bar on "Activate content"
Actual Results:
Scenario 1:
1. In current 6.3.0.4 release it shows in cell B2 "ErrorCode:540"
2. Only after manual activation of content the correct value is shown
Scenario 2:
1. In current 6.3.0.4 release it shows in cell B2 "ErrorCode:540"
2. Event if you activate the content it is still show the error code
Expected Results:
Both scenarios are regressions from previous stable version 6.2.x
- In 6.2.x in both scenarios after opening the document no error code is shown,
but instead the last value from the external link is shown. Even without the
need to activate the content.
- In 6.2.x in the second scenario after opening the document and activating the
content, the current value from the linked document is shown
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Version: 6.3.0.4
Build-ID: 1:6.3.0-0ubuntu0.18.04.1~lo2
CPU-Threads: 6; BS: Linux 4.15; UI-Render: Standard; VCL: gtk3;
Gebietsschema: de-DE (de_DE.UTF-8); UI-Sprache: de-DE
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>