• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Modifying Visio SmartShape Sy... > Intershape and Innershape References

Intershape and Innershape References

We have already seen how any ShapeSheet cell can reference any other cell in the same ShapeSheet. We do this by making a direct reference to that cell's name. For example, if the value to be used for the width of a given SmartShape symbol is to be taken from a user-defined cell and the user-defined cell is named MyWidth, the formula in the ShapeSheet's Width would be =GUARD(MyWidth). We have also seen that any Visio SmartShape symbol can reference another by using intershape references. If the height of a symbol called Sheet.2 must always be equal to the height of a symbol called Sheet.1, the height cell in the ShapeSheet for Sheet.2 would contain the formula =GUARD(Sheet.1!Height). We see that the exclamation point (!) is the separator between the SmartShape symbol name and the cell referenced in the referred to SmartShape symbol's ShapeSheet.

Under Visio 2000, this intershape referencing can be extended to be called cross-container references. The Syntax is slightly different when you rise beyond the intershape level to go across pages. Let's take the example of a basic rectangle SmartShape symbol whose name is Sheet.1 on Page-1, and another basic rectangle SmartShape symbol whose name is Sheet.2 on Page-2. If we wanted to have the fill foreground color of Sheet.1 on Page-1 controlled by the fill foreground color of Sheet.2 on Page-2, Sheet.1's FillForegnd cell in its ShapeSheet would contain the formula =GUARD(pages[Page-2]!Sheet.2!FillForegnd). Notice how the page reference takes on the form of the keyword pages followed by an opening square bracket, the name of the page to be referenced, a closing square bracket, and then the exclamation point as a separator. This is followed by the normal inter-shape reference structure.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint