Bug 138686 - I cannot remove/disconnect automatic update from external source
Summary: I cannot remove/disconnect automatic update from external source
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.3.1 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-12-06 00:23 UTC by Ron
Modified: 2022-12-22 08:22 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
File to test with in .xlsx (160.30 KB, application/zip)
2020-12-17 21:15 UTC, Ron
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Ron 2020-12-06 00:23:36 UTC
Description:
Somehow the spreadsheet is wanting to retrieve automatic date from external source.
I then select the option to DISCONNECT (i.e. it should forget the external source updating).
When saving it all seems ok but next time I open it again shows the pop-up that updating from external source is not enabled. I want that message to disappear as there is no external source it should connect to. Why doesn't it forget the external source connection when I tell it to ?

Steps to Reproduce:
1.forget the external source to update from
2.save
3.re-open spreadsheet
4. it hasn't kept the setting and again tries to update from external source

Actual Results:
Whatever I do, it doesn't remember the fact that I want it to totally forget the external source to update from. It keeps nagging about it even when I press the button to disconnect or forget the external source before saving the spreadsheet

Expected Results:
Read and remember the FORGET settings for external source update


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.0.3.1 (x64)
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); GI: nl-NL
Calc: threaded

Windows 7 Professional (X64 NL)
Comment 1 Julien Nabet 2020-12-06 08:38:15 UTC
Would it be possible you attach an example file (or perhaps a zip with 2 files: the ods file + external data file)?
Comment 2 Ron 2020-12-17 21:15:45 UTC
Created attachment 168268 [details]
File to test with in .xlsx

The file originally was saved .odf but was saved as .xlsx as recipient is using Office 365 unfortunately. I imported the original data from another file and then saved as. Since then the link to external source remains in even when I tell it to break the link and forget the external source.
Comment 3 Ron 2020-12-17 21:19:26 UTC
In addition to my last update: the external file is not residing on my PC, it is not accessible therefor I can't attach the external source file
Comment 4 Julien Nabet 2020-12-20 08:59:33 UTC
I don't see any "DISCONNECT" option but on pc Debian x86-64 with master sources updated today, if I try this:
- menu Edit/Links
- select link
- click "Break Link" button and confirm

if I open Edit/Links again
the link is not there.

- save the file in xlsx + ods file (just to compare).
- close files

if I open the xlsx or ods file, LO proposes to update external links and Edit/Links shows again the link.

Code pointer: cui/source/dialogs/linkdlg.cxx BreakLinkClickHdl
we go in the if block:
    if( pLinkMgr && pLinkMgr->GetPersist() )
        pLinkMgr->GetPersist()->SetModified();
Comment 5 Ron 2020-12-21 21:04:11 UTC
The Break link behaviour Julian describes is exactly the issue I'm running into. It should break the link and forget about the external link permanently, not reminding me again about updating from external source the next time I open the file.
Comment 6 QA Administrators 2022-12-22 03:36:15 UTC Comment hidden (obsolete)
Comment 7 Ron 2022-12-22 08:22:22 UTC
Bug is no longer present in latest version.

Version: 7.4.3.2 (x64) / LibreOffice Community
Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: nl-NL
Calc: threaded