Spread Windows Forms 17
Spread Windows Forms 17.0 Product Documentation / Developer's Guide / Rows and Columns / Moving Rows or Columns
In This Topic
    Moving Rows or Columns
    In This Topic

    You can allow the user to drag and move rows or columns. Set the AllowRowMove property to allow the user to move rows and the AllowColumnMove property to allow the user to move columns. If you wish to allow the user to move multiple rows or columns, also set the AllowRowMoveMultiple or AllowColumnMoveMultiple property.

    You can hide the drag band while moving the row or column with the ShowDragBandOnMoving property.

    For the user to move rows or columns, they left click on the header of the row or 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 (for multiple rows or columns, select them first). The row or column that is being moved is shown in a transparent clone attached to the pointer, as shown in this figure, where the fourth column is being moved to the left.

    Moving a Column by Dragging

    Moving the Row or Column in Code

    To relocate a row, use the SheetView.SheetView method; to remove multiple rows at a time, use the SheetView.RemoveRows method. To relocate a column, use the SheetView.MoveColumn method; to remove multiple columns at a time, use the SheetView.RemoveColumns method. Alternatively, you can use the Move method of the DefaultSheetAxisModel class.

    You can use the GetColumnFromTag method to find columns based on their Tag property, which you can set programmatically to whatever you want. You can do the same with the Tag method for rows.

    You can also delete multiple rows with the Remove method of the Rows class which represents a range of rows. Similarly, you can also remove multiple columns with the Remove method of the Columns class. For example,

    C#
    Copy Code
    fpSpread1.Sheets[0].Columns[1, 5].Remove();
    
    Visual Basic
    Copy Code
    FpSpread1.Sheets(0).Columns(1, 5).Remove()
    

    Using the Properties Window

    1. At design time, in the Properties window, select the Spread component.
    2. In the Misc category, select the AllowRowMove or the AllowColumnMove property.
    3. Click the drop-down arrow to display the choices and select the value (True or False). Repeat this for each property.

    Method to set

    Set the AllowRowMove or AllowColumnMove property for the FpSpread component.

    Example

    This example allows the user to move columns or rows.

    C#
    Copy Code
    fpSpread1.AllowRowMove = true;
    fpSpread1.AllowColumnMove = true;
    
    VB
    Copy Code
    fpSpread1.AllowRowMove = True
    fpSpread1.AllowColumnMove = True
    

    Using the Spread Designer

    1. Select Spread from the drop-down combo list located on the top right side of the Designer.
    2. From the Misc section, select True or False for AllowRowMove or AllowColumnMove.
    3. From the File menu, select Save and Exit to save the changes.
    See Also