Thank you for the sample application and file.
The reason why the delete and the back buttons do not work in this case is that when the sheet is protected, these key bindings are removed altogether, regardless of whether the currently selected cells are unlocked or not. This behavior is indeed different from the one in Excel, so I've included this in our backlog and I'm hoping we will fix it soon. I am updating your Telerik points as a token of our appreciation for pointing this out.
As you've mentioned before that you are unable to download our LIBs, I've tried to find a workaround that you can implement. What you can do is you can add the key bindings for the delete and back buttons yourself with your own command. The following snippet shows an example of how to do this without allowing the protected cells to be deleted.
RadWorksheetEditor editor =
ICommand clearCommand =
> isLocked = editor.Worksheet.Cells[editor.Selection.SelectedRanges].GetIsLocked();
(!isLocked.IsIndeterminate && !isLocked.Value)
editor.KeyBindings.RegisterCommand(clearCommand, Key.Delete, ModifierKeys.None);
editor.KeyBindings.RegisterCommand(clearCommand, Key.Back, ModifierKeys.None);
I hope this helps.
Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos
and start improving your app based on facts, not hunches.