Issue 126759 - Update link when loaded
Summary: Update link when loaded
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: 4.1.2
Hardware: All All
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-12-29 08:41 UTC by haupas
Modified: 2017-09-27 15:18 UTC (History)
6 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Step 1, OpenOffice, Calc, Options, General (72.94 KB, application/pdf)
2015-12-30 18:06 UTC, don1225
no flags Details
Step 2, OS X, Multiple files selected to open in OpenOffice Calc (679.73 KB, application/pdf)
2015-12-30 18:06 UTC, don1225
no flags Details
Step 3, OpenOffice, Calc, Gray Window, Never changes (139.02 KB, application/pdf)
2015-12-30 18:07 UTC, don1225
no flags Details
Step 4, OpenOffice, Calc, Select window from list (195.25 KB, application/pdf)
2015-12-30 18:08 UTC, don1225
no flags Details
Step 5, OpenOffice, Calc, After selecting window from list (877.88 KB, application/pdf)
2015-12-30 18:08 UTC, don1225
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description haupas 2015-12-29 08:41:48 UTC
If you use the function to link in a spreesheet  to another sheet, OpenOffice asks while the opening of the doucument 'if you want to actualise the document'. Normally you can change this setting in 'Extras'-'Settings'-'OpenOffice Calc' in the upper right corner.

But when you change this setting the document seems to ignoring it and aks me again.

I could reproduce this on two of my computer, one is running Win 8.1 Pro an the other one Win 10 Pro. All of the two have the latest (2.1.2) version installed.

I attached two screenshots (but they're in german -sorry)
Comment 1 oooforum (fr) 2015-12-29 13:49:11 UTC
(In reply to haupas from comment #0)
>All of the two have the latest (2.1.2) version
> installed.
2.1.2 ??? You means 4.1.2.

> I attached two screenshots (but they're in german -sorry)
No attached file to this issue.
Thanks to retry.
Comment 2 orcmid 2015-12-29 16:57:35 UTC
(In reply to haupas from comment #0)
> If you use the function to link in a spreesheet  to another sheet,
> OpenOffice asks while the opening of the doucument 'if you want to actualise
> the document'. Normally you can change this setting in
> 'Extras'-'Settings'-'OpenOffice Calc' in the upper right corner.
> 
> But when you change this setting the document seems to ignoring it and aks
> me again.

This appears to be a side-effect of changes made to mitigate a security vulnerability, <http://www.openoffice.org/security/cves/CVE-2015-4551.html>.  The immediate remedy was to always require user confirmation of access to external material.

Adjustments may be needed to have this work more smoothly without lowering the barrier to such exploits.  More analysis is required.
Comment 3 don1225 2015-12-30 18:05:25 UTC
I have the same problem.  I select and open multiple files in the OS file manager.  The first file opens to a gray window and never changes until I reselect it from a file list.  Then the contents appear and asks if I want update the links.  The Calc Options' General tab has "Always Update Links" selected.  Version 4.1.1 never asked the question.  With 4.1.2 I need to open 1 file at a time and answer the question.

The 5 attached PDFs show the 5 steps for reproducing the problem.

For now, I'm going back to version 4.1.1.
Comment 4 don1225 2015-12-30 18:06:24 UTC
Created attachment 85229 [details]
Step 1, OpenOffice, Calc, Options, General
Comment 5 don1225 2015-12-30 18:06:59 UTC
Created attachment 85230 [details]
Step 2, OS X, Multiple files selected to open in OpenOffice Calc
Comment 6 don1225 2015-12-30 18:07:29 UTC
Created attachment 85231 [details]
Step 3, OpenOffice, Calc, Gray Window, Never changes
Comment 7 don1225 2015-12-30 18:08:00 UTC
Created attachment 85232 [details]
Step 4, OpenOffice, Calc, Select window from list
Comment 8 don1225 2015-12-30 18:08:29 UTC
Created attachment 85233 [details]
Step 5, OpenOffice, Calc, After selecting window from list
Comment 9 orcmid 2015-12-30 21:11:15 UTC
(In reply to don1225 from comment #8)
> Created attachment 85233 [details]
> Step 5, OpenOffice, Calc, After selecting window from list

Thanks for all the work but we already confirmed the situation.  It is a consequence of the security vulnerability (not fixed in 4.1.1) that was remedied in 4.1.2.

We will look into how to smooth things up without re-opening the attack surface.

Note that one solution would be to simply remove the disabled option altogether.  We will strive to avoid that.