Displaying Inches as Fractions

I was recently asked if the Size & Position Window in Visio can display fractions of inches as fractions rather than as decimals.  Well, most people are aware than you can type fractions into the Size & Position Window, but it is immediately translated into decimals, and I cannot find any way to keep the display as fractions, however you can link Shape Data (nee Custom Properties) to the width and height.

In the image below, I have added two Shape Data rows (Prop.Width and Prop.Height) and I have linked the values of the rows to the shape’s Width and Heights with the formulae =SETATREF(Width) and =SETATREF(Height).

image

These formulae mean that any values typed into the Shape Data Window are immediately re-directed to the shape’s Width and Height cells, and the format picture ="# ##/## u" ensures that the values are displayed as fractions.

Moreover, values can be typed into either the Size & Position Window or the Shape Data Window.

In the above example, I also chose to display the Width and Height values in the text of the shape using the FIELDPICTURE(18), which displays the result as fractions.

P.S.  I’m old enough to remember Feet and Inches being called Imperial Units … it’s a sign of the times that they are now called US Units!

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

davecra.wordpress.com/

Microsoft Office Development, and more...

PowerShell.Amsterdam

Automate, Accelerate, Accurate

johnvisiomvp

Life with Visio and other Microsoft Toys!

Title (Required)

Windows Server Essentials Tips & Tricks

Nilsandrey's Weblog

Just another WordPress.com weblog

Things that Should be Easy

Every so often (too often in the IT industry) I encounter things that should have been very easy to do but turned out to be far too complicated. My favorite topics include SharePoint, .Net development, and software architecture, especially distributed systems.

Visio Guy

Shapes, Stencils, Drawings Templates, Tutorials, Tips & Developer Info for Microsoft Visio

Hannes's Virtual Earth

Tips & Tricks around Mapping and Cloud Computing

Pluralsight blog

be smart, be clear, be visual ...

%d bloggers like this: