2007-05-15 17:45:14 UTC
I have a custom property set in which I've created a field called "ShapeID". ShapeID is simply a concatenation of the contents of the "Shape Number" and "ShapeNumber Text" fields created by Visio when the "Number Shapes" Add-in is run. The concatenated info will be displayed on, and used as the sort field for, a report.
I've entered the formula Prop.ShapeNumberText&Prop.ShapeNumber in the Value field of the Define Custom Properties dialog box. I then copied the change to each shape in my diagram using the Apply custom property sets to selected shapes feature.
The problem I'm having is that Visio displays Prop.ShapeNumberText&Prop.ShapeNumber in the Define Custom Properties dialog yet in the shapesheet for each of the shapes the value field shows "Prop.ShapeNumberText&Prop.ShapeNumber" (Visio adds quotation marks which, as you've likely already guessed, converts the formula to a sting). So, when I run my report instead of the concatenated values of the two fields being displayed I see the phrase Prop.ShapeNumberText&Prop.ShapeNumber. The only way I've found to correct this is to manually go to each shape's shapesheet and remove the added quotes.
I suspect my problem has to do with the Value field from the Custom Properties dialog defaulting to a sting - is there any way to add a formula without having to enter each shape manually?
Thanks in advance for any light you can shed on my problem.