Using Fields from different shapes

Started by Steven_Hughes, November 07, 2011, 06:56:12 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Steven_Hughes

I have combined two shapes into one by grouping them together. I have created a shape data page for the new shape. How do I insert a field from the new combined shape's data into the text display for original component shapes?

Thanks,

Steven

Jumpy

I would first look at the (sheet)names of the shape, because you need them for reference later.
For example. The two original shapes could be Sheet.123 and Sheet.456 and the group could be Sheet.555.

I would than go into the shapesheet of a subshape for example Sheet.123.
There I'd create a new user defined cell: User.MyText with the formula: "=Sheet.555!Prop.MyShapeDataFromGroup".
With that construct, the info from the shapeData of the group is now known to the subshape.
Now you can go into textmodus (in the subshape), Insert->Fields->User defined cells->User.MyText.

--------------
A Shortcut could be to directly go to the subshape. Insert Field Dialog and in that dialog place the custom formula "Sheet.555!Prop.MyShapeDataFromGroup" but I recommend the longer way above, because later (3 month from now) it's easier to see, what you have done.

hth Jumpy

Steven_Hughes