|
|
|
date: Tue, 11 Sep 2007 06:56:01 -0700,
group: microsoft.public.visio.createshapes
back
Re: accessing GROUP custom properties from shapesheet of individual sh
Yes, you can.
You reference the Shape Data/Custom Properties/Cells in the Group shape just
like you wopuld anyother intershape references.
You need to know the Sheet ID of the shape for this, and the Drawing
Explorer window is handy for selecting the component shapes
For example, let's say that you have a group shape, Sheet.3, which contains
a sub-shape, Sheet.1
Sheet.3 has a Shape Data/Custom Property called Prop.Group
Sheet.1 has a Shape Data/Custom Property called Prop.PropA
You wish the values entered in one to update the other, and vice versa
Insert a User-defined Cell, let's say User.GroupChange, into the ShapeSheet
of Sheet.1 (the sub-shape), with the formula:
=DEPENDSON(Sheet.3!Prop.Group)+IF(NOT(STRSAME(Prop.PropA,Sheet.3!Prop.Group)),SETF(GetRef(Prop.PropA),"=SETATREF(Sheet.3!Prop.Group)"),0)
That's it!
Try it.
"DonZ" wrote in message
news:B503C1BB-98DD-4E26-8423-6F267B965F95@microsoft.com...
>I have a GROUP made up of two shapes. There is one custom property
> associated with each individual shape, plus there are 5 custom properties
> associated with the GROUP. I want the custom property of the individual
> shapes to automatically update with the contents of the related GROUP
> custom
> property whenever the GROUP shape properties are changed by the user.
> Likewise, I'd like the GROUP custom properties to update if the individual
> custom properties are updated. I believe this can be done without macro's
> just be using functions within the shape sheet but I can't figure out the
> right functions to use. Can I access the custom properties of the GROUP
> from
> the shape sheet of one of the embedded individual shapes? I use ID() to
> get
> the shape number of the individual shape or of the group shape, but how do
> I
> access the shape number of the group?
date: Wed, 12 Sep 2007 12:55:46 +0100
author: David Parker
Re: accessing GROUP custom properties from shapesheet of individua
Hi,
I have an additional question on this:
While this works fine for an existing shape, how do I extend this to shapes
created from a master? I'd like to have a group shape that acts as you have
descrbed, however when you add a master shape configured in this way to a
sheet, then the sub-shape references are different for each shape. Is there a
way of referencing individual group shapes in a relative way (i.e. 1st shape
in group) rather than in terms of the overall sheet?
Cheers
John
"David Parker" wrote:
> Yes, you can.
> You reference the Shape Data/Custom Properties/Cells in the Group shape just
> like you wopuld anyother intershape references.
> You need to know the Sheet ID of the shape for this, and the Drawing
> Explorer window is handy for selecting the component shapes
>
> For example, let's say that you have a group shape, Sheet.3, which contains
> a sub-shape, Sheet.1
> Sheet.3 has a Shape Data/Custom Property called Prop.Group
> Sheet.1 has a Shape Data/Custom Property called Prop.PropA
>
> You wish the values entered in one to update the other, and vice versa
>
> Insert a User-defined Cell, let's say User.GroupChange, into the ShapeSheet
> of Sheet.1 (the sub-shape), with the formula:
> =DEPENDSON(Sheet.3!Prop.Group)+IF(NOT(STRSAME(Prop.PropA,Sheet.3!Prop.Group)),SETF(GetRef(Prop.PropA),"=SETATREF(Sheet.3!Prop.Group)"),0)
>
> That's it!
> Try it.
>
>
> "DonZ" wrote in message
> news:B503C1BB-98DD-4E26-8423-6F267B965F95@microsoft.com...
> >I have a GROUP made up of two shapes. There is one custom property
> > associated with each individual shape, plus there are 5 custom properties
> > associated with the GROUP. I want the custom property of the individual
> > shapes to automatically update with the contents of the related GROUP
> > custom
> > property whenever the GROUP shape properties are changed by the user.
> > Likewise, I'd like the GROUP custom properties to update if the individual
> > custom properties are updated. I believe this can be done without macro's
> > just be using functions within the shape sheet but I can't figure out the
> > right functions to use. Can I access the custom properties of the GROUP
> > from
> > the shape sheet of one of the embedded individual shapes? I use ID() to
> > get
> > the shape number of the individual shape or of the group shape, but how do
> > I
> > access the shape number of the group?
>
>
date: Wed, 3 Oct 2007 01:57:00 -0700
author: John Ward John
Re: accessing GROUP custom properties from shapesheet of individua
John,
If you create your Master as a group, then your sub-shapes are referencing
the Greoup shape in the Master.
When you drag and drop, Visio will automatically update the references to
the Group instance.
"John Ward" <John Ward@discussions.microsoft.com> wrote in message
news:E252B6AD-9F29-4311-B831-FFB6801BFDD6@microsoft.com...
> Hi,
>
> I have an additional question on this:
>
> While this works fine for an existing shape, how do I extend this to
> shapes
> created from a master? I'd like to have a group shape that acts as you
> have
> descrbed, however when you add a master shape configured in this way to a
> sheet, then the sub-shape references are different for each shape. Is
> there a
> way of referencing individual group shapes in a relative way (i.e. 1st
> shape
> in group) rather than in terms of the overall sheet?
>
> Cheers
>
> John
>
> "David Parker" wrote:
>
>> Yes, you can.
>> You reference the Shape Data/Custom Properties/Cells in the Group shape
>> just
>> like you wopuld anyother intershape references.
>> You need to know the Sheet ID of the shape for this, and the Drawing
>> Explorer window is handy for selecting the component shapes
>>
>> For example, let's say that you have a group shape, Sheet.3, which
>> contains
>> a sub-shape, Sheet.1
>> Sheet.3 has a Shape Data/Custom Property called Prop.Group
>> Sheet.1 has a Shape Data/Custom Property called Prop.PropA
>>
>> You wish the values entered in one to update the other, and vice versa
>>
>> Insert a User-defined Cell, let's say User.GroupChange, into the
>> ShapeSheet
>> of Sheet.1 (the sub-shape), with the formula:
>> =DEPENDSON(Sheet.3!Prop.Group)+IF(NOT(STRSAME(Prop.PropA,Sheet.3!Prop.Group)),SETF(GetRef(Prop.PropA),"=SETATREF(Sheet.3!Prop.Group)"),0)
>>
>> That's it!
>> Try it.
>>
>>
>> "DonZ" wrote in message
>> news:B503C1BB-98DD-4E26-8423-6F267B965F95@microsoft.com...
>> >I have a GROUP made up of two shapes. There is one custom property
>> > associated with each individual shape, plus there are 5 custom
>> > properties
>> > associated with the GROUP. I want the custom property of the
>> > individual
>> > shapes to automatically update with the contents of the related GROUP
>> > custom
>> > property whenever the GROUP shape properties are changed by the user.
>> > Likewise, I'd like the GROUP custom properties to update if the
>> > individual
>> > custom properties are updated. I believe this can be done without
>> > macro's
>> > just be using functions within the shape sheet but I can't figure out
>> > the
>> > right functions to use. Can I access the custom properties of the
>> > GROUP
>> > from
>> > the shape sheet of one of the embedded individual shapes? I use ID()
>> > to
>> > get
>> > the shape number of the individual shape or of the group shape, but how
>> > do
>> > I
>> > access the shape number of the group?
>>
>>
date: Sun, 7 Oct 2007 09:59:37 +0100
author: David Parker
|
|
