Spread for ASP.NET 9.0 Product Documentation
ConditionalFormattingIcon Enumeration
Example Example 


The predefined icon for conditional formatting.
Syntax
'Declaration
 
Public Enum ConditionalFormattingIcon 
   Inherits System.Enum
'Usage
 
Dim instance As ConditionalFormattingIcon
public enum ConditionalFormattingIcon : System.Enum 
Members
MemberDescription
BlackCircleSpecifies the black circle icon.
BlackCircleWithBorderSpecifies the black circle with a border icon.
CircleWithOneWhiteQuarterSpecifies the circle with one white quarter icon.
CircleWithThreeWhiteQuartersSpecifies the circle with three white quarters icon.
CircleWithTwoWhiteQuartersSpecifies the circle with two white quarters icon.
CustomSpecifies a custom icon
FourFilledBoxesSpecifies the four filled boxes icon.
GoldStarSpecifies the gold star icon.
GrayCircleSpecifies the gray circle icon.
GrayDownArrowSpecifies the gray down arrow icon.
GrayDownInclineArrowSpecifies the gray down incline arrow icon.
GraySideArrowSpecifies the gray side arrow icon.
GrayUpArrowSpecifies the gray up arrow icon.
GrayUpInclineArrowSpecifies the gray up incline arrow icon.
GreenCheckSpecifies the green check icon.
GreenCheckSymbolSpecifies the green check symbol icon.
GreenCircleSpecifies the green circle icon.
GreenFlagSpecifies the green flag icon.
GreenTrafficLightSpecifies the green traffic light icon.
GreenUpArrowSpecifies the green up arrow icon.
GreenUpTriangleSpecifies the green up triangle icon.
HalfGoldStarSpecifies the half gold star icon.
NoneSpecifies no icon
OneFilledBoxSpecifies the one filled box icon.
PinkCircleSpecifies the pink circle icon.
RedCircleSpecifies the red circle icon.
RedCircleWithBorderSpecifies the red circle with border icon.
RedCrossSpecifies the red cross icon.
RedCrossSymbolSpecifies the red cross symbol icon.
RedDiamondSpecifies the red diamond icon.
RedDownArrowSpecifies the red down arrow icon.
RedDownTriangleSpecifies the red down triangle icon.
RedFlagSpecifies the red flag icon.
RedTrafficLightSpecifies the red traffic light icon.
SignalMeterWithFourFilledBarsSpecifies the signal meter with four filled bars icon.
SignalMeterWithNoFilledBarsSpecifies the signal meter with no filled bars icon.
SignalMeterWithOneFilledBarSpecifies the signal meter with one filled bar icon.
SignalMeterWithThreeFilledBarsSpecifies the signal meter with three filled bars icon.
SignalMeterWithTwoFilledBarsSpecifies the signal meter with two filled bars icon.
SilverStarSpecifies the silver star icon.
ThreeFilledBoxesSpecifies the three filled boxes icon.
TwoFilledBoxesSpecifies the two filled boxes icon.
WhiteCircleSpecifies the white circle icon.
YellowCircleSpecifies the yellow circle icon.
YellowDashSpecifies the yellow dash icon.
YellowDownInclineArrowSpecifies the yellow down incline arrow icon.
YellowExclamationSpecifies the yellow exclamation icon.
YellowExclamationSymbolSpecifies the yellow exclamation symbol icon.
YellowFlagSpecifies the yellow flag icon.
YellowSideArrowSpecifies the yellow side arrow icon.
YellowTrafficLightSpecifies the yellow traffic light icon.
YellowTriangleSpecifies the yellow triangle icon.
YellowUpInclineArrowSpecifies the yellow up incline arrow icon.
ZeroFilledBoxesSpecifies the zero filled boxes icon.
Example
This example sets the ConditionalFormattingIcon 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.ConditionalFormattingIcon

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.