Issue 23186

Summary:

external references to macro function calls are broken

Product:

Calc

Reporter:

uwekloss <uwe.h.kloss>

Component:

code

Assignee:

AOO issues mailing list <issues>

Status:

CONFIRMED ---

QA Contact:

Severity:

Trivial

Priority:

CC:

issues

Version:

OOo 1.1

Keywords:

oooqa

Target Milestone:

---

Hardware:

OS:

Windows 98

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Issue Depends on:

Issue Blocks:

20046, 81535

Attachments:

Description	Flags
sheet containing macros	none
sheet containing references to a.sxc	none

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.