Excel.Interfaces.DataBarConditionalFormatLoadOptions interface

Represents an Excel Conditional Data Bar Type.

[ API set: ExcelApi 1.6 ]

Properties

$all
axisColor

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

[ API set: ExcelApi 1.6 ]

axisFormat

Representation of how the axis is determined for an Excel data bar.

[ API set: ExcelApi 1.6 ]

barDirection

Represents the direction that the data bar graphic should be based on.

[ API set: ExcelApi 1.6 ]

lowerBoundRule

The rule for what consistutes the lower bound (and how to calculate it, if applicable) for a data bar.

[ API set: ExcelApi 1.6 ]

negativeFormat

Representation of all values to the left of the axis in an Excel data bar.

[ API set: ExcelApi 1.6 ]

positiveFormat

Representation of all values to the right of the axis in an Excel data bar.

[ API set: ExcelApi 1.6 ]

showDataBarOnly

If true, hides the values from the cells where the data bar is applied.

[ API set: ExcelApi 1.6 ]

upperBoundRule

The rule for what constitutes the upper bound (and how to calculate it, if applicable) for a data bar.

[ API set: ExcelApi 1.6 ]

Property Details

$all

$all?: boolean;

Property Value

boolean

axisColor

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

[ API set: ExcelApi 1.6 ]

axisColor?: boolean;

Property Value

boolean

axisFormat

Representation of how the axis is determined for an Excel data bar.

[ API set: ExcelApi 1.6 ]

axisFormat?: boolean;

Property Value

boolean

barDirection

Represents the direction that the data bar graphic should be based on.

[ API set: ExcelApi 1.6 ]

barDirection?: boolean;

Property Value

boolean

lowerBoundRule

The rule for what consistutes the lower bound (and how to calculate it, if applicable) for a data bar.

[ API set: ExcelApi 1.6 ]

lowerBoundRule?: boolean;

Property Value

boolean

negativeFormat

Representation of all values to the left of the axis in an Excel data bar.

[ API set: ExcelApi 1.6 ]

negativeFormat?: Excel.Interfaces.ConditionalDataBarNegativeFormatLoadOptions;

Property Value

positiveFormat

Representation of all values to the right of the axis in an Excel data bar.

[ API set: ExcelApi 1.6 ]

positiveFormat?: Excel.Interfaces.ConditionalDataBarPositiveFormatLoadOptions;

Property Value

showDataBarOnly

If true, hides the values from the cells where the data bar is applied.

[ API set: ExcelApi 1.6 ]

showDataBarOnly?: boolean;

Property Value

boolean

upperBoundRule

The rule for what constitutes the upper bound (and how to calculate it, if applicable) for a data bar.

[ API set: ExcelApi 1.6 ]

upperBoundRule?: boolean;

Property Value

boolean