Hello, I am trying to create a list in Shape Data and need to include strings like: "25P", "13IN" (so Prop.fieldValue.Format="25P;13IN")
Visio however transforms the text to units, so the output looks like: "25 p", "13 in". Is there a way I can instruct "the list" to show the items as strings (like "25P"...)
Thank you in advance.
The only thing I can think of would be to alter the strings by adding a character like an underscore (eg "25P_").
For further processing you could then remove this character by means of a formula (eg =SUBSTITUTE(Prop.Row_1,"_",""))
Assuming that you've selected Fixed List as the Type, then, the following should work, enter: CHAR(34)&"10U"&CHAR(34)&";"&CHAR(34)&"25P"&CHAR(34)&";"&CHAR(34)&"100mm"&CHAR(34)
The char(34) is like a dbl quote. Each value needs to be inside of quotes to look like a string to Visio and avoid having it change to standard units formatting. Enter your values of course. Mine are provided so you can see how it appears in the Shape Data form.
Wapperdude