I have a calc sheet with liks to external data wghich is an html file on disk. In tools->options->LibreOffice Calc->General I set "Updating" to "Always" and closed Calc.
When i re-open calc it stil prompts me "his file contains links to other files. Should they be updated?"
Steps to Reproduce:
1. create a spradhseet with a lihnk to an external HTML file containing a table
2. In Tools Options Calc General set "Updating" to "Always"
3. Save and close Calc
4. restart calc using this command line example (Stocks.ods is my sheet):
/opt/libreoffice5.3/program/soffice.bin --calc --accept="socket,host=localhost,port=2002;urp" Stocks.ods
5. You will get the prompt
Calc always prompts to update external links on startup
If I set the Updating Option to "Always" it should not prompt me on startup, it should just proceed as if i said "Yes" to the prompt.
User Profile Reset: No - this is a fresh install
[Information automatically included from LibreOffice]
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
[Information provided by me :-)]
Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2
CPU Threads: 12; OS Version: Linux 4.7; UI Render: default; VCL: x11; Layout Engine: new;
Locale: en-US (en_US.UTF-8); Calc: CL
Fresh install of LibreOffice from downloaded rpm's
Builds ID: LibreOffice 22.214.171.124
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0
On pc Debian x86-64 with master sources updated yesterday, I could reproduce this.
UX-Team: for Calc and Writer, the function isTrustedLocationUriForUpdatingLinks is called in this case.
Here is its definition:
OUString const & uri) const
return GetMacroSecurityLevel() == 0 || uri.isEmpty()
I think clicking on "Always" for updating should warn about this.
Just CC'ing the design ML.
(In reply to Eric from comment #0)
> Actual Results:
> Calc always prompts to update external links on startup
> Expected Results:
> If I set the Updating Option to "Always" it should not prompt me on startup,
> it should just proceed as if i said "Yes" to the prompt.
I just found out that the Help reads:
"This setting is treated as On request unless either the global macro security level is set to Low in Tools - Options... - LibreOffice - Security - Macro Security... - Security Level - Low (not recommended) or the document is located in a trusted place defined by Tools - Options... - LibreOffice daily20170720 - Security - Macro Security... - Trusted Sources - Trusted File Locations. "
So assuming it's not from a trusted location nor the 'security' is set to Low (none), then it works es designed
*** This bug has been marked as a duplicate of bug 92837 ***
You are right (I tried what you posted), however...
If you go to 'Tools->Options->LibreOffice Calc->General' and click the Help button that info isn't mentioned at all.
Here is what shows up :
Update links when loading
Always updates links while loading a document.
Updates links only on request while loading a document.
Links are never updated while loading a document.
I would expect that the info you found would or should be explained there.
CC'ing Olivier for the help question.
(In reply to Eric from comment #5)
> I would expect that the info you found would or should be explained there.
is has been pushed 2017-05-05 - so only in Master and 5.4.0beta, I gues ;)