Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Decimal attribute changes the comma possition when importing it to excel

Questions
Tags
Users
Badges
Andrea Fernández
(11●2) Jan 31 '17, 12:24 p.m.

Hello,

When I import a query result with few attributes, some decimal attributes change the comma position making inconsistent the exported data.
Is there any problem with the decimal export?
Thank you.

Error example: an attribute informed as '1,6667' is imported as '16,667' to the excel.

0 votes

1 answer
1,980 views
0 votes

One answer

Permanent link
Kevin Ramer
(4.5k●9●186●201) Jan 31 '17, 3:05 p.m.

That looks like locale might be a concern.  In US locale the imported value is correct with respect to the comma ( thousands separator ).  But in locale with , and . reversed ( decimal point, thousands separator ) the import is wrong.

Unfortunately, I'm not an expert on localization ( or even an idiot savant ), so I don't know where to make the locale "invert"  ;-)


0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,025

Question asked: Jan 31 '17, 12:24 p.m.

Question was seen: 1,980 times

Last updated: Jan 31 '17, 3:05 p.m.

Confirmation Cancel Confirm