Visio Format Code Mysteries

I have been trying to compile a list of the various Format codes Visio uses for information. I have created a sampler shape that shows a variety of what I have found. I have found that the documentation on Visio Format codes has gaps. These are some of mysteries into.

Mystery 1. Predefined Format Codes

The only reference to Predefined Formats is in visio/about-format-pictures as a Note.

Note:

To define a date or time format picture by using Microsoft Office system formatting, enclose the format picture in double curly braces , for example, “{{m/d/yy}}”. If you are using a predefined format, for example, 201, enclose it in curly braces and angle brackets, like this: “{<201>}”

To define a date or time format picture by using Microsoft Office system formatting, enclose the format picture in double curly braces , for example, “{{m/d/yy}}”. If you are using a predefined format, for example, 201, enclose it in curly braces and angle brackets, like this: “{<201>}”

There are enumerations here visio.visfieldformats. It is strange that Visio heavily uses enumerations in SRC, but for Predefined Formats, you have to use the enumeration value rather than the enumeration.

Mystery 2. Curly and angled brackets?

Is there documentation about the curly and angled brackets other than in Mystery 1?

Mystery 3. Ft & In vs ‘ & “

So, when does Visio use the abbreviations rather than the quotes? I think I have worked that out, but not with a high confidence level.

Okay, the solution I was following used User cells to divide the value into feet and inches and then append double and single quotes. Under the Data Format -Number is Feet and inches

that results in

in the shapesheet, but where is that Text Field Format documented?

There is https://docs.microsoft.com/en-us/office/vba/visio/concepts/about-units-of-measure-visio but that is ft and in, not feet-inch.

I hope you guys can helps.

John… Visio MVP in x-aisle
JohnVisioMVP.ca

Published by johnvisiomvp

The original Visio MVP. I have worked with the Visio team since 1993

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s