ClearConditionalFormating(Int32,Int32,Int32,Int32) メソッド

指定したセル範囲からすべての条件付き書式を削除します。

構文

Visual Basic
C#

'Declaration
 
Public Overloads Sub ClearConditionalFormating( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer _
)

'使用法
 
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
 
instance.ClearConditionalFormating(row, column, rowCount, columnCount)

public void ClearConditionalFormating( 
   int row,
   int column,
   int rowCount,
   int columnCount
)

パラメータ

row: 開始行インデックス
column: 開始列インデックス
rowCount: 行数
columnCount: 列数

例

次のサンプルコードは、書式をクリアします。

C#
VB.NET

private void Form1_Load(object sender, EventArgs e)
        {
            fpSpread1.Sheets[0].Cells[0, 0].Value = 3;
            fpSpread1.Sheets[0].Cells[1, 0].Value = 2;
            fpSpread1.Sheets[0].Cells[1, 1].Value = 10;
            fpSpread1.Sheets[0].Cells[0, 2].Value = 1;
            FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule unary = new FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo, 10, false);
            unary.Operator = FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo;
            unary.Value = 10;
            unary.BackColor = System.Drawing.Color.Red;

            FarPoint.Win.Spread.TopRankedValuesConditionalFormattingRule topRank = new FarPoint.Win.Spread.TopRankedValuesConditionalFormattingRule();
            topRank.IsDescending = true;
            topRank.BackColor = System.Drawing.Color.Tomato;
            topRank.ForeColor = System.Drawing.Color.Yellow;

            //CondtionalFormatting Constructor
            FarPoint.Win.Spread.ConditionalFormatting cf = new FarPoint.Win.Spread.ConditionalFormatting(new FarPoint.Win.Spread.Model.CellRange(0, 0, 2, 2));
            FarPoint.Win.Spread.ConditionalFormatting cf1 = new FarPoint.Win.Spread.ConditionalFormatting(new FarPoint.Win.Spread.Model.CellRange(0, 0, 2, 2), topRank, unary);
            fpSpread1.ActiveSheet.Models.ConditionalFormatting.Add(cf);
            fpSpread1.ActiveSheet.Models.ConditionalFormatting.Add(cf1);           
        }               

        private void button1_Click(object sender, EventArgs e)
        {
            fpSpread1.Sheets[0].ClearConditionalFormating(0, 0);
            //fpSpread1.Sheets[0].ClearConditionalFormating(0, 0, 2, 2);            
        }

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load       
        FpSpread1.Sheets(0).Cells(0, 0).Value = 3
        FpSpread1.Sheets(0).Cells(1, 0).Value = 2
        FpSpread1.Sheets(0).Cells(1, 1).Value = 10
        FpSpread1.Sheets(0).Cells(0, 2).Value = 1
        Dim unary As New FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo, 10, False)
        unary.Operator = FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo
        unary.Value = 10
        unary.BackColor = Drawing.Color.Red
        unary.FontStyle = New FarPoint.Win.Spread.SpreadFontStyle(FarPoint.Win.Spread.UnderlineFontStyle.None)

        Dim topRank As New FarPoint.Win.Spread.TopRankedValuesConditionalFormattingRule()
        topRank.IsDescending = True
        topRank.BackColor = Drawing.Color.Tomato
        topRank.ForeColor = Drawing.Color.Yellow

        'CondtionalFormatting Constructor
        Dim cf As New FarPoint.Win.Spread.ConditionalFormatting(New FarPoint.Win.Spread.Model.CellRange(0, 0, 2, 2))
        Dim cf1 As New FarPoint.Win.Spread.ConditionalFormatting(New FarPoint.Win.Spread.Model.CellRange(0, 0, 2, 2), topRank, unary)
        FpSpread1.ActiveSheet.Models.ConditionalFormatting.Add(cf)
        FpSpread1.ActiveSheet.Models.ConditionalFormatting.Add(cf1)
End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        'FpSpread1.Sheets(0).ClearConditionalFormating(0, 0)
        FpSpread1.Sheets(0).ClearConditionalFormating(0, 0, 2, 2)
    End Sub

参照

SheetView クラス
 SheetView メンバ
 オーバーロード一覧