Issue 23186 - external references to macro function calls are broken
Summary: external references to macro function calls are broken
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: PC Windows 98
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks: 20046 81535
  Show dependency tree
 
Reported: 2003-12-04 13:15 UTC by uwekloss
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
sheet containing macros (6.04 KB, application/octet-stream)
2003-12-08 19:38 UTC, uwekloss 		no flags Details
sheet containing references to a.sxc (5.09 KB, application/octet-stream)
2003-12-08 19:40 UTC, uwekloss 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description uwekloss 2003-12-04 13:15:16 UTC 
document external references to cells containing macro function calls 
local to the target document don't work.
Comment 1 frank 2003-12-05 10:31:50 UTC 
Hi Joerg,

could you have a look at this, please ?

@submitter

please attach a document showing your problem.

Frank
Comment 2 uwekloss 2003-12-08 19:38:02 UTC 
Created attachment 11818 [details]
sheet containing macros
Comment 3 uwekloss 2003-12-08 19:40:03 UTC 
Created attachment 11819 [details]
sheet containing references to a.sxc
Comment 4 utomo99 2003-12-12 06:24:59 UTC 
please explain step by step how to reproduce the problem ? 
Thanks
Comment 5 joerg.skottke 2003-12-12 09:25:59 UTC 
According to the OOo PCD i set this Bug/Enhancement to OOo Later
Comment 6 uwekloss 2003-12-13 11:48:10 UTC 
To utomo99

open the attached files an look at range a1:b2 in each of them
Comment 7 flibby05 2004-04-22 20:21:21 UTC 
confirmed with 1.1.1 linux build
Comment 8 joerg.skottke 2004-10-26 09:59:00 UTC 
jsk->tbe: is this intended to work?

in document A.SXC a macro is referenced
in B.SXC the cell in A.SXC containing the reference to the macro is referenced.

#value? is displayed here.
Comment 9 thomas.benisch 2004-10-26 11:03:01 UTC 
TBE->NN: The cell A2 in document A.sxc displays the correct value of the function 
Macro1. The cell A2 in document B.sxc references cell A2 in document A.sxc,
but displays '#VALUE!'.
I guess that something's wrong with the reference to the calc cell.
If you encounter a problem with macro event bindings please contact the 
scripting framework team (Noel.Power@sun.com).
Comment 10 uwekloss 2009-12-22 12:27:08 UTC 
hi, will this issue be revisited sometime or is it dead?
Comment 11 uwekloss 2009-12-22 12:55:14 UTC 
I have a hunch it might be related to problems to access _local_ macro
definitions via external references.
one might circumvent the problem by moving the macro definitions to "Meine
Macros & Dialoge".
But that defies the pupose of local definitions.