Author Topic: question about the page shapesheet  (Read 5731 times)

0 Members and 1 Guest are viewing this topic.

david

  • Full Member
  • ***
  • Posts: 101
question about the page shapesheet
« 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

Visio Guy

  • Administrator
  • Hero Member
  • *****
  • Posts: 1718
  • Smart Graphics for Visual People...n' Stuff
    • Visio Guy
Re: question about the page shapesheet
« Reply #1 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...
For articles, tips and free content, see the Visio Guy Website at http://www.visguy.com
Get my Visio Book! Using Microsoft Visio 2010

Paul Herber

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2955
    • Paul Herber's website
Re: question about the page shapesheet
« Reply #2 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.

Electronic and Electrical engineering, business and software stencils and applications for Visio -

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

wapperdude

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3833
  • Ideas Visio-lized into solutions
Re: question about the page shapesheet
« Reply #3 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.

Visio 2019 Pro

david

  • Full Member
  • ***
  • Posts: 101
Re: question about the page shapesheet
« Reply #4 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?
« Last Edit: July 30, 2008, 02:07:56 PM by Visio Guy »

wapperdude

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3833
  • Ideas Visio-lized into solutions
Re: question about the page shapesheet
« Reply #5 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.
Visio 2019 Pro

Visio Guy

  • Administrator
  • Hero Member
  • *****
  • Posts: 1718
  • Smart Graphics for Visual People...n' Stuff
    • Visio Guy
Re: question about the page shapesheet
« Reply #6 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.
For articles, tips and free content, see the Visio Guy Website at http://www.visguy.com
Get my Visio Book! Using Microsoft Visio 2010

Lars-Erik

  • Sr. Member
  • ****
  • Posts: 278
Re: question about the page shapesheet
« Reply #7 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" ?