ComboBoxCellType自动展开

收藏

按回车键转到下一单元格，并展开已经绑定好的下拉菜单，选择好后，再按回车转到下一单元格。可否实现？？

dexteryao · dexteryao

您好您希望回车移动下一行可以通过绑定InputMap
InputMap im = fpSpread1.GetInputMap(InputMapMode.WhenFocused);
im.Put(new Keystroke(Keys.Enter, Keys.None), SpreadActions.MoveToNextRow);

combo 编辑模式自动展开可以设置

private void FpSpread1_EditModeOn(object sender, EventArgs e)
{
var a = fpSpread1.EditingControl;
if (fpSpread1.EditingControl is FpCombo)
{
var comb = fpSpread1.EditingControl as FpCombo;
comb.DroppedDown = true;
}
}

复制代码

hbzck08 · hbzck08

按回车到下一单元格，编辑模式不触发啊。

dexteryao · dexteryao

hbzck08 发表于 2016-7-14 16:25
按回车到下一单元格，编辑模式不触发啊。

回车对于combo 就是展开选择，如果您不希望回车展开下拉可以设置 comb.ShowDropDownWhenEnter = false;

private void FpSpread1_EditModeOn(object sender, EventArgs e)
{
var a = fpSpread1.EditingControl;
if (fpSpread1.EditingControl is FpCombo)
{
var comb = fpSpread1.EditingControl as FpCombo;
comb.DroppedDown = true;
comb.KeyPress += Comb_KeyPress;
comb.ShowDropDownWhenEnter = false;
}
}
private void Comb_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Enter && !(sender as FpCombo).DroppedDown)
{
fpSpread1.EditMode = false;
}
}

复制代码

回车下一行并自动展开需要实现 Aciton

private void Form1_Load(object sender, EventArgs e)
{
InputMap im = fpSpread1.GetInputMap(InputMapMode.WhenFocused);
ActionMap am = fpSpread1.GetActionMap();
im.Put(new Keystroke(Keys.Enter, Keys.None), "MoveNextAndStartEditAction");
am.Put("MoveNextAndStartEditAction", new MoveNextAndStartEditAction());
}

复制代码

class MoveNextAndStartEditAction : FarPoint.Win.Spread.Action
{
public override void PerformAction(object source)
{
if (source is SpreadView)
{
SpreadView spread = (SpreadView)source;
SheetView sheet = spread.Sheets[spread.ActiveSheetIndex];
ActionMap am = spread.GetActionMap();
var nextAction = am.Get(SpreadActions.MoveToNextRow);
if (nextAction != null)
{
nextAction.PerformAction(source);
if (sheet.ActiveCell.CellType is ComboBoxCellType)
{
spread.EditMode = true;
}
}
}
}
}

复制代码

hbzck08 · hbzck08

这个就NB了，为啥我这加载第一个下拉菜单时会卡几秒？

dexteryao · dexteryao

本帖最后由 dexteryao 于 2016-7-15 09:10 编辑

几秒？这个有点夸张了，你菜单里数据多吗，我这挺快的。之前慢嘛?如果之前不慢你注释掉新加的代码，看是什么代码的问题。

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

[已处理] ComboBoxCellType自动展开

5 个回复

活字格认证

讲师达人

悬赏达人

元老葡萄

SpreadJS 认证

SpreadJS 高级认证

微信认证勋章