Spread Windows Forms 11.0 Product Documentation
Swapping Data on a Sheet
Spread Windows Forms 11.0 Product Documentation > Developer's Guide > Managing Data on a Sheet > Rearranging Data on a Sheet > Swapping Data on a Sheet

You can swap the contents of two cells or two ranges of cells.

When you swap data from a cell or a range of cells to another cell or range of cells, the settings for the cell are swapped along with the data. If you provided settings for the column or the row containing the cell, or the spreadsheet, but not the cell itself, those settings are not swapped. For example, if you have set the source cell background color to red, the background color is swapped and the target cell has a red background. However, if you have set the background color of the column containing the source cell to red, that setting is not swapped.

When you swap data from one cell to another, the data in one cell becomes the data in the other cell, and vice versa. For example, if cell A1 contains the value 4 and cell B3 contains the value 6 and you swap the values of the cells, the value of cell A1 becomes 6 and the value of cell B3 becomes 4.

If you attempt to swap a range that is larger than the available range at the destination, the swap operation is not performed. For example, if you attempt to swap a range of four cells and specify the destination as a cell at the edge of the spreadsheet, the swap does not take place.

If the swap operation swaps overlapping ranges of cells, individual cells are swapped starting at the overlapping corner.

If the ranges overlap, such as moving rows 1 and 2 before row 0, you can add extra rows, move the rows, and then remove the extra rows.

For more information on methods to move or swap data, refer to their page in the API reference:

Using Code

Here is an example of swapping a range of cells.

Example

This example swaps a range.

C#
Copy Code
fpSpread1.ActiveSheet.RowCount = 10;
fpSpread1.ActiveSheet.ColumnCount = 10;
private void button1_Click(object sender, System.EventArgs e)
{
      fpSpread1.ActiveSheet.SwapRange(0, 0, 3, 0, 3, 3, true);
}
VB
Copy Code
fpSpread1.ActiveSheet.RowCount = 10
fpSpread1.ActiveSheet.ColumnCount = 10
Private Sub void button1_Click(sender As Object, e As System.EventArgs)
      fpSpread1.ActiveSheet.SwapRange(0, 0, 3, 0, 3, 3, True)
End Sub 'button1_Click

Example

This example adds rows, moves rows, and then removes the extra rows.

C#
Copy Code
fpSpread1.ActiveSheet.RowCount = 10;
fpSpread1.ActiveSheet.ColumnCount = 10;
private void button1_Click(object sender, System.EventArgs e)
{
      fpSpread1.ActiveSheet.Rows[0,1].Add() ;
      fpSpread1.ActiveSheet.MoveRange(3,0,0,0,2,4,true);
      fpSpread1.ActiveSheet.Rows[3,4].Remove();
}
VB
Copy Code
fpSpread1.ActiveSheet.RowCount = 10
fpSpread1.ActiveSheet.ColumnCount = 10
Private Sub void button1_Click(sender As Object, e As System.EventArgs)
      fpSpread1.ActiveSheet.Rows(0,1).Add()
      fpSpread1.ActiveSheet.MoveRange(3,0,0,0,2,4,True)
      fpSpread1.ActiveSheet.Rows(3,4).Remove()
End Sub 'button1_Click

When you swap ranges of data, you can specify whether formulas are adjusted. For more information, see Recalculating and Updating Formulas Automatically.

See Also