Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Overridable Sub Swap( _ ByVal fromRow As Integer, _ ByVal fromColumn As Integer, _ ByVal toRow As Integer, _ ByVal toColumn As Integer, _ ByVal rowCount As Integer, _ ByVal columnCount As Integer _ ) | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As DefaultSheetSpanModel Dim fromRow As Integer Dim fromColumn As Integer Dim toRow As Integer Dim toColumn As Integer Dim rowCount As Integer Dim columnCount As Integer instance.Swap(fromRow, fromColumn, toRow, toColumn, rowCount, columnCount) | |
| C# | |
|---|---|
public virtual void Swap( int fromRow, int fromColumn, int toRow, int toColumn, int rowCount, int columnCount ) | |
Parameters
- fromRow
- Row index from which to begin swap
- fromColumn
- Column index from which to begin swap
- toRow
- Row index at which to get cell span to swap
- toColumn
- Column index at which to get cell span to swap
- rowCount
- Number of rows to swap
- columnCount
- Number of columns to swap
Example
This example adds spans to the SpanModel of the active sheet. The Swap method switches the span from the first column to the third.
| C# | Copy Code |
|---|---|
PrivatevoidPage_Load(objectsender,System.EventArgse)
{
If(this.IsPostBack)Return;
FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.RowCount=10;
FarPoint.Web.Spread.Model.DefaultSheetSpanModelmodel=(FarPoint.Web.Spread.Model.DefaultSheetSpanModel)FpSpread1.ActiveSheetView.SpanModel;
model.Add(0,0,4,1);
model.Add(0,2,2,1);
}
PrivatevoidButton1_Click(objectsender,System.EventArgse)
{
FarPoint.Web.Spread.Model.DefaultSheetSpanModelmodel=(FarPoint.Web.Spread.Model.DefaultSheetSpanModel)FpSpread1.ActiveSheetView.SpanModel;
model.Swap(0,0,0,2,4,1);
} | |
| Visual Basic | Copy Code |
|---|---|
PrivateSubPage_Load(ByValsenderAsSystem.Object,ByValeAsSystem.EventArgs)HandlesMyBase.Load
If(IsPostBack)ThenReturn
FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.RowCount=10
DimmodelAsFarPoint.Web.Spread.Model.DefaultSheetSpanModel=FpSpread1.ActiveSheetView.SpanModel
model.Add(0,0,4,1)
model.Add(0,2,2,1)
EndSub
PrivateSubButton1_Click(ByValsenderAsSystem.Object,ByValeAsSystem.EventArgs)HandlesButton1.Click
DimmodelAsFarPoint.Web.Spread.Model.DefaultSheetSpanModel=FpSpread1.ActiveSheetView.SpanModel
model.Swap(0,0,0,2,4,1)
EndSub | |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family