[Libreoffice-bugs] [Bug 137541] New: External links in Calc via INDIRECT() always require an update

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 137541
           Summary: External links in Calc via INDIRECT() always require
                    an update
           Product: LibreOffice
           Version: 7.0.2.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Chart
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: torgeriedel at gmx.de

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

-- 
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/20201016/b8ff8d93/attachment.htm>