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
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 |
---|---|
private void Page_Load(object sender,System.EventArgs e) { if(this.IsPostBack)return; FpSpread1.ActiveSheetView.ColumnCount=10; FpSpread1.ActiveSheetView.RowCount=10; FarPoint.Web.Spread.Model.DefaultSheetSpanModel model=(FarPoint.Web.Spread.Model.DefaultSheetSpanModel)FpSpread1.ActiveSheetView.SpanModel; model.Add(0,0,4,1); model.Add(0,2,2,1); } private void Button1_Click(object sender,System.EventArgs e) { FarPoint.Web.Spread.Model.DefaultSheetSpanModel model=(FarPoint.Web.Spread.Model.DefaultSheetSpanModel)FpSpread1.ActiveSheetView.SpanModel; model.Swap(0,0,0,2,4,1); } |
Visual Basic | Copy Code |
---|---|
Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles MyBase.Load If(IsPostBack)Then Return FpSpread1.ActiveSheetView.ColumnCount=10 FpSpread1.ActiveSheetView.RowCount=10 Dim model As FarPoint.Web.Spread.Model.DefaultSheetSpanModel=FpSpread1.ActiveSheetView.SpanModel model.Add(0,0,4,1) model.Add(0,2,2,1) End Sub Private Sub Button1_Click(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles Button1.Click Dim model As FarPoint.Web.Spread.Model.DefaultSheetSpanModel=FpSpread1.ActiveSheetView.SpanModel model.Swap(0,0,0,2,4,1) End Sub |
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6