Connecting Shape from Background-Page

Started by sindemic, May 05, 2015, 09:29:53 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

sindemic

Hello Gurus,

I want the width of a TextfieldShape to be the same as another TextfieldShape from the Background-Page.
I found this:
Pages[page name]!Sheet.n!Width
But that only works with foregroundpages.

Anyone has an idea?

Surrogate

i guess something like
QuotePages[Background-2]!Sheet.1!Width

sindemic

i tried that, but that doesn't work (Pop Up: error in the formula)
it would work if i use the formula with a forground page like "Pages[Page-2]!Sheet.1!Width"
But i Need it for a Background page sheet

Surrogate

Quote from: sindemic on May 05, 2015, 10:04:05 AM
But i Need it for a Background page sheet
Pages[Background-1]!ThePage!User.ololo i try this in visio2010, it is correct on my PC

Paul Herber

Maybe a simple question ... do you have the correct shape name?
Electronic and Electrical engineering, business and software stencils for Visio -

https://www.paulherber.co.uk/

Surrogate

may be you need get background's page width ?
Pages[Background-1]!ThePage!PageWidth

sindemic

Hello Paul,
yes, i have the correct shape, in my case it is sheet.18 from the Background-1 page.
i tried:
Pages[Background-1]!PageSheet.18!Width
Pages[Background-1]!ThePage!PageWidth      (for testing)
Pages[Background-1]!ThePage!Sheet.18!Width
Nothins works. Everytime the PopUp.
I Forget to say that i use visio 2013

Paul Herber

[Moderator] - I've moved this thread into the Visio 2013 area.
Electronic and Electrical engineering, business and software stencils for Visio -

https://www.paulherber.co.uk/

Paul Herber

Try the attached file:
The Page-1 shape PinX is tied to the background Page-2 shape PinX, so moving the background shape will cause the Page-1 shape to move.
P.S. the formula isn't guarded so moving the shape on Page-1 will overwrite the formula.
The formula is =Pages[Page-2]!Sheet.1!PinX
This is in Visio 2010. I don't touch Visio 2013 with a bargepole.
Electronic and Electrical engineering, business and software stencils for Visio -

https://www.paulherber.co.uk/

sindemic

thx for moving.

i hope i understand it right.
i named the backgroundpage : "Page-2"
the normal forgrounnd page called "Page-1"
i entered in Page-1 Sheet.1265 PinX : "=Pages[Page-2]!Sheet.18!PinX"
Same PopUp


i tried it again with a new normal forground page called "Zeichenseite-1" and sheet number 1
I tried:
=Pages[Zeichenseite-2]!Sheet.1!Width
same PopUp
I tried:
=Pages[Page-2]!Sheet.1!Width
and it works

i guess there is an error with Name reading
now i have to know, how visio called the first Background page.
i just tried:
background-0, background-1, background-2, backgroundpage-0, backgroundpage-1, backgroundpage-1, Background.page-0 and Background.page-1. i also tried to rename the Background-1 to Page-1/2/3. nothing helps 

Surrogate

#10
visio have two difference Local and Universal names of page
PageName(0) - local (non-english) pagename.
PageName(750) - universal pagename.

in shapesheet formula you need write only universal pagename. but via visio interface you see only local name! i get some problems with russian interface :)

sindemic

where i can see These local and universal page names?

maybe the Formular =Pages[page Name] isn't right because visio declare the Background not as a page

Surrogate

#12
Quote from: Visio Team 27 Jul 2006 в Name and NameUThe local name is a friendly name that is displayed in the Visio user interface. For Visio's own content, this is a string translated for the product sku of Visio (i.e. German strings in German Visio).  Users have the ability to rename Page and Master and Cell objects, and that changes the local name.  Local names allow users to see things in a language that makes sense to them.

The universal name is hidden from the user interface and can only be updated through automation.  This keeps a universal name consistent across product versions and user edits.  A constant name allows solution developers to refer to objects by an identifier that makes sense to them.  This identifier works no matter what is displayed for the local name.

Read more...

Surrogate

#13
sometimes ago i make this hint (see post in russian). but i can't tranlate this to english :(

i think this problem in not Visio'2013 issue :)

sindemic

i just translate it with Google. i feel like i understand it :-)

the Output was:
ActiveWindow.Selection(1).Cells("WIDTH").FormulaU = "pages[VHintergrund-1]!sheet.18!width"

so tried in Page-1:
=Pages[VHintergrund-1]!Sheet.18!Width
and it works :-)
i didn't still know what is the english universal Name of the Background page, but at least the german local one.

Thank you Surrogate
AND thanks Paul