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

Cell Dependencies

Thus far in this chapter, we have looked at Automation-based mechanisms for handling events. We will continue with this in a moment, but it is important to remember that many events can be handled on a SmartShape symbol-by-SmartShape symbol basis using cell dependencies. As you are aware, any cell in a Visio ShapeSheet can reference any other cell in a Visio ShapeSheet through formulas. These are the inter-cell references we spoke of in the earlier portions of the book. They create inter-cell relationships or cell dependencies.

These dependencies are implied by the cell names used in the formulas. In the following example of a 1-D connector SmartShape symbol, PinY depends on BeginY and EndY. EndY, in turn, depends on a ConnectionPoint in Sheet.2. When the value of the connection point changes, the value of the EndY cell is recalculated. When the value of EndY changes, the PinY Cell is recalculated.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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