News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Access Shape Data across master shapes

Started by Another_Noone, February 27, 2017, 11:29:28 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Another_Noone

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

Surrogate

IMHO: References like Masters[Legende] impossible in Visio

Another_Noone

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?

Surrogate


Another_Noone

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!)

Surrogate

IMHO The best wai is use TheDoc cells for that task

Another_Noone


Surrogate

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

Another_Noone

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

Surrogate

can you attach there vsd-file with simple example

Another_Noone

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.

Surrogate

#11
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
To reference a cell ofUse this syntaxExample
The same shapeCellNameWidth
A shape, group, or guideShapename!CellNameStar!Angle
A shape, group, or guide in which more than one shape at the same   
level has the same name
Shapename.ID!CellNameExecutive.2!Height
A named column with indexed rowsSection.Column[index]Char.Font[3]
An unnamed column with indexed rowsSection.ColumnIndexScratch.A5
Any shape, page, master, or styleSheet.ID!CellNameSheet.8!FillForegnd
A masterMasters[MasterName]!SheetName!CellReference          Masters[Gear]!Shaft!Geometry1.X1
The page or master page on which the object is locatedThePage!CellReferenceThePage!User.Vanishing_Point
Another page in the documentPages[PageName]!SheetName!CellReferencePages[Page-3]!Sheet.4!BeginX
A styleStyles!SheetName!CellReferenceStyles!Manager!LineColor
The DocumentTheDoc!CellReferenceTheDoc!PreviewQuality
A shape, page, master, document, or style with a nonstandard name.     'Sheetname'!CellName'1-D'!LineColor

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 430 (show)
Files included: 32 - 1207KB. (show)
Memory used: 1150KB.
Tokens: post-login.
Cache hits: 14: 0.00328s for 26,726 bytes (show)
Cache misses: 3: (show)
Queries used: 16.

[Show Queries]