[Libreoffice-bugs] [Bug 126928] New: FILEOPEN: Multiple external link chain with several calc documents doesn't work properly any more

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=126928

            Bug ID: 126928
           Summary: FILEOPEN: Multiple external link chain with several
                    calc documents doesn't work properly any more
           Product: LibreOffice
           Version: 6.3.0.4 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: torgeriedel at gmx.de

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190814/a3e401bc/attachment.html>