Excel.Interfaces.ConditionalDataBarNegativeFormatLoadOptions interface

Package:

excel

Represents a conditional format for the negative side of the data bar.

Remarks

[ API set: ExcelApi 1.6 ]

Properties

$all	Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).
borderColor	HTML color code representing the color of the border line, in the form #RRGGBB (e.g., "FFA500") or as a named HTML color (e.g., "orange"). Value is "" (an empty string) if no border is present or set.
fillColor	HTML color code representing the fill color, in the form #RRGGBB (e.g., "FFA500") or as a named HTML color (e.g., "orange").
matchPositiveBorderColor	Specifies if the negative data bar has the same border color as the positive data bar.
matchPositiveFillColor	Specifies if the negative data bar has the same fill color as the positive data bar.

Property Details

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

$all?: boolean;

Property Value

boolean

borderColor

HTML color code representing the color of the border line, in the form #RRGGBB (e.g., "FFA500") or as a named HTML color (e.g., "orange"). Value is "" (an empty string) if no border is present or set.

borderColor?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]

fillColor

HTML color code representing the fill color, in the form #RRGGBB (e.g., "FFA500") or as a named HTML color (e.g., "orange").

fillColor?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]

matchPositiveBorderColor

Specifies if the negative data bar has the same border color as the positive data bar.

matchPositiveBorderColor?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]

matchPositiveFillColor

Specifies if the negative data bar has the same fill color as the positive data bar.

matchPositiveFillColor?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]