PowerTools SPREAD for Windows Forms 10.0J
RangeGroupInfo プロパティ (RangeGroupStateChangedEventArgs)


状態が変更されたアウトライン(範囲グループ)に関する情報を取得します。
構文
'Declaration
 
Public ReadOnly Property RangeGroupInfo As RangeGroupInfo
'使用法
 
Dim instance As RangeGroupStateChangedEventArgs
Dim value As RangeGroupInfo
 
value = instance.RangeGroupInfo
public RangeGroupInfo RangeGroupInfo {get;}
次のサンプルコードは、特定の条件に応じてグループの色を変更します。
private void fpSpread1_RangeGroupStateChanged(object sender, FarPoint.Win.Spread.RangeGroupStateChangedEventArgs e) 
{
if ((e.IsRowGroup == false)) 
{
if ((e.RangeGroupInfo.State == FarPoint.Win.Spread.GroupState.Expanded)) 
{
e.View.Sheets[fpSpread1.ActiveSheetIndex].RangeGroupBackgroundColor = Color.Bisque;
}
}
}
Private Sub FpSpread1_RangeGroupStateChanged(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.RangeGroupStateChangedEventArgs)
Handles FpSpread1.RangeGroupStateChanged
If e.IsRowGroup = False Then
If e.RangeGroupInfo.State = FarPoint.Win.Spread.GroupState.Expanded Then
e.View.Sheets(FpSpread1.ActiveSheetIndex).RangeGroupBackgroundColor = Color.Bisque
End If
End If
End Sub
参照

RangeGroupStateChangedEventArgs クラス
RangeGroupStateChangedEventArgs メンバ

 

 


© 2004-2017, GrapeCity inc. All rights reserved.