Re: [libreoffice-users] Re: Deleting external links

also sprach Andreas Säger <villeroy@t-online.de> [2016-04-20 17:20 +0200]:
> DDE("soffice";"path_name","ref") and URL links
> 'file:///path/name.ods'#$Sheet.A1 are established by formula
> expressions. Before you can delete them in the links dialog, you
> have to remove all formula references.

I don't want to remove all links. I want to remove those links that
are no longer in use.

Here's a simple example: let's assume $A$1 has the contents
"blue.ods", and I fill $B1:$B100 with a formula along the lines of

  # effectively copy 100 cells from blue.ods#Sheet 1 column B
  DDE("soffice"; $A$1; CONCATENATE("Sheet 1.$B$"; ROW()))

This will generate 100 links.

Now I change "blue.ods" to "red.ods" and recalculate. Now I have 200
links, but 100 of those are no longer in use.

Does this make sense?

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
seen on an advertising for an elaborate swiss men's watch:
  "almost as complicated as a woman. except it's on time"
 
spamtraps: madduck.bogus@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted