Issue 57272

Summary: DDE links with macros not working
Product: Calc Reporter: kitsune6014 <kitsune6014>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.0   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Main.ods as per description
none
Link.ods as per description none

Description kitsune6014 2005-11-03 05:01:38 UTC
#VALUE! displayed in linked cell instead of correct value.

1. Create 2 documents (eg main.ods & link.ods).

2. Edit a cell in link.ods to use a user created macro.

3. Set a cell in main.ods to link to the cell in link.ods.

4. Close both documents.

5. Open the main.ods, when prompted to update links click YES.

6. Link to field displays #VALUE! instead of the correct value.

7. While main.ods is still open, open link.ods, #VALUE! is displayed in the cell
in link.ods.

Other points.

a) If link.ods is already open when main.ods is opened, problem does not occur.

b) Problem does not occur if macro is stored under My Macros.

c) This type of link worked correctly under Oo1.1.4.

d) Appears to me that when openening main.ods, that link.ods is opened as part
of the main.ods instance, but Oo cannot access the macros that are stored in
link.ods.  Oo1.1.4 opened a seperate instance, and therefore works.
Comment 1 kitsune6014 2005-11-03 05:02:51 UTC
Created attachment 31135 [details]
Main.ods as per description
Comment 2 kitsune6014 2005-11-03 05:03:38 UTC
Created attachment 31136 [details]
Link.ods as per description
Comment 3 frank 2005-12-06 10:53:28 UTC
Hi Niklas,

please have a look at this one.

Frank
Comment 4 Marcus 2017-05-20 11:11:27 UTC
Reset assigne to the default "issues@openoffice.apache.org".