PowerTools SPREAD for ASP.NET 8.0J
Style プロパティ (ConditionalFormat)

条件付き書式のスタイルを取得または設定します。
構文
'Declaration
 
Public Property Style As NamedStyle
public NamedStyle Style {get; set;}

プロパティ値

条件が満たされている場合に適用するスタイルを含む NamedStyle オブジェクト
次のサンプル コードは、スタイルの色を返します。
FarPoint.Web.Spread.NamedStyle above = new FarPoint.Web.Spread.NamedStyle(); 
FarPoint.Web.Spread.NamedStyle below = new FarPoint.Web.Spread.NamedStyle(); 
above.BackColor = Color.Red; 
below.BackColor = Color.Yellow; 
FarPoint.CalcEngine.Expression one; 
FarPoint.CalcEngine.Expression two; 
FarPoint.CalcEngine.Expression oneplustwo; 
FarPoint.Web.Spread.Model.DefaultSheetDataModel dm; 
one = new FarPoint.CalcEngine.DoubleExpression(100); 
two = new FarPoint.CalcEngine.DoubleExpression(20); 
oneplustwo = new FarPoint.CalcEngine.BinaryOperatorExpression(FarPoint.CalcEngine.BinaryOperatorInfo.AddOperator, one, two);

dm = (FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel; 
dm.SetExpression(1, 1, oneplustwo); 
FpSpread1.ActiveSheetView.SetConditionalFormat(1, 1, above, FarPoint.Web.Spread.ComparisonOperator.GreaterThan, one, two);

FpSpread1.ActiveSheetView.SetConditionalFormat(1, 1, below, FarPoint.Web.Spread.ComparisonOperator.LessThan, one, two); 
FarPoint.Web.Spread.ConditionalFormat[] cf; 
FarPoint.Web.Spread.ConditionalFormat item = new FarPoint.Web.Spread.ConditionalFormat(); 
cf = FpSpread1.ActiveSheetView.GetConditionalFormats(1, 1); 
foreach (int item in cf) { 
 string msg = "The style color is " + item.Style.BackColor.ToString(); 
 Response.Write("alert('" + msg + "')"); 
}
Dim above As New FarPoint.Web.Spread.NamedStyle
Dim below As New FarPoint.Web.Spread.NamedStyle
above.BackColor = Color.Red
below.BackColor = Color.Yellow

Dim one As FarPoint.CalcEngine.Expression
Dim two As FarPoint.CalcEngine.Expression
Dim oneplustwo As FarPoint.CalcEngine.Expression
Dim dm As FarPoint.Web.Spread.Model.DefaultSheetDataModel
one = New FarPoint.CalcEngine.DoubleExpression(100.0)
two = New FarPoint.CalcEngine.DoubleExpression(20.0)
oneplustwo = New FarPoint.CalcEngine.BinaryOperatorExpression(FarPoint.CalcEngine.BinaryOperatorInfo.AddOperator, one, two)
dm = FpSpread1.ActiveSheetView.DataModel
dm.SetExpression(1, 1, oneplustwo)

FpSpread1.ActiveSheetView.SetConditionalFormat(1, 1, above, FarPoint.Web.Spread.ComparisonOperator.GreaterThan, one, two)
FpSpread1.ActiveSheetView.SetConditionalFormat(1, 1, below, FarPoint.Web.Spread.ComparisonOperator.LessThan, one, two)


Dim cf As FarPoint.Web.Spread.ConditionalFormat()
Dim item As New FarPoint.Web.Spread.ConditionalFormat
cf = FpSpread1.ActiveSheetView.GetConditionalFormats(1, 1)
For Each item In cf
Dim msg As String = "The style color is " & item.Style.BackColor.ToString()
Response.Write("alert('" & msg & "')")
Next
参照

ConditionalFormat クラス
ConditionalFormat メンバ

 

 


© 2003-2015, GrapeCity inc. All rights reserved.