[Solved] Unable to see floating point numbers in the shape sheet

[charlykuntz]

Hello,

I don't know what setting I adjusted wrong but actually I can't see floating point numbers of the cell's values using the Visio UI. Nevertheless I can set a value to a floating point number and Visio processes it but the value displayed in the cell is rounded to an integer. Also the format the value is displayed is quite strange where units are shown in capital letters (see attached screenshot).

I am using Visio 2013 Professional. Does anybody know a solution for this?

[charlykuntz]

After reading how to reset the user settings of Microsoft Office I exported and deleted the whole HKEY_CURRENT_USER\Software\Microsoft\Visio registry key. Then I started Visio, the registry key was created again but the ShapeSheet looked as weird as before.

Then I started investigating the subkeys of HKEY_CURRENT_USER\Software\Microsoft\Visio\Application. Then I saw the MeasurementDigits_SheetForm and MeasurementDigits_SheetVal being set to 0. Finally I set them to 4 and the formulas and values looked pretty perfect.

On this page all the registry keys of the Visio user setting are documented: http://support.microsoft.com/kb/298736/en-us

[Visio Guy]

If you just want to inspect a cell or two, you can use the FORMAT function to show lots of digits.

Here's an example of a User-cell set up to show 16 digit places:

User.CheckDigits =FORMAT(Width,"0.0000000000000000")