var instance = new GC.Spread.Sheets.ConditionalFormatting.ScaleRule();
function ScaleRule;
var instance = new GC.Spread.Sheets.ConditionalFormatting.ScaleRule();
function ScaleRule;
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);
Object
GC.Spread.Sheets.ConditionalFormatting.ScaleRule
GC.Spread.Sheets.ConditionalFormatting.DataBarRule
GC.Spread.Sheets.ConditionalFormatting.IconSetRule
Name | Description | |
---|---|---|
ScaleRule Constructor | Represents a scale conditional rule. |
Name | Description | |
---|---|---|
createCondition | Creates a condition for the rule. | |
evaluate | Returns a specified value of the rule if the cell satisfies the condition. | |
maxColor | Gets or sets the maximum color scale. | |
maxType | Gets or sets the maximum scale type. | |
maxValue | Gets or sets the maximum scale value. | |
midColor | Gets or sets the midpoint scale color. | |
midType | Gets or sets the midpoint scale type. | |
midValue | Gets or sets the midpoint scale value. | |
minColor | Gets or sets the minimum scale color. | |
minType | Gets or sets the type of minimum scale. | |
minValue | Gets or sets the minimum scale value. | |
stopIfTrue | Gets whether evaluation should stop if the condition evaluates to true . |