Customize copy, prevent cut & paste

[Steve]

I am trying to figure out how to replace the copy command with my own version that can copy the row/column headers, as well as prevent cut and paste. In other controls I handled PreviewCanExecute and PreviewExecuted, but those don't seem to get triggered here. I tried to replace the editor.Commands.Copy command but it is readonly. Same with the command descriptors.

[Tanya]

Hi Steve,

Disabling the key bindings for cut and paste can be done by registering an empty command for the KeyBindings collection of the active editor:

this.radSpreadsheet.ActiveSheetEditorChanged += this.RadSpreadsheet_ActiveSheetEditorChanged;

private void RadSpreadsheet_ActiveSheetEditorChanged(object sender, EventArgs e)
{
    if (this.radSpreadsheet.ActiveWorksheetEditor != null)
    {
        this.radSpreadsheet.ActiveWorksheetEditor.KeyBindings.RegisterCommand(new DelegateCommand(p => { }), Key.C, ModifierKeys.Control, null);
    }
}

If you are using the UI of RadSpreasheet, you might need to also disable the buttons. You can achieve that by directly modifying the XAML of the control. Here is how such a button looks like in the XAML code:

<telerik:RadRibbonButton Command="{Binding Path=Cut.Command}"  IsEnabled="{Binding Path=Cut.IsEnabled}" ... />

  ...

<telerik:RadMenuItem Header="Cut" Command="{Binding Path=Cut.Command}" Visibility="{Binding Path=Cut.IsEnabled, Mode=TwoWay, Converter={StaticResource BoolToVisibilityValueConverter}}">
 ...
</telerik:RadMenuItem>

To customize the way the content is copied, you will need to create a custom command descriptor for the Paste command. I am attaching an example to show how this can be achieved.

Hope this is helpful.

Regards,
Tanya
Progress Telerik

[Prashant]

Hi Tanya,

How do we completely disable CutCopyPaste functionality for the radspreadsheet.

 

Thanks

Prashant