When we copy numbers with different formatting from UX to excel, we see that some of the formats are not copied properly.
Here only the one with point decimal separator, which has also comma thousand separator, is copied properly, i.e. no comma separator is seen in excel only point decimal separator is seen and the value considered as number. However, for the other two, thousand separators, space and point characters are also copied to excel as it seen in the figure, therefore these values are considered as texts not number.
This issue does not exist when the values are exported to Excel via Export button.
Export to Excel:
Copy to excel:
Do you know whether there is a way to fix this?
UX version is 2021.21.11 FP2.