Visio Guy

Visio Discussions => General Visio => Topic started by: Visisthebest on April 23, 2024, 02:01:40 PM

Title: Why does Visio show two different digit separators (. or ,) in the shapesheet?
Post by: Visisthebest on April 23, 2024, 02:01:40 PM
I notice in the shapesheet Visio converts a cell reference in a user cell with say 0.25 (so 1/4) to a 0,25 in the shape data cell that references the cell. This is in the shapesheet not just in the shape data editor.

It is a bit confusing because if you enter say a 0,50 in to the shape data shapesheet cell I do get an error.

It uses commas yet you will get an error if you do so as well in a shape data shapesheet cell.

I think I overlooked this before, I wonder if it could cause issues I'm not anticipating but should be aware of.
Title: Re: Why does Visio show two different digit separators (. or ,) in the shapesheet?
Post by: Surrogate on April 23, 2024, 03:23:26 PM
Quote from: Visisthebest on April 23, 2024, 02:01:40 PMIt is a bit confusing because if you enter say a 0,50 in to the shape data shapesheet cell I do get an error.
I use Visio and MS Windows with Russian interface. I get same error too!
What about peoples with EN-US locale? 
Title: Re: Why does Visio show two different digit separators (. or ,) in the shapesheet?
Post by: wapperdude on April 23, 2024, 04:15:07 PM
Technically, yes.  But it would be expected as decimal separator is always a period in English system.  I suspect that since Visio internally uses English system, then, within shapesheet enties, it would expect the period. Haven't tried to change the language and/or the separator.  There was a discussion, not too long ago, related to this, but don't recall specifics.
Title: Re: Why does Visio show two different digit separators (. or ,) in the shapesheet?
Post by: Surrogate on April 23, 2024, 06:44:49 PM
Quote from: wapperdude on April 23, 2024, 04:15:07 PMThere was a discussion, not too long ago, related to this, but don't recall specifics.
Do you mean this thread (http://visguy.com/vgforum/index.php?topic=8076.0)?
Title: Re: Why does Visio show two different digit separators (. or ,) in the shapesheet?
Post by: wapperdude on April 23, 2024, 07:43:39 PM
Yes.  That's the one that came to mind.
Title: Re: Why does Visio show two different digit separators (. or ,) in the shapesheet?
Post by: Nikolay on April 23, 2024, 08:57:30 PM
It is not an issue, it is a feature.

Shape Sheet is considered developer tool, and uses the "internal" locale (i.e. English)
Shape Data window is considered a user tool, and uses the system locale (i.e. German)

English: "0.25" (dot as separator)
German: "0,25" (comma as separator)

This is just according to the language grammar rules.
English-speaking people are actually using dot to separate the decimal (fractional) part, even in real life!

Here is an interesting map of "dot people" vs "comma people"
(https://i.imgur.com/m7x3IEJ.png)

https://en.wikipedia.org/wiki/Decimal_separator
Title: Re: Why does Visio show two different digit separators (. or ,) in the shapesheet?
Post by: Visisthebest on April 24, 2024, 09:05:31 AM
Nikolay yes it is also a feature, but for this: in the shapesheet cells of the shape data section, floating point numbers put in directly are written like 0.50 while numbers from things like a reference to a user cell are written 0,50. Not just in the shape data editor UI but also in the shapesheet.

You get dots and commas mixed in the shapesheet.
Title: Re: Why does Visio show two different digit separators (. or ,) in the shapesheet?
Post by: wapperdude on April 24, 2024, 03:40:47 PM
Wow!  It is a feature!!!  Since I only use English, I cannot indulge in such benefits.   :o  Poor me.  ::)   ;D  ;D  ;D