Skip to content

CellDataBar

Defined in: src/core/document-model/types.ts:813

A conditional-format data bar: a horizontal bar of width fraction (0..1 of the cell), painted over the shading and under the text (E-SHEET SC1c). It starts at startFraction from the cell’s left (default 0); a mixed-sign range puts the axis inside the cell so negative bars run left of it (tail TC4).

readonly colorHex: string

Defined in: src/core/document-model/types.ts:815


readonly fraction: number

Defined in: src/core/document-model/types.ts:814


readonly optional negative?: boolean

Defined in: src/core/document-model/types.ts:822

The bar runs LEFT from the axis (a negative value in a mixed-sign range), so its solid end is its right one. Excel fades a data bar away from the axis, and which way that is depends on the sign.


readonly optional startFraction?: number

Defined in: src/core/document-model/types.ts:816