作成日: 2017/02/23 最終更新日: 2017/02/23
文書種別
使用方法
詳細
下記サンプルコードのように、グループデータモデルのTargetModelプロパティを使用して、グループ化されたデータモデルをオリジナルのデータモデルに戻すことでグループ化を解除できます。
◎サンプルコード(VB)
◎サンプルコード(C#)
◎サンプルコード(VB)
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
' 列の移動を許可します
FpSpread1.AllowColumnMove = True
' グループ化バーを表示します
FpSpread1.ActiveSheet.GroupBarVisible = True
' グループ化を許可します
FpSpread1.ActiveSheet.AllowGroup = True
FpSpread1.ActiveSheet.ColumnCount = 4
FpSpread1.ActiveSheet.RowCount = 4
FpSpread1.ActiveSheet.Columns(0).Label = "名前"
FpSpread1.ActiveSheet.Columns(1).Label = "性別"
FpSpread1.ActiveSheet.Columns(2).Label = "報酬"
FpSpread1.ActiveSheet.Columns(3).Label = "職業"
FpSpread1.ActiveSheet.Cells(0, 0).Value = "Jack"
FpSpread1.ActiveSheet.Cells(0, 1).Value = "Male"
FpSpread1.ActiveSheet.Cells(0, 2).Value = "3000 USD"
FpSpread1.ActiveSheet.Cells(0, 3).Value = "Teacher"
FpSpread1.ActiveSheet.Cells(1, 0).Value = "Tommy"
FpSpread1.ActiveSheet.Cells(1, 1).Value = "Male"
FpSpread1.ActiveSheet.Cells(1, 2).Value = "3000 USD"
FpSpread1.ActiveSheet.Cells(1, 3).Value = "Developer"
FpSpread1.ActiveSheet.Cells(2, 0).Value = "Cassie"
FpSpread1.ActiveSheet.Cells(2, 1).Value = "FeMale"
FpSpread1.ActiveSheet.Cells(2, 2).Value = "3200 USD"
FpSpread1.ActiveSheet.Cells(2, 3).Value = "Teacher"
FpSpread1.ActiveSheet.Cells(3, 0).Value = "Mary"
FpSpread1.ActiveSheet.Cells(3, 1).Value = "FeMale"
FpSpread1.ActiveSheet.Cells(3, 2).Value = "2700 USD"
FpSpread1.ActiveSheet.Cells(3, 3).Value = "Accountant"
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If TypeOf (FpSpread1.ActiveSheet.Models.Data) Is FarPoint.Win.Spread.Model.GroupDataModel Then
' グループ化を解除します
Dim gm As FarPoint.Win.Spread.Model.GroupDataModel
gm = CType(FpSpread1.ActiveSheet.Models.Data, FarPoint.Win.Spread.Model.GroupDataModel)
If gm.SortInfo.Length > 0 Then
FpSpread1.ActiveSheet.Models.Data = gm.TargetModel
End If
End If
End Sub
' 列の移動を許可します
FpSpread1.AllowColumnMove = True
' グループ化バーを表示します
FpSpread1.ActiveSheet.GroupBarVisible = True
' グループ化を許可します
FpSpread1.ActiveSheet.AllowGroup = True
FpSpread1.ActiveSheet.ColumnCount = 4
FpSpread1.ActiveSheet.RowCount = 4
FpSpread1.ActiveSheet.Columns(0).Label = "名前"
FpSpread1.ActiveSheet.Columns(1).Label = "性別"
FpSpread1.ActiveSheet.Columns(2).Label = "報酬"
FpSpread1.ActiveSheet.Columns(3).Label = "職業"
FpSpread1.ActiveSheet.Cells(0, 0).Value = "Jack"
FpSpread1.ActiveSheet.Cells(0, 1).Value = "Male"
FpSpread1.ActiveSheet.Cells(0, 2).Value = "3000 USD"
FpSpread1.ActiveSheet.Cells(0, 3).Value = "Teacher"
FpSpread1.ActiveSheet.Cells(1, 0).Value = "Tommy"
FpSpread1.ActiveSheet.Cells(1, 1).Value = "Male"
FpSpread1.ActiveSheet.Cells(1, 2).Value = "3000 USD"
FpSpread1.ActiveSheet.Cells(1, 3).Value = "Developer"
FpSpread1.ActiveSheet.Cells(2, 0).Value = "Cassie"
FpSpread1.ActiveSheet.Cells(2, 1).Value = "FeMale"
FpSpread1.ActiveSheet.Cells(2, 2).Value = "3200 USD"
FpSpread1.ActiveSheet.Cells(2, 3).Value = "Teacher"
FpSpread1.ActiveSheet.Cells(3, 0).Value = "Mary"
FpSpread1.ActiveSheet.Cells(3, 1).Value = "FeMale"
FpSpread1.ActiveSheet.Cells(3, 2).Value = "2700 USD"
FpSpread1.ActiveSheet.Cells(3, 3).Value = "Accountant"
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If TypeOf (FpSpread1.ActiveSheet.Models.Data) Is FarPoint.Win.Spread.Model.GroupDataModel Then
' グループ化を解除します
Dim gm As FarPoint.Win.Spread.Model.GroupDataModel
gm = CType(FpSpread1.ActiveSheet.Models.Data, FarPoint.Win.Spread.Model.GroupDataModel)
If gm.SortInfo.Length > 0 Then
FpSpread1.ActiveSheet.Models.Data = gm.TargetModel
End If
End If
End Sub
◎サンプルコード(C#)
private void Form1_Load(object sender, EventArgs e)
{
// 列の移動を許可します
fpSpread1.AllowColumnMove = true;
// グループ化バーを表示します
fpSpread1.ActiveSheet.GroupBarVisible = true;
// グループ化を許可します
fpSpread1.ActiveSheet.AllowGroup = true;
fpSpread1.ActiveSheet.ColumnCount = 4;
fpSpread1.ActiveSheet.RowCount = 4;
fpSpread1.ActiveSheet.Columns[0].Label = "名前";
fpSpread1.ActiveSheet.Columns[1].Label = "性別";
fpSpread1.ActiveSheet.Columns[2].Label = "報酬";
fpSpread1.ActiveSheet.Columns[3].Label = "職業";
fpSpread1.ActiveSheet.Cells[0, 0].Value = "Jack";
fpSpread1.ActiveSheet.Cells[0, 1].Value = "Male";
fpSpread1.ActiveSheet.Cells[0, 2].Value = "3000 USD";
fpSpread1.ActiveSheet.Cells[0, 3].Value = "Teacher";
fpSpread1.ActiveSheet.Cells[1, 0].Value = "Tommy";
fpSpread1.ActiveSheet.Cells[1, 1].Value = "Male";
fpSpread1.ActiveSheet.Cells[1, 2].Value = "3000 USD";
fpSpread1.ActiveSheet.Cells[1, 3].Value = "Developer";
fpSpread1.ActiveSheet.Cells[2, 0].Value = "Cassie";
fpSpread1.ActiveSheet.Cells[2, 1].Value = "FeMale";
fpSpread1.ActiveSheet.Cells[2, 2].Value = "3200 USD";
fpSpread1.ActiveSheet.Cells[2, 3].Value = "Teacher";
fpSpread1.ActiveSheet.Cells[3, 0].Value = "Mary";
fpSpread1.ActiveSheet.Cells[3, 1].Value = "FeMale";
fpSpread1.ActiveSheet.Cells[3, 2].Value = "2700 USD";
fpSpread1.ActiveSheet.Cells[3, 3].Value = "Accountant";
}
private void button1_Click(object sender, EventArgs e)
{
if (fpSpread1.ActiveSheet.Models.Data is FarPoint.Win.Spread.Model.GroupDataModel)
{
// グループ化を解除します
FarPoint.Win.Spread.Model.GroupDataModel gm;
gm = (FarPoint.Win.Spread.Model.GroupDataModel)fpSpread1.ActiveSheet.Models.Data;
if (gm.SortInfo.Length > 0)
{
fpSpread1.ActiveSheet.Models.Data = gm.TargetModel;
}
}
}
{
// 列の移動を許可します
fpSpread1.AllowColumnMove = true;
// グループ化バーを表示します
fpSpread1.ActiveSheet.GroupBarVisible = true;
// グループ化を許可します
fpSpread1.ActiveSheet.AllowGroup = true;
fpSpread1.ActiveSheet.ColumnCount = 4;
fpSpread1.ActiveSheet.RowCount = 4;
fpSpread1.ActiveSheet.Columns[0].Label = "名前";
fpSpread1.ActiveSheet.Columns[1].Label = "性別";
fpSpread1.ActiveSheet.Columns[2].Label = "報酬";
fpSpread1.ActiveSheet.Columns[3].Label = "職業";
fpSpread1.ActiveSheet.Cells[0, 0].Value = "Jack";
fpSpread1.ActiveSheet.Cells[0, 1].Value = "Male";
fpSpread1.ActiveSheet.Cells[0, 2].Value = "3000 USD";
fpSpread1.ActiveSheet.Cells[0, 3].Value = "Teacher";
fpSpread1.ActiveSheet.Cells[1, 0].Value = "Tommy";
fpSpread1.ActiveSheet.Cells[1, 1].Value = "Male";
fpSpread1.ActiveSheet.Cells[1, 2].Value = "3000 USD";
fpSpread1.ActiveSheet.Cells[1, 3].Value = "Developer";
fpSpread1.ActiveSheet.Cells[2, 0].Value = "Cassie";
fpSpread1.ActiveSheet.Cells[2, 1].Value = "FeMale";
fpSpread1.ActiveSheet.Cells[2, 2].Value = "3200 USD";
fpSpread1.ActiveSheet.Cells[2, 3].Value = "Teacher";
fpSpread1.ActiveSheet.Cells[3, 0].Value = "Mary";
fpSpread1.ActiveSheet.Cells[3, 1].Value = "FeMale";
fpSpread1.ActiveSheet.Cells[3, 2].Value = "2700 USD";
fpSpread1.ActiveSheet.Cells[3, 3].Value = "Accountant";
}
private void button1_Click(object sender, EventArgs e)
{
if (fpSpread1.ActiveSheet.Models.Data is FarPoint.Win.Spread.Model.GroupDataModel)
{
// グループ化を解除します
FarPoint.Win.Spread.Model.GroupDataModel gm;
gm = (FarPoint.Win.Spread.Model.GroupDataModel)fpSpread1.ActiveSheet.Models.Data;
if (gm.SortInfo.Length > 0)
{
fpSpread1.ActiveSheet.Models.Data = gm.TargetModel;
}
}
}
旧文書番号
40054