Add connection points by using shapesheet fomulae

Started by DGR2017, May 27, 2019, 05:51:43 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

DGR2017

Hi, I want to add a connection point with right click action ("Add connection point) and formulae in the shapesheet. Appreciate if some one can provide me directions on how to accomplish this. Thank you in advance.

vojo

if you want to add connection points, then either  VBA or have user do it

if you want to move around connection points, then formulas

For example
- create 4 connection points at 0,0
     - forumlas be something like this    connections.x1 = if (actions.row_1.checked, width *0.5, width*0)
- create action rows (1 for all 4 points or 1 for each point)
     - formula be something like sthis    actions.row_1 = setf(getref(actions.row_1.checked), if(actions.row_1.checked, 0,1))

you could do this with shape data as well to specify where the point should got
    - in shape data,  myconn1X = 10mm   myconn1Y = 15mm
    - connections.x1 = myconn1X    connections.y1 = my conn1Y    //assume defaut for shape data is 0,0 ==>connections 0,0
           - can build logic on top of this if you want or even combine with actions
           - DEPENDSON function might be of help
           
Could do this with controls
- Visio guy got real slick and showed how to constrain a control point in a circle
     - point is that using similar methodology that visio guy used, you can do some real complex logic here.

point its, you can not use formulas to create a connection point but you can use formulas to modify them

DGR2017