ConditionalFormattingIconValue Constructor(Object,ConditionalFormattingValueType,Boolean)

Initializes a new instance of the ConditionalFormattingIconValue class.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal value As Object, _
   ByVal type As ConditionalFormattingValueType, _
   ByVal isGreaterOrEquals As Boolean _
)

'Usage
 
Dim value As Object
Dim type As ConditionalFormattingValueType
Dim isGreaterOrEquals As Boolean
 
Dim instance As New ConditionalFormattingIconValue(value, type, isGreaterOrEquals)

public ConditionalFormattingIconValue( 
   object value,
   ConditionalFormattingValueType type,
   bool isGreaterOrEquals
)

Parameters

value: The value.
type: The type. Note: ConditionalFormattingIconValue accepts only Number, Percent, Percentile, and Formula values of ConditionalFormattingValueType.
isGreaterOrEquals: if set to true is greater or equal.

Example

This example creates an icon rule.

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;
//IconSetConditionalFormatting
FarPoint.Win.Spread.IconSetConditionalFormattingRule c = new FarPoint.Win.Spread.IconSetConditionalFormattingRule(FarPoint.Win.Spread.ConditionalFormattingIconSetStyle.ThreeTriangles);
c.IconRuleSet.Add(new FarPoint.Win.Spread.ConditionalFormattingIconValue(10, FarPoint.Win.Spread.ConditionalFormattingValueType.Number, true));
FarPoint.Win.Spread.ConditionalFormatting IconSetCF = new FarPoint.Win.Spread.ConditionalFormatting(new FarPoint.Win.Spread.Model.CellRange(0, 0, 2, 2), c);
//fpSpread1.Sheets[0].SetConditionalFormatting(1,1,c);
fpSpread1.Sheets[0].Models.ConditionalFormatting.Add(IconSetCF);

VB.NET

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
'IconSetConditionalFormatting
Dim c As New FarPoint.Win.Spread.IconSetConditionalFormattingRule(FarPoint.Win.Spread.ConditionalFormattingIconSetStyle.ThreeTriangles)
c.IconRuleSet.Add(New FarPoint.Win.Spread.ConditionalFormattingIconValue(10, FarPoint.Win.Spread.ConditionalFormattingValueType.Number, True))
Dim IconSetCF As New FarPoint.Win.Spread.ConditionalFormatting(New FarPoint.Win.Spread.Model.CellRange(0, 0, 2, 2), c)
'FpSpread1.Sheets(0).SetConditionalFormatting(1, 1, c)
FpSpread1.Sheets(0).Models.ConditionalFormatting.Add(IconSetCF)

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

ConditionalFormattingIconValue Class
ConditionalFormattingIconValue Members
Overload List