Execute メソッド (PrePaintConditionalFormattingRule)

セルのスタイルを変更する条件付き書式ルールを実行します。

構文

Visual Basic
C#

'Declaration
 
Public Overridable Function Execute( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal value As Object _
) As PrePaintResult

public virtual PrePaintResult Execute( 
   int row,
   int column,
   object value
)

パラメータ

row: セルの行。
column: セルの列。
value: 結果スタイルを決定する値。

戻り値の型

ルール実行後の結果。

例

次のサンプルコードは、条件付きルールを作成します。

C#
Visual Basic

FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule unary = new FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo, 3);
unary.Operator = FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo;
//unary.Value = 3;
unary.BackColor = Color.Red;
unary.FontStyle = new FarPoint.Web.Spread.SpreadFontStyle(FarPoint.Web.Spread.UnderlineFontStyle.None);
unary.FontStyle.RegularBoldItalic = FarPoint.Web.Spread.RegularBoldItalicFontStyle.Bold;
FarPoint.Web.Spread.Model.CellRange range = new FarPoint.Web.Spread.Model.CellRange(0, 0, 3, 3);
FarPoint.Web.Spread.ConditionalFormatting cfequal = new FarPoint.Web.Spread.ConditionalFormatting(range);
cfequal.Add(unary);

FpSpread1.ActiveSheetView.ConditionalFormatting.Add(cfequal);
//FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, unary);
//FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, unary);

FarPoint.Web.Spread.IPrePaintConditionalFormattingRule[] prePaintRule;
FarPoint.Web.Spread.IPrePaintTextConditionalFormattingRule[] prePaintTextRule;
FpSpread1.ActiveSheetView.GetValidConditionalFormat(0, 0, out prePaintRule, out prePaintTextRule);

FarPoint.Web.Spread.PrePaintResult pp = prePaintRule[0].Execute(0, 0, FpSpread1.ActiveSheetView.Cells[0, 0].Value);
FarPoint.Web.Spread.StyleInfo source = new FarPoint.Web.Spread.StyleInfo();
FpSpread1.ActiveSheetView.Cells[1, 1].Value = 3;
FarPoint.Web.Spread.PrePaintResult pp1 = prePaintRule[0].Execute(1, 1, FpSpread1.ActiveSheetView.Cells[1, 1].Value);

Dim unary As New FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo, 3)
unary.[Operator] = FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo
'unary.Value = 3;
unary.BackColor = Drawing.Color.Red
unary.FontStyle = New FarPoint.Web.Spread.SpreadFontStyle(FarPoint.Web.Spread.UnderlineFontStyle.None)
unary.FontStyle.RegularBoldItalic = FarPoint.Web.Spread.RegularBoldItalicFontStyle.Bold
Dim range As New FarPoint.Web.Spread.Model.CellRange(0, 0, 3, 3)
Dim cfequal As New FarPoint.Web.Spread.ConditionalFormatting(range)
cfequal.Add(unary)

FpSpread1.ActiveSheetView.ConditionalFormatting.Add(cfequal)
'FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, unary);
'FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, unary);

Dim prePaintRule As FarPoint.Web.Spread.IPrePaintConditionalFormattingRule()
Dim prePaintTextRule As FarPoint.Web.Spread.IPrePaintTextConditionalFormattingRule()
FpSpread1.ActiveSheetView.GetValidConditionalFormat(0, 0, prePaintRule, prePaintTextRule)

Dim pp As FarPoint.Web.Spread.PrePaintResult = prePaintRule(0).Execute(0, 0, FpSpread1.ActiveSheetView.Cells(0, 0).Value)
Dim source As New FarPoint.Web.Spread.StyleInfo()
FpSpread1.ActiveSheetView.Cells(1, 1).Value = 3
Dim pp1 As FarPoint.Web.Spread.PrePaintResult = prePaintRule(0).Execute(1, 1, FpSpread1.ActiveSheetView.Cells(1, 1).Value)

参照

PrePaintConditionalFormattingRule クラス
 PrePaintConditionalFormattingRule メンバ