Decimal attribute changes the comma possition when importing it to excel
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
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.
|