Get Fixed List Value from Cell Value.

Started by bwharrington, January 28, 2019, 07:28:12 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

bwharrington

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?

bwharrington

I found that,

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

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