also sprach Andreas Säger <ville...@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.bo...@madduck.net
--
To unsubscribe e-mail to: users+unsubscr...@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
