Edit

Share via

Excel.Interfaces.ConditionalDataBarPositiveFormatLoadOptions interface

  • Reference
Package:
excel

Represents a conditional format for the positive 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").
gradientFill

Specifies if the data bar has a gradient.

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 ]

gradientFill

Specifies if the data bar has a gradient.

gradientFill?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]