Author Topic: Dynamic Connectors smal blue handles  (Read 15244 times)

0 Members and 1 Guest are viewing this topic.

novski

• Full Member
• Posts: 182
Re: Dynamic Connectors smal blue handles
« Reply #30 on: September 21, 2014, 07:04:41 AM »
HI
Yes ist is exactly what im looking for.

This is acepted but does not give out the Value of Geometry1.X1 instead it is static 0.000
=EVALTEXT("""Geometry1.X"""&User.LineCount)

This gives out a 1.000
=EVALCELL(User.ValueLineEnd)

This gets accepted but gives out a #VALUE! error
=SETF((User.Row_45),EVALTEXT("""Geometry1.X"""&User.LineCount))

This gives out a 0.000
=SETF(GetRef(User.Row_45),EVALTEXT("""Geometry1.X"""&User.LineCount)))

:2h later...
I found a way.

Setting the Prompt cell to:
=SETF(GetRef(User.Row_54),"""=Geometry1.X1|=Geometry1.X2|=Geometry1.X3|=Geometry1.X4|=Geometry1.X5|=Geometry1.X6|=Geometry1.X7|""")
Gives a base to make a index in a other prompt cell: =SETF(GetRef(User.Row_53),INDEX(User.Row_56,User.Row_54,"|",))
And that gives out my Geometry1.X1 point in mm witch in my case is 0.00mm in Cell: User.Row_53.Value
now i can change User.Row_56.Value by hand to any number i want. (+1)

With setting User.Row_56 to User.Row_55 i can make my operation be done automatically.

So now i get the coordinate of my x point as i need it. really cool.

novski

• Full Member
• Posts: 182
Re: Dynamic Connectors smal blue handles
« Reply #31 on: September 21, 2014, 07:06:42 AM »
I still have a question.

Jumpy helped me out on the task to get hold of the Geometry1.X sections also when the geometry sections disappear.
He made a +Dependson(TxtPinX) behind the formula. Now my text will not move so it will not update the formula as well.
I experimentd a bit with the Pathlengt and segments but i can't follow how the segments are counted.
Neather do i find any information about the number of segments related to a connection line.
here: http://blogs.msdn.com/b/visio/archive/2010/01/15/the-point-along-path-shapesheet-functions-in-visio-2010.aspx
or here:

if i draw a straight 1D Line it counts 1 segment. If i lift of the middle vertex i get 7 and if i make a "S" its 11.

How does it count the segments or what is a segment...?

novski

• Full Member
• Posts: 182
Re: Dynamic Connectors smal blue handles
« Reply #32 on: September 26, 2014, 12:03:32 AM »
fount it. And its a waaaaaaay easier formula than the absolutely cool trick from jumpy (thank you Jumpy anyway, to give me the knowledge about how to fix Visio to effect my formulas of GeometryX.XY trough the Prompt cell!)

The segmentcount seams to count the (Legs + edge). So because the two ends don't have an edge its possible to count +2 and then divide it trough 2 to get the correct number of Legs we see. This is more accurate than the reseting of a formula trough the prompt cell.
I noticed that that is hard to configure because the +Dependson(TxtPinX) sometimes doesn't seams to work on certain cells.

This is the full formula:
User.ConnectorLegs=INT((SEGMENTCOUNT(Geometry1.Path)+2)/2)

cheers
novski