Change spreadsheet default paste behaviour to paste values only

[Remy]

Dear Syncfusion Team,

While using your spreadsheet component, I faced an issue (that is probably expected) where when I cut cells and paste them elsewhere on the spreadsheet, it cuts not only the values but also the formatting and completely removes the cells from the spreadsheet as if these cells don't exist anymore instead of just clearing their content after the content was pasted elsewhere. They lose their formatting and become locked cells even though they were unlocked before the cut/paste operation. I want to prevent this from happening. Is there a way to. change the default paste behaviour on the spreadsheet to paste values only when pressing CTRL + V (or COMMAND + V on a mac)? I tried to do it programatically with the spreadsheet's keydown event detecting the CTRL + V key combination and applying the spreadsheet's .paste event specifying the type as "Values", but it seems as though the browser intercepts the CTRL + V altogether to do its own thing ignoring completely the coded .paste event.

Demonstration :

Here is a sample demonstrating the issue :

https://stackblitz.com/edit/angular-jhtxqp?file=app.component.html

Thank you,

Remy

[Sangeetha Priya Murugan]

Hi Remy, 

 

Thank you for contacting Syncfusion support. 

 

Query # 1: Unlocked cells become locked in copy/cut paste action in spreadsheet. 

 

We have checked your reported issue in our end and we considered this as an improvement. And the fix will be available our Essential studio volume 1 SP 1 2021 release. We appreciate your patience until then. You can track the status of this feature using below link from our feedback portal. We appreciate your patience until then. 

 

https://www.syncfusion.com/feedback/22194/need-to-improve-the-lockcell-functionalities-while-cut-copy-and-paste-actions  

 

Query #2: Paste values only not working programmatically. 

 

We have checked the reported issues and the paste option works only properly in our end. And CTRL + V action paste only the values instead of paste the formats in spreadsheet. In your sample also border not applied in the pasted cells. So, please ensure that you are using the latest version in your application. 

 

Could you please check the above details and get back to us, if you need any further assistance on this. 

 

Regards, 

Sangeetha M 

[Remy]

Hi,

Query #1 still seems to be broken, even with the new release. Are there any plans to fix this anytime soon?

Thank you,

Remy

[Sangeetha Priya Murugan]

Hi Remy, 

 

Thank you for your update. 

 

We have promised this fix in our Essential studio volume 1 SP1 release. Which is scheduled to be rolled out in first week of May 2021. We appreciate your patience until then. 

 

Regards, 

Sangeetha M 

[Sangeetha Priya Murugan]

Hi Remy,  

 

Thank you for your patience. 

 

We are glad to announce that our Essential Studio 2021 Volume 1 service pack release v19.1.0.63 is rolled out and is available for download under the following link. In this we have included the fix for this improvement (Unlocked cells become locked in copy/cut paste action in spreadsheet.) in our EJ2 Spreadsheet. 

https://www.syncfusion.com/forums/165437/essential-studio-2021-volume-1-service-pack-release-v19-1-0-63-is-available-for-download 

 

We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance. 

 

Regards, 

Sangeetha M