Stack Overflow
Stack Overflow

Questions tagged [shapesheet]

The ShapeSheet is a spreadsheet-like environment, which is part of Microsoft Visio. It allows a shape to have its appearance and behavior controlled parametricly using constant values and expressions. This tag should be used for Visio related questions where the problem concerns ShapeSheet access and syntax.

Behind every Shape (and in fact, Page and Document), sits the ShapeSheet. It is the interface for most of the properties of a Shape that effect the shape's apprearance and behavior.

Although it is a visible part of Visio's UI, it also represents the conceptual structure of a shape's properties.

Most of the cells that you find in the ShapeSheet are the only means of accessing that particular attribute of a shape. So even if you're writing code against Visio you still need to address these cells via the CellsU and CellSRC properties on the shape object.

enter image description here

55 questions
0
votes
2 answers

Visio Master Shape to update shape text based on shape data field

I have a Visio (365) Master Shape I am creating for my work. I have a number of defined shape data fields, such as Type / Status / Display / Category etc... These are defined as defined as shape data and not as shape data set and can be accessed in…
The Frog
  • 85
  • 7
0
votes
1 answer

Automatically Show ShapeSheet of Current Shape

I do a lot of Visio ShapeSheet editing and it would save me a tremendous amount of time to automatically switch to the current shape's sheet when I select a new shape. Let's assume I only have 1 ShapeSheet open, only select 1 Shape, and have all the…
Vince
  • 467
  • 3
  • 8
0
votes
0 answers

Scale master shape on drop

I need to know how to set a master shape to scale down by percentage, when it is dropped onto page. If I have a page that is 600 mm x 300 mm that is scaled 1:1 and I have a master shape that is 14 inches x 36 inches (a chicken door), and I want to…
Mouthpear
  • 199
  • 1
  • 3
  • 13
0
votes
1 answer

How to refer to the text of a shape in another page

I have two shapes, masterShape on the page Data and slaveShape on the page ESB. I mention that the Name & NameU of my pages are the same. I already read a lot about this (See here for example). My goal is to make the text of slaveText equal to this…
Belight
  • 205
  • 2
  • 14
0
votes
3 answers

Visio - How to use the same shape property for many shapes

I have created one master shape with many properties. In the "Define Shape Data" windows of the master shape (of the document stencil), one of the properties (masterProp) is a variable list (so with a list of allowed values). Is it possible to…
Belight
  • 205
  • 2
  • 14
0
votes
1 answer

Change Shape Fill based on Shape Data in Visio

Wondering if someone can help me with what I thought was a simple Shapesheet issue. I'd like the fill colour of a shape to change based on one of the shape data values. I thought I could do this easily: FillForeground:…
Steven Lamb
  • 1
  • 2
0
votes
1 answer

Make a line in visio change colour when another object changes colour

I want to change the line color of a line when the foreground color of another object is changed. Is it possible to link the line color directly with a formula in shapesheet? I was thinking something like…
Pengatom
  • 15
  • 3
0
votes
2 answers

Visio VBA - Adding Shape Data Properties

i'm creating and testing a UserForm where user can add the shapes and add the predefined Shape Data Value to the Shape Data. The Shape Data name is "Element" as you can see the image below. Dim vsoRound As Visio.Shape Dim cell As Visio.cell If…
MG78
  • 219
  • 2
  • 5
  • 12
0
votes
1 answer

How can set show multiplicity option to association shape (Visio) C#, Microsoft.Office.Interop.Visio

How can I turn on the show multiplicity option to association shape and access 4 position in visio using c# and Microsoft.Office.Interop.Visio.
Priya
  • 3
  • 4
0
votes
2 answers

How can I add ScreenTip to shape (Visio) C#, Microsoft.Office.Interop.Visio

How can I add screen tip to shape in visio using c# and Microsoft.Office.Interop.Visio Actually I tried to use Controls Section and I followed microsoft documentation but it does not work and showing me this error: "\n\nUnexpected end of file." here…
samer nassar
  • 3
  • 1
  • 4
0
votes
0 answers

Visio custom circle where diameter is calculated from control distance

I'm trying to figure out how to create a custom circle shape in Visio using the ShapeSheet to dynamically calculate the diameter of the circle relative to a control point. The control point is essentially the vertex of an isosceles triangle and the…
MarkE
  • 123
  • 8
0
votes
1 answer

How can I programmatically format text in visio shapes (color, size, font)?

I can change the font, color, size of characters in the shape. But only for rows that already exist in the VisSectionIndices.visSectionCharacter of shapesheet. I cant create new rows for this section and cant change the number of characters for each…
Сергей Карпенко
  • 3
  • 2
0
votes
1 answer

Visio ShapeSheet ShapeData: keep two rows in sync

I have two Shape Data rows for a Shape's ShapeSheet: Shape Data Label Prompt Type Format Value …
Chelmite
  • 360
  • 3
  • 18
0
votes
0 answers

ShapeSheet cell reference error when using Shape.SetFormulas in Visio

When I try to use .SetFormulas to reference Connector shapes on different page, I keep getting the #Name? error. The error would occur in both Visio 2010 and 2016. The code below works for circles and grouped shapes but not my connectors. Dim…
Helmut S
  • 21
  • 1
  • 7
0
votes
1 answer

How to copy a Visio shapesheet section between shapes in VBA

Is there a method available for copying a section out of a shape to another shape using VBA? I'm specifically trying to copy all the custom properties and user cells from one pagesheet to another page.
Jon Fournier
  • 4,299
  • 3
  • 33
  • 43
1 2
3
4