Spread Windows Forms 17
Spread Windows Forms 17.0 Product Documentation / Version Comparison Reference / Differences in Behavior and Operation / Mapping Actions of COM in .NET
In This Topic
    Mapping Actions of COM in .NET
    In This Topic

    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.