bVisual

Visio

Published on by

A visual exploration of Penrose Tiling in Visio

Maybe it is because I used to be a building architect, but I have always been fascinated by the relationship between numbers and visualisations. Perhaps the most famous one is the Golden Ratio which has been used as the basis of many building designs and art pieces. It is often recognised to create a harmony that is universally understood, and is repeatedly found in nature, yet it all boils down to a simple ratio of about 1.618 … and is related to the Fibonacci Numbers. Roger Penrose (re-)discovered shapes based on the Golden Ratio can be arranged aperiodically on an infinite canvas without a repeating pattern. These Penrose Tiling shapes were developed into two groups (P2 and P3) each with two shapes.

There are rules about the arrangement to ensure that they do not fall into a repeatable series. These rules can be followed by ensuring that the ends of the arcs within each shape meet each other. The shapes can be used to try to create an aperiodic pattern of an infinite size, and then a timer can randomly change the colours. It’s a little festive fun!

  • Kites and Darts with Arcs
  • Kites and Darts without Arcs
  • Thick and Thin Rhombi with Arcs
  • Thick and Thin Rhombi without Arcs
  • Patterned Rhombi
[Read more…] about A visual exploration of Penrose Tiling in Visio

Published on by

How SVG in Visio can cause a Shape.BoundingBox(…) error

I have used Visio’s Shape.BoundingBox(…) for many, many years and I cannot ever recall it failing, but I have now managed to create some shapes that cause it to error. This caused many hours of confusion, so I nearly abandoned using the method, until I discussed it with my fellow Visio MVP, John Goldsmith (see VisualSignals), and together we examined the cause. It came down to a badly formed sub-shape within the shape that had zero dimension … and in fact had an incomplete ShapeSheet. If you look at the screenshot below, then you may notice that there is no Shape Transform section! That is a mandatory section, and should always exist … so how did this happen?

[Read more…] about How SVG in Visio can cause a Shape.BoundingBox(…) error

Published on by

Post-Processing Paste from Clipboard in Visio

One of my current Visio VSTO add-in projects requires me to react to users pasting custom shapes in the Visio page from the clipboard. The process involves registering the ExitScope event and then checking the Clipboard contents. Initially, I was merely testing for a line in the DataObject that started with the word “Visio “, but then testing revealed that copying and pasting text from one shape to another was also getting processed, so then I added a further check that the line also finished with the word ” Shapes”. This works fine, but then I got to wonder if I could also post-process tables copied and pasted from Excel because the standard paste maintains font settings but omits the tabs and line feeds, making the text unusable without serious manual editing. This article explains how this can done.

[Read more…] about Post-Processing Paste from Clipboard in Visio

Published on by

Jumping between Shapes in Visio

Many Visio diagrams get quite large, and sometimes it is useful to provide the ability to jump to another shape quickly in the same document, either on a different page or on the same one. Although there is an add-on provided in desktop Visio that is used by the Off-Page Reference shape provided in the Basic Flowcharts Shapes stencil (see my other posts), this article is about using the hyperlinks available in both the desktop and browser editions of Visio. Fortunately, Visio desktop has the ability to create hyperlinks to a specific shape by selecting the page and entering the name of the target shape. This creation ability is not available in Visio for the web, but using the desktop created ones is!

  • Insert Field to display shape ID and Name
  • Hyperlink Sub-Address
  • Following a hyperlink
[Read more…] about Jumping between Shapes in Visio

Published on by

Co-authoring and Commenting with Visio Documents

Microsoft Visio can be used in the web browser and on the desktop, but there are several licensing options available, so which ones can be used concurrently whilst supporting co-authoring and commenting? This article tests the various scenarios but assumes that the Visio documents are stored in OneDrive for Business or SharePoint Online\Teams. The Microsoft article, Work together on Visio drawings, explains most of the scenarios, but does not clearly explain the scope of the Visio web licenses with respect to diagram types or customisations.

[Read more…] about Co-authoring and Commenting with Visio Documents

Published on by

Merging Linked Data from Similar Tables

I was recently asked how to link data from different tables but with similar column names to Visio shapes. In this case, each table has the same unique identifier, but some of the column names are the same. The problem is that the data linking matches the column name with the label of a Shape Data row label, so the shared columns were updated with the values from the last linked data recordset. In this article I present a simple way that this restriction can be overcome.

[Read more…] about Merging Linked Data from Similar Tables