Spread for ASP.NET 8.0 Product Documentation
Reversed Property
Example 


Gets or sets a value that indicates whether this IconSetConditionalFormattingRule is reversed.
Syntax
'Declaration
 
Public Property Reversed As Boolean
'Usage
 
Dim instance As IconSetConditionalFormattingRule
Dim value As Boolean
 
instance.Reversed = value
 
value = instance.Reversed
public bool Reversed {get; set;}

Property Value

true if reversed; otherwise, false.
Example
This example sets the Reversed property.
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, 1].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));
    c.Reversed = true;
    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);
}
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, 1).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))
c.Reversed = True
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)
End Sub
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

Reference

IconSetConditionalFormattingRule Class
IconSetConditionalFormattingRule Members

 

 


Copyright © GrapeCity, inc. All rights reserved.