The fourth 34 of the Visio ShapeSheet functions that start with the letters L through to N 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 L through to N are on separate pages in the following Visio document. Apart from NOW(), they all work in Visio for the Web, and the document can be downloaded and placed into OneDrive for Business or SharePoint Online. It can then be edited in Visio for the Web as a tutorial.
If the Visio document does not display above, then you can download it directly from here.
Note that NOW() triggers every minute in Visio for the Desktop, and the default date format in Visio for the Desktop is the active Windows date format, but it is the en-us format in Visio for the Web.
Related Articles
Automatic Line and Segment Lengths in Visio
Many years ago, I wrote some VBA code to calculate the length of a multi-segment line in Visio, see Automating Area and Perimeter Length Shape Data , but Microsoft have since provided a handy ShapeSheet function, PATHLENGTH(…), to do the same without any VBA. The function is described on one of the pages in Visio…
Visio ShapeSheet Functions S
The sixth 19 of the Visio ShapeSheet functions that start with the letter S 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…)
Testing Regional Settings in Visio
There are times that I have been caught out by assuming that everyone speaks “proper” English, like what I do (sic), and forgetting that there are other languages with their own formatting conventions. I think most of the world is bemused at the USA date format where they put the month before the day and…
Visio ShapeSheet Functions O-R
The fifth 33 of the Visio ShapeSheet functions that start with the letters O through to R 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…)
Visio ShapeSheet Functions G-K
The third 26 of the Visio ShapeSheet functions that start with the letters G through to K 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…)
Two Quote or Not Two Quote …
… that is the question! I have known for some time that it is safer to copy and paste code from the web into Notepad or similar, before copying and pasting that into my own code. It is not only new line characters that can be different but also the double-quotes. I recently noticed this…
Leave a Reply