Author Topic: shape dimensions driven by linked data  (Read 19509 times)

0 Members and 1 Guest are viewing this topic.

Lars-Erik

  • Sr. Member
  • ****
  • Posts: 278
Re: shape dimensions driven by linked data
« Reply #15 on: May 11, 2008, 05:03:10 PM »
Personally i don't know of any way to edit for example the "Height" section of the ShapeSheet of multiple shapes. That trully would rock.
But I'm afraid I don't know how to do this. Anyone else know a way to do this ?
« Last Edit: May 13, 2008, 04:52:14 PM by Visio Guy »

Visio Guy

  • Administrator
  • Hero Member
  • *****
  • Posts: 1723
  • Smart Graphics for Visual People...n' Stuff
    • Visio Guy
Re: shape dimensions driven by linked data
« Reply #16 on: May 13, 2008, 04:51:08 PM »
Here we go, you're probably doing this:
Dragging the shape while holding Ctrl. (it seems to change the custom fields in width and height to static values)

Yes, formulas in the Width, Height and Pin cells can get very easily blasted.

One way to stop this is with the GUARD function. So:

 Width = GUARD(Prop.Row_1)
 Height = GUARD(Prop.Row_2)

This will stop your formulas from getting blasted, no matter how you copy the shape.

However, you won't be able to freely resize the shapes either.
For articles, tips and free content, see the Visio Guy Website at http://www.visguy.com
Get my Visio Book! Using Microsoft Visio 2010

Visio Guy

  • Administrator
  • Hero Member
  • *****
  • Posts: 1723
  • Smart Graphics for Visual People...n' Stuff
    • Visio Guy
Re: shape dimensions driven by linked data
« Reply #17 on: May 13, 2008, 05:12:07 PM »
Guys,

Here's a thread about modifying many ShapeSheet cells at once:

Code to Modify ShapeSheet Cells of Many Shapes
For articles, tips and free content, see the Visio Guy Website at http://www.visguy.com
Get my Visio Book! Using Microsoft Visio 2010

papacat21

  • Newbie
  • *
  • Posts: 2
Re: shape dimensions driven by linked data
« Reply #18 on: August 14, 2012, 02:51:41 PM »
In the second section of this thread (the first response) is a graphic reference that appears to be no longer available, and I think that's the info I actually need.   There are graphics later in the thread that work OK so I think the problem is with the graphic iteself.  Anyway,  I'm trying to create a bunch of rectangles with speciifc height and width dimensions from a simple table in Excel.  I'm NOT trying to insert shape data into existing shapes, I'm trying to CREATE shapes much as described in the video referencing the ship loading problem.  I don't care where they're positioned - I'll need to deal with that manually.  I just need to be able to process a simple list of dimensions into a bunch of rectangles.  Is that graphic available, or can someone direct me to appropriate instructions?

thx