FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace : ConditionalFormattingValueType Enumeration |
'Declaration Public Enum ConditionalFormattingValueType Inherits System.Enum
'Usage Dim instance As ConditionalFormattingValueType
public enum ConditionalFormattingValueType : System.Enum
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. |
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
System.Object
System.ValueType
System.Enum
FarPoint.Win.Spread.ConditionalFormattingValueType
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8