FarPoint's Spread for Windows Forms Product Tour

You can allow the user to drag and move rows or columns. To move rows or columns, simply 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.

// Allow user to move rows and columns

							fpSpread1.AllowRowMove = true;

							fpSpread1.AllowColumnMove = true;

							

							' Allow user to move rows and columns

							fpSpread1.AllowRowMove = True

							fpSpread1.AllowColumnMove = True

play video

Freezing Rows or Columns

You can freeze (make unscrollable) any number of the rows or columns in a sheet. The frozen rows are always the top rows. The frozen columns are always the leftmost columns.

// Freeze the first column and row

							fpSpread1.Sheets[0].FrozenColumnCount = 1;

							fpSpread1.Sheets[0].FrozenRowCount = 1;

							

							' Freeze the first column and row

							fpSpread1.Sheets(0).FrozenColumnCount = 1

							fpSpread1.Sheets(0).FrozenRowCount =  1

play video

Trailing Freezing Rows or Columns
You can also freeze (make unscrollable) any number of the trailing bottom rows or trailing right-most columns. The frozen trailing rows and columns stay at the bottom and right of the view regardless of the scrolling. `// Freeze the last column and row fpSpread1.Sheets[0].FrozenTrailingColumnCount = 1; fpSpread1.Sheets[0].FrozenTrailingRowCount = 1; ' Freeze the last column and row fpSpread1.Sheets(0).FrozenTrailingColumnCount = 1 fpSpread1.Sheets(0).FrozenTrailingRowCount = 1`

Allowing the User to Resize Rows or Columns

You can allow the user to readjust the size of a row or column in the control. Set the Resizable property for the row to allow the user to resize rows and the Resizable property for the column to allow the user to resize columns. You can also select which rows can be resized.

// Turn on resizing for all columns in the row header

							fpSpread1.Sheets[0].RowHeader.Columns.Default.Resizable = true;

							

							' Turn on resizing for all columns in the row header

							fpSpread1.Sheets(0).RowHeader.Columns.Default.Resizable = true