SPREAD for .NET Windows Forms Edition.

使SPREAD处于编辑状态.
private void Form1_Load(object sender, System.EventArgs e)
{
　　fpSpread1.EditModePermanent = true;　
　　// 定义一个ENTER事件
　　FarPoint.Win.Spread.InputMap inputmap1;
　　inputmap1 = fpSpread1.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused);
　　inputmap1.Put(new FarPoint.Win.Spread.Keystroke(Keys.Enter, Keys.None), FarPoint.Win.Spread.SpreadActions.None);
}

private void fpSpread1_EditModeOn(object sender, System.EventArgs e)
{
　　//
　　fpSpread1.EditingControl.KeyDown += new System.Windows.Forms.KeyEventHandler(this.fpSpread1_KeyDown);
}

private void fpSpread1_EditModeOff(object sender, System.EventArgs e)
{
　　//
　　fpSpread1.EditingControl.KeyDown -= new System.Windows.Forms.KeyEventHandler(this.fpSpread1_KeyDown);
}

private void fpSpread1_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e)
{
　　if (e.KeyCode == Keys.Enter)
　　{
　　　　Console.WriteLine("ENTER.KEYDOWN");
　　}
}

以下是VB.NET
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
　　FpSpread1.EditModePermanent = True
　　
　　Dim im As New FarPoint.Win.Spread.InputMap
　　im = FpSpread1.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused)
　　im.Put(New FarPoint.Win.Spread.Keystroke(Keys.Enter, Keys.None), FarPoint.Win.Spread.SpreadActions.None)
End Sub

Private Sub FpSpread1_EditModeOn(ByVal sender As Object, ByVal e As System.EventArgs) Handles FpSpread1.EditModeOn
　　''进入编辑状态
　　Dim KeyDownHandler As KeyEventHandler = AddressOf FpSpread1_KeyDown
　　AddHandler FpSpread1.EditingControl.KeyDown, KeyDownHandler
End Sub

Private Sub FpSpread1_EditModeOff(ByVal sender As Object, ByVal e As System.EventArgs) Handles FpSpread1.EditModeOff
　　''解除编辑状态
　　Dim KeyDownHandler As KeyEventHandler = AddressOf FpSpread1_KeyDown
　　RemoveHandler FpSpread1.EditingControl.KeyDown, KeyDownHandler
End Sub

Private Sub FpSpread1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles FpSpread1.KeyDown
　　If e.KeyCode = Keys.Enter Then
　　　　Debug.WriteLine("Enter.KeyDown")
　　End If
End Sub

方法3:

private void fpSpread1_EditModeOn(object sender, System.EventArgs e)
{

     //Handle respective Key events at the timing when cell editing begins.
     fpSpread1.EditingControl.KeyDown += new KeyEventHandler(this.fpSpread1_KeyDown);
    
     fpSpread1.EditingControl.KeyPress += new KeyPressEventHandler(this.fpSpread1_KeyPress);
    
     fpSpread1.EditingControl.KeyUp += new KeyEventHandler(this.fpSpread1_KeyUp);
    
}

private void fpSpread1_EditModeOff(object sender, System.EventArgs e)
{

     //Release respective Key event handles at the timing when cell editing is complete.
     fpSpread1.EditingControl.KeyDown -= new KeyEventHandler(this.fpSpread1_KeyDown);

     fpSpread1.EditingControl.KeyPress -= new KeyPressEventHandler(this.fpSpread1_KeyPress);

     fpSpread1.EditingControl.KeyUp -= new KeyEventHandler(this.fpSpread1_KeyUp);

}

private void fpSpread1_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e)
{
     Console.WriteLine("KeyDown event: " + e.KeyCode.ToString());
}

private void fpSpread1_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e)
{
     Console.WriteLine("KeyPress event: " + e.KeyChar.ToString());
}

private void fpSpread1_KeyUp(object sender, System.Windows.Forms.KeyEventArgs e)
{
     Console.WriteLine("KeyUp event: " + e.KeyCode.ToString());
}

Visual Basic .NET Code

Private Sub FpSpread1_EditModeOn(ByVal sender As Object, ByVal e As System.EventArgs) Handles FpSpread1.EditModeOn

     'Handle respective Key events at the timing when cell editing begins.
     Dim KeyDownHandler As KeyEventHandler = AddressOf FpSpread1_KeyDown
     AddHandler FpSpread1.EditingControl.KeyDown, KeyDownHandler

     Dim KeyPressHandler As KeyPressEventHandler = AddressOf FpSpread1_KeyPress
     AddHandler FpSpread1.EditingControl.KeyPress, KeyPressHandler

     Dim KeyUpHandler As KeyEventHandler = AddressOf FpSpread1_KeyUp
     AddHandler FpSpread1.EditingControl.KeyUp, KeyUpHandler

End Sub

Private Sub FpSpread1_EditModeOff(ByVal sender As Object, ByVal e As System.EventArgs) Handles FpSpread1.EditModeOff

     'Release respective Key event handles at the timing when cell editing is complete.
     Dim KeyDownHandler As KeyEventHandler = AddressOf FpSpread1_KeyDown
     RemoveHandler FpSpread1.EditingControl.KeyDown, KeyDownHandler

     Dim KeyPressHandler As KeyPressEventHandler = AddressOf FpSpread1_KeyPress
     RemoveHandler FpSpread1.EditingControl.KeyPress, KeyPressHandler

     Dim KeyUpHandler As KeyEventHandler = AddressOf FpSpread1_KeyUp
     RemoveHandler FpSpread1.EditingControl.KeyUp, KeyUpHandler

End Sub

Private Sub FpSpread1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles FpSpread1.KeyDown
     Console.WriteLine("KeyDown event: " + e.KeyCode.ToString)
End Sub

Private Sub FpSpread1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles FpSpread1.KeyPress
     Console.WriteLine("KeyPress event: " + e.KeyChar.ToString)
End Sub

Private Sub FpSpread1_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles FpSpread1.KeyUp
     Console.WriteLine("KeyUp event: " + e.KeyCode.ToString)
End Sub