ig.excel.NegativeBarFormat
Dependencies
-
barBorderColor
- .barBorderColor( );
Returns a WorkbookColorInfo which defines the border color applied to data bars with a negative value.
Remarks
This property is only applicable when the NegativeBarFormat.barBorderColorType property is set to Color.
-
barBorderColor
- .barBorderColor( value:ig.excel.WorkbookColorInfo );
Returns a WorkbookColorInfo which defines the border color applied to data bars with a negative value.
- value
- Type:ig.excel.WorkbookColorInfo
Remarks
This property is only applicable when the NegativeBarFormat.barBorderColorType property is set to Color.
-
barBorderColorType
- .barBorderColorType( );
Returns a DataBarNegativeBarColorType value which specifies whether the same border color as that which is used for data bars with positive cell values is also used for data bars with negative cell values.
Remarks
By default, databars for cells with negative values use the same color as those with positive values, and the NegativeBarFormat.barBorderColor property is not used.
Use this property to apply the color specified by the NegativeBarFormat.barBorderColor property to the borders of databars with negative cell values.
-
barBorderColorType
- .barBorderColorType( value:ig.excel.DataBarNegativeBarColorType );
Sets a DataBarNegativeBarColorType value which specifies whether the same border color as that which is used for data bars with positive cell values is also used for data bars with negative cell values.
- value
- Type:ig.excel.DataBarNegativeBarColorType
Remarks
By default, databars for cells with negative values use the same color as those with positive values, and the NegativeBarFormat.barBorderColor property is not used.
Use this property to apply the color specified by the NegativeBarFormat.barBorderColor property to the borders of databars with negative cell values.
-
barColor
- .barColor( );
Returns a WorkbookColorInfo which defines the fill color applied to data bars with a negative value.
Remarks
This property is only applicable when the NegativeBarFormat.barColorType property is set to Color.
-
barColor
- .barColor( value:ig.excel.WorkbookColorInfo );
Returns a WorkbookColorInfo which defines the fill color applied to data bars with a negative value.
- value
- Type:ig.excel.WorkbookColorInfo
Remarks
This property is only applicable when the NegativeBarFormat.barColorType property is set to Color.
-
barColorType
- .barColorType( );
Returns a DataBarNegativeBarColorType value which specifies whether the same color as that which is used for the positive data bars is used.
Remarks
By default, databars for cells with negative values have a different color than those with positive values.
Use this property to apply the same color to databars regardless of whether the cell value is positive or negative.
-
barColorType
- .barColorType( value:ig.excel.DataBarNegativeBarColorType );
Sets a DataBarNegativeBarColorType value which specifies whether the same color as that which is used for the positive data bars is used.
- value
- Type:ig.excel.DataBarNegativeBarColorType
Remarks
By default, databars for cells with negative values have a different color than those with positive values.
Use this property to apply the same color to databars regardless of whether the cell value is positive or negative.