GcSpread.Sheets Namespace > TwoScaleRule class : setMinimumValue Method |
var instance = new GcSpread.Sheets.TwoScaleRule(minType, minValue, minColor, maxType, maxValue, maxColor); var returnValue; // Type: any returnValue = instance.setMinimumValue(value);
function setMinimumValue( value : object ) : 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);