It's all about the answers!

Ask a question

Decimal attribute changes the comma possition when importing it to excel


Andrea Fernández (112) | 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



permanent link
Kevin Ramer (4.5k9186201) | 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.