Author Topic: ShapeData list and units  (Read 745 times)

0 Members and 1 Guest are viewing this topic.

jiri

  • Newbie
  • *
  • Posts: 1
ShapeData list and units
« on: November 25, 2018, 10:31:36 AM »
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

  • Hero Member
  • *****
  • Posts: 2713
Re: ShapeData list and units
« Reply #1 on: November 25, 2018, 04:17:07 PM »
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

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3855
  • Ideas Visio-lized into solutions
Re: ShapeData list and units
« Reply #2 on: November 25, 2018, 07:35:48 PM »
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