Visio cant't handle regional settings

T

Toman Larsson

I am using standard metric Swedish settings in
the "Regional Settings", "," for decimal and "space" as
thousands separator.
When I'm generating a report from Visio and it is saved
as an Excel File, the all decimals disappear f.ex. if I
have "2,2555552" in one cell that is included in the
report, it is reportad as "22555552".
If I change the rgional settings in the control-panel
do "." as decimal and "," as thousands separator it works
ok. Anyone else experiencing the same problem.
 
M

Mark Nelson [MS]

OK, thanks. I tried repeating this problem with a generic shape and by
running the Shape Inventory report. This seemed to generate the correct
output. Perhaps you can try this simple case as well. Just put some shapes
in your drawing and run the Shape Inventory report. Note the Height, Width,
X Location and Y Location and see if the results are wrong.

If that works for you, then perhaps you can provide more details about the
scenario that does not work. What shapes are you reporting on, what report
are you running, what are the name of the properties that have the bad
output?
 
T

Tomas Larsson

OK, I have tested it, it works as you said ok for a
standard shape.
My shapes are either custom made or heavily customized
standard shapes.
The cells that I want a report on are all calculated with
custom formulas from the user section.
There is in total up to some 30 cells in the user section
and I need a report on up to maybe 5 of them.
The report is a created one that simply should output the
selected cells to a Excel spreadsheet with no further
calculations.
The cells contains normally no units.
This an exampel for one formula in the user section, and
this one gives me most headace with incorrect exported
data:[User.Volume] =((User.Di*10)^2*PI()/4)*
(Prop.length*10)
It displays correctly in Visio though.
And as I mentioned switching the decimal sign in the
controlpanel gave correct data, but makes an havoc with
all formulas where I have decimal constants.
Also one page in a drawing could contain upp to some 1000
shapes and there could be up to some 5-10 pages to report
on.
 
M

Mark Nelson [MS]

I tried creating a shape with more complexity, such as your volume
calculation below. This did expose a problem, though I am not sure whether
it is the same problem you are having.

There does seem to be a bug when decimal numbers in Shape Text are reported
on in locales where the decimal symbol is not a period. I did not find any
problem when similar numbers in Shapesheet cells where reported on.

Here are the simple repro steps for the bug:
- Set Locale to a locale that does not use period for a decimal symbol
- In Visio draw a rectangle
- Enter 1,234 as text for the rectangle (where "," is the locale's decimal
symbol)
- Generate a new report that reports on the shape text for each shape
- Run the report and send output to Excel for verification of number

Please let me know if the problem you are seeing extends beyond this issue.
Thanks.

--
Mark Nelson
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.


Tomas Larsson said:
OK, I have tested it, it works as you said ok for a
standard shape.
My shapes are either custom made or heavily customized
standard shapes.
The cells that I want a report on are all calculated with
custom formulas from the user section.
There is in total up to some 30 cells in the user section
and I need a report on up to maybe 5 of them.
The report is a created one that simply should output the
selected cells to a Excel spreadsheet with no further
calculations.
The cells contains normally no units.
This an exampel for one formula in the user section, and
this one gives me most headace with incorrect exported
data:[User.Volume] =((User.Di*10)^2*PI()/4)*
(Prop.length*10)
It displays correctly in Visio though.
And as I mentioned switching the decimal sign in the
controlpanel gave correct data, but makes an havoc with
all formulas where I have decimal constants.
Also one page in a drawing could contain upp to some 1000
shapes and there could be up to some 5-10 pages to report
on.
-----Original Message-----
OK, thanks. I tried repeating this problem with a generic shape and by
running the Shape Inventory report. This seemed to generate the correct
output. Perhaps you can try this simple case as well. Just put some shapes
in your drawing and run the Shape Inventory report. Note the Height, Width,
X Location and Y Location and see if the results are wrong.

If that works for you, then perhaps you can provide more details about the
scenario that does not work. What shapes are you reporting on, what report
are you running, what are the name of the properties that have the bad
output?

--
Mark Nelson
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.





.
 
M

Mark Nelson [MS]

More information:

After having our development team analyze the problem, we discovered the bug
to be caused by Excel. Sending a report to HTML or XML works fine. The
problem seems to be that Excel misinterprets numerical data that is stored
as a String type. In Visio, shape text and User-defined cells are string
data types. Excel thinks that the information is not a string and performs
its own (improper) conversion in the cell. I am passing along this
information to the Excel team.

--
Mark Nelson
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.


Mark Nelson said:
I tried creating a shape with more complexity, such as your volume
calculation below. This did expose a problem, though I am not sure whether
it is the same problem you are having.

There does seem to be a bug when decimal numbers in Shape Text are reported
on in locales where the decimal symbol is not a period. I did not find any
problem when similar numbers in Shapesheet cells where reported on.

Here are the simple repro steps for the bug:
- Set Locale to a locale that does not use period for a decimal symbol
- In Visio draw a rectangle
- Enter 1,234 as text for the rectangle (where "," is the locale's decimal
symbol)
- Generate a new report that reports on the shape text for each shape
- Run the report and send output to Excel for verification of number

Please let me know if the problem you are seeing extends beyond this issue.
Thanks.

--
Mark Nelson
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.


