Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index

also sprach Andreas Säger <> [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 | |
seen on an advertising for an elaborate swiss men's watch:
  "almost as complicated as a woman. except it's on time"

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.