constructor

• new CellDataBarInfo(a, b, c, d, e, f, g, h, i, j): CellDataBarInfo

• Parameters

  • a: number

  • b: number

  • c: number

  • d: boolean

  • e: boolean

  • f: DataBarDirection

  • g: DataBarFillType

  • h: WorkbookColorInfo

  • i: WorkbookColorInfo

  • j: WorkbookColorInfo

  Returns CellDataBarInfo

Static $t

axisColor

• get axisColor(): WorkbookColorInfo

• The color to use to draw the axis line or null if no axis line is to be drawn (read-only).

  See

  [[axisPosition]]

  Returns WorkbookColorInfo

axisPosition

• get axisPosition(): number

• 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.

  See

  [[axisColor]]

  Returns number

barBorder

• get barBorder(): WorkbookColorInfo

• The color to use to draw the border around the data bar or null if no border is to be drawn (read-only).

  Returns WorkbookColorInfo

barColor

• get barColor(): WorkbookColorInfo

• The color to use to draw the data bar (read-only).

  See

  • [[barFillType]]
  • [[barPositionFrom]]
  • [[barPositionTo]]

  Returns WorkbookColorInfo

barFillType

• get barFillType(): DataBarFillType

• Specifies whether the data bar should be filled with a sold color or a gradient (read-only).

  See

  [[barColor]]

  Returns DataBarFillType

barPositionFrom

• get barPositionFrom(): number

• Species the position, as a percentage of the cell width, where the data bar should begin (read-only).

  See

  • [[barPositionTo]]
  • [[direction]]

  Returns number

barPositionTo

• get barPositionTo(): number

• Species the position, as a percentage of the cell width, where the data bar should end (read-only).

  See

  • [[barPositionFrom]]
  • [[direction]]

  Returns number

direction

• get direction(): DataBarDirection

• Specifies the direction of the bata bar (read-only).

  See

  • [[barPositionFrom]]
  • [[barPositionTo]]

  Returns DataBarDirection

isNegative

• get isNegative(): boolean

• Returns true if the cell value is negative (read-only).

  Returns boolean

showValue

• get showValue(): boolean

• Returns whether the cell value is to be shown along with the data bar (read-only).

  Returns boolean