Pasting single value into range doesn't seem to work.

[Christopher]

A client of an app we're developing pointed this out to us, and since I know you guys are trying to match Excel behavior I thought I should point it out:

"Pasting" a single value doesn't appear to paste into a range of values like it does in Excel.

Steps to reproduce:

In excel:

1. Copy a single cell with a random value in it, say "1111".
2. Select a range of cells.
3. Paste (CTRL+V), notice all cells now have the value "1111".

In a blank spreadsheet (dojo):

1. Copy a single cell with a random value in it, say "2222".
2. Select a range of cells.
3. Paste (CTRL+V), notice only the top left cell gets the value.

Expected behavior:

Users expect the paste action to match Excel's paste action.

 

Notes:

As a developer, there's no clear path to implement support for this without hacking the widget and taking over the pasting action keybinds (ugly). If there was a "paste" event we could listen to that provided the range selected and the pasting value(s)/range and we could manipulate data before the "paste" action continued, a hack/implementation would be easier.

[Ivan Danchev]

Hello Christopher,

We are aware of the described difference in behavior between the Spreadsheet and Excel. A related enhancement issue has already been logged in our public Github repo, but it is still not scheduled for implementation, thus at present we cannot provide a time frame on when this change to the way values are pasted in the Spreadsheet will become available.

Regards,
Ivan Danchev
Progress Telerik

[Roger]

We are experiencing the same problem, which still exists in the current version of kendo ui (as appearing on the spreadsheet demo page).  

It's been a year.   Any updates or idea when the issue might be addressed?

 

[Ivan Danchev]

Hello Roger,

As of now the enhancement linked in my previous reply is not yet planned for implementation and other features took precedence in the 2018 releases. On a side note, this feature request has not been logged in our Feedback Portal, so if you want to you can log it, or we could do it on your behalf. Having it there would allow the community to vote for it. In general highly demanded features are implemented with precedence, so adding the request to the Portal could speed up its implementation.

Regards,
Ivan Danchev
Progress Telerik

[Roger]

I tried to go do the feedback portal and add an item for this, as suggested, but it felt like i was just creating another bug report. So i didn't do that and i would very much appreciate if you could do whatever it is that will get help this get resolved sooner.

Thanks.

 

roger

[Ivan Danchev]

Hi Roger,

I logged a feature request on your behalf.

Regards,
Ivan Danchev
Progress Telerik

[Roger]

Thank you.