My answer is down there. 2008/10/18 Andrew Douglas Pitonyak <[EMAIL PROTECTED]>
> Ely Schoenfeld wrote: > >> Now I get it. I have just discovered why nobody answers to my last few >> mails. WRONG "FROM" ADDRESS! ha ha ha. >> >> > > I usually reply to the list directly, but I have been overly busy. it is > past 2:00 AM, and I still have much to do (that will be left undone). I am > simply unwinding before crawling into bed. > > Andrew: You where right, I had to use the setLinkMode() method. But in the >> correct place. He he he. >> >> > > It is always the case. > > I plan to send the whole macro when its finished (in case someone else can >> use it). >> >> My problem now is that the documentation doesn't say how to delete "left >> out" DDE links. >> >> http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/DDE_Links >> >> > > Hmm, DDE links. Another can of worms. Do you have embeded objects in the > document? If so, I expect that you need to delete the object. Does this even > work on Linux? Hmmm.. No, I don't have any object there. I would guess the API has a way to delete DDE links, because you can go to Edit/Links menu, select one over there and press the "Break" button. That way it does delete the link. If you happen to have any DDE formula, the link is reestablished upon recalc... but this is not the case. My formula gets overwritten with the "text only" value. It's easy to reproduce those left over links in the document: a) create a DDE link formula, just make sure the "filename" comes from another cell b) change file names on the "filename" cell (They don't even have to exist) c) go to Edit/Link menu, and you will see those "leftover" links... and only one formula. Can't understand why the API documentation doesn't tell how to delete those. Maybe they didn't expect to be possible to have "leftover" links and this is a bug. Andrew: Do you agree? Should I go and file a bug report? Thank you in advance >> When I "point to" data from other documents, changing things back and >> forth >> over time, I get a lot of rows at menu "Edit/Links..." that are no longer >> needed. >> >> What I want to accomplish is to press a button that copy the few (5) cells >> with "foreign" data and paste them as text, and then delete all those >> links >> at "Edit/Links..." >> The first part because OO Calc becomes very slow with a bunch of open open >> files that have references to each other, and the second part to keep >> things >> clean and avoid the "update links" dialog that appears every time I open >> the >> document >> >> I couldn't open the "mailing list guidelines" now so I don't know if I'm >> permitted to add attachments, meanwhile I give this link to download a 3 >> very small calc documents with an example and instructions.(A 24k zip >> file) >> >> >> http://www.mitalteli.com/tmp/ootest_HelpNeededToDeleteLinksToOtherCalcDocuments-20081013.zip >> >> Thank you in advance. >> >> Ely. >> >> >>
