BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

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.


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.

Visio 2019 Pro

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 184 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1057KB.
Tokens: post-login.
Cache hits: 13: 0.00125s for 26,767 bytes (show)
Cache misses: 2: (show)
Queries used: 16.

[Show Queries]