IconCriterion Constructor(Boolean,IconValueType,Object)

Creates new icon criteria with the specified operator, scale value, and type.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal isGreaterThanOrEqualTo As System.Boolean, _
   ByVal type As IconValueType, _
   ByVal value As System.Object _
)

'Usage
 
Dim isGreaterThanOrEqualTo As System.Boolean
Dim type As IconValueType
Dim value As System.Object
 
Dim instance As New IconCriterion(isGreaterThanOrEqualTo, type, value)

public IconCriterion( 
   System.bool isGreaterThanOrEqualTo,
   IconValueType type,
   System.object value
)

Parameters

isGreaterThanOrEqualTo: If set to true use the greater than and equal to operator to calculate the value.
type: Type of scale value.
value: Scale value.

Remarks

If the isGreaterThanOrEqualTo parameter is set to true, use the greater than and equal to operator to calculate the value.

Example

This example creates an icon rule.

GcSpreadSheet1.Sheets[0].Cells[0, 0].Value = 1;
GcSpreadSheet1.Sheets[0].Cells[1, 0].Value = 10;
GcSpreadSheet1.Sheets[0].Cells[2, 0].Value = 6;
GcSpreadSheet1.Sheets[0].Cells[3, 0].Value = 3;

GrapeCity.Windows.SpreadSheet.Data.IconSetRule test = new GrapeCity.Windows.SpreadSheet.Data.IconSetRule();
test.IconSetType = GrapeCity.Windows.SpreadSheet.Data.IconSetType.FourTrafficLights;
test.IconCriteria[0] = new GrapeCity.Windows.SpreadSheet.Data.IconCriterion(true, GrapeCity.Windows.SpreadSheet.Data.IconValueType.Number, 6);
test.Ranges = new GrapeCity.Windows.SpreadSheet.Data.CellRange[] { new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1) };
GcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(test);

VB.NET

GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = 1
GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = 10
GcSpreadSheet1.Sheets(0).Cells(2, 0).Value = 6
GcSpreadSheet1.Sheets(0).Cells(3, 0).Value = 3
Dim test As New GrapeCity.Windows.SpreadSheet.Data.IconSetRule()
test.IconSetType = GrapeCity.Windows.SpreadSheet.Data.IconSetType.FourTrafficLights
test.IconCriteria(0) = New GrapeCity.Windows.SpreadSheet.Data.IconCriterion(True, GrapeCity.Windows.SpreadSheet.Data.IconValueType.Number, 6)
test.Ranges = New GrapeCity.Windows.SpreadSheet.Data.CellRange() {New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1)}
GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(test)

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

IconCriterion Class
IconCriterion Members
Overload List