Swaps the specified ranges of cells.
            
            
            
Syntax
            Parameters
- fromRow
 
- Row index of starting position of range to move
 - fromColumn
 
- Column index of starting position of range to move
 - toRow
 
- Row index of starting position of destination
 - toColumn
 
- Column index of starting position of destination
 - rowCount
 
- Number of rows in range
 - columnCount
 
- Number of columns in range
 
            
             
            
Exceptions
						
            
            
            
            
            
Example
| Visual Basic |  Copy Code | 
|---|
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5)
Dim i, j As Integer
FpSpread1.ActiveSheet.Models.Data = dataModel
For i = 0 To 4
For j = 0 To 4
dataModel.SetValue(i, j, i + 1)
Next j
Next i
dataModel.Swap(0, 0, 3, 0, 2, 2)  | 
 
| C# |  Copy Code | 
|---|
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5);
int i, j;
fpSpread1.ActiveSheet.Models.Data = dataModel;
for(i = 0; i <= 4; i++)
{
for(j = 0; j <= 4; j++)
dataModel.SetValue(i, j, i + j);
}
dataModel.Swap(0, 0, 3, 0, 2, 2); | 
 
 
            
            
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
 
            
            
See Also