Tomas Larsson said:
OK, I have tested it, it works as you said ok for a
standard shape.
My shapes are either custom made or heavily customized
standard shapes.
The cells that I want a report on are all calculated with
custom formulas from the user section.
There is in total up to some 30 cells in the user section
and I need a report on up to maybe 5 of them.
The report is a created one that simply should output the
selected cells to a Excel spreadsheet with no further
calculations.
The cells contains normally no units.
This an exampel for one formula in the user section, and
this one gives me most headace with incorrect exported
data:[User.Volume] =((User.Di*10)^2*PI()/4)*
(Prop.length*10)
It displays correctly in Visio though.
And as I mentioned switching the decimal sign in the
controlpanel gave correct data, but makes an havoc with
all formulas where I have decimal constants.
Also one page in a drawing could contain upp to some 1000
shapes and there could be up to some 5-10 pages to report
on.
-----Original Message-----
OK, thanks. I tried repeating this problem with a generic shape and by
running the Shape Inventory report. This seemed to generate the correct
output. Perhaps you can try this simple case as well. Just put some shapes
in your drawing and run the Shape Inventory report. Note the Height, Width,
X Location and Y Location and see if the results are wrong.

If that works for you, then perhaps you can provide more details about the
scenario that does not work. What shapes are you reporting on, what report
are you running, what are the name of the properties that have the bad
output?

--
Mark Nelson
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.


2k2 together with Office XP and Win XP
All latest SP an known fixes applied
-----Original Message-----
What version of Visio are you using?

--
Mark Nelson
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and
confers no rights.


"Toman Larsson" <[email protected]>
wrote in message
I am using standard metric Swedish settings in
the "Regional Settings", "," for decimal and "space" as
thousands separator.
When I'm generating a report from Visio and it is saved
as an Excel File, the all decimals disappear f.ex. if I
have "2,2555552" in one cell that is included in the
report, it is reportad as "22555552".
If I change the rgional settings in the control- panel
do "." as decimal and "," as thousands separator it
works
ok. Anyone else experiencing the same problem.


.



.
 
T

Tomas Larsson

Thanx, I'll wait for the Excel update then.
-----Original Message-----
More information:

After having our development team analyze the problem, we discovered the bug
to be caused by Excel. Sending a report to HTML or XML works fine. The
problem seems to be that Excel misinterprets numerical data that is stored
as a String type. In Visio, shape text and User-defined cells are string
data types. Excel thinks that the information is not a string and performs
its own (improper) conversion in the cell. I am passing along this
information to the Excel team.

--
Mark Nelson
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.


I tried creating a shape with more complexity, such as your volume
calculation below. This did expose a problem, though
I am not sure
whether
it is the same problem you are having.

There does seem to be a bug when decimal numbers in
Shape Text are
reported
on in locales where the decimal symbol is not a
period. I did not find
any
problem when similar numbers in Shapesheet cells where reported on.

Here are the simple repro steps for the bug:
- Set Locale to a locale that does not use period for a decimal symbol
- In Visio draw a rectangle
- Enter 1,234 as text for the rectangle (where "," is
the locale's
decimal
symbol)
- Generate a new report that reports on the shape text for each shape
- Run the report and send output to Excel for verification of number

Please let me know if the problem you are seeing
extends beyond this
issue.
Thanks.

--
Mark Nelson
Microsoft Corporation

This posting is provided "AS IS" with no warranties,
and confers no
rights.
OK, I have tested it, it works as you said ok for a
standard shape.
My shapes are either custom made or heavily customized
standard shapes.
The cells that I want a report on are all calculated with
custom formulas from the user section.
There is in total up to some 30 cells in the user section
and I need a report on up to maybe 5 of them.
The report is a created one that simply should output the
selected cells to a Excel spreadsheet with no further
calculations.
The cells contains normally no units.
This an exampel for one formula in the user section, and
this one gives me most headace with incorrect exported
data:[User.Volume] =((User.Di*10)^2*PI()/4)*
(Prop.length*10)
It displays correctly in Visio though.
And as I mentioned switching the decimal sign in the
controlpanel gave correct data, but makes an havoc with
all formulas where I have decimal constants.
Also one page in a drawing could contain upp to some 1000
shapes and there could be up to some 5-10 pages to report
on.

-----Original Message-----
OK, thanks. I tried repeating this problem with a
generic shape and by
running the Shape Inventory report. This seemed to
generate the correct
output. Perhaps you can try this simple case as well.
Just put some shapes
in your drawing and run the Shape Inventory report.
Note the Height, Width,
X Location and Y Location and see if the results are
wrong.

If that works for you, then perhaps you can provide more
details about the
scenario that does not work. What shapes are you
reporting on, what report
are you running, what are the name of the properties
that have the bad
output?

--
Mark Nelson
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and
confers no rights.


2k2 together with Office XP and Win XP
All latest SP an known fixes applied
-----Original Message-----
What version of Visio are you using?

--
Mark Nelson
Microsoft Corporation

This posting is provided "AS IS" with no warranties,
and
confers no rights.


"Toman Larsson"
wrote in message
I am using standard metric Swedish settings in
the "Regional Settings", "," for decimal
and "space" as
thousands separator.
When I'm generating a report from Visio and it is
saved
as an Excel File, the all decimals disappear f.ex.
if I
have "2,2555552" in one cell that is included in the
report, it is reportad as "22555552".
If I change the rgional settings in the control-
panel
do "." as decimal and "," as thousands separator it
works
ok. Anyone else experiencing the same problem.


.



.


.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top