This behavior is a result of a security-vulnerability mitigation that was introduced in Apache OpenOffice 4.1.2. See <http://www.openoffice.org/security/cves/CVE-2015-4551.html>.
The remedy that was used is not very nuanced. I believe that the Tools > Options > OpenOffice Calc > General > Updating options are ignored and "On request" is performed instead of "Always." You can verify that. See Bugzilla Issue 126641, <https://bz.apache.org/ooo/show_bug.cgi?id=126641>. If you are careful to use the workaround only when working with spreadsheets of your own creation and not obtained from others, the adjustment that Andrea Pescetti describes might work for you, even though it talks about macros. Try it. With regard to the notification about whether updating from links was successful or not, we probably would require that to be there, simply because it is the only way someone might see that unexpected link updating is happening when part of a covert action. That should be treated as a separate issue for further consideration. That is not going to happen so easily. - Dennis > -----Original Message----- > From: Johnny Rosenberg [mailto:gurus.knu...@gmail.com] > Sent: Thursday, April 14, 2016 14:56 > To: users@openoffice.apache.org > Subject: Default behaviour with links to other documents > > I have a few spreadsheet documents that contain one or more links to > other > documents. Every time I open them I get the very annoying question about > whether I want the links to be updated or not. > > Is there a way I can set a default behaviour for that? I mean the > current > behaviour seems to be ”ask the user”, and I want it do be either ”yes” > or > ”no”, just so I don't need to get annoyed by that irritating dialogue > every > time I open such a document (which I do daily). > > And if I select ”yes” or ”no” as default behaviour, I don't want to see > any > dialogue windows about it at all from there on. No ”Your links were > updated > successfully”, nor ”Your links were not updated”. > > > Kind regards > > Johnsenberg --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
