You can allow the user to drag and move columns. Set the AllowColumnMove property in the SheetView class to allow the user to move columns.
For the user to move columns, they simply left click on the header of the column to move and drag the header back or forth over the header area and release the mouse over the header of the desired destination.
Moving columns is not supported in child sheets in hierarchical displays.
Return to the overview of Customizing Interaction with Rows and Columns.
Using the Properties Window
- At design time, in the Properties window, select the FpSpread component.
- Select the Sheets property.
- Click the button to display the SheetView Collection Editor.
- In the Behavior section, set the AllowColumnMove property.
- Click OK to close the SheetView Collection Editor.
Using a Shortcut
Set the AllowColumnMove property.
Example
This example code sets the AllowColumnMove property.
C# | Copy Code |
---|---|
FpSpread1.ActiveSheetView.AllowColumnMove = true;
|
VB | Copy Code |
---|---|
FpSpread1.ActiveSheetView.AllowColumnMove = True
|