Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Enum ConditionalFormattingValueType Inherits System.Enum | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As ConditionalFormattingValueType | |
| C# | |
|---|---|
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.
| C# | Copy Code |
|---|---|
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 | Copy Code |
|---|---|
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
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6