SwapColumns メソッド

Visual Basic
C#

'Declaration
 
Public Sub SwapColumns( _
   ByVal fromColumn As Integer, _
   ByVal toColumn As Integer, _
   ByVal count As Integer _
)

public void SwapColumns( 
   int fromColumn,
   int toColumn,
   int count
)

パラメータ

fromColumn: 列範囲の交換元の列インデックス
toColumn: 列範囲の交換先の列インデックス
count: 交換する列数

この例では、アクティブシートのSpanModelに連結セルを追加します。SwapColumnsメソッドで、連結セルを１番目の列から２番目の列に交換します。

C#
Visual Basic

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, 1, 4, 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.SwapColumns(0, 1, 1);
}

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, 1, 4, 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.SwapColumns(0, 1, 1)
End Sub

DefaultSheetSpanModel クラス
 DefaultSheetSpanModel メンバ
 Swap メソッド
 SwapRows メソッド
 CopyColumns メソッド
 MoveColumns メソッド