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

Intercell References

Before I end this chapter and move on to more complex issues, I want to take a moment to further discuss intercell references. You have already made use of intercell references when you created your smart arrow symbol, as well as your indicator symbol. Intercell references lend a great additional power to the ShapeSheet development environment. They assist in optimization of SmartShape symbols, as well as make it much faster and easier to create the custom symbols. However, the intercell references must be utilized properly. Whereas it is very good for Geometry1.X2, Geometry1.X3, Geometry1.X4, and Geometry1.X5 all to reference Geometry1.X1, because this optimizes the formulae and limits the required number of recalculations, it is not only bad form but also counterproductive to have Geometry1.X4 reference Geometry1.X3, which references Geometry1.X2, which, in turn, references Geometry1.X1. These “chained” references actually slow down the recalculation engine and decrease the efficiency of any given SmartShape symbol.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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