You need to understand that your 'shape' is actually a nest of shapes. The parent shape contains a bunch of children shapes. Each shape has its own shapesheet and formulas can point up to the parent shapesheet fields or any of the child shapesheet fields.
The reason you can't find the wires on the shapesheet is that the geometry of each wire is on each of the child shapesheets. To edit a child shapesheet, you need to click once on the parent shape (you will see the main shape handles show it is selected), THEN click on the wire (you should see the selection handles change to the line ONLY and the title in the Shape Data window changes to the Wire). NOW right click on that wire and choose to view the ShapeSheet.
In the screenshot, you can see that in this case we are looking at the shapesheet for Wire2 and that the parent shape is called Sheet.1 so the formula that points at the position of Wire2's second geometry position is using the width of the line and 10% of the size in the parent shape's Scratch.B1 cell. To move that point to the right (instead of the left), change the minus to a plus
=Width - 0.1*Sheet.1!Scratch.B1
should be
=Width + 0.1*Sheet.1!Scratch.B1
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|