Excel.Interfaces.ConditionalDataBarPositiveFormatLoadOptions interface

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

Remarks

[ API set: ExcelApi 1.6 ]

Properties

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: 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").

gradientFill

Specifies if the data bar has a gradient.

Property Details

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: 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 ]

gradientFill

Specifies if the data bar has a gradient.

gradientFill?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]