Visio Guy

Hi,
my problem is:

I have 2 MasterShapes.
I need to Access the Shape Data of one MasterShape from a Shape within the other MasterShape.
I tried using
Masters[Legende]!Sheet.55!Prop.size (Legende is the masterShape wich contains the data i need, its on Sheet 55 and called size)
It seems to work (Auto completion shows the prop.size, but as soon as i enter,
it says i have a formula error in this block.
So,
1. where is my mistake
2. Or is there an easier way to get the shape data for my formula
?
Thx in advance

IMHO: References like Masters[Legende] impossible in Visio

Quote from: Surrogate on February 27, 2017, 11:42:56 AM
IMHO: References like Masters[Legende] impossible in Visio

Are you sure?
If yes, is there another way to access the data?

Quote from: Another_Noone on February 27, 2017, 11:44:41 AMAre you sure?

Yes!

Quote from: Another_Noone on February 27, 2017, 11:44:41 AMis there another way to access the data?

Which data you need ? And what kind of access ?

Quote from: Surrogate on February 27, 2017, 11:47:32 AM
Which data you need ? And what kind of access ?

The Mastershape has a ShapeData called size (a number), wich i need to include in a formula within a shapedata for another shape (in another mastershape!)

IMHO The best wai is use TheDoc cells for that task

Quote from: Surrogate on February 27, 2017, 11:54:34 AM
use TheDoc cells

How exactly would I do that, Im not that experienced.

1. add user-defined cell in TheDoc, for example user.size
2.in another master add user-defined cell with formula
SETF(GetRef(TheDoc!User.size),sheet.55!Prop.size)
3. in target shape you can use reference: TheDoc!user.size

Quote from: Surrogate on February 27, 2017, 12:05:50 PM

Code Select Expand

SETF(GetRef(TheDoc!User.size),sheet.55!Prop.size)

Answer from Visio is:
Mistake in formula

can you attach there vsd-file with simple example

I just figured it out, thank you.
My mistake was, i put the user.size cell into the Pages ShapeSheet, and not the documents.
Now it works, like its supposed to.

I was wrong !

Quote from: Surrogate on February 27, 2017, 11:42:56 AMIMHO: References like Masters[Legende] impossible in Visio

Quote from: M$FT Dev Center article About Cell References (https://msdn.microsoft.com/en-us/library/office/ff768760.aspx)

To reference a cell of	Use this syntax	Example
The same shape	CellName	Width
A shape, group, or guide	Shapename!CellName	Star!Angle
A shape, group, or guide in which more than one shape at the same    level has the same name	Shapename.ID!CellName	Executive.2!Height
A named column with indexed rows	Section.Column[index]	Char.Font[3]
An unnamed column with indexed rows	Section.ColumnIndex	Scratch.A5
Any shape, page, master, or style	Sheet.ID!CellName	Sheet.8!FillForegnd
A master	Masters[MasterName]!SheetName!CellReference	Masters[Gear]!Shaft!Geometry1.X1
The page or master page on which the object is located	ThePage!CellReference	ThePage!User.Vanishing_Point
Another page in the document	Pages[PageName]!SheetName!CellReference	Pages[Page-3]!Sheet.4!BeginX
A style	Styles!SheetName!CellReference	Styles!Manager!LineColor
The Document	TheDoc!CellReference	TheDoc!PreviewQuality
A shape, page, master, document, or style with a nonstandard name.	'Sheetname'!CellName	'1-D'!LineColor