ShapeData list and units

Started by jiri, November 25, 2018, 03:31:36 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

jiri

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.

Yacine

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,"_",""))
Yacine

wapperdude

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
Visio 2019 Pro