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.


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.5k8178197) | 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.