Copy/paste values from Excel (w/ thousands separator)

[Wei Wang]

When copying a number from Excel with commas separating thousands (e.g., 1,200 or 7,700), UX does not receive the right number on pasting. However, it seems to be work fine if there are two or more commas (e.g., 1,200,000) or if there are any decimal points (e.g., 1,200.0).

In my example, 1,200 becomes “1.2” and 7,700 becomes “7.7” after pasting into the UX Grid.

This is similar to the issue below which was marked as resolved but there are still some cases when it is not fixed.

https://bitbucket.org/apliqoc3ux/apq-c3-ux/issues/55/copy-paste-values-from-excel-is-not

[Cyrus Rashedi]

To add to this, the copy/paste issue is also present when copying data within a UX widget. Example - enter 7000 in UX, 7,000 is displayed. Then when copying that cell, the 7,000 is taken (rather than the value of 7000). This makes it so users cannot reliably copy and paste from one measure to another in UX, where this is not a problem in Arc or PAW.

I’ve tried turning off the default format (comma) in the default_constants, but I can’t seem to get UX to adopt a true “general” format (no commas).

[Ada Trajer]

Hi Cyrus,
I understand that the problem is that even when the element has general format set (without comma), after copying and pasting, the value for this element will be displayed with a comma?
If yes, then the way to solve this problem is to change the format of the element from general to fixed or change the option: 'NUMBER_FORMAT' : '#, ###; (#, ###); 0; -', which can be found in the default.constant file.

Regards,

Ada

[Ada Trajer]

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

[Scott Wiltshire]

Removing milestone: 2021_Q2 (automated comment)