Re: Default formulas

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Harry,

I played around with it a little bit, and tried all sorts of sneaky tricks,
but it looks like you can only get *some* evaluation of formulas to occur,
but you don't seem to be able to reference any Shape*** cells.

For instance, with a data-type of "number", I was able to enter the default
formula: Min(3, 1) and the property-set dialog accepted this.

But if I changed it to Min(3, Width), it didn't like it. I think that,
technically/theoretically speaking, there's no guarentee that a shape will
have a Width cell (even though the all do....)

If you created a master shape with a set of custom properties, then the
values in the master would serve as defaults, but then you couldn't apply
these to other shapes...

--
Hope this helps,

Chris Roth
Visio MVP

Free Visio shapes:
http://www.visguy.com/category/shapes
Visio programming info:
http://www.visguy.com/category/programming/
Other Visio resources:
http://www.visguy.com/visio-links/

"Harry" <a@xxxxx> wrote in message
news:%23O5dEp%23lHHA.1216@xxxxxxxxxxxxxxxxxxxxxxx
Is it possible to define a default formula for a field's properties within
a Custom Property Set? I've tried entering a valid formula in the "Value"
field but Visio converts the formula to text by adding quotes in the Value
field of the Shape***.

Can formulas be added as defaults?

Thanks in advance,
Harry



.

Quantcast