ConditionalFormattingValueType Enumeration

Represents the value type of the conditional formatting.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum ConditionalFormattingValueType 
   Inherits System.Enum

'Usage
 
Dim instance As ConditionalFormattingValueType

public enum ConditionalFormattingValueType : System.Enum

Members

Member	Description
AutoMax	The larger of zero or the maximum value from the range of cells that the conditional formatting rule applies to.
AutoMin	The smaller of zero or the minimum value from the range of cells that the conditional formatting rule applies to.
Formula	The 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.
Max	The maximum value from the range of cells that the conditional formatting rule applies to.
Min	The minimum value from the range of cells that the conditional formatting rule applies to.
Number	Indicates the number value.
Percent	The 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.
Percentile	The 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);
        }

VB.NET

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

Reference

FarPoint.Web.Spread Namespace