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: 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
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 |