bVisual

ShapeSheet Functions

Published on by

Smart Radio Buttons and Check Boxes in Visio

A recent project requires an interactive tutorial within Microsoft Visio desktop where a lot of the questions need a single answer using radio buttons, or multiple-choice answers using check boxes. I thought that this would be a great use of the list containers capability because the questions and answers could be part of the container shape whilst the individual questions are presented as items in the list and automatically inheriting their particular question text from the containing list shape. So, this article provides these smart master shapes, and explains how they are built.

  • In Tutor mode, the Questions, Answers, Explanation and More Info can be edited
  • In normal mode, the Questions are presented unmarked and without explanation
  • Incorrect answers are marked with a red cross. An explanation and optional more info hyperlink is available
  • Correct answers are marked with a green tick. An explanation and optional more info hyperlink is available.
[Read more…] about Smart Radio Buttons and Check Boxes in Visio

Published on by

Using Button Face Ids in Visio

Microsoft Visio desktop has the ability to display icons from a built-in list of Office icons on Actions and Action Tags (nee Smart Tags). These can be set in the ShapeSheet by using the desired number from several thousand in the ButtonFace cell. Although there is the ability to add better icons using code, the quick ShapeSheet formulas are useful way of indicating the purpose of a command. This article simply lists the first 3,600 of these fas a quick and easy reference for me, and othe ShapeSheet disigners out there!

  • Face Ids from 0001 to 0360
  • Face Ids from 0361 to 0720
  • Face Ids from 0721 to 1400
  • Face Ids from 1441 to 1800
  • Face Ids from 1801 to 2160
  • FaceI ds from 2161 to 2520
  • Face Ids from 2521 to 2880
  • Face Ids from 2881 to 3240
  • Face Ids from 3241 to 3600
[Read more…] about Using Button Face Ids in Visio

Published on by

Grid Snapping Revisited

I have previously tackled the subject of snapping to grids in Visio desktop (see https://bvisual.net/2018/06/19/really-snapping-to-grids-in-visio/ ) but a recent project required me to improve the example because it did not respond to all cursor arrow keys. The problem was that the previous solution could not understand which arrow key had been clicked, therefore it did not know if to reposition to the previous or next grid. The new ShapeSheet code solution can now respond to the correct arrow key … and all without any add-in. In addition, I also show how a Control point can be made to snap to a grid spacing, and how AutoConnect can be set to add the next shape at the right offset in both the horizontal and vertical directions.

Lastly, Microsoft released the web edition of Visio since the last article, and I demonstrate the difference behaviour of grid snapping between that and the desktop edition.

  • Set the Horizontal and Vertical Grid Spacing
  • Turn OFF Snap to Ruler subdivisions and Grid ON
  • Edit Space between Shapes for AutoConnect
[Read more…] about Grid Snapping Revisited

Published on by

Setting Default Measurement Units in Visio Pages

Microsoft Visio can handle many different units of measurements which can be set for a page and separately for shapes, such as dimensions, within the page. This can confuse some users who expect them both to be the same all the time. In fact, the dimension units can be set to be the same as the page units, but not necessarily so. It is possible to have different units on different dimension shapes, but is also possible to set all the same with one click, and to synchronise them with the page units.

  • Page Units
  • Dimension Units
  • Page Scale
[Read more…] about Setting Default Measurement Units in Visio Pages

Published on by

Synchronizing Visio Shape Fill Color (or almost any cell) across pages

I was recently asked how the color of one shape can be changed and for other shapes to be automatically updated to the same color … even if they are on different pages! Well, it is possible with Microsoft Visio’s awesome ShapeSheet formulas. In fact, this capability is not limited to the FillForegnd cell … check out the Microsoft Learn page about SETATREF(…), and view the video below to find out more.

[Read more…] about Synchronizing Visio Shape Fill Color (or almost any cell) across pages

Published on by

Understanding Segments of Visio Geometry

I recently had to revise my understanding of the POINTALONGPATH(…) function in Visio because I was getting a #REF! error in some cases. My particular scenario requires a line with a number of vertices that are initially all in a straight line but can be moved by dragging controls around that each vertex is bound to. My assumption had been that a segment of a path is always between vertices in a geometry section, but this is not the case. So, I thought I would look deeper into the ShapeSheet functions of paths and segments. The following screenshots show a series of ShapeSheet formulas and the result of them on a single line that has 4 vertices that can be moved using a yellow control that they are bound to. Notice how the PATHLENGTH(…) formula fails to understand the segment parameter until the vertices are moved.

  • A straight line with 4 vertices
  • Then 1 vertex moved
  • With 2 vertices moved

In case the screenshots are a little dry, I have recorded a short video to explain further.

My own need was for a boundary shape around some other shapes where I wanted to make the segments disappear if they were outside of the Visio page. The unexpected #REF! values were causing distortions because the co-ordinates were failing to update.

However, I can see that this understanding of line segments and points will be useful in many types of diagrams.

For completeness, I thought I would try the same exercise with a PolyLineTo row rather than multiple LineTo rows.

  • A straight PolyLine with 4 vertices
  • Then 1 vertex moved
  • With 2 vertices moved

The PolyLineTo formula does have the advantage of being a single row, but this means that the PATHLENGTH(…) function does not have a segment index to that can be used to calculate with. In fact a PolyLineTo row does have two segments, but the last one is always 0 length!

  • Muliple LineTo Geometry rows
  • A single PolyLineTo Geometry ow

However, I was able to calculate the lengths of each segment in both cases, by using the co-ordinates of the Controls in the Tip cell for each Controls row with the SQRT(…) and POW(…) functions..

  • PATHLENGTH() matches trigonometry formula for LineTos
  • PATHLENGTH() not available for PolyLineTo row

Related articles

Fixing dimensions of 2D shapes

I am often asked what makes Visio unique and makes it stand out from the crowd, especially in today’s online world. Well, I think there are many reasons, but one of them is the ability to create scaled drawings with parametric components of specific dimensions. This was crucial for my adoption of Visio back in…

Smart Radio Buttons and Check Boxes in Visio

A recent project requires an interactive tutorial within Microsoft Visio desktop where a lot of the questions need a single answer using radio buttons, or multiple-choice answers using check boxes. I thought that this would be a great use of the list containers capability because the questions and answers could be part of the container…

Using Button Face Ids in Visio

Microsoft Visio desktop has the ability to display icons from a built-in list of Office icons on Actions and Action Tags (nee Smart Tags). These can be set in the ShapeSheet by using the desired number from several thousand in the ButtonFace cell. Although there is the ability to add better icons using code, the…

Grid Snapping Revisited

I have previously tackled the subject of snapping to grids in Visio desktop (see https://bvisual.net/2018/06/19/really-snapping-to-grids-in-visio/ ) but a recent project required me to improve the example because it did not respond to all cursor arrow keys. The problem was that the previous solution could not understand which arrow key had been clicked, therefore it did…

Synchronizing Visio Shape Fill Color (or almost any cell) across pages

I was recently asked how the color of one shape can be changed and for other shapes to be automatically updated to the same color … even if they are on different pages! Well, it is possible with Microsoft Visio’s awesome ShapeSheet formulas. In fact, this capability is not limited to the FillForegnd cell ……

Positioning Visio Shape Text Block with a Control Handle

I was recently asked how a control handle can be added to a Visio shape so that it can be used to re-position the text block. Fortunately, it is extremely easy to setup, and requires just two formulas to be updated in the ShapeSheet. This is a great use of the SETATREF(…) function. (more…)