GC.Spread.Sheets.ConditionalFormatting Namespace : DataBarRule class |
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. |