Dates not properly pasted when they are copied from Excel while displayed as hash tags ####

[pepinho24]

Bug report

Reported in ticket № 1429260

Reproduction of the problem

1. Create a date in a cell in Excel, e.g. 9/9/2019 with format type as "Date"; Test.xlsx

2. Shrink the column so that the date is displayed as hash tags ####;

3. Select the cell and copy it

4. Paste it in any Kendo UI Spreadsheet cell

Current behavior

The date is pasted as string with value of hash tags.

Expected/desired behavior

The date is pasted as a date

Environment

• Kendo UI: 2022.3.913

Notes

The e.ClipboardContent.data contains the hash tag string as value, so the issue should be somewhere in the clipboard pasting logic