Spread中Combo Cell类型在编辑时无法捕获KeyDown事件.

收藏

我们的要求是在输入Enter键后,光标位置从左到右,从上到下的跳转.
这个控制写在了KeyDown事件内.
在非编辑状态下是起效的
但是,对应Combo类型的Cell,当下拉列表展开时,Enter的效果是收起下拉列表,而不会走到我们的KeyDown事件处理内.
请问如何处理?

ZenosZeng · ZenosZeng

Spread for WinForms是通过 InputMap 来控制键盘操作，通过以下代码可以实现ComboBox编辑状态下，按Enter键之后跳转到下一个单元格：

private void Form1_Load(object sender, EventArgs e)
{
fpSpread1.ActiveSheet.RowCount = 10;
fpSpread1.ActiveSheet.ColumnCount = 5;
FarPoint.Win.Spread.CellType.ComboBoxCellType cbct = new FarPoint.Win.Spread.CellType.ComboBoxCellType();
cbct.Editable = true;
cbct.Items = new string[] { "AA","BB","CC"};
fpSpread1.ActiveSheet.Columns[0].CellType = cbct;
FarPoint.Win.Spread.InputMap im = new FarPoint.Win.Spread.InputMap();
im = fpSpread1.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenFocused);
im.Put(new FarPoint.Win.Spread.Keystroke(Keys.Enter, Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToNextColumnWrap);
im = fpSpread1.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused);
im.Put(new FarPoint.Win.Spread.Keystroke(Keys.Enter, Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToNextColumnWrap);
}

复制代码

ZenosZeng · ZenosZeng

默认情况下不会触发下拉列表的Enter事件，不过可以指定自己的下拉列表控件，主要是设置ListControl 属性，比如下面的代码：

private void Form1_Load(object sender, EventArgs e)
{
fpSpread1.ActiveSheet.RowCount = 10;
fpSpread1.ActiveSheet.ColumnCount = 5;
FarPoint.Win.Spread.CellType.ComboBoxCellType cmbocell = new FarPoint.Win.Spread.CellType.ComboBoxCellType();
ListBox list = new ListBox();
list.Items.AddRange(new Object[] { "One", "Two", "Three" });
cmbocell.ListControl = list;
cmbocell.ListControl.KeyDown += new KeyEventHandler(ListControl_KeyDown);
cmbocell.Items = (new String[] { "One", "Two", "Three" });
fpSpread1.ActiveSheet.Columns[0].CellType = cmbocell;
}
void ListControl_KeyDown(object sender, KeyEventArgs e)
{
System.Diagnostics.Debug.WriteLine(e.KeyValue);
}

复制代码

		自动登录	找回密码
密码			立即注册

[已处理] Spread中Combo Cell类型在编辑时无法捕获KeyDown事件.