Determining if a dynamic connector is connected to shape

Started by morelup, February 20, 2019, 03:27:42 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

morelup

I'm trying to make a dynamic connector show a different color if it isn't connected on both ends to shapes.  As far as i can tell, the only thing that changes when a dynamic connector connects to a shape is that the begin/end x/y cells change from literal values to functions.  Is there a function I can use to determine if a function is in a cell and not a literal value (or some other way to identify this scenario?)

Surrogate

#1
Try use EndTrigger/BeginTrigger in GlueInfo section, this syntax in LineColor cell

IF(BegTrigger+EndTrigger>=3,2,0)



morelup

Ok that might work, My visio is forcing the value to be _XFTrigger(Connector!EventXFMod) then updates to _XFTRIGGER(Sheet.17!EventXFMod) when i connect it to a shape.  It looks like that resolves to 1|2 though like your example shows so that might work.

Thank you!

wapperdude

What you're looking at is the literal formula in the cell.  Right click in the shape sheet and choose show values.  Surrogate's solution uses the values. 
Visio 2019 Pro

Visio Guy

Pro tip:

[F5] toggles values and formulas in the ShapeSheet!
For articles, tips and free content, see the Visio Guy Website at http://www.visguy.com
Get my Visio Book! Using Microsoft Visio 2010