Catch the radSpreadsheet.CommandDescriptors.SaveFile.Command event

[Patrick]

Hi,

 

I want to be able to receive the file and/or set the file for the radSpreadsheet.CommandDescriptors.SaveFile.Command  command. It appears that no event can be handled before or after the command is executed.

 

Thanks

[Nikolay Demirev]

Hi Patrick,

You could create a custom save command and bind it to the Save button command. This way you won't use the default command descriptor and you will be able to handle the opened file.

Here is the default command implementation which you could use in your custom command:

SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = FileDialogsHelper.GetSaveFileDialogFilter();

saveFileDialog.FileName = editor.Owner.Workbook.Name;

if (saveFileDialog.ShowDialog() == true)
{
    string extension = Path.GetExtension(saveFileDialog.SafeFileName);
    using (Stream output = saveFileDialog.OpenFile())
    {
        WorkbookFormatProvidersManager.Export(editor.Owner.Workbook, extension, output);
    }
}

I hope this helps.

Regards,
Nikolay Demirev
Telerik by Progress

[Coopbase]

I am struggling on this at this moment.

 

How to create "custom command". I am playing with sample Spreadsheet that comes with Telerik UI for WPF template > Excel.

 

1. I want to change Ctrl + S to route to new methods that I created.

2. I want to change the Command="{Binding Path=SaveFile.Command}"

So far, what I have seen are old samples based on SilverLight.  

 

thank you very much,

 

Rene

 

[Coopbase]

Ignore this post.  I got it, finally.  I overthink.  Thanks.

[Robby]

Hi,

Can you give more info how to create a custom save command to overwrite the default save behaviour?

Thanks

[Tanya]

Hi,

In RadSpreadsheet you can customize the command descriptors for the key bindings and insert the desired logic there:

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

In the above example, the SaveCommandHandler() method should contain the logic that needs to be executed when users press Ctrl+S, or you can pass null if you don't need to execute anything. Please, note that this modification of the bindings should be applied when the ActiveSheetEditor is changed.

If you are using the ribbon of RadSpreadsheet, you can expand its XAML code and directly modify the buttons there or add new ones.

Hope this is helpful.

Regards,
Tanya
Progress Telerik

[Robby]

Hi,

This solution does not catch the save button on the quick access bar and in the application menu. We want to catch all possible save actions in the software.

Regards,

Robby

[Dimitar]

Hi Robby, 

This should be handled separately. Once the editable XAML of the ribbon is extracted (see the above post). You can assess the save buttons and bind the custom commands or handle their click events. I have attached some screenshots that show this as well. 

Let me know if I can assist you further.