Print Page - Get Fixed List Value from Cell Value.

Title: Get Fixed List Value from Cell Value.
Post by: bwharrington on January 28, 2019, 07:28:12 PM

I have a property that is a fixed list,

The Format for this property is,

="Undefined;On-Premise;Private Cloud;"

The value is,

=INDEX(0,Prop.myshapeProperty.Format)

The 0 is referring to the array position of the formatted list where 0 is undefined.

Knowing the property name and the shape is there a way for me to Translate the cells formula value into the fixed list in the format property?

Title: Re: Get Fixed List Value from Cell Value.
Post by: bwharrington on January 28, 2019, 07:37:35 PM

I found that,

shape.CellsU[cellName].ResultStr[""]

Gets me what I am looking for. Thanks all for reading.

Visio Guy

Visio Discussions => Programming & Code => Topic started by: bwharrington on January 28, 2019, 07:28:12 PM