https://bugs.documentfoundation.org/show_bug.cgi?id=137541
--- Comment #14 from Torge Riedel <[email protected]> --- (In reply to Eike Rathke from comment #13) > As said in comment 5: > > 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). > > i.e. under Tools -> LibreOffice -> Security, Macro Security, Trusted > Sources, add a dedicated path to Trusted File Locations. > Under Tools -> LibreOffice -> Calc -> General, Update links when opening, > choose Always (from trusted locations). > Place the _calling_ (the one that contains the INDIRECT() function) document > in the trusted source path. Dears, thank you for taking a look here. As I replied in comment 6 the issue is not the trusty location (BTW: I added the file's location to the proper settings, but nothing improved for my issue). I will try to explain again: The issue is, that with 6.2.x release I was able to open such a file and there seems to be a kind of cached value used (I guess the latest value received when updating the external links the last time). So if I know that nothing was changed in the external file, I was able to work with the opened file. Now I always need to update from external links, otherwise the whole file is unusable. Scenario: 1. File 2024.ods links with INDIRECT() to a cell of file 2023.ods 2. 90% of the calcution in 2024.ods needs this value 3. Opening 2024.ods with current version show "Error: 504" in the cell of 2024.ods where the INDIRECT() function is used 4. Due to that whole calculation in 2024.ods shows errors 5. Updating external links solves the issue and - lets assume - the value 47.11 is received from 2023.ods, displayed in 2024.ods and the whole calculation is done correct 6. Make some changes to 2024.ods, save the file and close 7. Reopening the file 2024.ods, again "Error: 504" With Calc 6.2.x there difference is in step 7 where Calc was still displaying the value 47.11 in the cell where INDIRECT() is used and the calculation in the whole is still the same when saved. So my feeling is there was a kind of caching of the value or backup. Since there are a lot of Calc files involved, with several values retrieved via INDIRECT() updating takes time. Luckily with fast SSDs and CPU it is acceptable. But before the hardware it was a pain. So, please reopen, my issue is still not solved. -- You are receiving this mail because: You are the assignee for the bug.
