1. Home
  2. Forum
  3. WPF
  4. Copy from Clipboard to unlocked cells in protected Worksheet

Copy from Clipboard to unlocked cells in protected Worksheet

Hi everybody!


MAbe you can help me with the following issue:

When I try to paste the clipboard content (a table or value) into one or more unlock cells on a protected Worksheet an error message appears :-(

Maybe this issue came with the upgrade to the newes NuGet package but I actually don't know :-S

I unlock the cells like this:

IWorksheet ws = _spreadsheet.ActiveSheet;
ws.Range[iRow, iColumn].CellStyle.Locked = false;

and protect the worksheet like this:

_spreadsheet.ProtectSheet(ws, "Some Password");

Thank you very much for your help!


Victor

Attachment: 20210610_Syncfusion_SfSpreadSheet_Error_b0f9ad29.zip

2 Replies
BT Balamurugan Thirumalaikumar Syncfusion Team June 14, 2021 03:02 AM UTC

Hi Victor, 

Thank you for Interesting in Syncfusion products. 

We have checked your query “When I try to paste the clipboard content (a table or value) into one or more unlock cells on a protected Worksheet an error message appears” at our end. We could reproduce the reported scenario in spreadsheet. So, we have forwarded the use case to our development team for further analysis. We will update you with proper details on June 15, 2021. We appreciate your patience till then. 

Balamurugan Thirumalaikumar  



BT Balamurugan Thirumalaikumar Syncfusion Team June 15, 2021 11:30 AM UTC

Hi Victor,  
  
Thank you for your patience.  
  
We confirmed that the reported scenario is a defect from our end. We have logged a bug report for this issue “Pasting in unlocked cells of protected sheet is not working properly” Here we have provided private feedback link, we request you to log in to view the link further      
   
  
The fix will be available in our upcoming Volume 2 SP 1 release which is scheduled to be rolled out at the mid of August 2021. If you have any more specification replication procedure or a scenario to be tested you can add it as a comment in the portal also if the version is not correct, please specify the version in which you need the patch. 
  
Regards,   
Balamurugan.Thirumalaikumar 


Loader.
Up arrow icon