GC.Spread.Sheets.ConditionalFormatting 名前空間 > ScaleRule クラス : midType メソッド |
Javascript (Usage) | |
---|---|
var instance = new GC.Spread.Sheets.ConditionalFormatting.ScaleRule(); var returnValue; // Type: any returnValue = instance.midType(value); |
Javascript (Specification) | |
---|---|
function midType( value : ScaleValueType ) : any; |
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);
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); alert("Color: " + scale.midColor() + " Type: " + scale.midType() + " Value: " + scale.midValue());