Spread for ASP.NET 7.0 Product Documentation
ConditionalFormattingIcon Enumeration
Example  See Also  Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace : ConditionalFormattingIcon Enumeration


Glossary Item Box

The predefined icon for conditional formatting.

Syntax

Visual Basic (Declaration) 
Public Enum ConditionalFormattingIcon 
   Inherits System.Enum
Visual Basic (Usage)Copy Code
Dim instance As ConditionalFormattingIcon
C# 
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.
C#Copy Code
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;
}
VB.NETCopy Code
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 Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.