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.
The second 32 of the Visio ShapeSheet functions that start with the letters D through to F 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. Each of the ShapeSheet functions that start with the letters…
The first 36 of the Visio ShapeSheet functions that start with the letters A through to C 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. (more…)
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…
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…
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…
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…