bVisual

ShapeSheet Formulas

Published on by

Automatically displaying Visio shape text in other shapes

There are times, in Visio, when you just need to ensure that the text in a primary shape is synchronised with the text in different secondary shapes … even if they are on different pages of a Visio document. My previous article, Forcing Display Update of Inherited Data Values , describes a method of synchronising the values in Shape Data rows from a central data source in the document, and that allows for the values to be viewed and edited in multiple pages or shapes. However, the text of a Visio shape is different because it is not stored in a single ShapeSheet cell, so how can you display the text of one shape in another?

[Read more…] about Automatically displaying Visio shape text in other shapes

Published on by

Forcing Display Update of Inherited Data Values

I was going to title this “When is a truth not a truth?” because I have found that Visio can sometimes refuse to apparently update the displayed value in a cell, even though it has been changed. However, this was, in this instance, down to a misunderstanding of the formula evaluation events on my part. Take the scenario where you have some data that you want to be available to all pages and all shapes in the Visio document. There are some built-in Document Properties in Visio that are accessible to all pages and shapes using ShapeSheet functions ( eg TITLE(), SUBJECT(), COMPANY(), Categories / CATEGORY(), Tags / KEYWORDS(), Comments / DESCRIPTION(), Author / CREATOR(), MANAGER() and HYPERLINKBASE()). However, Visio does not have custom Document Properties like the other Office applications. Instead, Visio allows for the addition of User-Defined Cells and Shape Data rows in the DocumentSheet of the document. These can be uniquely named, and Shape Data rows can be given a data type (of sorts), a label, prompt and format.

These values can be accessed via a ShapeSheet function from anywhere within the document, which ensures that you only have one version of the truth. However, there is no non-developer user-interface to edit these DocumentSheet Shape Data values in Visio, so what do you do? And how can you be sure that you are always seeing these centralised values correctly?

I created the following master shape to test how this can be done. It is a group shape that contains a single StartDate Shape Data row, which is used to edit or view the date in the similarly named Shape Data row in the DocumentSheet. For good measure, I also added a similarly named Shape Data row to the page, so the Shape Data window in the page could also be used. I then used Insert / Field to display the values in the ShapeSheet, PageSheet and DocumentSheet:

[Read more…] about Forcing Display Update of Inherited Data Values

Published on by

Using Custom Fill Patterns from a List

A reader asked how to fill a shape with a custom fill pattern from a fixed list in of a shape. They had no trouble with the first 25 standard fill patterns, but couldn’t figure out how to apply a custom pattern. So, I shall try to explain how this can be done …

[Read more…] about Using Custom Fill Patterns from a List

Published on by

Visio in Microsoft 365? What’s that?

Now that a version of Visio is being rolled out as part of the commercial subscription of Microsoft 365, what is the difference between it and the Visio Web App that is delivered by Visio Plan 1 and Visio Plan 2 subscriptions?

Moreover, can a Visio diagram created by an M365 user be round-tripped with Visio Web App and Visio Desktop App users?

The current Visio editions

First of all, lets review the editions of Visio currently available:

  • Visio in Microsoft 365 – a web app that is included in M365 for business
  • Visio Web App – a web app that requires an extra Visio Plan 1 subscription
  • Visio Desktop App – a web-delivered Windows app that requires an extra Visio Plan 2 subscription (includes Visio Web App)
  • Visio Professional – a Windows app for a one-time purchase, previously installed via a msi package, now Click-to-Run and called LTSC
  • Visio Standard – a Windows app for a one-time purchase, previously installed vi a msi package, now Click-to-Run and called LTSC

So, is that clear? The good news is that all editions use the same file format, and can be viewed by anyone, with the relevant access permission, if the Visio document is stored in OneDrive or SharePoint Online/Teams. This Visio Viewer also provides visibility of the Shape Data, Hyperlinks and Comments. It also has a JavaScript API which makes it extremely useful for developing custom web pages in SharePoint Online/Teams.

[Read more…] about Visio in Microsoft 365? What’s that?

Published on by

Keeping Visio Data Graphic Items Level

My good friend Scott Helmers, Visio author and trainer, of Harvard Computing Group , recently asked for some help in keeping data graphic items level when their target shape is rotated. Fortunately, I was able to assist, so I thought I would explain how this can be done, and also update my Icon Maker macro from a few years ago. The updated macro is available to download for free and includes the extra ability of sizing the icons. I chose to use some bee stickers from the Insert / Illustrations / Icons tool in Visio Plan 2, and the Status options from the Process shape in the Basic Flowchart Shapes stencil to demonstrate.

[Read more…] about Keeping Visio Data Graphic Items Level

Published on by

Visio ShapeSheet Functions T – Z

The seventh, and final, 25 of the Visio ShapeSheet functions that start with the letters T – Z are visually described in the Visio document below that is available for download.

Please see the general introduction to this series at ShapeSheet Functions A-Z for more information.

[Read more…] about Visio ShapeSheet Functions T – Z