Spread Windows Forms 11.0 Product Documentation
ConditionalFormattingValueType Enumeration
Example Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace : ConditionalFormattingValueType Enumeration
Represents the value type of the conditional formatting.
Syntax
'Declaration
 
Public Enum ConditionalFormattingValueType 
   Inherits System.Enum
'Usage
 
Dim instance As ConditionalFormattingValueType
public enum ConditionalFormattingValueType : System.Enum 
Members
MemberDescription
AutoMaxThe larger of zero or the maximum value from the range of cells that the conditional formatting rule applies to.
AutoMinThe smaller of zero or the minimum value from the range of cells that the conditional formatting rule applies to.
FormulaThe result of the formula determines the minimum or maximum value of the cell range that the rule applies to. If the result is not numeric, it is treated as zero.
MaxThe maximum value from the range of cells that the conditional formatting rule applies to.
MinThe minimum value from the range of cells that the conditional formatting rule applies to.
NumberIndicates the number value.
PercentThe minimum value in the range of cells that the conditional formatting rule applies to plus X percent of the difference between the maximum and minimum values in the range of cells that the conditional formatting rule applies to.
PercentileThe minimum value of the cell that is in the X percentile of the range of cells that the conditional formatting rule applies to.
Remarks
The Maximum property should not be set to a ConditionalFormattingValue value such as ConditionalFormattingValueType.Min or ConditionalFormattingValueType.AutoMin. An exception will occur in this case. The Minimum property should not be set to a ConditionalFormattingValue value such as ConditionalFormattingValueType.Max or ConditionalFormattingValueType.AutoMax. An exception will occur in this case.
Example
This example creates a conditional rule.
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;
        }

        private void button1_Click(object sender, EventArgs e)
        {

            FarPoint.Win.Spread.TwoColorScaleConditionalFormattingRule two = new FarPoint.Win.Spread.TwoColorScaleConditionalFormattingRule();
            two.MaxValue = new FarPoint.Win.Spread.ConditionalFormattingColorValue(Color.Red, 10, FarPoint.Win.Spread.ConditionalFormattingValueType.Max);
            fpSpread1.ActiveSheet.SetConditionalFormatting(1, 1, two);
        }
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
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim two As New FarPoint.Win.Spread.TwoColorScaleConditionalFormattingRule()
        two.MaxValue = New FarPoint.Win.Spread.ConditionalFormattingColorValue(Color.Red, 10, FarPoint.Win.Spread.ConditionalFormattingValueType.Max)
        FpSpread1.Sheets(0).SetConditionalFormatting(1, 1, two)
    End Sub
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Win.Spread.ConditionalFormattingValueType

See Also

Reference

FarPoint.Win.Spread Namespace