These are some tips for using the Visio shapesheet.
Background shapes: A description of how the background shapes work. John Marshall, Visio MVP | The functionality of the background shapes is based on several shapesheet values and an add-on. To duplicate the functionality, create a shape (it does not matter what the size or shape is) and drag the shape to a stencil. Open the shapesheet of the shape in the stencil and change it’s Height, Width; PinX, PinY and EventDrop function. The specific shapesheet changes are: In the Shape Transform section Set PinY to =GUARD(Height/2) |
Colour based on status: A suggestion on how to set the colour of a shape based on the value of a field. Mark Nelson, Visio | Put this formula in the FillForegnd cell. =Lookup(Prop.Status,”Black;White;Red;Green;Blue;Yellow”)(A formula error will occur if the custom property, in this case Status, does not already exist.) Lookup will match the value of the custom property Status to the list shown above. The value returned by Lookup will be a number starting with 0 which corresponds to the position of the matched value in the list. The list shows Visio’s numbering sequence for the colours. =Lookup(Prop.Status,”Black;White;Warning;Clear;Blue;Caution”) |
Empty Text: Chris Roth – the Visio Guy | To check in the shapesheet if a shape has no text try: StrSame( ShapeText( TheText ), “” )Black magic… – Chris |
Add shape to Offpage Reference: Chris Roth – the Visio Guy | When you double-click the “off-page reference” shape, Visio sends you to the correct page and selects the corresponding off-page reference shape, but you have to scroll to find it. 1. Add an Off-Page Connector. |
Pop up text on a document saved as HTML: Mark Nelson Office Graphics – Visio Microsoft Corporation | You can add the User.visEquivTitle cell to your shape and provide a string that will display as a tooltip in the web output. The shape must also have at least one custom property for the tooltip to be visible. Steps: 1) Select the shape in your drawing that you want to add a web tooltip for 2) Go to Window > Show Shapesheet3) Go to Insert > Section, check User-defined cells and click OK |
Set RGB fill colour: John Marshall | FillForegnd=THEMEGUARD(RGB(71,7,190)) |
Set Text Colour based on background colour: Saveen Reddy | If the background colour is light, the text will be black, if the background colour is dark, the text wil be white. Guard(IF(Lum(FillForegnd)>140,0,1)) |