FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > ConditionalFormattingIconValue Class > ConditionalFormattingIconValue Constructor : ConditionalFormattingIconValue Constructor(Object,ConditionalFormattingValueType,Boolean,ConditionalFormattingIcon) |
true
is greater or equal.
'Declaration Public Function New( _ ByVal value As Object, _ ByVal type As ConditionalFormattingValueType, _ ByVal isGreaterOrEquals As Boolean, _ ByVal icon As ConditionalFormattingIcon _ )
'Usage Dim value As Object Dim type As ConditionalFormattingValueType Dim isGreaterOrEquals As Boolean Dim icon As ConditionalFormattingIcon Dim instance As New ConditionalFormattingIconValue(value, type, isGreaterOrEquals, icon)
public ConditionalFormattingIconValue( object value, ConditionalFormattingValueType type, bool isGreaterOrEquals, ConditionalFormattingIcon icon )
true
is greater or equal.protected void Page_Load(object sender, System.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; } protected void Button1_Click(object sender, EventArgs e) { //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, 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].SetConditionalFormatting(1,1,c); FpSpread1.Sheets[0].ConditionalFormatting.Add(IconSetCF); }
Private Sub Page_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 Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click '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, 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).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