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, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access