GrapeCity.Xaml.SpreadSheet.Data
IconCriterion Constructor(Boolean,IconValueType,Object)
Example 


GrapeCity.Xaml.SpreadSheet.Data Namespace > IconCriterion Class > IconCriterion Constructor : IconCriterion Constructor(Boolean,IconValueType,Object)
If set to true use the greater than and equal to operator to calculate the value.
Type of scale value.
Scale value.
Creates new icon criteria with the specified operator, scale value, and type.
Syntax
'Declaration
 
Public Function New( _
   ByVal isGreaterThanOrEqualTo As Boolean, _
   ByVal type As IconValueType, _
   ByVal value As Object _
)
'Usage
 
Dim isGreaterThanOrEqualTo As Boolean
Dim type As IconValueType
Dim value As Object
 
Dim instance As New IconCriterion(isGreaterThanOrEqualTo, type, value)
public IconCriterion( 
   bool isGreaterThanOrEqualTo,
   IconValueType type,
   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 sets the icon criteria.
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.Xaml.SpreadSheet.Data.IconSetRule test = new GrapeCity.Xaml.SpreadSheet.Data.IconSetRule();
test.IconSetType = GrapeCity.Xaml.SpreadSheet.Data.IconSetType.FourTrafficLights;
test.IconCriteria[0] = new GrapeCity.Xaml.SpreadSheet.Data.IconCriterion(true, GrapeCity.Xaml.SpreadSheet.Data.IconValueType.Number, 6);
test.Ranges = new GrapeCity.Xaml.SpreadSheet.Data.CellRange[] { new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1) };
GcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(test);  
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.Xaml.SpreadSheet.Data.IconSetRule()
test.IconSetType = GrapeCity.Xaml.SpreadSheet.Data.IconSetType.FourTrafficLights
test.IconCriteria(0) = New GrapeCity.Xaml.SpreadSheet.Data.IconCriterion(True, GrapeCity.Xaml.SpreadSheet.Data.IconValueType.Number, 6)
test.Ranges = New GrapeCity.Xaml.SpreadSheet.Data.CellRange() {New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1)}
GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(test)
See Also

Reference

IconCriterion Class
IconCriterion Members
Overload List