Copy/paste values from Excel is not working

Describe the bug

When copy/paste from Excel to grid values are not updated in UX as UX is seeing values as text. Double-click on individual cell after paste and value is in the cell even though it displays as 0. When grid is refreshed no values are updated. If copy/paste to individual cell then it works but copy range, select individual cell in UX grid and paste no values are updated.

To Reproduce

Copy range of values from Excel. PAste into UX. Cells must be number. Even very basic formatting doesn’t work (e.g. no thousand separator, “-” as minus indicator)

Expected behaviour

If it’s an upstream issue with rest API where one cell in batch fails then whole batch fails then UX needs to be smarter about how fields which are numeric are parsed …

strip out spaces
strip out thousand separator
convert (negative) into -negative
convert % to div100 (e.g. 10% to 0.1)
strip out any non-numeric characters

Component

Grid / Views

Version

2.4.1

Desktop (please complete the following information)

Chrome

Comments (4)