Switching Metric and US Units in #Visio floor plans

I recently wrote an article comparing Metric and US Units in Visio for floor plans (see Metric vs US Units in #Visio floor plans). The intention was always to create right mouse actions on a Visio floor plan border shape to provide many alternative page sizes and scales. I have now done this, with the help of Excel and LinqPad.

This slideshow requires JavaScript.

The action formulas in the ShapeSheet all create multiple SETF(..) formulas that emulate the actions performed by the multiple tabs in the Page Setup dialog, but simplified into a single action:

SETF(GetRef(ThePage!DrawingSizeType),@DrawingSizeType)+

SETF(GetRef(ThePage!DrawingScaleType),@DrawingScaleType)+

SETF(GetRef(ThePage!DrawingResizeType),@DrawingResizeType)+

SETF(GetRef(ThePage!PageScale),@PageScale)+

SETF(GetRef(ThePage!DrawingScale),@DrawingScale)+

SETF(GetRef(ThePage!PageWidth),@PageWidth)+

SETF(GetRef(ThePage!PageHeight),@PageHeight)+

SETF(GetRef(ThePage!PagesX),1)+

SETF(GetRef(ThePage!PagesY),1)+
SETF(GetRef(ThePage!PrintPageOrientation),2)+

SETF(GetRef(ThePage!PageLeftMargin),@PageLeftMargin)+

SETF(GetRef(ThePage!PageTopMargin),@PageTopMargin)+

SETF(GetRef(ThePage!PageRightMargin),@PageRightMargin)+

SETF(GetRef(ThePage!PageBottomMargin),@PageBottomMargin)+

SETF(GetRef(ThePage!BlockSizeX),@BlockSizeX)+

SETF(GetRef(ThePage!BlockSizeY),@BlockSizeY)+

SETF(GetRef(ThePage!AvenueSizeX),@AvenueSizeX)+

SETF(GetRef(ThePage!AvenueSizeY),@AvenueSizeY)+

SETF(GetRef(ThePage!LineToNodeX),@LineToNodeX)+

SETF(GetRef(ThePage!LineToNodeY),@LineToNodeY)+

SETF(GetRef(ThePage!LineToLineX),@LineToLineX)+

SETF(GetRef(ThePage!LineToLineY),@LineToLineY)

I made an unexpected discovery … it appears that Visio has a limit of 38 custom Action rows in the ShapeSheet that can be displayed, even though many more can exist in the ShapeSheet.
This the Excel workbook tat I created to view the pages sizes, orientations and scales:

This is a Visio diagram used in this example : Pages and Scales Visio document

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

Chris Webb's BI Blog

Microsoft Analysis Services, MDX, DAX, Power Pivot, Power Query and Power BI

davecra.wordpress.com/

Microsoft Office 365 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: