Spread Windows Forms 8.0 Product Documentation
ConditionalFormattingIconSetStyle Enumeration
Example Example 


Represents the style of the icon set.
Syntax
'Declaration
 
Public Enum ConditionalFormattingIconSetStyle 
   Inherits System.Enum
'Usage
 
Dim instance As ConditionalFormattingIconSetStyle
public enum ConditionalFormattingIconSetStyle : System.Enum 
Members
MemberDescription
CustomIndicates a set of custom icons.
FiveBoxesIndicates a set of five box icons.
FiveColoredArrowsIndicates a set of five colored arrow icons.
FiveGrayArrowsIndicates a set of five gray arrow icons.
FiveQuartersIndicates a set of five quarter icons.
FiveRatingsIndicates a set of five rating icons.
FourColoredArrowsIndicates a set of four colored arrow icons.
FourGrayArrowsIndicates a set of four gray arrow icons.
FourRatingsIndicates a set of four rating icons.
FourTrafficLightsIndicates a set of four traffic light icons.
RedToBlackIndicates a set of circled icons from red to black.
ThreeCircledSymbolsIndicates a set of three circled symbol icons.
ThreeColoredArrowsIndicates a set of three colored arrow icons.
ThreeFlagsIndicates a set of three flag icons.
ThreeGrayArrowsIndicates a set of three gray arrow icons.
ThreeRimmedTrafficLightsIndicates a set of three rimmed traffic light icons.
ThreeSignsIndicates a set of three sign icons.
ThreeStarsIndicates a set of three star icons.
ThreeTrianglesIndicates a set of three triangle icons.
ThreeUnCircledSymbolsIndicates a set of three uncircled symbol icons.
ThreeUnrimmedTrafficLightsIndicates a set of three unrimmed traffic light icons.
Example
This example creates a conditional rule.
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)
        {

            //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.ConditionalFormattingIcon.BlackCircle));
            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);
        }
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
        '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, FarPoint.Win.Spread.ConditionalFormattingIcon.BlackCircle))
        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)
    End Sub
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Win.Spread.ConditionalFormattingIconSetStyle

Requirements

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

See Also

Reference

FarPoint.Win.Spread Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.