Copy/Paste range of data should behave like Excel

[boyandim]

Description

Pasting a single value in a multi-cell range pastes the value only to the first cell in the range.

Suggested in Ticket 1086515
Public Feedback item

Reproduction of the problem

1. Go to https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Click on cell B3 (Calzone) and press CTRL+C
3. Click on cell B4, hold the shift key and arrow down until cells B4-B7 are highlighted
4. Press CTRL+V

Current behavior

Only cell B4 receives the value of "Calzone".

Expected/desired behavior

All cells B4-B7 should have the value Calzone".

Environment

• Kendo UI version: 2019.2.619
• jQuery version: 1.12.3
• Browser: all

[veselints]

also requested in: https://supportheroes.telerik.com/ticket/1453633

[veselints]

Possible implementation is available here:
https://dojo.telerik.com/udopeJOl

[mparvanov]

1. Go to spreadsheet/index
2. Click on cell B3 (Calzone) and press CTRL+C
3. Click on cell B4, hold the shift key and arrow down until cells B4-B7 are highlighted
4. Press CTRL+V -> All cells B4-B7 have the value Calzone"
5. Press CTRL+Z

Current behavior

Only cell B4 restores its initial value.

Expected/desired behavior

All cells B4-B7 restore their initial values

[mparvanov]

1. Go to spreadsheet/index
2. Mark cells C3 to C5 and press CTRL+C
3. Click on cell C9 and press CTRL+V -> C9 to C11 values are changed from 5,4,3 to 1,2,1
4. Press CTRL+Z

Current behavior

C9 to C11 values are changed from 1,2,1 to 5,2,1

Expected/desired behavior

C9 to C11 values are changed from 1,2,1 to 5,4,3

[mparvanov]

Cells formatting is not preserved on copy/paste:

1. Select D3 to D5
2. Copy and paste - Ctrl+C and Ctrl +V
   Current behavior: the currency $ symbol is not pasted