FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > ConditionalFormattingIconValue Class > ConditionalFormattingIconValue Constructor : ConditionalFormattingIconValue Constructor(Object,ConditionalFormattingValueType,Boolean,String) |
true
is greater or equal.
'Declaration Public Function New( _ ByVal value As Object, _ ByVal type As ConditionalFormattingValueType, _ ByVal isGreaterOrEquals As Boolean, _ ByVal iconUrl As String _ )
'Usage Dim value As Object Dim type As ConditionalFormattingValueType Dim isGreaterOrEquals As Boolean Dim iconUrl As String Dim instance As New ConditionalFormattingIconValue(value, type, isGreaterOrEquals, iconUrl)
public ConditionalFormattingIconValue( object value, ConditionalFormattingValueType type, bool isGreaterOrEquals, string iconUrl )
true
is greater or equal.protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; 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; //IconSetConditionalFormatting 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, "http://www.componentone.com/newimages/Products/Icons/wijmo_icon_16x16.png")); FarPoint.Web.Spread.ConditionalFormatting IconSetCF = new FarPoint.Web.Spread.ConditionalFormatting(new FarPoint.Web.Spread.Model.CellRange(0, 0, 2, 2), c); //FpSpread1.Sheets[0].SetConditionalFormatting(1,1,c); FpSpread1.Sheets[0].ConditionalFormatting.Add(IconSetCF); }
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If (IsPostBack) Then Return End If 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 'IconSetConditionalFormatting 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, "http://www.componentone.com/newimages/Products/Icons/wijmo_icon_16x16.png")) Dim IconSetCF As New FarPoint.Web.Spread.ConditionalFormatting(New FarPoint.Web.Spread.Model.CellRange(0, 0, 2, 2), c) 'FpSpread1.Sheets(0).SetConditionalFormatting(1, 1, c) FpSpread1.Sheets(0).ConditionalFormatting.Add(IconSetCF) End Sub
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