Completed
Last Updated: 28 Nov 2019 14:23 by ADMIN
Naveen
Created on: 07 Oct 2019 12:57
Category: Spreadsheet
Type: Bug Report
2
Paste as Value (ctrl+shift+v) feature does not paste empty cells

Dear Concerned,

1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index

2. Copy from F3:F15

3. Paste as value (ctrl+shift+v) in H3

4. See it pasted only non-empty cells

Empty cells values should be pasted as well as Excel does.

 

4 comments
ADMIN
Dimitar
Posted on: 28 Nov 2019 14:23

Hello Naveen,

Ctrl+Shift+V is a browser specific keyboard combination, which is not supported by Spreadsheet. There is no code added to handle such pasting. Providing Paste Values only in Spreadsheet would be a new feature, which is currently not implemented. Another option is to prevent Ctrl+Shift+V combination from pasting any values in the Spreadsheet.

The purpose of Knowledge Base articles is to show how to handle common scenarios, which need specific widgets' configuration and integration to cover them. The KB article, which I suggested, shows how to handle Spreadsheet's paste event to paste only values.

Regards,
Dimitar
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Naveen
Posted on: 26 Nov 2019 14:50
I am not aware of what is the purpose of Knowledge Base but above issue can be easily reproduced and it is a bug, which I suppose should be fixed. I think please reconsider this request.
ADMIN
Dimitar
Posted on: 25 Oct 2019 10:42

Hello Naveen,

Paste as Values (Ctrl + Shift +V) is a browser specific feature, which currently works only in Chrome and Firefox. It is not working in IE and Edge for example. Previously it was working only in Chrome as I commented in Allow the Spreadsheet Copy - Paste of only values (no formatting) from Excel, when testing it in 2017. The Paste values scenario was implemented as a Knowledge Base article, handling the paste event. This is the recommended way to handle this scenario and it works on all browsers. The currently logged issue is not reproducible when using the knowledge base article approach.

Regards,
Dimitar
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
ADMIN
Nencho
Posted on: 08 Oct 2019 07:17

Hello Naveen,

Indeed, the reported problematic behavior is a bug. This ticket was converted to a BugReport, visible in our Feedback Portal. 

In addition, I have updated your Telerik points for reporting for that problem.

Please excuse us for any inconvenience caused by the bug.

Regards,


Nencho
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.