Issue 15667 - External links aren't automatically removed
Summary: External links aren't automatically removed
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 1.1 Beta2
Hardware: Other All
: P4 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: rfe_eval_ok
: 22268 35487 55486 82226 83009 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-06-16 08:20 UTC by cdunham
Modified: 2013-08-07 15:12 UTC (History)
3 users (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description cdunham 2003-06-16 08:20:00 UTC
Make a simple ss with a reference to an external document - remove that 
reference and save, open again, you are prompted to reload external reference - 
link should automatically go away when all references do. Also, "break link" is 
confusing. Maybe "delete"? 
 
Thanks!
Comment 1 oc 2003-06-20 13:17:20 UTC
A simple deleting of the cell does not break the link, because when
you create a link to another document, a hidden sheet is inserted into
your document. For getting rid of these hidden sheet you have to break
the link (EDIT-LINKS-BREAK LINK).
Comment 2 oc 2003-06-20 13:17:54 UTC
Closed because not an issue
Comment 3 cdunham 2003-06-20 14:56:25 UTC
Hmm. That seems like implementation driving functionality. The  
behaviour is quite unexpected and non-intuitive. If creating the first link 
creates a "hidden" sheet, removing the last one should delete it. 
Comment 4 oc 2003-06-25 11:44:15 UTC
This could be considered as an enhancement
Comment 5 frank 2003-11-12 15:03:31 UTC
*** Issue 22268 has been marked as a duplicate of this issue. ***
Comment 6 bettina.haberer 2003-12-04 18:14:05 UTC
Summary: External links aren't automatically removed. Proposed is if
creating the first link creates a "hidden" sheet, removing the last
one should delete it. 

Comment 7 frank 2004-10-15 11:04:12 UTC
*** Issue 35487 has been marked as a duplicate of this issue. ***
Comment 8 mmenaz 2005-10-18 18:54:33 UTC
I would put it in a higher priority. This defect is much worse now that a lot of
people (hopefully) will migrate from Excel to OpenOffice.
I've migratd all my files, and in Calc files that were Excel files with external
links, after manually changing them to the .ods files (see my issue #55655),
I've found that I still have the links to the old .XLS files, and also the
"hidden sheets" to them!
In any case
a) this mechanism that is automatic only in one direction (creation) is very
confusing (=bad) for the user. I did never thought about such "external links"
list and "hidden sheets" until some expert pointed me to them in IRC channel.
b) I think that the hidden sheet is a bad desigh choice. I've 40 calc files that
take a single value from a big calc file, and I've that big file duplicated
(copied as hidden sheet) 40 times. I think that the referred sheet does not have
to be saved, and should be reloaded (and not saved in any case) when (if)
needed. In addition consider that you could give to someone else a file that,
and you as "average user" are not aware of, has a lot of "hidden" information
(i.e. you copy a file and modify it to point to other files... your previous
pointed data are still there, in hidden sheets...).
And the fact that Excel does it is one more reason to do it different ;)
Comment 9 frank 2005-10-25 13:47:54 UTC
*** Issue 55486 has been marked as a duplicate of this issue. ***
Comment 10 frank 2007-10-15 14:19:16 UTC
*** Issue 82226 has been marked as a duplicate of this issue. ***
Comment 11 Rainer Bielefeld 2007-10-15 16:38:30 UTC
Due to  Issue 82226 
Comment 12 frank 2007-10-29 09:26:30 UTC
*** Issue 83009 has been marked as a duplicate of this issue. ***
Comment 13 bettina.haberer 2010-05-21 15:13:00 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".