Spread Windows Forms 9.0 Product Documentation
Mapping Actions of COM in .NET

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 Managing Keyboard Interaction in the Spread Window Forms Developer’s Guide.

See Also

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options | Documentation Feedback