This error message STILL pops up in Calc 7.2.3.2.
Even after going to Tools–Options–LibreOffice–Security–Trusted Sources–Trusted File Locations and Adding the directory there.
Even after going to Edit–Links…all the links show the correct source file.
SO, what is causing the error message each and every time I open LibreOffice Calc?
Thanks!
Please inform us about your installation (Help / About LibreOffice, press Version Information).
Ver: 7.2.3.2
Envir: CPU Threads: 12; OS: Linux 5.13
User Infc: UI render: default; VCL: gtk3
Locale: En-US (en_US.UTF-8); UI: en-US
Misc: Ubuntu package version: 1:7.2.3-0ubuntu0.21.10.1
Calc: threaded
I’m getting the same. The link for a spreadsheet is in a trusted directory, and Tools|Options|Calc|General|Update links… is set to Always from trusted locations.
Version: 7.2.6.2 (x64) / LibreOffice Community
Build ID: b0ec3a565991f7569a5a7f5d24fed7f52653d754
CPU threads: 12; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded
As @Jim_HiTek says, it’s annoying rather than a show-stopper, but it would be good to know if anyone’s solved it.
Checked: version 7.3.3.2 Win 10 does not have this problem.
Just in case, let’s check the clock readings: if the formula in the cell of document A contains a reference to the cell of document B, then the warning will not be issued (with appropriate options) if document A is in the trusted file location.
Ah - I get it. It’s the folder for the document in which the link occurs. I’d thought it was the folder for the document to which the link points. I should have looked further down and found this out from @erAck 's comment.
This whole thing strikes me as illogical - why protect a document from updating links based on a ‘macro trusted source’? Macros and links have nothing to do with each other. It would make more sense to make this a property of a document rather than a global setting. Or am I missing something?
It is a trusted source directory. We could create yet another Options option with a different name and pull the same dialog in, or come up with some creative wording to not have the Macro Security options only say Macro Security (probably best). And no, making that a document property defeats the purpose, which is to allow only trusted documents to access resources on your system. You do not want arbitrary documents (even downloaded) from arbitrary locations to read your files and send content somewhere. It’s also not only about links but also spreadsheet functions that can read content or even transfer information to another party.
Thanks @erAck for the explanation. I wasn’t thinking straight.
I think that the wording in the ‘Options|Security’ tab should be made more explicit to list all types of folder that it applies to. We’ve already identified links - are there others that I’m unaware of?
Any reference to external documents and INDIRECT() and HYPERLINK() and WEBSERVICE() and DDE() are examples.
Hmmm @erAck . I’m trying to think of a word or phrase which encapsulates this sort of action and am failing. It can’t be too long or there wouldn’t be room in the menu. If what’s left of my brain comes up with an idea I’ll come back.
[Later] I think that two actions are needed here.
The first is to add a new topic to the Tools|Options|Security page called ‘Trusted Sources’ with text something like ‘Specify trusted sources for macros and links to external documents’, and move the ‘Trusted sources’ page to this topic.
The second is to update the help page to reflect this, and add text to clarify the use of trusted sources. Can LO document types other than Calc have links - I’m not a power user?
As the message says… automatic update has been disabled. So either click Allow, or enable the update under Tools → Options → Calc → General, Update links when opening: Always (from trusted locations).
What version are you using? Because mine is ALREADY SET at ‘Always’.
Works in any version I tried, including 7.2.0 and 7.2.4.
Note that the document you open must be in the trusted directory to be able to update links from that document.
Check my first post about that.
Check what? You only said “Adding the directory there”. The directory containing what files? The file you open, or the files that are linked to?
Tools-Options-LibreOffice-Security-Macro Security-Trusted Sources-Trusted File Locations
is the actual thread. Sorry I left out Macro Security in my first post. Anywho, on that trusted sources tab page, it has a ‘Trusted Certificates’ box which is empty. Below that is ‘Trusted File Locations’ box in which there is this one thing: “/home/jim_hitek/Documents/My Spreadsheets/Spreadsheets 21”
That is the correct path for all my spredsheet files. There may have been security on that folder at one time, but I removed it years ago. Linux allows that. I just checked the security on the files in that folder and the folder itself and it is ‘unsecure’, any program can read or write to them.
Should I enter each ‘File’ too? I’ll go try that. What is there now is a default added by LibreOffice. I never entered it myself that I recall. NOPE, won’t let me enter a file, everything in that folder is grayed out so it only allows folder names, not file names.
LibreOffice does not add a default trusted directory, the list is initially empty. (unless the administrative shared installation environment setting tells something different for new user profiles, which could be possible but I doubt is your case).
Anyway, you could try to move the current local user profile temporarily out of the way and try with fresh settings, see the wiki page, whether that helps your case.
Yeah, I sorta knew that as how would it know what to enter there unless I’d told it? I thought it might happen when I was at the SS and opened another SS with the data I wanted to import side by side. So on the main SS, I click on an empty cell, put ‘=’ inside, than mouse over to the target SS and click on the cell I want to import the data from.
I was thinking that maybe that action created the file directory that I find in ‘Trusted File Locations’ because I don’t recall physically entering that directory tree. I’ve been doing this for over a decade but it’s only been the last few years that this error message has been popping up.
It’s just annoying, doesn’t seem to affect anything, and all I do is click on it, and the data is filled or updated in the proper cells correctly. I would prefer if it did it automatically, but I can live with a simple click to cause it.
Sorry readers, I did find a solution for this months ago but forgot to come back and let everyone know.
I’m not at that computer and I don’t recall what the fix was only that it was simple. I’ll try to find it and come back with a report later today.