Exposes the information necessary for drawing a data bar for a specific cell.

See

CellConditionalFormat

Hierarchy

Hierarchy

  • Base
    • CellDataBarInfo

Constructors

Properties

$type: Type
$t: Type
nextHashCode: number

Accessors

  • 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

  • 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

  • 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

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

    See

    barColor

    Returns DataBarFillType

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

    See

    Returns number

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

    See

    Returns number

  • get isNegative(): boolean
  • Returns true if the cell value is negative (read-only).

    Returns boolean

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

    Returns boolean

Methods

  • Parameters

    • other: any

    Returns boolean

  • Returns number

  • Parameters

    • item1: any
    • item2: any

    Returns number

  • Parameters

    • item1: any
    • item2: any

    Returns number

  • Parameters

    • item1: any
    • item2: any

    Returns boolean

  • Parameters

    • a: any
    • b: any

    Returns boolean

  • Parameters

    • obj: any

    Returns any[]

  • Parameters

    • obj: any

    Returns any[]

  • Parameters

    • obj: any

    Returns number

  • Parameters

    • a: any
    • b: any

    Returns boolean