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.
Set the AllowRowMove property.
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: