File upload widget - loaded values are wrong

[Radu Cantor]

‌

When trying to load values that are percentages, the widget automatically multiplied all values with 1000

‌

‌

[srichardson]

Hi Radu

This issue can most likely be overcome with some configuration settings.
Firstly the excel file that is being imported is using '.' as the decimal point?

If so then in the custom default.constant.js file you can configure: (If you were using german decimals ',' in excel then you wouldn’t really want to do this. )

        'INPUT_DECIMAL_POINT': '.',

This will then set the decimal point for all imported data to be '.'.

This will mean though that not all combinations of entering numbers with the german format will now work… simple cases should still work though.

This is a tricky problem to overcome and there doesn’t appear to be a way that it can be done that will work in every case.

‌

[Ada Trajer]

Issue has been resolved and the fix will be part of July release.

[Scott Wiltshire]

Removing milestone: 2020_Q4 (automated comment)