SpreadJS 13
GC.Spread.Sheets.ConditionalFormatting Namespace / ScaleRule class / ScaleRule Constructor
In This Topic
    ScaleRule Constructor
    In This Topic
    Represents a scale conditional rule.
    Syntax
    var instance = new GC.Spread.Sheets.ConditionalFormatting.ScaleRule();
    function ScaleRule() : ScaleRule;
    Example
    The following examples create scale rules.
    var scale = new GC.Spread.Sheets.ConditionalFormatting.ScaleRule();
    scale.ruleType(GC.Spread.Sheets.ConditionalFormatting.RuleType.threeScaleRule);
    scale.midColor("red");
    scale.midType(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number);
    scale.midValue(50);
    scale.maxColor("blue");
    scale.maxType(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number);
    scale.maxValue(100);
    scale.minColor("yellow");
    scale.minType(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number);
    scale.minValue(10);
    scale.ranges([new GC.Spread.Sheets.Range(0, 0, 10, 3)]);
    activeSheet.conditionalFormats.addRule(scale);
    activeSheet.setValue(0,0, 1,3);
    activeSheet.setValue(1,0, 50,3);
    activeSheet.setValue(2,0, 100,3);
    activeSheet.conditionalFormats.add2ScaleRule(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number,1,"Yellow",GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number,50,"Blue", [new GC.Spread.Sheets.Range(0,0,20,1)]);
    activeSheet.setValue(0,0,1,3);
    activeSheet.setValue(1,0,45,3);
    activeSheet.setValue(2,0,75,3);
    See Also

    Reference

    ScaleRule class