Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / ConditionalFormattingValueType Enumeration
Example Example


In This Topic
    ConditionalFormattingValueType Enumeration
    In This Topic
    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.
    Example
    This example uses the ConditionalFormattingValueType enumeration.
    protected void Page_Load(object sender, System.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;
                           }
    
    protected void Button1_Click(object sender, EventArgs e)
            {
                //IconSetConditionalFormatting
                FarPoint.Web.Spread.IconSetConditionalFormattingRule c = new FarPoint.Web.Spread.IconSetConditionalFormattingRule(FarPoint.Web.Spread.ConditionalFormattingIconSetStyle.ThreeTriangles);
                c.IconRuleSet.Add(new FarPoint.Web.Spread.ConditionalFormattingIconValue(10, FarPoint.Web.Spread.ConditionalFormattingValueType.Number, true, FarPoint.Web.Spread.ConditionalFormattingIcon.BlackCircle));
                FarPoint.Web.Spread.ConditionalFormatting IconSetCF = new FarPoint.Web.Spread.ConditionalFormatting(new FarPoint.Web.Spread.Model.CellRange(0, 0, 2, 2), c);                          
                //FpSpread1.Sheets[0].SetConditionalFormatting(1,1,c);
                FpSpread1.Sheets[0].ConditionalFormatting.Add(IconSetCF);
            }
    Private Sub Page_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
    
    Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
                 'IconSetConditionalFormatting
                Dim c As New FarPoint.Web.Spread.IconSetConditionalFormattingRule(FarPoint.Web.Spread.ConditionalFormattingIconSetStyle.ThreeTriangles)
                c.IconRuleSet.Add(New FarPoint.Web.Spread.ConditionalFormattingIconValue(10, FarPoint.Web.Spread.ConditionalFormattingValueType.Number, True, FarPoint.Web.Spread.ConditionalFormattingIcon.BlackCircle))
                Dim IconSetCF As New FarPoint.Web.Spread.ConditionalFormatting(New FarPoint.Web.Spread.Model.CellRange(0, 0, 2, 2), c)
                'FpSpread1.Sheets(0).SetConditionalFormatting(1, 1, c)
                FpSpread1.Sheets(0).ConditionalFormatting.Add(IconSetCF)
            End Sub
    Inheritance Hierarchy

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

    See Also