Using Custom Property Lists

When you have a shape with a Custom Property/Shape Data List you may want to refer to it from within the shapesheet or an associated shapesheet. The first inclination would be to do a string comparison within the test. My preference is to create a User cell that uses Lookup to convert the text into a numeric value. So for a list named Relation, the Shape Data row would be:Name:   Prop.RelationType:   1Format:   “Hostile;Close;Distant”   Value:   =INDEX(1,Prop.Relation.Format) So what would be in the Value of the User Property cell User.Relation_nbr? The LOOKUP function would need the string to search for (which is … Continue reading Using Custom Property Lists