The Spread COM properties EditEnterAction and ProcessTab are not available in Spread.NET, but their behavior can be duplicated by setting input maps.
The following Visual Basic code sets the input maps for Normal operation mode to move the active cell to the left when the user presses the Enter key, re-creating one of the settings of the EditEnterAction property.
| VB |
Copy Code
|
|---|---|
Dim im As 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.MoveToPreviousColumn) im=FpSpread1.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenFocused) im.Put(New FarPoint.Win.Spread.Keystroke(Keys.Enter, Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToPreviousColumn) |
|
The following Visual Basic code sets the Tab and Shift+Tab keys to move the focus between components, and not move the active cell in the Spread component, re-creating the ProcessTab property’s False setting.
| VB |
Copy Code
|
|---|---|
Dim im As FarPoint.Win.Spread.InputMap im = FpSpread1.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused) im.Put(New FarPoint.Win.Spread.Keystroke(Keys.Tab, Keys.None), FarPoint.Win.Spread.SpreadActions.None) im = FpSpread1.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused) im.Put(New FarPoint.Win.Spread.Keystroke(Keys.Tab, Keys.Shift), FarPoint.Win.Spread.SpreadActions.None) |
|
For more information about input maps, action maps, and keystroke processing, refer to the chapter on Keyboard Interaction in the Spread Window Forms Developer’s Guide.