(Msg. 1) Posted: Tue Sep 11, 2007 6:56 am
Post subject: accessing GROUP custom properties from shapesheet of individual sh Add to elertz Archived from groups: microsoft>public>visio>createshapes (more info?)
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?
(Msg. 2) Posted: Wed Sep 12, 2007 12:55 pm
Post subject: Re: accessing GROUP custom properties from shapesheet of individual sh Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" <DonZ DeleteThis @discussions.microsoft.com> 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?
(Msg. 3) Posted: Wed Oct 03, 2007 1:57 am
Post subject: Re: accessing GROUP custom properties from shapesheet of individua Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" <DonZ.RemoveThis@discussions.microsoft.com> 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?
>
>
(Msg. 4) Posted: Sun Oct 07, 2007 9:59 am
Post subject: Re: accessing GROUP custom properties from shapesheet of individua Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.RemoveThis@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" <DonZ.RemoveThis@discussions.microsoft.com> 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?
>>
>>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office Other