Spread ASP.NET 16
Spread for ASP.NET 16 Product Documentation / Developer's Guide / Customizing User Interaction / Customizing Interaction with Rows and Columns / Allowing the User to Move Rows
In This Topic
    Allowing the User to Move Rows
    In This Topic

    You can allow the user to drag and move rows. Set the AllowRowMove property in the SheetView class to allow the user to move rows.

    For the user to move rows, they simply left click on the row header to move it and drag the header back or forth over the header area and release the mouse over the header of the desired destination.

    Using the Properties Window

    1. At design time, in the Properties window, select the FpSpread component.
    2. Select the Sheets property.
    3. Click the button to display the SheetView Collection Editor.
    4. In the Behavior section, set the AllowRowMove property.
    5. Click OK to close the SheetView Collection Editor.

    Using a Shortcut

    Set the AllowRowMove property.

    Example

    This example code sets the AllowRowMove property.

    C#
    Copy Code
    FpSpread1.ActiveSheetView.AllowRowMove = true;
    
    VB
    Copy Code
    FpSpread1.ActiveSheetView.AllowRowMove = True
    

     

    Note: Moving rows is not supported in the following scenarios:

    • In Child sheets in hierarchial displays.
    • If Spread has a data source.
    • If Spread is operating in group mode.
    • Changing row order is not permitted.