SpreadJS 13
GC.Spread.Sheets.ConditionalFormatting Namespace / Top10ConditionType Enumeration
In This Topic
    Top10ConditionType Enumeration
    In This Topic
    Specifies the top 10 condition type.
    Members
    MemberDescription
    bottomSpecifies the bottom condition.
    topSpecifies the top condition.
    Example
    This example uses the Top10ConditionType enumeration.
    var style = new GC.Spread.Sheets.Style();
    style.backColor = "red";
    var ranges=[new GC.Spread.Sheets.Range(0,0,10,1)];
    activeSheet.conditionalFormats.addTop10Rule(GC.Spread.Sheets.ConditionalFormatting.Top10ConditionType.top, 2, style, ranges);
    activeSheet.setValue(0, 0, 1);
    activeSheet.setValue(1, 0, 50);
    activeSheet.setValue(2, 0, 11);
    activeSheet.setValue(3, 0, 5);
    Inheritance Hierarchy

    Object
       GC.Spread.Sheets.ConditionalFormatting.Top10ConditionType

    See Also