Exposes properties which displays data bars in a [[WorksheetCell]] based on the cell's value as relative to the associated range.

Constructors

Section titled "Constructors"

DataBarConditionalFormat

new DataBarConditionalFormat(a: number): DataBarConditionalFormat

Returns DataBarConditionalFormat

Properties

Section titled "Properties"

$t

Section titled "$t" 
$t: Type

axisColor

Section titled "axisColor" 
axisColor: WorkbookColorInfo

axisPosition

Section titled "axisPosition" 
axisPosition: DataBarAxisPosition

barBorderColor

Section titled "barBorderColor" 
barBorderColor: WorkbookColorInfo

barColor

Section titled "barColor" 
barColor: WorkbookColorInfo

barFillType

Section titled "barFillType" 
barFillType: DataBarFillType

direction

Section titled "direction" 
direction: DataBarDirection

fillPercentMax

Section titled "fillPercentMax" 
fillPercentMax: number

fillPercentMin

Section titled "fillPercentMin" 
fillPercentMin: number

priority

Section titled "priority"

Inherited from: ThresholdConditionBase 

priority: number

showBorder

Section titled "showBorder" 
showBorder: boolean

showValue

Section titled "showValue" 
showValue: boolean

stopIfTrue

Section titled "stopIfTrue"

Inherited from: ThresholdConditionBase 

stopIfTrue: boolean

Accessors

Section titled "Accessors"

conditionType

Section titled "conditionType"

Inherited from: ThresholdConditionBase

Returns a [[FormatConditionType]] value which identifies the type of condition for this instance.

get conditionType(): FormatConditionType

Returns FormatConditionType

formula

Section titled "formula"

Inherited from: ThresholdConditionBase

Returns the formula which determines the values to which this condition applies. Note: the formula should return a boolean result. When the formula is applied to cells in the region if the formula returns false then those cells will not be included in the formatting.

get formula(): Formula

Returns Formula

maxPoint

Section titled "maxPoint"

Returns or sets a value which determines the manner in which the longest bar is evaluated for this condition.

get maxPoint(): ConditionValue

Returns ConditionValue

minPoint

Section titled "minPoint"

Returns or sets a value which determines the manner in which the shortest bar is evaluated for this condition.

get minPoint(): ConditionValue

Returns ConditionValue

negativeBarFormat

Section titled "negativeBarFormat"

Returns a [[negativeBarFormat]] object which defines the visual attributes of negative-value data bars.

get negativeBarFormat(): NegativeBarFormat

Returns NegativeBarFormat

regions

Section titled "regions"

Inherited from: ThresholdConditionBase

Returns the [[WorksheetRegion]] which identifies the cell range with which this condition is associated.

get regions(): ReadOnlyCollection$1<WorksheetRegion>

Returns ReadOnlyCollection$1<WorksheetRegion>

workbook

Section titled "workbook"

Inherited from: ThresholdConditionBase

Returns a reference to the associated workbook.

get workbook(): Workbook

Returns Workbook

worksheet

Section titled "worksheet"

Inherited from: ThresholdConditionBase

Returns a reference to the associated worksheet.

get worksheet(): Worksheet

Returns Worksheet

Methods

Section titled "Methods"

setFirstPriority

Section titled "setFirstPriority"

Inherited from: ThresholdConditionBase

Sets the [[priority]] value for this rule such that it is the first condition to be evaluated. Applicable only in the case where there is more than one element contained within the associated collection.

setFirstPriority(): void

Returns void

setFormula

Section titled "setFormula"

Inherited from: ThresholdConditionBase

Assigns a new [[Formula]] to the [[formula]] property. Note: the formula should return a boolean result. When the formula is applied to cells in the region if the formula returns false then those cells will not be included in the formatting.

setFormula(formula: string, cellReferenceMode: CellReferenceMode): void

Parameters

  • formula: string

    The string representation of the formula.
  • cellReferenceMode: CellReferenceMode

    A [[CellReferenceMode]] value which specifies whether the 'formula' parameter should be interpreted as an A1 or R1C1 expression. This parameter is optional and defaults to null, in which case the [[Workbook.cellReferenceMode]] property is used.

Returns void

setLastPriority

Section titled "setLastPriority"

Inherited from: ThresholdConditionBase

Sets the [[priority]] value for this rule such that it is the last condition to be evaluated. Applicable only in the case where there is more than one element contained within the associated [[ConditionalFormatCollection]].

setLastPriority(): void

Returns void

setRegions

Section titled "setRegions"

Inherited from: ThresholdConditionBase

Replaces the existing regions with new ones

setRegions(regionAddress: string, cellReferenceMode: CellReferenceMode): void

Parameters

  • regionAddress: string

    A string with one or more comma separated region address
  • cellReferenceMode: CellReferenceMode

    An optional cell reference mode

Returns void

staticInit

Section titled "staticInit"

Inherited from: ThresholdConditionBase 

staticInit(): void

Returns void