GC.Spread.Sheets.ConditionalFormatting 名前空間 > ConditionalFormats タイプ : addDataBarRule メソッド |
Javascript (Usage) | |
---|---|
var instance = new GC.Spread.Sheets.ConditionalFormatting.ConditionalFormats(worksheet); var value; // Type: object value = instance.addDataBarRule(minType, minValue, maxType, maxValue, color, ranges); |
Javascript (Specification) | |
---|---|
function addDataBarRule( minType : ScaleValueType, minValue : object, maxType : ScaleValueType, maxValue : object, color : string, ranges : undefined ) : object; |
activeSheet.setValue(0,0,1,3); activeSheet.setValue(1,0,15,3); activeSheet.setValue(2,0,25,3); activeSheet.setValue(3,0,-1,3); activeSheet.conditionalFormats.addDataBarRule(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number, -1, GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number, 40, "orange", [new GC.Spread.Sheets.Range(0,0,4,1)]);