Hello everyone!
First of all, thanks a lot to Visio Guy! I learnt a lot from your website!
So, I'm an IT technician in a small business where we manage infrastructure moves from our clients to Datacenters. I recently discovered the use of Visio to create layouts in order to estimate the length of the future cables that will be installed in the Datacenters.
I found the very helpful post
Simple Cabling Shape with Length Reporting and was able to create dynamic cables which show their length as well as their source and destination devices and then I create reports from visio to process that data with Excel.
Here is my issue:
The formula that I use to show the length for the cable going to the same face of the rack is :
FORMAT(0 m+PATHLENGTH(Geometry1.Path),"0.00u")
and for the cables going from to the other side of the rack :
FORMAT(1 m+PATHLENGTH(Geometry1.Path),"0.00u")
This formula is added in the .Format and .Value of a "Length" section in the Shape Data in each of my cables (It's actually directly in each master's shape data, because I've got one master per cable type).
So, it works very well BUT everytime I close the file and reopen it, all the lengths (or sometimes just a part of it) are wrong. For instance, instead of a 1.40m cable, it changed to 0.03m. From what I can see, each cable's length become randomly less than 0.10m, but never above that.
Does anyone have an idea? I searched on the forum, but didn't find anything similar..
Thanks !