https://bugs.documentfoundation.org/show_bug.cgi?id=137541
Eike Rathke <[email protected]> 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 <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
