We are all spending more time in Teams or SharePoint nowadays, but not everyone knows that Visio documents can now be shared and collaborated with, and even set as a Teams tab. I was trying to think of a suitable demonstration of the co-working and collaboration possibilities, and came up with a reworking of an earlier post about playing checkers with Visio. Since this previous document was made before Visio for the web, I made some enhancements that work just as well with Visio for desktop and Visio for the web. This article explains a few ShapeSheet customisations that can be developed in Visio for the desktop, but can then be used in Visio for the web. Notice how each player can see which piece was moved by their opponent because their initials are displayed, and this is expanded to the full name if the mouse cursor is hovered over them.

Firstly, I reminded myself of the rules of checkers (or draughts in the UK), and for the first time realised that there are three different sizes of boards, 8×8, 10×10 and 12×12. So, my new board shape has the ability of switching between each with a simple data change that can be done with the Shape Data window or a right mouse menu action. However, I have included three pages in the provided Visio document, one for each board size, along with the checkers already laid out.
Secondly, I think that one of the time-consuming parts of playing checkers is setting the pieces up for the start of a game, so I wanted to include a purely ShapeSheet way of re-positioning the pieces easily, and one that can work in Visio for the web.
The rules of the game can be opened from the right mouse menu of the Controller shape in the top left corner. The board can be reset by selecting the Reset Positions option on the right mouse menu, twice.
When a checker is taken, then it should just be moved to the side, off the board. It should not be deleted because it will be automatically re-positioned before the start of a new game.
When a checker reaches the opposite end, then the right mouse menu of the checker turns it into a King. There is no need to manually turn the back to normal mode at the end of a game, because the Reset Positions action will do this too.
The page has been set to a Fixed Grid, with the XGridSpacing and YGridSpacing set to the same dimensions of the squares in the board. This makes it easier to snap the checker pieces in the squares.
The ShapeSheet formula that does this is in the User.SizeTrigger cell of the Controller shape:
=SETF(GetRef(ThePage!XGridSpacing),"="&Width/User.Units)+
SETF(GetRef(ThePage!YGridSpacing),"="&Width/User.Units)+
SETF(GetRef(ThePage!XRulerDensity),"=0")+
SETF(GetRef(ThePage!YRulerDensity),"=0")+
SETF(GetRef(ThePage!XGridDensity),"=0")+
SETF(GetRef(ThePage!YGridDensity),"=0")
The User.Units value is 8, 10 or 12, depending upon the Prop.Size option selected. The change in value will cause the formula in User.SizeTrigger to set the desired changes in the page cells.
So, how does the position resetting work? Well, there is a ResetPositions User-defined cell whose value is toggled between TRUE and FALSE by the Reset Positions action of the Controller shape.
When the User.ResetPositions value in the page is TRUE, then in value causes the formula in the User.PinTrigger of each Checker shape to set the PinX, PinY, Prop.King and Prop.Color formulas. These formulas are captured when the User.SetPositions vale in the page is TRUE.
=IF(ThePage!User.SetPositions,
SETF(GetRef(User.PinX),"="&PinX)+
SETF(GetRef(User.PinY),"="&PinY)+
SETF(GetRef(User.Color),"="&User.ColorIdx)
,
IF(ThePage!User.ResetPositions,
SETF(GetRef(PinX),"="&User.PinX)+
SETF(GetRef(PinY),"="&User.PinY)+
SETF(GetRef(Prop.King),"=FALSE")+
SETF(GetRef(Prop.Color),"=INDEX("&User.Color&",Prop.Color.Format)")
,
0)
)
Note that the right mouse menu of the page is not available in Visio for the web, so the Controller shape duplicates these actions, but I have left the Set Positions row as invisible, since it is only required to capture the formulas when the board has been initially laid out. After that, the only action required is the Reset Positions one.
All in all, I think that this demonstrates that Visio for the desktop can be used to create smart Visio documents that can be edited in Visio for the web.
Please download the Online Checkerboards.vsdx and try it in your own Office365 tenant, and maybe include it as a tab in Teams.
Play Backgammon with Visio
Still in lockdown on holiday, so I thought I would create a version of backgammon that can be played with Visio for the web. This was inspired by my original Visio tutor, the late David Edson, who created a Visio backgammon document which included macros. Macros are not available in Visio for the web, so…
Play Chess with Visio in Teams
Following on from my last article about playing checkers with Visio in Teams, I decided that I should also revisit my earlier Visio chessboard to make it work in Visio online. I have implemented the ability to automatically reset the positions before a new game, and I have made a single chess piece shape that…
Visio is NOT Vizio!
Update 1 : Microsoft read this post and immediately corrected the spelling so the following now works : https://adoption.microsoft.com/virtual-hub/search/?_sft_vh_product=microsoft-visio 🙂 Update 2 : Mr VisGuy! “spelt” is the same as “spelled” outside USA! Aarghh! What kind of message is sent out if a company does not know how to spell the name of their own…
Visio now and beyond at Microsoft Ignite 2020
I have presented at the last four Microsoft Ignite conferences and was part way through the world-wide tour when this pandemic began. I was looking forward to visiting New Orleans for this years shindig, but, alas, we are now in a new world where in-person events are a fond memory. Fortunately, Microsoft have the tools…
Manual Fix for Slide Snippets in Visio Plan 2
Microsoft Visio Plan 2 has a cool feature, Slide Snippets, that can create a PowerPoint slide show from special rectangle shapes placed around the pages of a Visio document. Unfortunately, there is currently an issue with distortion of the images in PowerPoint, so I will show how this can be fixed manually… (more…)
Learn how to create custom Visio web app templates
I have now finished three articles about the differences between the Visio desktop and web apps, and how you can already create custom templates for Visio Plan 1. Comparing Visio for the Web and Desktop Customising Visio shapes for the web app Key differences between the Visio desktop and web apps Register for my webinar…
Leave a Reply