var instance = new GC.Spread.Sheets.ConditionalFormatting.DataBarRule(minType, minValue, maxType, maxValue, color, ranges);
function DataBarRule;
var instance = new GC.Spread.Sheets.ConditionalFormatting.DataBarRule(minType, minValue, maxType, maxValue, color, ranges);
function DataBarRule;
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 dataBarRule = new GC.Spread.Sheets.ConditionalFormatting.DataBarRule(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number, -1, GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number, 40, "green", [new GC.Spread.Sheets.Range(0,0,4,1)]); dataBarRule.color("green"); dataBarRule.showBorder(true); dataBarRule.borderColor("orange"); dataBarRule.dataBarDirection(GC.Spread.Sheets.ConditionalFormatting.BarDirection.leftToRight); dataBarRule.negativeFillColor("yellow"); dataBarRule.useNegativeFillColor(true); dataBarRule.negativeBorderColor("red"); dataBarRule.useNegativeBorderColor(true); dataBarRule.axisPosition(GC.Spread.Sheets.ConditionalFormatting.DataBarAxisPosition.automatic); dataBarRule.axisColor("blue"); dataBarRule.showBarOnly(false); activeSheet.conditionalFormats.addRule(dataBarRule);
Object
GC.Spread.Sheets.ConditionalFormatting.ScaleRule
GC.Spread.Sheets.ConditionalFormatting.DataBarRule
Name | Description | |
---|---|---|
DataBarRule Constructor | Represents a data bar conditional rule with the specified parameters. |
Name | Description | |
---|---|---|
axisColor | Gets or sets the axis color of the data bar. | |
axisPosition | Gets or sets the axis position of the data bar. | |
borderColor | Gets or sets the color of the border. | |
color | Gets or sets the postive fill color of the data bar. | |
createCondition | (Inherited from GC.Spread.Sheets.ConditionalFormatting.ScaleRule) | |
dataBarDirection | Gets or sets the data bar direction. | |
evaluate | Returns the specified value of the rule if the cell meets the condition. | |
gradient | Gets or sets a value that indicates whether the data bar is a gradient. | |
maxColor | (Inherited from GC.Spread.Sheets.ConditionalFormatting.ScaleRule) | |
maxType | (Inherited from GC.Spread.Sheets.ConditionalFormatting.ScaleRule) | |
maxValue | (Inherited from GC.Spread.Sheets.ConditionalFormatting.ScaleRule) | |
midColor | (Inherited from GC.Spread.Sheets.ConditionalFormatting.ScaleRule) | |
midType | (Inherited from GC.Spread.Sheets.ConditionalFormatting.ScaleRule) | |
midValue | (Inherited from GC.Spread.Sheets.ConditionalFormatting.ScaleRule) | |
minColor | (Inherited from GC.Spread.Sheets.ConditionalFormatting.ScaleRule) | |
minType | (Inherited from GC.Spread.Sheets.ConditionalFormatting.ScaleRule) | |
minValue | (Inherited from GC.Spread.Sheets.ConditionalFormatting.ScaleRule) | |
negativeBorderColor | Gets or sets the color of the negative border. | |
negativeFillColor | Gets or sets the color of the negative fill. | |
showBarOnly | Gets or sets whether to display the data bar without text. | |
showBorder | Gets or sets a value that indicates whether to paint the border. | |
stopIfTrue | (Inherited from GC.Spread.Sheets.ConditionalFormatting.ScaleRule) | |
useNegativeBorderColor | Gets or sets a value that indicates whether the negative border color is used to paint the border for the negative value. | |
useNegativeFillColor | Gets or sets a value that indicates whether the negative fill color is used to paint the negative value. |