See bellow.
2008/10/11 Andrew Douglas Pitonyak <[EMAIL PROTECTED]>
> If you check the link mode, what is it? NONE, NORMAL, or VALUE? What
> happens if you use a macro to set from NONE to something else?
>
It has a 0, nothing changes when I change it's value.
Some thing strange that I discovered is that the problem doesn't happen when
using "dde" formulas, for example:
=DDE("soffice";CONCATENATE("'";"file:///path/to/";$E$8);I11)
Where:
E8 Contains a File Name
I11 Contains something like "$Sheet1.$A$1" (The remote cell I want to
link to)
Every time the formula is entered, the link to that specific cell is added,
and every time the formula es deleted, the link is deleted automatically.
(OO3.0RC4, Win XP)
Either way... I still think there is a bug with the
"='file:///path/to/file.ods'#$Sheet.$A$1" formula.
Ely.
>
>
> Ely Schoenfeld wrote:
>
>> Hello all.
>>
>> I discovered that if you go to "Edit/Links...", select a linked file,
>> click
>> on "break link" button (or however is called in English) and press the
>> "ok"
>> button then you aren't able to add new linked data ever again.
>>
>> I have OO3.0RC4 on Windows XP
>>
>> To reproduce do the following:
>>
>> 1) Create new calc document
>> 2) Enter "hello" into cell B4
>> 3) Enter "bye" into cell B5
>> 4) Save the file with any name, for example "first.ods"
>> 5) Create another calc document
>> 6) Go to cell C2
>> 7) Enter the "=" sign (don't press the "Enter" key yet)
>> 8) Go to "first.ods" file and select the B4 cell
>> 9) Press "Enter"
>>
>> Here you can see "hello" at C2 in the second document
>>
>> 10) Press "Backspace" key (to delete the formula)
>> 11) Go to menu "Edit/Links..."
>> 12) Select the link to "first.ods" file
>> 13) press the "break link" button
>> 14) accept the form in order to close it
>> 15) Go to cell C8
>> 16) again enter a "=" sign (don't press "Enter" key yet)
>> 17) again go to "first.ods" file but now select the B5 cell
>> 18) Press Enter
>>
>> Here you should see "bye" at C8 in the second document, but instead of
>> this
>> you get a "0".
>>
>> And the menu item "Edit/Links..." is disabled
>>
>> I also tried saving the second document and what ever came into my mind
>> but
>> couldn't get remote data from first.ods file again.
>> I found out It is possible to get linked data from other documents, but
>> hever from first.ods.
>>
>> How to restore the link to the first.ods document?
>>
>> I hope someone could test it to see if he/she can reproduce it.
>>
>>
>> Thank you all in advance
>>
>>
>>
>
> --
> Andrew Pitonyak
> My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
> My Book: http://www.hentzenwerke.com/catalog/oome.htm
> Info: http://www.pitonyak.org/oo.php
> See Also: http://documentation.openoffice.org/HOW_TO/index.html
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
