[Libreoffice-bugs] [Bug 137541] 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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Hardware|x86-64 (AMD64)              |All
                 OS|Linux (All)                 |All
          Component|Chart                       |Calc
            Version|7.0.2.2 release             |6.2.6.2 release

--- Comment #5 from Eike Rathke <erack at redhat.com> ---
With
> 1. Set option "Update external links on request" in Calc
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).

-- 
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/20201026/120eb00f/attachment.htm>