Can the Ctrl + A key combination only select used cells?

[özer]

Hi.

As is known, Ctrl + A selects all cells in the spreadsheet. Can we change this to only select cells that are full?

[Dimitar]

Hi Ozer,

You need to create a custom input behavior and override the ProcessKeyDown method. Here is a sample implementation of this:

public partial class RadForm1 : Telerik.WinControls.UI.RadForm
{
    public RadForm1()
    {
        InitializeComponent();

        radSpreadsheet1.InputHandler = new MyInputBehavior(this.radSpreadsheet1.SpreadsheetElement);
    }
}

class MyInputBehavior : SpreadsheetInputBehavior
{
    RadSpreadsheetElement spreadsheet;

    public MyInputBehavior(RadSpreadsheetElement spreadsheet) : base (spreadsheet)
    {
        this.spreadsheet = spreadsheet;
    }

    public override void ProcessKeyDown(System.Windows.Forms.KeyEventArgs e)
    {
        if (e.Control && e.KeyCode == Keys.A)
        {
            CellRange usedRange = this.spreadsheet.ActiveWorksheet.UsedCellRange;
            spreadsheet.ActiveWorksheetEditor.Selection.Select(usedRange);
            return;
        }
        base.ProcessKeyDown(e);
    }
}

I hope this helps. Should you have any other questions do not hesitate to ask.

Regards,
Dimitar
Progress Telerik

[özer]

Hi Dimitar,

Thanks for help. This was exactly the solution I was looking for.