Exposes the information necessary for drawing a data bar for a specific cell.
Constructors
Section titled "Constructors"CellDataBarInfo
new CellDataBarInfo(a: number, b: number, c: number, d: boolean, e: boolean, f: DataBarDirection, g: DataBarFillType, h: WorkbookColorInfo, i: WorkbookColorInfo, j: WorkbookColorInfo): CellDataBarInfoReturns CellDataBarInfo
Properties
Section titled "Properties"$t: TypeAccessors
Section titled "Accessors"axisColor
Section titled "axisColor"The color to use to draw the axis line or null if no axis line is to be drawn (read-only).
get axisColor(): WorkbookColorInfoReturns WorkbookColorInfo
axisPosition
Section titled "axisPosition"Specifies the position, as a percentage of the cell width, where the axis ahould be rendered (read-only) a percentage from 0 to 100 Note: if [[axisColor]] returns null then this property can be ignored.
get axisPosition(): numberReturns number
barBorder
Section titled "barBorder"The color to use to draw the border around the data bar or null if no border is to be drawn (read-only).
get barBorder(): WorkbookColorInfoReturns WorkbookColorInfo
barColor
Section titled "barColor"The color to use to draw the data bar (read-only).
get barColor(): WorkbookColorInfoReturns WorkbookColorInfo
barFillType
Section titled "barFillType"Specifies whether the data bar should be filled with a sold color or a gradient (read-only).
get barFillType(): DataBarFillTypeReturns DataBarFillType
barPositionFrom
Section titled "barPositionFrom"Species the position, as a percentage of the cell width, where the data bar should begin (read-only).
get barPositionFrom(): numberReturns number
barPositionTo
Section titled "barPositionTo"Species the position, as a percentage of the cell width, where the data bar should end (read-only).
get barPositionTo(): numberReturns number
direction
Section titled "direction"Specifies the direction of the bata bar (read-only).
get direction(): DataBarDirectionReturns DataBarDirection
isNegative
Section titled "isNegative"Returns true if the cell value is negative (read-only).
get isNegative(): booleanReturns boolean
showValue
Section titled "showValue"Returns whether the cell value is to be shown along with the data bar (read-only).
get showValue(): booleanReturns boolean