Rank 1
I am registering my own command for the editor to handle copy. It works but users have reported intermittent issues which I've finally tracked down but have not been able to figure out a workaround.
editor.KeyBindings.RegisterCommand(Me.CopyCommand, Key.C, modifierKeys:=ModifierKeys.Control)
The issue is that this only works if the user clicks within the cells of the spreadsheet. If they have clicked on the row or column headers to select cells, or the "select all" in the corner without first clicking within the cells, the command is never called. Once they have clicked in the cells it works to click on the headers, but if they click on a control entirely outside of the spreadsheet, then the problem repeats.
I've tried all kinds of workarounds, including key bindings and event handlers for all the key and previewkey events on the editor, the spreadsheet, and even the header controls. None of them are ever called. Something is eating the events.
Edit: I should add I removed all other key bindings and also tried different key combinations and it still doesn't work.
Hi Steve,
I have tested this and it works on my side with the latest version of the suite. I would recommend posting a new ticket for this where you can attach your project. This will allow us to properly investigate the issue.
In addition, please make sure that the command is registered in the ActiveSheetEditorChanged event handler. This will ensure that the command is not lost when changing the editor.
I hope this helps. Should you have any other questions do not hesitate to ask.