Shape data linked to shape properties

Started by rainman, October 23, 2014, 10:43:40 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

rainman

Hello,

I am busy with a link between excel and visio. In excel I have geometric properties like With , Length, X and Y. I want to link these properties to the shape.

Prop._VisDM_Lengte is a item in de Shape data (that is linked to Excel). in de properties of Shape Transform is a item called Width. I made a formula Width = Prop._VisDM_Lengte.

This works fine. Also if I make a copy of this shape or make a shape in a shape stencils.

But when I do the same with Prop._VisDM_X and the item PinX in de Shape Transform box with the formula PinX=Prop._VisDM_X I do not work. It looks like it works when you look at it when you made de formula, but if there is a copy made, the formula PinX=Prop._VisDM_X is disappeared and a fix value is present.

Does any one know how to keep the formula in the property?

With regards,

Edwin Steenbeek

Yacine

That's because, when you drop the shape on the page you assign it new coordinates. So as to overwrite the formula.
This doesn't happen with the width as you don't modify it.
Change the formula to "guard(Prop._VisDM_X)". It should work.
Yacine