Issue 23186 - external references to macro function calls are broken
Summary: external references to macro function calls are broken
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:
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: ---

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

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 ?


please attach a document showing your problem.

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 ? 
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 (
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.