Visio Guy

Visio Discussions => ShapeSheet & Smart Shapes => Topic started by: david on July 23, 2008, 02:10:05 AM

Title: question about the page shapesheet
Post by: david on July 23, 2008, 02:10:05 AM
for some reason the following formula didn't work:

i wrote it in the FillForegnd cell  of one of the shapes:

"=ThePage!Prop.mask_color"

mask_color is a property i added to the custom properties of the page.

the formula wasn't recognized.

anyone knows the reason?

thanks
David
Title: Re: question about the page shapesheet
Post by: Visio Guy on July 23, 2008, 03:21:06 AM
Hi david,

Is the row name "mask_color" or just the Label? (check the ShapeSheet..."mask_color" should be red)

Otherwise, I'm not sure...
Title: Re: question about the page shapesheet
Post by: Paul Herber on July 23, 2008, 03:51:39 AM

"=ThePage!Prop.mask_color"


Hi David, you don't need the quotes in the formula. The quotes will make it a text string instead of a formula.

Title: Re: question about the page shapesheet
Post by: wapperdude on July 27, 2008, 10:18:24 PM
Hey David --

Is your prop.mask_color part of your shape custom properties?  If so, it's not a page property but rather a shape property.  That being the case, drop the "ThePage!" from your formula.

Title: Re: question about the page shapesheet
Post by: david on July 30, 2008, 06:59:54 AM
thanks for your answers.
Paul, i wrote the quotes only here not in the formulas.
wapperdude, it's not a mistake.  it indeed should be the page property.  it should affect all the shapes in the same page.

anyway, the formula i wrote works in a regular shape (not a group).  but when i wrote exactly the same formula in the fillforegnd cell of a shape which is a member of a group for some reason it didn't work.

anyone know why?
Title: Re: question about the page shapesheet
Post by: wapperdude on July 30, 2008, 01:41:11 PM
The shapes in the group will not automatically inherit the group settings.  So, just as you did ThePage! for the group, you need to pass the page info into the shapes.
Title: Re: question about the page shapesheet
Post by: Visio Guy on July 30, 2008, 02:09:25 PM
A reference to ThePage! should work at all levels of grouping in Visio shapes - ie: every shape and sub-shape on a given page has equal access to ThePage. Not sure why it didn't work.
Title: Re: question about the page shapesheet
Post by: Lars-Erik on August 01, 2008, 01:02:16 AM
Could it be that the value of the property is whats trowing off Visio? so the value of the "mask_color" ?