[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

--- Comment #6 from Torge Riedel <torgeriedel at gmx.de> ---
Thanks for your answers.

Let me explain my scenario a bit more:

I have several Calc files each of them contains data for a specific year (2020,
2019, 2018, ...). They are all linked, cause sometimes data needs to be
adjusted in - let's say 2018 - so Calc files for 2019 and 2020 needs to
updated. In this case I opened the files 2019 & 2020, clicked on "Refresh /
Update" and the whole file is updated with the new data from the links.
Afterwards I saved them.

If there were no changes in older files I was able to open the file for 2020
without the need to click on "Refresh / Update" and work with that data.

This was possible as long as I used a 6.2.x version and it could be that it was
not the latest patch version, but the one before the changes were implemented.

Now, when I open the file for 2020 it is flooded with "540" errors and I always
have to "Refresh / Update", otherwise it is impossible to work with the file.
And the refresh takes a while. There are 10 files involved.

Several years ago I used the function DDE(), but switched to INDIRECT() cause
it is (was) more flexible. Now it is unusable for me.

@Eike:
You mentioned "..., contrary to direct external references, ...": Is there
another way to link data from the files including caching?

The challenge is: I have lots of external references in the file and when a new
year starts I save 2020 file as 2021 and with INDIRECT() I only need to change
the value of one cell in the table to switch links from 2019 to 2020. I fear
this is not possible without INDIRECT().

-- 
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/20201115/ad353c19/attachment.htm>