It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787
×11,924

question asked: Jan 31 '17, 12:24 p.m.
question was seen: 1,371 times
last updated: Jan 31 '17, 3:05 p.m.

Related questions

FAQ - How this Forum works

Decimal attribute changes the comma possition when importing it to excel

0
Andrea Fernández (11●2) | asked 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.

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Kevin Ramer (4.5k●8●183●200) | answered 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"  ;-)


Your answer

Register or 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.