GcSpread.Sheets Namespace > TwoScaleRule class : setMaximumColor Method |
var instance = new GcSpread.Sheets.TwoScaleRule(minType, minValue, minColor, maxType, maxValue, maxColor); var value; // Type: any value = instance.setMaximumColor(color);
function setMaximumColor( color : string ) : any;
var scale = new GcSpread.Sheets.TwoScaleRule(); scale.setMaximumColor("blue"); scale.setMaximumType(2); scale.setMaximumValue(100); scale.setMinimumColor("yellow"); scale.setMinimumType(1); scale.setMinimumValue(10); scale.ranges = [new GcSpread.Sheets.Range(0, 0, 10, 3)]; activeSheet.getConditionalFormats().addRule(scale); activeSheet.setValue(0,0, 1,3); activeSheet.setValue(1,0, 50,3); activeSheet.setValue(2,0, 100,3);