Spread for ASP.NET 9.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 uses the ConditionalFormattingIconSetStyle enumeration.
protected void Page_Load(object sender, System.EventArgs e)
{
if (this.IsPostBack) return;
FpSpread1.Sheets[0].RowCount = 5;
FpSpread1.Sheets[0].Cells[0, 1].Value = 3;
FpSpread1.Sheets[0].Cells[1, 1].Value = 2;
FpSpread1.Sheets[0].Cells[2, 1].Value = 10;
FpSpread1.Sheets[0].Cells[3, 1].Value = 1;
FarPoint.Web.Spread.IconSetConditionalFormattingRule c = new FarPoint.Web.Spread.IconSetConditionalFormattingRule(FarPoint.Web.Spread.ConditionalFormattingIconSetStyle.ThreeTriangles);
c.IconRuleSet.Add(new FarPoint.Web.Spread.ConditionalFormattingIconValue(10, FarPoint.Web.Spread.ConditionalFormattingValueType.Number, true, FarPoint.Web.Spread.ConditionalFormattingIcon.BlackCircle));
FarPoint.Web.Spread.ConditionalFormatting IconSetCF = new FarPoint.Web.Spread.ConditionalFormatting(new FarPoint.Web.Spread.Model.CellRange(0, 0, 2, 2), c);
FpSpread1.Sheets[0].ConditionalFormatting.Add(IconSetCF);
FarPoint.Web.Spread.IconFilterItem iconfilter = new FarPoint.Web.Spread.IconFilterItem(FarPoint.Web.Spread.ConditionalFormattingIcon.BlackCircle);
FarPoint.Web.Spread.IRowFilter rowFilter = new FarPoint.Web.Spread.HideRowFilter(FpSpread1.ActiveSheetView);
FarPoint.Web.Spread.FilterColumnDefinition fd = new FarPoint.Web.Spread.FilterColumnDefinition(1, FarPoint.Web.Spread.FilterListBehavior.Custom);
fd.Filters.Add(iconfilter);
rowFilter.ColumnDefinitions.Add(fd);
FpSpread1.ActiveSheetView.RowFilter = rowFilter;
FpSpread1.ActiveSheetView.AutoFilterColumn(1, iconfilter.DisplayName);
FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.Enhanced;
}
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If (IsPostBack) Then
    Return
End If
FpSpread1.Sheets(0).RowCount = 5
FpSpread1.Sheets(0).Cells(0, 1).Value = 3
FpSpread1.Sheets(0).Cells(1, 1).Value = 2
FpSpread1.Sheets(0).Cells(2, 1).Value = 10
FpSpread1.Sheets(0).Cells(3, 1).Value = 1
Dim c As New FarPoint.Web.Spread.IconSetConditionalFormattingRule(FarPoint.Web.Spread.ConditionalFormattingIconSetStyle.ThreeTriangles)
c.IconRuleSet.Add(New FarPoint.Web.Spread.ConditionalFormattingIconValue(10, FarPoint.Web.Spread.ConditionalFormattingValueType.Number, True, FarPoint.Web.Spread.ConditionalFormattingIcon.BlackCircle))
Dim IconSetCF As New FarPoint.Web.Spread.ConditionalFormatting(New FarPoint.Web.Spread.Model.CellRange(0, 0, 2, 2), c)
FpSpread1.Sheets(0).ConditionalFormatting.Add(IconSetCF)
Dim iconfilter As New FarPoint.Web.Spread.IconFilterItem(FarPoint.Web.Spread.ConditionalFormattingIcon.BlackCircle)
Dim rowFilter As New FarPoint.Web.Spread.HideRowFilter(FpSpread1.ActiveSheetView)
Dim fd As New FarPoint.Web.Spread.FilterColumnDefinition(1, FarPoint.Web.Spread.FilterListBehavior.Custom)
fd.Filters.Add(iconfilter)
rowFilter.ColumnDefinitions.Add(fd)
FpSpread1.ActiveSheetView.RowFilter = rowFilter
FpSpread1.ActiveSheetView.AutoFilterColumn(1, iconfilter.DisplayName)
FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.Enhanced
End Sub
Inheritance Hierarchy

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

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

FarPoint.Web.Spread Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.