コーディングでグループ化を解除したい
対象製品
SPREAD for ASP.NET 8.0J
詳細
下記サンプルコードのように、グループデータモデルのTargetModelプロパティを使用して、グループ化されたデータモデルをオリジナルのデータモデルに戻すことでグループ化を解除できます。
◎サンプルコード(VB)
◎サンプルコード(C#)
◎サンプルコード(VB)
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If IsPostBack Then
Return
End If
FpSpread1.ActiveSheetView.AllowColumnMove = True
FpSpread1.ActiveSheetView.GroupBarVisible = True
FpSpread1.ActiveSheetView.AllowGroup = True
FpSpread1.ActiveSheetView.ColumnCount = 4
FpSpread1.ActiveSheetView.RowCount = 4
' テストデータを設定します
FpSpread1.ActiveSheetView.Cells(0, 0).Text = "Jack"
FpSpread1.ActiveSheetView.Cells(0, 1).Text = "Male"
FpSpread1.ActiveSheetView.Cells(0, 2).Text = "3000 USD"
FpSpread1.ActiveSheetView.Cells(0, 3).Text = "Teacher"
FpSpread1.ActiveSheetView.Cells(1, 0).Text = "Tommy"
FpSpread1.ActiveSheetView.Cells(1, 1).Text = "Male"
FpSpread1.ActiveSheetView.Cells(1, 2).Text = "3000 USD"
FpSpread1.ActiveSheetView.Cells(1, 3).Text = "Developer"
FpSpread1.ActiveSheetView.Cells(2, 0).Text = "Cassie"
FpSpread1.ActiveSheetView.Cells(2, 1).Text = "FeMale"
FpSpread1.ActiveSheetView.Cells(2, 2).Text = "3200 USD"
FpSpread1.ActiveSheetView.Cells(2, 3).Text = "Teacher"
FpSpread1.ActiveSheetView.Cells(3, 0).Text = "Mary"
FpSpread1.ActiveSheetView.Cells(3, 1).Text = "FeMale"
FpSpread1.ActiveSheetView.Cells(3, 2).Text = "2700 USD"
FpSpread1.ActiveSheetView.Cells(3, 3).Text = "Accountant"
End Sub
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
' クライアント側の変更を確定します
FpSpread1.SaveChanges()
' グループ化を解除します
Dim gm As FarPoint.Web.Spread.Model.GroupDataModel
gm = CType(FpSpread1.ActiveSheetView.DataModel, FarPoint.Web.Spread.Model.GroupDataModel)
FpSpread1.ActiveSheetView.DataModel = gm.TargetModel
End Sub
If IsPostBack Then
Return
End If
FpSpread1.ActiveSheetView.AllowColumnMove = True
FpSpread1.ActiveSheetView.GroupBarVisible = True
FpSpread1.ActiveSheetView.AllowGroup = True
FpSpread1.ActiveSheetView.ColumnCount = 4
FpSpread1.ActiveSheetView.RowCount = 4
' テストデータを設定します
FpSpread1.ActiveSheetView.Cells(0, 0).Text = "Jack"
FpSpread1.ActiveSheetView.Cells(0, 1).Text = "Male"
FpSpread1.ActiveSheetView.Cells(0, 2).Text = "3000 USD"
FpSpread1.ActiveSheetView.Cells(0, 3).Text = "Teacher"
FpSpread1.ActiveSheetView.Cells(1, 0).Text = "Tommy"
FpSpread1.ActiveSheetView.Cells(1, 1).Text = "Male"
FpSpread1.ActiveSheetView.Cells(1, 2).Text = "3000 USD"
FpSpread1.ActiveSheetView.Cells(1, 3).Text = "Developer"
FpSpread1.ActiveSheetView.Cells(2, 0).Text = "Cassie"
FpSpread1.ActiveSheetView.Cells(2, 1).Text = "FeMale"
FpSpread1.ActiveSheetView.Cells(2, 2).Text = "3200 USD"
FpSpread1.ActiveSheetView.Cells(2, 3).Text = "Teacher"
FpSpread1.ActiveSheetView.Cells(3, 0).Text = "Mary"
FpSpread1.ActiveSheetView.Cells(3, 1).Text = "FeMale"
FpSpread1.ActiveSheetView.Cells(3, 2).Text = "2700 USD"
FpSpread1.ActiveSheetView.Cells(3, 3).Text = "Accountant"
End Sub
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
' クライアント側の変更を確定します
FpSpread1.SaveChanges()
' グループ化を解除します
Dim gm As FarPoint.Web.Spread.Model.GroupDataModel
gm = CType(FpSpread1.ActiveSheetView.DataModel, FarPoint.Web.Spread.Model.GroupDataModel)
FpSpread1.ActiveSheetView.DataModel = gm.TargetModel
End Sub
◎サンプルコード(C#)
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
FpSpread1.ActiveSheetView.AllowColumnMove = true;
FpSpread1.ActiveSheetView.GroupBarVisible = true;
FpSpread1.ActiveSheetView.AllowGroup = true;
FpSpread1.ActiveSheetView.ColumnCount = 4;
FpSpread1.ActiveSheetView.RowCount = 4;
// テストデータを設定します
FpSpread1.ActiveSheetView.Cells[0, 0].Text = "Jack";
FpSpread1.ActiveSheetView.Cells[0, 1].Text = "Male";
FpSpread1.ActiveSheetView.Cells[0, 2].Text = "3000 USD";
FpSpread1.ActiveSheetView.Cells[0, 3].Text = "Teacher";
FpSpread1.ActiveSheetView.Cells[1, 0].Text = "Tommy";
FpSpread1.ActiveSheetView.Cells[1, 1].Text = "Male";
FpSpread1.ActiveSheetView.Cells[1, 2].Text = "3000 USD";
FpSpread1.ActiveSheetView.Cells[1, 3].Text = "Developer";
FpSpread1.ActiveSheetView.Cells[2, 0].Text = "Cassie";
FpSpread1.ActiveSheetView.Cells[2, 1].Text = "FeMale";
FpSpread1.ActiveSheetView.Cells[2, 2].Text = "3200 USD";
FpSpread1.ActiveSheetView.Cells[2, 3].Text = "Teacher";
FpSpread1.ActiveSheetView.Cells[3, 0].Text = "Mary";
FpSpread1.ActiveSheetView.Cells[3, 1].Text = "FeMale";
FpSpread1.ActiveSheetView.Cells[3, 2].Text = "2700 USD";
FpSpread1.ActiveSheetView.Cells[3, 3].Text = "Accountant";
}
protected void Button1_Click(object sender, EventArgs e)
{
// クライアント側の変更を確定します
FpSpread1.SaveChanges();
// グループ化を解除します
FarPoint.Web.Spread.Model.GroupDataModel gm;
gm = (FarPoint.Web.Spread.Model.GroupDataModel)FpSpread1.ActiveSheetView.DataModel;
FpSpread1.ActiveSheetView.DataModel = gm.TargetModel;
}
{
if (IsPostBack)
{
return;
}
FpSpread1.ActiveSheetView.AllowColumnMove = true;
FpSpread1.ActiveSheetView.GroupBarVisible = true;
FpSpread1.ActiveSheetView.AllowGroup = true;
FpSpread1.ActiveSheetView.ColumnCount = 4;
FpSpread1.ActiveSheetView.RowCount = 4;
// テストデータを設定します
FpSpread1.ActiveSheetView.Cells[0, 0].Text = "Jack";
FpSpread1.ActiveSheetView.Cells[0, 1].Text = "Male";
FpSpread1.ActiveSheetView.Cells[0, 2].Text = "3000 USD";
FpSpread1.ActiveSheetView.Cells[0, 3].Text = "Teacher";
FpSpread1.ActiveSheetView.Cells[1, 0].Text = "Tommy";
FpSpread1.ActiveSheetView.Cells[1, 1].Text = "Male";
FpSpread1.ActiveSheetView.Cells[1, 2].Text = "3000 USD";
FpSpread1.ActiveSheetView.Cells[1, 3].Text = "Developer";
FpSpread1.ActiveSheetView.Cells[2, 0].Text = "Cassie";
FpSpread1.ActiveSheetView.Cells[2, 1].Text = "FeMale";
FpSpread1.ActiveSheetView.Cells[2, 2].Text = "3200 USD";
FpSpread1.ActiveSheetView.Cells[2, 3].Text = "Teacher";
FpSpread1.ActiveSheetView.Cells[3, 0].Text = "Mary";
FpSpread1.ActiveSheetView.Cells[3, 1].Text = "FeMale";
FpSpread1.ActiveSheetView.Cells[3, 2].Text = "2700 USD";
FpSpread1.ActiveSheetView.Cells[3, 3].Text = "Accountant";
}
protected void Button1_Click(object sender, EventArgs e)
{
// クライアント側の変更を確定します
FpSpread1.SaveChanges();
// グループ化を解除します
FarPoint.Web.Spread.Model.GroupDataModel gm;
gm = (FarPoint.Web.Spread.Model.GroupDataModel)FpSpread1.ActiveSheetView.DataModel;
FpSpread1.ActiveSheetView.DataModel = gm.TargetModel;
}
キーワード
グループ化