Spread Windows Forms 10.0 Product Documentation
MoveToPreviousColumnVisual Field
Example 


Moves the active cell to the left one column.
Syntax
'Declaration
 
Public Shared ReadOnly MoveToPreviousColumnVisual As Object
'Usage
 
Dim value As Object
 
value = SpreadActions.MoveToPreviousColumnVisual
public static readonly object MoveToPreviousColumnVisual
Example
This example uses the MoveToPreviousColumnVisual action.
FarPoint.Win.Spread.InputMap im;
im = fpSpread1.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenFocused);
im.Put(new FarPoint.Win.Spread.Keystroke(Keys.P, Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToPreviousColumnVisual);
Dim im As FarPoint.Win.Spread.InputMap
im = FpSpread1.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenFocused)
im.Put(New FarPoint.Win.Spread.Keystroke(Keys.P, Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToPreviousColumnVisual)
Remarks

This action moves the focus to the cell in the previous column to the left by visual layout in the same row in the sheet. This action is similar to the MoveToPreviousColumn action. The difference is in the meaning of Previous. Instead of defining Previous based on cell coordinates (that is, PreviousColumn is ActiveColumn - 1), this action defines Previous based on the left to right visual layout of the columns on the screen (that is, PreviousColumn is column that is visually left of ActiveColumn and NextColumn is column that is visually right of ActiveColumn). With the new actions and bindings, the left key will always move left and the right key will always move right regardless of the control's RightToLeft property setting. The suffix "Visual" (as in MoveToNextColumnVisual) indicates that the action is using a visual ordering (for example, previous column is defined as the column to the left) rather than a logic ordering (for example, previous column index is defined as current column index - 1). The Visual suffix on the names of the new actions indicates that the definition of Previous is based on the left-to-right visual layout of the columns.

The default key combination assigned to this action is the left arrow key or Ctrl+left arrow key combination.

You can use this action along with a custom key combination by defining your own input or action map. For more information about maps, see Managing Keyboard Interactions.

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

SpreadActions Class
SpreadActions Members

 

 


Copyright © GrapeCity, inc. All rights reserved.