Excel.Interfaces.ConditionalDataBarNegativeFormatLoadOptions interface

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 ]