请问如何屏蔽spread7的GcDateTimeEditingControl的F5事件？

收藏

我用的是spread7
在spread7有个单元格使用的是GcDateTimeEditingControl。
现在其他的function key都能捕捉到，只有F5捕捉不到。总是执行它默认的操作（把单元格的值设置成当前系统日期）
我的使用方法如下：
'========================================================
Private Sub InitSpread()
With Me.sprList
            .EditMode = True
            .EditModePermanent = True             Dim inputmap1 As New FarPoint.Win.Spread.InputMap()
            Dim inputmap2 As New FarPoint.Win.Spread.InputMap()
            inputmap1 = .GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused)
            inputmap1.Put(New FarPoint.Win.Spread.Keystroke(Keys.Escape, Keys.None), FarPoint.Win.Spread.SpreadActions.None)
            inputmap1.Put(New FarPoint.Win.Spread.Keystroke(Keys.F1, Keys.None), FarPoint.Win.Spread.SpreadActions.None)
            inputmap1.Put(New FarPoint.Win.Spread.Keystroke(Keys.F2, Keys.None), FarPoint.Win.Spread.SpreadActions.None)
            inputmap1.Put(New FarPoint.Win.Spread.Keystroke(Keys.F3, Keys.None), FarPoint.Win.Spread.SpreadActions.None)
            inputmap1.Put(New FarPoint.Win.Spread.Keystroke(Keys.F4, Keys.None), FarPoint.Win.Spread.SpreadActions.None)
            inputmap1.Put(New FarPoint.Win.Spread.Keystroke(Keys.F5, Keys.None), FarPoint.Win.Spread.SpreadActions.None)
            inputmap1.Put(New FarPoint.Win.Spread.Keystroke(Keys.F6, Keys.None), FarPoint.Win.Spread.SpreadActions.None)
            inputmap1.Put(New FarPoint.Win.Spread.Keystroke(Keys.F7, Keys.None), FarPoint.Win.Spread.SpreadActions.None)
            inputmap1.Put(New FarPoint.Win.Spread.Keystroke(Keys.F8, Keys.None), FarPoint.Win.Spread.SpreadActions.None)
            inputmap1.Put(New FarPoint.Win.Spread.Keystroke(Keys.F9, Keys.None), FarPoint.Win.Spread.SpreadActions.None)
            inputmap1.Put(New FarPoint.Win.Spread.Keystroke(Keys.F10, Keys.None), FarPoint.Win.Spread.SpreadActions.None)
            inputmap1.Put(New FarPoint.Win.Spread.Keystroke(Keys.F11, Keys.None), FarPoint.Win.Spread.SpreadActions.None)
            inputmap1.Put(New FarPoint.Win.Spread.Keystroke(Keys.F12, Keys.None), FarPoint.Win.Spread.SpreadActions.None)
            inputmap2 = .GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenFocused)
            inputmap2.Put(New FarPoint.Win.Spread.Keystroke(Keys.Enter, Keys.None), FarPoint.Win.Spread.SpreadActions.None)
            .Enabled = False
         End With
End Sub
'========================================================
Protected Overrides Function ProcessCmdKey(ByRef msg As Message, ByVal keyData As Keys) As Boolean
      Try
         Select Case keyData
            Case Windows.Forms.Keys.Escape
                  Me.MsubESCKeyEvent()
            Case Windows.Forms.Keys.F1
                  Me.MsubF1KeyEvent()
            Case Windows.Forms.Keys.F5
                  Me.MsubF5KeyEvent()
         End Select
      Catch ex As Exception
         Throw ex
      End Try
End Function

iceman · iceman

回复 1楼dorothe的帖子

如果你指的是 detect Spread F5 快捷键，那么可以通过 fpSpread1_PreviewKeyDown 获取。

GcDateTimeEditingControl 对 F5 做了内部处理操作，我暂时还没有找办法获取。正在调查中。

dorothe · dorothe

回复 2楼iceman的帖子

多谢版主回复，
我想屏蔽GcDateTimeEditingControl自己的F5事件，这个动作在spread的keydown事件中捕捉不到。
你提到的previewkeydown事件，我没用过，现在试试去。

iceman · iceman

回复 3楼dorothe的帖子

dorothe 你好，
这个问题我已经发送给产品组调查，有结果我会反馈给你。

iceman · iceman

回复 3楼dorothe的帖子

首先需要移除 F5 的默认行为，具体做法参见代码：

private void Form1_Load(object sender, EventArgs e)
{
GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType datecell = new GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType();
datecell.MaxDate = new System.DateTime(9999, 12, 31);
datecell.MinDate = DateTime.Now;
datecell.MaxMinBehavior = GrapeCity.Win.Spread.InputMan.CellType.MaxMinBehavior.Clear;
datecell.ShortcutKeys.Remove(Keys.F5);
fpSpread1.Sheets[0].Cells[0, 0].CellType = datecell;
fpSpread1.EditModeOn += new EventHandler(fpSpread1_EditModeOn);
}
void fpSpread1_EditModeOn(object sender, EventArgs e)
{
GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeEditingControl gcec = this.fpSpread1.EditingControl as GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeEditingControl;
if (gcec != null)
{
gcec.KeyDown += new KeyEventHandler(gcec_KeyDown);
gcec.PreviewKeyDown += new PreviewKeyDownEventHandler(gcec_PreviewKeyDown);
}
}
void gcec_PreviewKeyDown(object sender, PreviewKeyDownEventArgs e)
{
throw new NotImplementedException();
}

复制代码

dorothe · dorothe

回复 5楼iceman的帖子

多谢帮助，我去试试

roger.wang · roger.wang

回复 6楼dorothe的帖子

请问，可以了吗？

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

[已处理] 请问如何屏蔽spread7的GcDateTimeEditingControl的F5事件？

6 个回复

活字格认证

微信认证勋章

元老葡萄