SpreadJS Documentation
DataBarRule Constructor
The minimum scale type.
The minimum scale value.
The maximum scale type.
The maximum scale value.
The fill color of the data bar.
Represents a data bar conditional rule with the specified parameters.
Syntax
var instance = new GcSpread.Sheets.DataBarRule(minType, minValue, maxType, maxValue, color);
function DataBarRule( 
   minType : ScaleValueType,
   minValue : object,
   maxType : ScaleValueType,
   maxValue : object,
   color : string
) : DataBarRule;

Parameters

minType
The minimum scale type.
minValue
The minimum scale value.
maxType
The maximum scale type.
maxValue
The maximum scale value.
color
The fill color of the data bar.
Example
This example creates a data bar rule.
activeSheet.setValue(0,0,1,3);
activeSheet.setValue(1,0,15,3);
activeSheet.setValue(2,0,25,3);
activeSheet.setValue(3,0,-1,3);

var cfs = activeSheet.getConditionalFormats();
var dataBarRule = new GcSpread.Sheets.DataBarRule();
dataBarRule.ranges=[new GcSpread.Sheets.Range(0,0,4,1)];
dataBarRule.minimumType(GcSpread.Sheets.ScaleValueType.Number);
dataBarRule.minimumValue(-1);
dataBarRule.maximumType(GcSpread.Sheets.ScaleValueType.Number);
dataBarRule.maximumValue(40);
dataBarRule.color("green");
dataBarRule.showBorder(true);
dataBarRule.borderColor("orange");
dataBarRule.dataBarDirection(GcSpread.Sheets.BarDirection.LeftToRight);
dataBarRule.negativeFillColor("yellow");
dataBarRule.useNegativeFillColor(true);
dataBarRule.negativeBorderColor("red");
dataBarRule.useNegativeBorderColor(true);
dataBarRule.axisPosition(GcSpread.Sheets.DataBarAxisPosition.Automatic);
dataBarRule.axisColor("blue");
dataBarRule.showBarOnly(false);
cfs.addRule(dataBarRule);
See Also

Reference

DataBarRule class

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.