constructor

• new NegativeBarFormat(a, b): NegativeBarFormat

• Parameters

  • a: DataBarConditionalFormat

  • b: ((arg1) => void)

    • • (arg1): void

      • Parameters

        • arg1: string

        Returns void

  Returns NegativeBarFormat

Static $t

barBorderColor

• get barBorderColor(): WorkbookColorInfo

• Returns a [[WorkbookColorInfo]] which defines the border color applied to data bars with a negative value.

  This property is only applicable when the [[barBorderColorType]] property is set to Color.

  See

  [[barBorderColorType]]

  Returns WorkbookColorInfo

• set barBorderColor(a): void

• Parameters

  • a: WorkbookColorInfo

  Returns void

barBorderColorType

• get barBorderColorType(): DataBarNegativeBarColorType

• Returns or sets a [[DataBarNegativeBarColorType]] value which specifies whether the same border color as that which is used for data bars with positive cell values is also used for data bars with negative cell values.

  By default, databars for cells with negative values use the same color as those with positive values, and the [[barBorderColor]] property is not used.

  Use this property to apply the color specified by the [[barBorderColor]] property to the borders of databars with negative cell values.

  See

  • [[barBorderColor]]
  • [[DataBarConditionalFormat.barBorderColor]]

  Returns DataBarNegativeBarColorType

• set barBorderColorType(a): void

• Parameters

  • a: DataBarNegativeBarColorType

  Returns void

barColor

• get barColor(): WorkbookColorInfo

• Returns a [[WorkbookColorInfo]] which defines the fill color applied to data bars with a negative value.

  This property is only applicable when the [[barColorType]] property is set to Color.

  See

  [[barBorderColorType]]

  Returns WorkbookColorInfo

• set barColor(a): void

• Parameters

  • a: WorkbookColorInfo

  Returns void

barColorType

• get barColorType(): DataBarNegativeBarColorType

• Returns or sets a [[DataBarNegativeBarColorType]] value which specifies whether the same color as that which is used for the positive data bars is used.

  By default, databars for cells with negative values have a different color than those with positive values.

  Use this property to apply the same color to databars regardless of whether the cell value is positive or negative.

  See

  • [[barColor]]
  • [[DataBarConditionalFormat.barColor]]

  Returns DataBarNegativeBarColorType

• set barColorType(a): void

• Parameters

  • a: DataBarNegativeBarColorType

  Returns void