News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Visio cuts visPropTypeNumber to 4 decimals ?

Started by smelvadj, January 14, 2020, 10:34:57 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

smelvadj

Hi all,

I have a number in a shape. the type is 2= visPropTypeNumber, format is "0.00000000".

When i write e.g. 0.00005 in the shape data, then the number in the "value" field shows 0.0001. It rounds to 4 decimals!?

If i write 0.000005 then the "value" field shows 0.

It seems like visio only can handle numbers with 4 decimals !?

How can i solve this ?

I hope you can help.
Thanks!


vojo

Why...you think you more decimal places will help something??

AFAIK there is no way to change such precision

Hey Ken

Vojo:

   Given that one US dollar is currently worth about 0.0001 Bitcoin, let me add my two cents to the discussion (or should I say "my ₿0.000002") to point out that such precision can occasionally be helpful.  ;- )

   - Ken

Ken V. Krawchuk
Author
No Dogs on Mars - A Starship Story
http://astarshipstory.com

Hey Ken



Smelvadj:

   Maybe I'm missing something, but I played around a bit with this and had no trouble displaying out to eight decimals.  I saw two ways:

   On the shapesheet, in the Shape Data section, in the Format cell, I entered the value ="0.0000000" (with equals sign and quotes), and set the Value cell to 0.00000010.  When I display the shape data for the shape via right click, it shows that correct value.  I can also change it, and it does so correctly.

   Likewise, in any other shapesheet field, I used the FORMAT function to do the same thing, such as =FORMAT(User.TestField,"0.00000000") such that when I assign 0.000001 to User.TestField, the FORMATted cell contains the correct decimal value.  It also works in the Text Fields section when the tiny decimal is displayed as the shape's text.  Granted, sometimes Visio will round it to the nearest wrong value, but the FORMAT pictures override that.

   More info about the FORMAT function pictures can be found here.

   Good luck!

   - Ken

Ken V. Krawchuk
Author
No Dogs on Mars - A Starship Story
http://astarshipstory.com

wapperdude

Visio 2019 Pro

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 221 (show)
Files included: 40 - 1775KB. (show)
Memory used: 1309KB.
Tokens: post-login.
Cache hits: 13: 0.00165s for 26,767 bytes (show)
Cache misses: 2: (show)
Queries used: 16.

[Show Queries]