Description: If calc was able to update linked data from another opened documents, it does so, but still asks user if he wants to update data. Steps to Reproduce: 1. Open main.ods 2. Note value "1" in A1 cell and dialog asking to update external links. 3. Close main.ods 4. Open include.ods (note value "42" in A1 cell) 5. Open main.ods without closing include.ods 6. Note updated value "42" and dialog asking to update external links. Actual Results: LO shows updated values in table and at the same asks to update. Expected Results: If all external data were updated no dialog should appear. -or- Data should not be updated if user did not allowed it yet. Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36
Created attachment 139128 [details] main.ods
Created attachment 139129 [details] include.ods
In tools/options/LibreOffice Calc/general there is a item "Update links on opening" with three choices Always; default is On request and Never. (Steps 4=>6) When uncheck the "On request" and check "Never" the problem goes away when the opening document is updated on his own. But with "Never" checked i think this is not always a good solution, because when the main document is first opened and then the include document there is no update. So how to update these document when the request is not showing?
Updating external reference values even if already loaded without asking is already wrong. Rather than silently doing that and suppressing the confirmation, the update should be delayed until after confirmation.
Vasily Melenchuk committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=8b98991a66197a71953dbb900dc3aece6b4f9e3a tdf#115044: do not load external documents if it is not allowed It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Vasily Melenchuk committed a patch related to this issue. It has been pushed to "libreoffice-6-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=cef36cbbeafa9d7899bfb9c2404dec253cc86ee2&h=libreoffice-6-0 tdf#115044: do not load external documents if it is not allowed It will be available in 6.0.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Vasily Melenchuk committed a patch related to this issue. It has been pushed to "libreoffice-5-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=0e7c8c3a1be5c266f8ba7ad42fd9ce80beae5264&h=libreoffice-5-4 tdf#115044: do not load external documents if it is not allowed It will be available in 5.4.5. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.